Tip #6: Crea campos únicos para evitar el duplicado de registros

Tip #6: Crea campos únicos para evitar el duplicado de registros

Tips and tricks #06, adaptado de Aishwarya EK
¡Hola usuarios!

La semana pasada hablamos de la importancia de tener una base de datos organizada para empezar mejor el nuevo año. Si bien es importante tener el foco en utilizar Zoho CRM de la mejor forma, también lo es el mantener una base de datos limpia y ordenada. Siguiendo con este hilo, hoy te ofrecemos un nuevo consejo sobre cómo evitar los registros duplicados en tu base de datos de CRM.

Tip #6: Crea campos únicos para evitar el duplicado de registros.

Campaigns, Social, Backstage, Sales IQ, etc. ¡Tenemos tantas posibilidades de recoger y almacenar posibles clientes! Con múltiples fuentes y diversos compañeros utilizando el mismo sistema CRM, la probabilidad de añadir contactos duplicados se incrementa. Y mientras la base de datos crece, es más complicado buscar estos registros duplicados manualmente. No te preocupes, ¡estás cubierto!

Zoho CRM te ayuda a evitar la creación de registros duplicados desde su creación. ¿Cómo? Marca el campo como único.

Un campo único es un campo en un registro cuyo valor lo hace único. Un ejemplo de campo único puede ser el del correo electrónico, ya que de forma habitual cada correo electrónico corresponde a una sola persona. Si se define este campo como único, sólo los datos de una persona se asociarán a esa cuenta de correo electrónico.



Otro campo que puede servir como único es para datos como el DNI, NIF y otros documentos de identificación personal y fiscal. Puedes añadir estos campos personalizados y hacerlos campos únicos en los módulos de posibles clientes, contactos y cuentas. De esta forma, Zoho CRM no permitirá la creación de registros duplicados que contengan un valor ya existente en el mismo campo.

Veamos algunos casos en los que podrían surgir registros duplicados para comprender mejor la herramienta.

Caso 1: Posibles clientes a través de formularios web y formularios integrados en aplicaciones.

En aquellos casos en los que el registro de posible cliente se realice mediante la integración con otras aplicaciones y formularios web, utilizar el campo único como campo requerido a rellenar por el usuario puede facilitarnos el control de registros duplicados. En este caso, los registros se almacenarán en tu CRM para su aprobación en Posibles Clientes > Más (...) > Aprobar Posibles Clientes > Duplicar Posibles Clientes.



Caso 2: Nuevo posible cliente que ya existe como contacto.

Los campos únicos son específicos para cada módulo. Por ejemplo, si marcas un campo único en el módulo Contactos, y un nuevo contacto se crea con el mismo valor de campo único (pongamos el mismo correo electrónico), el sistema alertará sobre el registro duplicado. Sin embargo, la inspección de duplicados no se realizará en el módulo de Posibles Clientes. Atención: si decides convertir el Posible Cliente a Contacto, el sistema te alertará de que éste ya existe como contacto, por lo que te obligará a que la información de ambos se quede en el registro de contacto existente:



Los campos únicos juegan un rol importante en la gestión de registros duplicados de distintas fuentes, como son la creación manual, registros creados via importación, APIs, integraciones con aplicaciones, formularios web, etc. Para descubrir más sobre campos únicos, haz clic aquí.

¿Conocías esta función? ¿Qué te parece? ¡Añádelo en los comentarios!

    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts





                                                          Manage your brands on social media



                                                                Zoho TeamInbox Resources



                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources

                                                                                            Zoho Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ






                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • What is the maximum file size of a video upload in Zoho chat?

                                                                                                            Can I upload a 20 mb video file and share it with my colleagues? 
                                                                                                          • Update a field in ALL all calls under a contact

                                                                                                            HI guys! I have written some deluge code to update a field in my calls after i have comepleted the call, i need this field to update in all my scheduled calls as well that are comeing up. I just cant seem to get it to work, i have put teh code below,
                                                                                                          • In place field editing for candidates

                                                                                                            Wondering about any insight/best practices for efficiently updating candidate records while reviewing them in a Job Opening pipeline. We can do in-field editing (e.g. update job title or City) only when we have the full candidate record open, however
                                                                                                          • Automatic Matching from Bank Statements / Feeds

                                                                                                            Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these
                                                                                                          • Verifying Zoho Mail Functionality After Switching DNS from Cloudflare to Hosting Provider

                                                                                                            I initially configured my domain's (https://roblaxmod.com/) email with Zoho Mail while using Cloudflare to manage my DNS records (MX, SPF, etc.). All services were working correctly. Recently, I have removed my site from Cloudflare and switched my domain's
                                                                                                          • Fat Download of Ulaa Browser

                                                                                                            I just observed that Ulaa Browser is offering an one-capsule big download. These days it is a custom to offer a small bootstrap downloader and based on user customization options an appropriate download completes. And this is particularly common with
                                                                                                          • Cancelled Transfer order problem

                                                                                                            Hello, We've canceled a transfer order, and we can't add the related items to a new Transfer Order. The system tells us that the bin doesn't have the required quantity, but when we check the item, it indicates that there are 2 units in the bin. It also
                                                                                                          • Zoho Creator customer portal limitation | Zoho One

                                                                                                            I'm asking you all for any feedback as to the logic or reasoning behind drastically limiting portal users when Zoho already meters based on number of records. I'm a single-seat, Zoho One Enterprise license holder. If my portal users are going to add records, wouldn't that increase revenue for Zoho as that is how Creator is monetized? Why limit my customer portal to only THREE external users when more users would equate to more records being entered into the database?!? (See help ticket reply below.)
                                                                                                          • Billing Management: #8 Usage Billing in Logistics & Delivery Services

                                                                                                            The logistics and delivery industry thrives on movement and precision. Every delivery completed, every kilometre driven, and every ton transported is a measurable activity. However, billing often lags behind. Many logistics companies still rely on fixed-rate
                                                                                                          • Tags for New Tickets

                                                                                                            Hi there, When creating a new ticket, there is currently no way to choose a tag you would like to associate with the new ticket. Being able to associate a tag while creating a new ticket will be very beneficial as it will save time and flow well with
                                                                                                          • Zoho Desk: No Incoming email

                                                                                                            Is Zoho Desk services down? No incoming email reflect to desk tickets.
                                                                                                          • Zoho CRM - Widgets | Update #3 : Introducing SDK V1.5 along with new ZDK Methods and ZRC Support

                                                                                                            Hello everyone! Widgets in Zoho CRM just got a big upgrade! With the release of SDK v1.5, developers can now create more immersive widget experiences. This update elevates Widget development with new ZDK methods for easier interactivity and ZRC support
                                                                                                          • Unusual activity detected, account blocked

                                                                                                            I am unable to send emails and am getting the error "Outgoing blocked: Unusual activity detected. To unblock your account, please and submit a request. Learn more.". I am unsure as to why this is happening since all my activity is legitimate, mainly confirmation
                                                                                                          • Unable to Send Emails – Outgoing Mail Blocked (Error 554 5.1.8)

                                                                                                            Description: Hello Zoho Support Team, I am facing an issue with my Zoho Mail account ( admin@osamarahmani.tech ). Whenever I try to send an email, I get the following error: 554 5.1.8 Email Outgoing Blocked I would like to clarify that I have not done
                                                                                                          • Issue connecting Zoho Mail to Thunderbird (IMAP/SMTP authentication error)

                                                                                                            Dear Zoho Support, I am trying to configure my Zoho Mail account on Thunderbird, but I keep getting authentication errors. Account: info@baktradingtn.com Domain: baktradingtn.com Settings used: IMAP: imap.zoho.com, Port 993, SSL/TLS, Normal Password SMTP:
                                                                                                          • Payment issue with Mail Lite plan – personal NIF not accepted as payment info

                                                                                                            Hello, I have already contacted Zoho Support by email regarding this, but since I haven’t received any reply yet, I’m sharing it here as well to see if the community can help. I’m facing a payment issue for my Mail Lite plan. I have a personal account
                                                                                                          • Customer payment alerts in Zoho Cliq

                                                                                                            For businesses that depend on cash flow, payment updates are essential for operational decision-making and go beyond simple accounting entries. The sales team needs to be notified when invoices are cleared so that upcoming orders can be released. In contrast,
                                                                                                          • Figma in Zoho Creator

                                                                                                            Hi Team, I’m creating a form using Figma and would like to know how to add workflows like scheduling, custom validation, and other logic to it. Can anyone help me understand how to set this up for a Figma-based Creator UI form?
                                                                                                          • Restore lost Invoice!

                                                                                                            Some time ago I tried to Upgrade from Invoice to Books. I not upgraded and staid n Invoice. Now i tried again and first i deleted the old trial of books. But now all is gone, PLEASE HELP!! i have no backup and i have to have at least 7 years data retention by law. 
                                                                                                          • Zoho Desk Down

                                                                                                            Not loading
                                                                                                          • lookup and integrated forms

                                                                                                            I might be misunderstanding things but I wanted to integrate our zoho crm contacts into creator. I imagined that when I used the integration it would mirror into creator. It did brilliant. BUT We have a ticket form in creator that we want to use a lookup
                                                                                                          • Partially receive PO without partial Bill?

                                                                                                            Most of our inventory is pre-paid. Let's say we purchase 30 pieces of 3 different items for a total of 90 pieces. It is common for our supplier to send us the items as they are ready. So we will receive 30 pieces at a time. How can I partially receive
                                                                                                          • 2 users editing the same record - loose changes

                                                                                                            Hello, I'm very new to Zoho so apology if this has been addressed somewhere i can't find. I have noticed the following: If we have 2 users put an inventory item in edit mode at the same time: say user1 click on edit and user2 while user1 is still in edit,
                                                                                                          • How to get the Dashboard page to be the first page when you open the app

                                                                                                            So when it opens on a tablet or phone it opens on the welcome page, thanks.
                                                                                                          • How I set default email addresses for Sales Orders and Invoices

                                                                                                            I have customers that have different departments that handle Sales Orders and Invoices. How can i set a default email for Sales Orders that's different than the default email for Invoices? Is there a way I can automate this using the Contact Persons Departments
                                                                                                          • Formula fields not refreshing until page is reloaded

                                                                                                            I need help/advice about the formula fields and how I can refresh the information in real-time. We have two formula fields on our deals page which show calculated prices: One formula is in a subform which calculates the subform total + 1 other field amount
                                                                                                          • How can I setup Zoho MCP with Chat GPT

                                                                                                            I can set up custom connections with Chat GPT but I cat an error when I try to set it up. The error is: "This MCP server can't be used by ChatGPT to search information because it doesn't implement our specification: search action not found" Thoughts?
                                                                                                          • API ZOHO CRM Picket list with wrong values

                                                                                                            I am using Zoho API v.8. with python to create records in a custom module named "Veranstaltung" in this custom module I've got a picket list called "Email_Template" with 28 Values. I've added 8 new values yesterday, but if I try to use on of those values
                                                                                                          • Group Emails

                                                                                                            I have synced Zoho CRM to Campaigns but there are certain email not synced. showing it is Group Emails, but this email ids belongs to different individuals. please provide a solution as i nedd to sync the same.
                                                                                                          • Enable Password Import option in ulaa browser

                                                                                                            Dear Ulaa Team, I noticed that the Ulaa Password Manager currently offers an option to export passwords, but not to import them. This limitation poses a challenge for users like me who have stored numerous credentials in browsers like Chrome. Manually
                                                                                                          • "Is Zoho CRM customer" vs "Is linked with Zoho CRM"

                                                                                                            Recently while building a Flow, I was setting up a Decision action following a Zoho Invoice Fetch record action. There were 2 choices that I had not seen as something I could manually action in Zoho Invoice: "Is Zoho CRM customer" and "Is linked with
                                                                                                          • Client Script | Update - Introducing ZRC: Simplified HTTP request library

                                                                                                            Hello Developers! Are you tired of juggling different methods to make API calls? Are you confused with multiple syntaxes and version restrictions? Have you ever wished for one simple way to make all API calls in CRM? We heard you :) Here comes ZRC (Zoho
                                                                                                          • Selection Filed for Data Export section

                                                                                                            Hi FSM Team, I hope you are all doing well. I would like to share an idea for future development based on my experience. Currently, in FSM, we can only download up to 5,000 records at a time. If the development team could add a selection option to choose
                                                                                                          • Text wrap column headers in reports?

                                                                                                            Is it possible to auto wrap column headers so that a longer multi-word header displays as two lines when the column is narrower than the width of the header title?
                                                                                                          • What if I dont see contacts on the left side list

                                                                                                            My CRM does not show the contacts tab. In order to create list this is needed and I cant find it.
                                                                                                          • Comments Vs. Replies

                                                                                                            I'm curious as to the difference between a "Reply" and a "Comment" on a ticket. It appears that "Replies" are what's used to determine response time SLA's and there are also used to automatically re-open tickets. I'm just trying to understand the key differences so I can educate both our clientele and our back-end users on which function/feature to use to better improve the ticket lifecycle. If anyone has any insight it would be appreciated. Thanks!
                                                                                                          • Transitioning to API Credits in Zoho Desk

                                                                                                            At Zoho Desk, we’re always looking for ways to help keep your business operations running smoothly. This includes empowering teams that rely on APIs for essential integrations, functions and extensions. We’ve reimagined how API usage is measured to give
                                                                                                          • Resetting auto-number on new year

                                                                                                            Hi everyone! We have an auto-number with prefix "D{YYYY}-", it generates numbers like D2025-1, D2025-2, etc... How can we have it auto-reset at the beginning of the next year, so that it goes to D2026-1? Thanks!
                                                                                                          • Can you prevent closing Ulaa window when the last tab is closed (inadvertently)?

                                                                                                            Most browsers have started to bring this feature in to prevent closing their windows when the last tab is closed (inadvertently). I hope Ulaa should get this in too.
                                                                                                          • Microsoft Phone Link

                                                                                                            Does anyone know if you can use Microsoft Phone Link to make calls through Zoho?
                                                                                                          • Next Page