Unique ID: A little field that saves you a lot of hassle

Unique ID: A little field that saves you a lot of hassle

If you go to the Zoho Forms builder and look under Advanced Fields, you'll find this field called the Unique ID. The Unique ID field is one of the most under-utilized features in Forms and one with a lot of hidden
potential; literally. 

It's a field that remains hidden when a user fills out the form, but you can see it while viewing the form submission. How is this helpful, you ask? Ever tried to find a needle in a needle stack? When you have a bunch of orders or bookings and a customer has a query about their particular order or booking, that's when Unique ID comes in handy. When you add the Unique ID field, it creates a number for each form that helps identify individual submissions.

Let's look at a working example of how we can apply this field to make our forms more efficient. 

Take a doctor's appointment form. To make booking appointments easier, we can add the Unique ID field. This adds a unique number to each form submission. You can even specify a prefix or suffix to be added to each ID, for example, a prefix of PI for Patient ID.

Now every single appointment form has a unique number associated with it. Let's take this a step further and send it to the patient who made the booking, so when they arrive at the clinic, they just need to mention their Patient ID and take a seat. To do this, go to Form Rules, under the Rules tab, and click Create Form Rule. Specify a rule for the condition, If 'Name' 'Is Not Empty', then 'Send Email.' Click on the email field and configure the email in the pop-up that appears, like so:

 

To send this mail to the patient, in the 'To' address field, select the required email address field from the Choose Email Field dropdown. This sends the email to the address filled in your form's Email ID field. Personalize the message by including responses to form fields by choosing the required field from the Choose Field dropdown.

For example, you can choose 'Name - First' and 'Name - Last' from the 'Choose Field' dropdown to include the patient's name in the message. Similarly, you can send their Patient ID by including the Unique ID field in the message. Now, the patient can keep a note of this ID on the day of the appointment and for booking follow-up appointments. 

Thus, keeping track of bookings becomes easier with the Unique ID field. Go on and use it in your forms and tell us if it makes your life easier. 

Best
Anugraha 
Zoho Forms



    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



                                                          • Sticky Posts

                                                          • Easily track referrals with Zoho Forms

                                                            Referral tracking can be a powerful way for businesses to understand where their leads are coming from. With Zoho Forms, tracking the referral sources of your leads is an easy and straightforward process. Here are some tips to help you make the most of
                                                          • 9 Ways to use Zoho Forms this Navratri

                                                            Hello form builders!Navratri is almost here! It is a time for celebration and culture in the Indian community, and organizing such a grand event can be overwhelming. But with the right tools, you can streamline the process and focus on creating unforgettable
                                                          • The secret to collecting data from valid users

                                                            Collecting accurate data is crucial for making informed decisions. Zoho Forms offers two efficient ways to validate user data and ensure that you collect entries exclusively from valid users. Double Opt-in: Double Opt-in is a privacy feature that ensures
                                                          • Storage space in Zoho Forms: The ultimate guide to efficiently managing your data

                                                            Are you using Zoho Forms for data collection? As with any data-intensive application, understanding how storage space is calculated is essential. That's why we've created this guide— to show you everything you need to know about managing storage space
                                                          • Linking primary form submissions to a second form submission

                                                            Let's imagine you have a form that you use to request a minimal amount of data from your users. To collect additional information, you redirect them to another form either automatically or based on a condition. During the course of redirection, you can


                                                          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 Writer

                                                                                            Get Started. Write Away!

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

                                                                                              Zoho CRM コンテンツ





                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • How can I filter a field integration?

                                                                                                            Hi,  I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.
                                                                                                          • Adding image in HTML report page

                                                                                                            Hi, I want to know two things: 1. Can anyone advise how to add an image in HTML report. The tagged used is <img> but what path do I mention for the image to be added in the HTML report. 2. Also, I want to know if I am creating an application for the market
                                                                                                          • How to change view of HTML report based on device but always print in A4

                                                                                                            Hello everyone, I am aware that HTML report view can be configured to adjust according to the screen size like Laptop, Tablet and mobile using media queries. But my concern is no matter on which device the reports is opened when printed should always
                                                                                                          • Age Calculation

                                                                                                            I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.
                                                                                                          • Search on Custom Field

                                                                                                            We're working on an integration with the Zoho FSM API and are trying to retrieve companies based on a custom field we added to the Companies module. However, we can't find a way to filter or query records using custom fields through the API. We have a
                                                                                                          • Sendmail function / custom action?

                                                                                                            I've setup a function hoping to email various business departments the details of a record once all work in that record is complete so gone about setting up a custom action in such way that each record line on the report has a button to click. Question is how do I actually include data from that record in the email that is sent when the button is clicked? I had thought that since this were being sent per record the email would include the data which had been entered
                                                                                                          • API to post drafts for social media

                                                                                                            I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA Jon
                                                                                                          • Canvas View in Zoho Recruit

                                                                                                            Is it possible or would it be possible to have the new 'Canvas View' in Zoho Recruit?
                                                                                                          • What impactful sales coaching techniques have you used to boost your team's performance?

                                                                                                            I'm curious about the real-world impact of sales coaching on team performance. What specific techniques or strategies have you found most effective in driving consistent improvement and growth in your sales team? Any success stories or lessons learned
                                                                                                          • Adding Taxes to paid consultations in Zoho Bookings

                                                                                                            I created a 'paid' consultation under Zoho Booking and integrated it with payment gateways for online/instant payment before a booking is done. How can I add 'taxes' to the price of consultation? I can add taxes to other Zoho apps (liks Books, Checkout,
                                                                                                          • Zoho Finance Suite - Customer Custom Tabs - Dynamic Link

                                                                                                            Hi Finance Suite team, When creating a Custom Tab for a Client Portal, there is no option to add dynamic parameters. This would be very helpful for adding Zoho Analytics dashboards which can be dynamically filtered through the URL to only show information
                                                                                                          • Feature Request - Insert URL Links in Folders

                                                                                                            I would love to see the ability to create simple URL links with titles in WorkDrive. or perhaps a WorkDrive extension to allow it. Example use case: A team is working on a project and there is project folder in WordDrive. The team uses LucidChart to create
                                                                                                          • How to Calculate MTTR (Mean Time to Resolve)

                                                                                                            We want to calculate MTTR (Mean Time to Resolve) in our Zoho Analytics report under Tickets. Currently, we are using the following fields: Ticket ID Ticket Created Time Ticket Closed Time Ticket On Hold Time We are planning to calculate MTTR (in days)
                                                                                                          • Possible to bold or indent text in the description field?

                                                                                                            As part of one item, I often have a detailed description that would be much easier to read if there was the ability to have a bulleted list or bold text and the like. Is this possible? My last invoicing software allowed markup in the field so, for example, an asterisk meant a bullet. I haven't been able to find any documentation related to this.  Any information would be appreciated. Thank you.
                                                                                                          • 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?
                                                                                                          • Formatting of Balance Sheet and Profit & Loss Reports

                                                                                                            The default format of the Balance Sheet and P&L Reports are based on the Account Types and then the individual accounts within the Chart of Accounts. These are then ordered alphabetically under these sub-headings and one is unable to re-order these or
                                                                                                          • UK MTD reports concerning turnover and cerash accounting

                                                                                                            Hi I am a sole trader, and I have just started with Zoho Books in order to comply with the new HMRC requirements. I use 'cash basis' - which I understand to mean that income is when the cash comes in (not the invoice date) and expenses are when they are
                                                                                                          • Retainer Invoice.

                                                                                                            Why ZOHO not have facilities to deduct partially advance payment from an invoice.
                                                                                                          • IMAP Server not responding.

                                                                                                            Trying to connect a phone via IMAP and getting "imap.zoho.com not responding." Is the server down, for maintenance or otherwise? I've tried this on two different devices and got the same error on both.
                                                                                                          • Share saved filters between others

                                                                                                            Hi, I am in charge to setup all zoho system in our company. I am preparing saved filters for everybody, but the only one can see its me. How can others see it? Thanks
                                                                                                          • GST Slabs Redefined: Stay Compliant Using Zoho Books!

                                                                                                            Hello Everyone! The Government of India is rolling out new GST rates, a major reform aimed at simplifying the current tax structure starting 22 September 2025. GST will move from four slabs (5%, 12%, 18%, 28%) to two main slabs (5% and 18%), plus a special
                                                                                                          • Kanban view on Zoho CRM mobile app!

                                                                                                            What is Kanban? The name doesn't sound English, right? Yes, Kanban is a Japanese word which means 'Card you can see'. As per the meaning, Kanban in CRM is a type of list view in which the records will be displayed in cards and categorized under the given
                                                                                                          • Presenting ABM for Zoho CRM: Expand and retain your customers with precision

                                                                                                            Picture this scenario: You're a growing SaaS company ready to launch a powerful business suite, and are looking to gain traction and momentum. But as a business with a tight budget, you know acquiring new customers is slow, expensive, and often delivers
                                                                                                          • No practical examples of how survey data is analyzed

                                                                                                            There are no examples of analysis with analytics of zoho survey data. Only survey meta data is analyzed, such as number of completes, not actual analysis of responses, such as the % in each gender, cross-tabulations of survey responses. One strange characteristic of Zoho analytics is that does not seem aware of how Zoho Survey codes 'multiple response' questions. These are questions where more than one option can be selected from a list. Zoho Survey stores this data as text, separated by commas within
                                                                                                          • Zoho Creator as LMS and Membership Solution

                                                                                                            My client is interested in using Zoho One apps to deploy their membership academy offer. Zoho Creator was an option that came up in my research: Here are the components of the program/offer: 1. Membership portal - individual login credentials for each
                                                                                                          • Adding Chargebee as a Data Connector

                                                                                                            Is it possible to get Chargebee added as a Zoho Analytics data connector?
                                                                                                          • Webform & spam

                                                                                                            Hi, We set up 2 webform on our website, fowarding the content to Zoho CRM. Since it has been opened up, we are getting lot of spam message (for now about 20 a day). To lower the  amount of false new leads we added the captcha field and new enquieries are send to the Approval Leads list. However we still get some spam. Is there any "anti spam" mechanism built in Zoho CRM, or how is the best way to avoid these kind of spam ? Thanks
                                                                                                          • Dropbox to Workdrive

                                                                                                            Namaste, Trust you all are doing well. Wanted to check how this can be done with Zoho flow. I typically receive dropbox links from my clients. Is there a way where I can provide the link to Zoho flow and it downloads the files from dropbox link to a work
                                                                                                          • Deals by Stages Funnel not showing in correct order

                                                                                                            Using the Stage-Probability Mapping for the Deals module we have created a steps our deals will pass through, RFQ, Closed/Lost, Declined/No-Go, Pricing, Submitted, Negotiations, Won. However when I view the Deal By Stages Funnel it does not show in the
                                                                                                          • Adding a developer for editing the client application with a single user license

                                                                                                            Hi, I want to know that I as a developer I developed one application and handed over to the customer who is using the application on a single user license. Now after6 months customer came back to me and needs some changes in the application. Can a customer
                                                                                                          • Turning off the new UI

                                                                                                            Tried the new 'enhanced' UI and actively dislike it. Anyone know how to revert back?
                                                                                                          • Confirmation prompt before a custom button action is triggered

                                                                                                            Have you ever created a custom button and just hoped that you/your users are prompted first to confirm the action? Well, Zoho knows this concept. For example, in blueprint, whenever we want to advance to the next state by clicking the transition, it is
                                                                                                          • Cost of good field

                                                                                                            Is there a way we can have cost of good sold as a field added to the back end of the invoicing procedure and available in reports?
                                                                                                          • How to create auto populate field based on custom module in Zoho CRM?

                                                                                                            Hello, i'm still new to Zoho CRM and work as administrator in my company. Currently, I'm configuring layout for Quotes Module. So, the idea is, I've created a read-only field in Quotes called "Spec". I want this field automatically filled with Specification
                                                                                                          • Rich Text For Notes in Zoho CRM

                                                                                                            Hello everyone, As you know, notes are essential for recording information and ensuring smooth communication across your records. With our latest update, you can now use Rich Text formatting to organize and structure your notes more efficiently. By using
                                                                                                          • Change Last Name to not required in Leads

                                                                                                            I would like to upload 500 target companies as leads but I don't yet have contact people for them. Can you enable the option for me to turn this requirement off to need a Second Name? Moderation update (10-Jun-23): As we explore potential solutions for
                                                                                                          • Office 365 and CRM mail integration: permission required

                                                                                                            Has anyone run into this weird problem? My email server is Office 365. When I try to configure Zoho CRM to use this server, a Microsoft popup window opens requesting user and password. After entering that, I get a message in the Microsoft window saying
                                                                                                          • Tables improvement ideas / features

                                                                                                            Heya, I've been using Zoho Tables for a few months now and wanted to post some features that I think will be greatly beneficial for the tool: 1. Ability to delete a record in automation or move a record in automation. - Usecase: I move a record from one
                                                                                                          • Deluge - Can't get phone number SalesIQ

                                                                                                            Hey folks, I’m building a custom plug for SalesIQ that’s supposed to register leads into Zoho CRM. The SalesIQ chat is being implemented on WhatsApp, and in my plug I’m using this line: mobile_clean = session.get("phone").get("value"); From what I understand,
                                                                                                          • how to differentiate if whatsapp comes from certain landing page?

                                                                                                            I create a Zobot in SalesIQ to create a Whatsapp bot to capture the lead. I have 2 landing pages, one is SEO optimized and the other want is optimized for leads comes from Google Ads. I want to know from which landing page this lead came through WhatsApp
                                                                                                          • Next Page