Regex in Layout and Validation Rules

Regex in Layout and Validation Rules

Regular expressions (regex) are a sequence of characters that define a pattern. They are used to find and match similar patterns in a piece of text. In other words, regex is a set of strings that holds a particular pattern. It is commonly used to authenticate values entered by the users during submission of any form. It helps:

 

  • Increase efficiency: Regex makes it easier to find specific patterns in a large amount of data.
  • Improve data identification: Regex allows to specify the exact pattern reducing the possibility of missing or misidentification of data.
  • Facilitate reusability: Once you have created a regex pattern, you can reuse the same pattern in different contexts.
  • Maintain data accuracy: Regex can be used to validate the input data and ensure that it meets certain criteria before processing it further.

 

Some common instances where regex can be useful in validating user's input: 

  1. Email addresses: Regex can be used to validate the format of an email address. For example, the below regex pattern can be used to validate if an email address has the "@" symbol and the domain name in the right sequence. 
    ^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$

  2. Account numbers: Regex can be used to validate bank account numbers. Here's an example of a regex pattern to validate a U.S. bank account number:
    ^\d{1,17}$
    The above pattern will check whether the account numbers contain 1-17 digits.

  3. Password Strength: Regex can also be used to validate the strength of passwords. For example, the following regex pattern can be used to check for a strong password:
    ^(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[^\w\d\s:])([^\s]){8,16}$
    This regex pattern checks for a password that contains at least one digit, one lowercase letter, one uppercase letter, one special character, and is between 8 and 16 characters long.

 

In addition to creating regex pattern while defining a criteria in layout/validation rules, there's also an option to select preferred regex patterns from the regex gallery. With regex gallery, you can use the predefined regex patterns at any time, eliminating the need to create the pattern every time.

 

Following are the Regex patterns that are available in the gallery:


Regex pattern
Description

Alphanumeric Characters (letters [a-z] and digits [0-9])
This pattern ensures that the input contains a combination of lowercase letters and digits.
Example: `abc123` (contains letters and digits)

Alphanumeric Characters with Space
This pattern allows letters, digits, and spaces.
Example: `hello world123` (contains letters, digits, and a space)

Alphanumeric Characters with "-" or "_"
This pattern permits letters, digits, hyphens "-", and underscores "_".
Example: `user-name_123` (contains letters, digits, hyphen, and underscore)

Alphabets Only
This pattern accepts only lowercase or uppercase letters.
Example: `alphabetsonly` (contains letters only)

Alphabets Only with Space
This pattern allows letters and spaces.
Example: `words only` (contains letters and a space)

Numbers Only
This pattern validates that the input consists solely of digits.
Example: `123456` (contains digits only)

URL
This pattern verifies a standard URL format.
Example: `https://www.example.com` (valid URL format)

Email ID
This pattern ensures the input follows a standard email format.
Example: `user@example.com` (valid email format)

Mobile Number (10 digits, optional +91 or 0)
This pattern validates a 10-digit mobile number, optionally preceded by +91 or 0.
Example: `9876543210` or `+919876543210` (valid mobile number formats)

U.S. Postal Code
This pattern validates the common 5-digit U.S. postal code format.
Example: `12345` (valid U.S. postal code)

U.S. State
This pattern allows common U.S. state names.
Example: `California` (valid U.S. state name)

Phone Number ((xxx) xxx-xxxx format)
This pattern verifies the common (xxx) xxx-xxxx phone number format.
Example: `(123) 456-7890` (valid phone number format)

Social Security Number (xxx-xx-xxxx format)
This pattern validates the common xxx-xx-xxxx Social Security number format.
Example: `123-45-6789` (valid Social Security number format)

MAC Address
This pattern checks for the common MAC address format, separated by colons or hyphens.
Example: `00:1A:2B:3C:4D:5E` (valid MAC address format)

IP Address (both IPv4 and IPv6)
This pattern verifies both IPv4 and IPv6 address formats.
Example: `192.168.1.1` or `2001:0db8:85a3:0000:0000:8a2e:0370:7334` (valid IP address formats)

Credit Card (xxxx-xxxx-xxxx-xxxx)
This pattern validates a 16-digit credit card number format, separated by hyphens. 
Example: `1234-5678-9012-3456` (valid credit card number format)

Regex Criteria 

Regex criteria are special patterns that match the user input precisely. This regex criteria is used to find, validate, or replace specific patterns of characters in a chunk of text. Before looking into regex in layout and validation rules, let's cover the different regex criteria available.

  1. Matches Regex:

    1. When to use: This option is used when a user want to find data that precisely match a specific pattern defined using regex.
    2. What can be achieved: Matches Regex can be used to search for data that adhere to a very specific and defined pattern. For example, you could use it to find if all email addresses matches a particular alphanumeric pattern.

  2. Not Matches Regex:

    1. When to use: Not Matches Regex is helpful when a user wants to filter out data that match a particular regex pattern.
    2. What can be achieved: This option excludes data that meet a specific pattern. For instance, you might want to exclude usernames entries that contain special characters. By applying Not Matches Regex, you can easily avoid the usernames that don't align with your desired pattern.

  3. Contains Regex:
  1. When to use: The Contains Regex option is used when a user wants to find or validate data that contain a specific pattern.
  2. What Can Be Achieved: This option allows user to identify instances where a particular pattern exists within the provided text. Consider an online marketplace where sellers list products. To ensure accurate shipping information, you want to identify product listings that mention U.S. postal codes. By using Contains Regex, you can automatically detect listings that reference the five-digit format of U.S. postal codes. 

Points to Remember

 

  • A layout/validation rule can have five primary conditions, and each condition can have a separate regex criteria.
  • You cannot add the regex criteria for secondary conditions in layout and validation rule.





  • While defining the regex criteria, you can either manually create a custom regex pattern or select a pattern from the regex gallery.


Using  Regex in layout rules 

Layout rules are used to define dependency between fields or sections based on the user's input. So, when a user fills in a field, the layout progressively adds more fields or sections based on the user's input. In general, layout rules can be used to define the dynamic behavior of the layout based on a value entered in a field. See also: Creating Layout Rules in Zoho Desk.

 

While configuring layout rules, regex can be set on the primary field so that the value can be validated when entered by the user. This can be useful in determining the layout behavior based on the format of the data given and eliminates the need to create several criteria. 

 

For example, in a product purchase form a user needs to fill the credit card number, based on which a section with fields such as expiry date, card holder's name etc. is displayed. With regex, the credit card number format and pattern can be validated so that users fill a valid 16-digit number. If the field value is incorrect, the dependent section will not be displayed. 


You can create a layout rule using the below regex criteria:
Credit card number + Contains Regex + Credit Card Number


 

 To create a layout rule using regex 

  1. Navigate to Setup (  ) > Customization > Layout and Fields.
  2. Select Layout Rules from the left pane.
  3. Click Create Rule in the upper-right corners.



  4. In the Create Layout Rule window, do the following:
    1. Enter the rule name.
    2. Give a Description for the rule.
    3. Select the desired Layout.
    4. Choose a Primary field that controls this rule.
    5. Choose a Condition to initiate the rule. 
    6. Select the desired regex criteria. 
    7. You can choose from Matches Regex, Not Matches Regex, and Contains Regex (For example: Credit card Number + Contains Regex + Credit Card Number).
    8. Click Next.



  5. In the Create Layout Rule Editor, click Trigger an action and choose the desired actions from the list.
  6. In the Create Action page, click Show Fields, Show Sections, and Set Mandatory Fields, then select the respective fields.
  7.  Click Done.
    Actions in Layout Rule.
  8. Check Apply to Help Center to manage dependencies between fields when tickets are submitted through your help center.
  9. Click Save.



Using Regex in validation rules 

Validation rules ensures that valid data enters the system. If the value is incorrect, an error message prompts the user to rectify before saving the record. See also: Creating Validation Rules in Zoho Desk.

 

Using regex in validation rules, helps ensure that only those records where the user's input matches the specific pattern are saved in the system. This was, organizations can prevent invalid inputs.

 

For example, let's say you want to validate whether an end user enters an email address in a specific format, such as johnsmith123@zylker.com. In such a case, you can create a validation rule and define or choose a regex pattern that matches the format of a valid email address (Such as Email + Matches Regex + Email Address). This pattern can then be used to check whether the entered email address matches that format. 



Likewise, you can also create a regex pattern that matches email addresses ending with the zylker [your desired] domain. 

 

(?i)[a-z0-9.-]+@zylker\.com$

 

In this pattern, (?i) is a modifier that makes the pattern case-insensitive. This regular expression allows for alphanumeric characters (lowercase), periods, and hyphens in the email username. It then matches the literal string "@zylker.com", and the $ symbol specifies that the match must end with the domain name "zylker.com".

 

 To create a validation rule using regex 

 

  1. Navigate to Setup (  ) > Customization > Layout and Fields.
  2. Select Validation Rules from the left pane.
  3. Click Create Rule in the upper-right area



  4. In the New Validation Rule window, do the following:
    1. Select the desired Layout.
    2. Choose a primary field that controls this rule.
    3. Click Next.
  5. In the Create Validation Rule editor, click Add Another Option and specify the regex criteria to validate.
    You can choose from Matches Regex, Not Matches Regex, and Contains Regex. For example: Email + Matches Regex + Email Address.
  6. Click Done.





  7. Specify the necessary Alert message.



  8. Check Apply to Help Center to validate tickets submitted through your help center.
  9. Click Save.

 

Note: You can either disable or delete the layout or validation rule when not in use. When you delete a rule, it will be permanently removed and cannot be recovered.




        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          Access your files securely from anywhere

            Zoho CRM Training Programs

            Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

            Zoho CRM Training
              Redefine the way you work
              with Zoho Workplace

                Zoho DataPrep Personalized Demo

                If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

                Zoho CRM Training

                  Create, share, and deliver

                  beautiful slides from anywhere.

                  Get Started Now


                    Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                    BOOK A SESSION







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG

                                  Zoho FSM Video Tutorials


                                        All-in-one knowledge management and training platform for your employees and customers.

                                                  Create. Review. Publish.

                                                  Write, edit, collaborate on, and publish documents to different content management platforms.

                                                  Get Started Now




                                                                    You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                        Manage your brands on social media


                                                                          • Desk Community Learning Series


                                                                          • Digest


                                                                          • Functions


                                                                          • Meetups


                                                                          • Kbase


                                                                          • Resources


                                                                          • Glossary


                                                                          • Desk Marketplace


                                                                          • MVP Corner


                                                                          • Word of the Day


                                                                          • Ask the Experts


                                                                            Zoho Sheet Resources

                                                                             

                                                                                Zoho Forms Resources


                                                                                  Secure your business
                                                                                  communication with Zoho Mail


                                                                                  Mail on the move with
                                                                                  Zoho Mail mobile application

                                                                                    Stay on top of your schedule
                                                                                    at all times


                                                                                    Carry your calendar with you
                                                                                    Anytime, anywhere




                                                                                          Zoho Sign Resources

                                                                                            Sign, Paperless!

                                                                                            Sign and send business documents on the go!

                                                                                            Get Started Now




                                                                                                    Zoho TeamInbox Resources





                                                                                                              Zoho DataPrep Demo

                                                                                                              Get a personalized demo or POC

                                                                                                              REGISTER NOW


                                                                                                                Design. Discuss. Deliver.

                                                                                                                Create visually engaging stories with Zoho Show.

                                                                                                                Get Started Now








                                                                                                                                    • Related Articles

                                                                                                                                    • Creating Validation Rules

                                                                                                                                      Go to any website with a registration form, and you will notice that they provide you feedback when you don't enter your data in the format they are expecting. For example, when the phone number field on a form is not filled in or does not contain 10 ...
                                                                                                                                    • Understanding Layouts and Layout Rules

                                                                                                                                      Creating Layouts Layouts control the organization of fields and related sections on the module page of a department. Each department can have its own layout that consists of both default and custom fields. They also determine which fields are ...
                                                                                                                                    • FAQs: Validation Rules

                                                                                                                                      What is a validation rule? Validation rule provides businesses a way to ensure that the data entered by the customers and the employees is correct and meets their standards. It helps maintain data authenticity. When customers submit tickets or agents ...
                                                                                                                                    • FAQs: Assignment Rules

                                                                                                                                      Assignment basics 1. What is an assignment rule and why do I need it? Assignment rule is an automation tool that lets the support administrator automate the process of assigning tickets to agents. Customer support is a crucial job, and timely and ...
                                                                                                                                    • FAQs: Workflow Rules

                                                                                                                                      1. What is a Workflow Rule? A Workflow Rule is an automation mechanism that executes a predefined set of actions — alerts, tasks, field updates, and custom functions — when specific conditions are met on a record. Instead of requiring agents to ...
                                                                                                                                      Wherever you are is as good as
                                                                                                                                      your workplace

                                                                                                                                        Resources

                                                                                                                                        Videos

                                                                                                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                        eBooks

                                                                                                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                        Webinars

                                                                                                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                        CRM Tips

                                                                                                                                        Make the most of Zoho CRM with these useful tips.



                                                                                                                                          Zoho Show Resources