Introducing new options for more flexible validation rules in CRM

Introducing new options for more flexible validation rules in CRM

Notes
Editions:  Professional and above
DCs: All
Release plan: We've started rolling out this enhancement to customers. It is being released in a phased manner and will soon be available to all customers in all DCs.

[Update | 26 Sep 2024] This enhancement has been released to all users in all DCs.

Help doc: Working with validation rules

Hello everyone,

You can configure validation rules to alert users of mistakes and prevent incorrect data from being submitted. They are useful in situations like the following:
  • Preventing a form from being saved if the social security number doesn't contain nine characters.
  • Validating an IBAN number against the specified format.

We've added new configuration options to validation rules for increased flexibility. With these options, you can:
  • Quickly validate individual fields
  • Allow the record to be saved with an alert
  • Decide where the error messages will be displayed.
Let's look at them one by one.

Quickly validate individual fields


Fields were previously validated only upon clicking the save button. To validate fields as you filled out a form, you had to:
  • Ensure that the mandatory fields were filled
  • Click the save button to validate a field.
Each click of the save button triggers the execution of all validation rules, displaying error messages throughout the form.

Now, we've added a new option: "Field verify and save". Users may need to quickly validate an important field before they proceed to other fields. In such cases, they can pick Field verify and save for validating those important fields.



Validation will take place when you click the "Verify" button next to the field and when saving the record. This speeds up field verification by allowing you to click a button right next to the filled field and executing only that field's validation rule.

This is available for both validation rules based on criteria and those that use functions.

Notes
[Updated on 23 Jan 2025] The field verify and save option is not available in:

Allow the record to be saved with an alert

Let's say that you have a company policy that prohibits discounts exceeding 15%, and that your sales reps are encouraged to avoid offering discounts over 10%.

The challenge lies in not allowing values above 15% at all, while also permitting values above 10% but reminding sales reps that discounts above 10% are not ideal.

You can manage situations like this by setting the validation preference as:
  • Stop with error (prevents the saving of the record)
  • Allow by alert (allows the saving of the record after getting confirmation from the user)


When you choose to stop with an error, the record will not be saved with the entered value. This feature is beneficial for completely blocking the input of inaccurate data. Before this enhancement, this was the default behavior of all validation rules.



With this enhancement, we've added the allow by alert option to remind users to verify the data before saving it. This enables them to save a record after being reminded of the policy and confirming that they understand it, which is useful when the entered value isn't optimal and you want to ensure the user has not made an error.



You can set this preference independently for each condition in your validation rule.
Notes
This option is available for validation rules using criteria where the validation happens on Save only.

Decide where the error messages will be displayed

Additionally, you can select where error messages will appear for a specific condition in a validation rule.



If a field's value is not related to another field, it's best to display the error near the field itself. This enables users to quickly identify and correct any mistakes. Therefore, you should select the on primary field option for these scenarios. Previously, all error messages were displayed in this manner.



In complex and data-intensive forms, validation errors may occur due to inter-dependencies between the values entered in different fields. In these cases, consolidating these validation errors in one place can help users resolve these issues more efficiently. With this enhancement, you can choose the top of page option in such scenarios.



You can set the error location separately for each condition in your validation rule.
Notes
This option is available for validation rules using criteria where the validation happens on Save only. It will be available in all conditions where the validation preference is Stop with error.

In addition to the above changes, you can now create validation rules for lookup fields as well.

Do share your feedback in the comments section below!



        • Recent Topics

        • Copy / Duplicate Workflow

          I have workflows setup that are very similar to each other. We have a monitoring system watching servers, and all notifications - no matter what client it is about - will come from a  noreply@ address which is not very helpful in having it auto assigned to the right account. I have setup a workflow that will change the contact name of the ticket (currently it would say noreply@) to the correct customer which is based on the subject line, as that mentions which server the alert it is about. I need

        • Subtasks don't update parent task's times

          Hi there: I've recently upgraded to premium and check that subtasks completion % don't update the proportional completion of the parent tasks related to it.  We've been challenging with the problem of having to update twice or sometimes 3 times the completion of the related tasks. I've seen posts similar to this, of 3 years old.  Is there any roadmap for making this happen in a future release? Thanx César Ratto Lima, Perú.

        • Should I Use DMARC?

          When I configure Zoho Mail's DMARC settings, it's mandatory to fill in the RUA and RUF (Aggregate notification email address*, Forensic notification email address*) addresses. When we enter an email address in these fields, we receive reports from the

        • Tip #44 – Get Deeper Insights with Zoho Assist’s Custom Reports – ‘Insider Insights’

          In today’s fast-paced IT environment, having a clear view of your remote support activities is more important than ever. Zoho Assist’s Custom Reports feature gives IT teams the ability to generate tailored reports that provide actionable insights and

        • Message "...does not support more than 100 distinct values..." WHY????

          I get this message on one of my reports: Sorry, Zoho Reports currently does not support more than 100 distinct values in columns. 'Account Name * Sum(Amount),Count(Amount Tier)' contains more than 100 distinct values.  Possibly, you can apply filter to reduce the number of distinct values in 'Account Name' or drop the 'Account Name' field in Rows. I want to list all ACCOUNT NAMES (about 500) with SALES BY ACCOUNT.  What is blocking this?

        • Setting up primary mobile number.

          Hi Sir Earlier I joined IIFL team and got an organizational email of zoho services. Later i quit and now my account is deactivated with IIFL but i am unable to link my mobile number to my own email id with zoho.

        • Need Easy Way to Update Item Prices in Bulk

          Hello Everyone, In Zoho Books, updating selling prices is taking too much time. Right now we have to either edit items one by one or do Excel export/import. It will be very useful if Zoho gives a simple option to: Select multiple items and update prices

        • Let's Talk Recruit: Super-charge hiring with Zoho Recruit add-ons

          Welcome back to our Let’s Talk Recruit series! This time, we’re diving into something that might seem like a small upgrade but has a huge impact on recruiter productivity: Zoho Recruit add-ons. Think about how much of your day is spent in your inbox or

        • Vendor Signatures Needed for Purchase Orders

          Hello everyone, We have a unique requirement that necessitates that Vendors & Suppliers formally acknowledge our Purchase Orders upon receipt. I was hoping that there would be an option to do so in Zoho Books, but that does not appear to be the case.

        • Is there an API to "File a Ticket" in Desk

          Hi, Is there an API to "File a Ticket" in Desk to zoho projects?

        • Store "Sign in with Google/Microsoft/GitHub etc." details

          Quite often now, users are using a sign-in provider like Google or Microsoft to sign into various apps and services. It would be great if Vault could remember which providers you use for each website and sign you in with that provider instead of a username

        • Tip of the Week #72– Assign thread ownership to avoid confusion.

          When teams handle a large volume of emails, managing threads becomes important to stay organized. Without a clear system, duplicate replies, missed follow-ups, or confusion over responsibilities can happen. Thread assignment solves this by designating

        • Unarchive tickets

          How can I manually unarchive tickets?

        • Optimize your Knowledge Base for enhanced accessibility by adding alt tags for images

          Let's learn why alt tags are crucial for your articles. You can add alternative tags (alt tags) and alternative text (alt text) to the images you share on your community forums or when embedding them in articles. Alt tags refer to the HTML attribute,

        • FSM trying again

          have not linked FSM yet to the rest of out Zoho suit. It certainly looks like the apointment and service part is more manageable for our staff. The question is that our engineers multi task examples 1. deliver products to customers not fitted 2. Service

        • Feature Request: Conditional Field Mandatoriness Based on Display Status

          Hello Zoho Creator Team, I would like to suggest an enhancement to improve the flexibility of form validations. Currently, when we need a field to be mandatory only if it's displayed on the form, the only option is to: Set the field as not mandatory in

        • Data Migration Strategies for Moving to a Cloud Solution

          Hi everyone, I’ve been working on moving some of our critical systems, including CRM and project data, to a Zoho cloud solution, and one of the biggest challenges I’ve encountered is data migration. Transferring large volumes of data while keeping it

        • Commerce Order as Invoice instead of Sales Order?

          I need a purchase made on my Commerce Site to result in an Invoice for services instead of a Sales Order that will be pushed to Books. My customers don't pay until I after I add some details to their transaction. Can I change the settings to make this

        • How to set different item selling prices for Zoho Commerce and Zoho Books

          Item selling prices for Zoho Commerce and Zoho Books are in sync. If we update the Item selling price in Books, the same will happen in commerce and vice versa. I need a separate commerce selling price for online users and a separate books selling price

        • Time Entry Notifications

          Hi All - I have support staff who place notes of their work in the time entry section of Zoho Desk. Is there a specific workflow or setting I need to enable to have the ticket holder updated via email when an entry is saved?

        • How to report 'Response violation' OR 'Resolution violation'

          Hi, I want to report on SLA Violation Type. I grouped my tickets on this column. It seems I only get 'Response and Resolution Violation' or 'Not Violated'. The former seems to be given to a ticket if only the Response Time was violated. I would expect

        • [Webinar] Automate sales and presales workflows with Writer

          Sales involves sharing a wide range of documents with customers across the presales, sales, and post-sales stages: NDAs, quotes, invoices, sales orders, and delivery paperwork. Generating and managing these documents manually slows down the overall sales

        • Power of Automation :: Quick way to associate your Projects with Zoho CRM

          A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate complex tasks and

        • Date triggering Workflow rule

          I have a function triggered by a workflow rule. The function takes a date and creates a task for that date and fills in a field with the name of the day for that date. It also updates the status field of the record. The workflow rule is set to run whenever

        • Restricting contact creation

          Hi all! I am looking to use Zoho Desk in a part of the business that takes end user enquiries. These are generally single interactions, and not linked to an account name. As Desk is Account centric, has anyone designed a way to manage these incoming emails

        • Import Holiday Calendars

          HI Zoho Is there anyway of importing an online calendar like https://www.calendarlabs.com into the business hours calendars, to speed up setup of holiday calendars. Also could we also request a feature where you can specify a Holiday as hours, i.e it could be that the company is on a 1/2 day due to a holiday or when it is Eid in the UAE and they are only allowed to work restricted hours so we need the calendar to be flexible to allow for this. Regards Jamie

        • Filtering Tickets based on Email headers

          We're starting to get a lot more junk coming into our Zoho Desk, which is then triggering unnecessary email alerts to agents. Once thing we could do to cut this junk in half, is to filter tickets based on email headers. Any email containing the `List-Unsubscribe`

        • Error 550 5.4.1

          I’ve tried sending an email to someone but keep receiving this back. Any help would be greatly appreciated 

        • Billing Management: #2 Fair way of Billing- Prorated Billing

          Hello, From speaking about the traditional ways of billing in the previous post, we are moving into the deep sea of billing. We are now in a zone to break out the most complex yet, I would call it the fairest way of billing, the Prorated Billing. Prorated

        • Has Anyone successfully integrated Zoho and Sage Intact?

          Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,

        • 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,

        • Next Page