Field to Field Comparison

Field-to-Field Comparison

Overview 

Field-to-Field Comparison in Advanced Rules allows users to compare the values of two fields dynamically. This feature is particularly useful in scenarios where conditions depend on the relationship between two fields rather than pre-configured values.

Let's use an example to understand this better:
A customer receives an email from their bank with a link to a pre-approved loan offer of 500,000. The link redirects them to a loan request form, where they are required to fill out the Required Loan Amount field.



If the Required Loan Amount is less than or equal to the Pre-approved Loan Amount, the user can submit the request, and the loan will be auto-processed.



However, if the Required Loan Amount is greater than the Pre-approved Loan Amount (for example, 600,000), the bank requires the customer's income proof to process the loan. In this case, the Upload Income Proof field will be displayed dynamically to the customer.

Let's look at how it can be configured via Field Rules:
  1. Navigate to the Rules tab and under Field Rules, click Configure Now.
  2. Click Switch to Advanced Rules.
  3. Select the primary field as Required Loan Amount.
  4. To choose the secondary field for comparison, click the Choose Field Icon on the rightmost side and select the desired field, which in this case is Pre-approved Loan Amount.
  5. Select the dependent field as Upload Income Proof.


  6. Click Save once you're done. The form is now ready to use. Learn more about configuring rules 

Supported Field-to-Field Comparisons

The following table lists the field types, their supported operators, and the supported fields available for Field-to-Field comparison to form a rule criterion in the 'If' section:
  

Field Types

Supported Operators

Supported fields for comparison

Single Line

  • Is

  • Is Not

  • Single Line

  • Number

  • Phone

  • Email

  • Date

  • Time

  • Date-Time

  • Month-Year

  • Website

  • Slider

  • Rating

  • DropDown

  • Name (Elements only)

  • Address (Elements only)

  • Radio

 

Number

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Number

  • Decimal

  • Currency

  • Slider

  • Rating

  • Formula

Decimal

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Number

  • Decimal

  • Currency

  • Slider

  • Rating

  • Formula

Phone

  • Is

  • Is Not

  • Phone

Email

  • Is

  • Is Not

  • Email

Date

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Date

  • DateTime

Time

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Time

Date-Time

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Date

  • Date-Time

Month-Year

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Month-Year

Website

  • Is

  • Is Not

  • Website

Currency

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Number

  • Decimal

  • Currency

  • Slider

  • Rating

  • Formula

Slider

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Number

  • Decimal

  • Currency

  • Slider

  • Rating

  • Formula

Rating

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Number

  • Decimal

  • Currency

  • Slider

  • Rating

  • Formula

Formula

  • Is

  • Is Not

  • Is Less Than

  • Is Greater Than

  • Is Less Than or Equal To

  • Is Greater Than or Equal To

  • Number

  • Decimal

  • Currency

  • Slider

  • Rating

  • Formula

  • Name (Elements only)

    • Title

    • First Name

    • Last Nam

    • Middle name

  • Is

  • Is Not

  • SingleLine

  • Name (Elements only)

    • Title

    • First Name

    • Last Name

    • Middle name

 

Address (Elements only)

  • Street address

  • Address Line 2

  • City

  • State

  • Zip code

  • Country

  • Is

  • Is Not

  • SingleLine

  • Address (Elements only)

    • Street address

    • Address Line 2

    • City

    • State

    • Zip code

    • Country

DropDown

  • Is

  • Is Not

  • Radio

  • Dropdown

DecisionBox

  • Is

  • Is Not

  • DecisionBox

  • Terms and Conditions

Radio

  • Is

  • Is Not

  • Radio

  • Dropdown

Terms and Conditions

  • Is

  • Is Not

  • DecisionBox

  • Terms and Conditions

  

Notes:
  1. This feature is supported only if you have switched to Advanced Rules.
  2. The dependent field, that's shown or hidden based on the field-to-field comparison, should be placed after the two fields being compared in the builder—this applies to Field Rules only.
  3. If a Date field and a Date-Time field are being compared, only the Date value is used for comparison.
  4. The following field types are not supported in Field-to-Field Comparison: MultiLine, Multiple Choice, Matrix Choice, Image Choice, Checkbox, and Signature. Ensure that the fields you want to compare are supported and listed here.
  5. For Phone fields, if both sides include the country code, the phone number with the country code will be compared. Otherwise, only the phone number will be considered.
  6. When comparing two Dropdown fields, if both use Group Choices, the comparison is based on the choice along with the group name. Otherwise, only the choice value will be compared.
  7. The Name and Address fields cannot be used directly in Field-to-Field Comparison. Only their individual elements (First Name, Last Name, City, State, etc.) can be used for comparison.
In addition to Field RulesField-to-Field Comparison is also supported in Form Rules, Page Rules, Deny Submissions & Rules in Form Approvals

      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 FormsLegalMobile App
                              Form DesignerHRMobile 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 FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      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

                                                              Use cases

                                                              Make the most of Zoho Desk with the use cases.

                                                               
                                                                

                                                              eBooks

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

                                                               
                                                                

                                                              Videos

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

                                                               
                                                                

                                                              Webinar

                                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                               
                                                                
                                                              • Desk Community Learning Series


                                                              • Meetups


                                                              • Ask the Experts


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner

                                                                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

                                                                                                                        • Field Rules

                                                                                                                          Overview Using the Field Rules, you can choose to show or hide certain form fields to your respondents or set certain fields as mandatory to fill in based on their previous responses on the form. This way, you can let your respondents see only the ...
                                                                                                                        • Field Properties

                                                                                                                          Table of Contents Overview Dynamic Field Labels Rename Uploaded Files Assign Values to Choices Import Choices Group Choices Choice Availability Overview You can set the properties to customize each field added to your form. To do so, click the field ...
                                                                                                                        • Terms and Conditions Field

                                                                                                                          Whenever you collect users' data via forms on your websites, blogs, or e-commercials, it is recommended that you have your user's consent before you share their data to avoid any legal disputes, privacy concerns, or security risks. To allow users to ...
                                                                                                                        • Zoho CRM Field

                                                                                                                          The Zoho CRM field is a lookup field that helps you fetch data from a Zoho CRM module and prefill your form fields. Prefilling forms with data simplifies the form filling experience for your respondents and saves time. You can also push form entries ...
                                                                                                                        • Field Alias - Prefill URL

                                                                                                                          Table of contents What is prefilling form fields? Why is prefilling forms important? What is Field Alias? Set Field Alias Generate a prefilled form URL Manually create the URL of a prefilled form Prefill a Multiple Choice Field Prefill a Dropdown ...
                                                                                                                          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