Field Rules with Subform Fields

Field Rules with Subform Fields

If you wish to use the fields within a Subform of your form while configuring the Field Rules, you will have to to switch to Advanced Rules.

Let us look into a few scenarios to understand how Field Rules can be used with subform fields.

Using Subform fields in both the Condition and Action of a Field Rule

You have a Subform within your Job Application form with a section to provide education qualifications. It includes fields for selecting a qualification and entering a University name. You want to ensure that if a user selects a qualification, they provide the corresponding University name.

Field Rule:
Condition: If Qualification (subform field) is not empty
Action: Show School/University Name (subform field)

This rule checks if the Qualification field within the Subform is filled. If a qualification is selected, only then it shows up the School/University Name and the Year Completed fields in that Subform row. If the University Name is left blank while a Qualification is selected, an error message will be thrown to prompt the user to provide the missing information.

When using Subform fields in both the condition and action of a Field Rule, the rule will be evaluated for each row added in the subform, and the action will be performed accordingly. This allows you to apply the condition and action to each individual row within the subform.

Subform Field Rules

Using a Form field in the Condition and a Subform field in the Action

You have a form to order a gift where you let the users choose if they want to include flowers and chocolates. You have a Subform within this form to get additional details about the flowers and chocolates. If the user selects to include only flowers, then hide the column that asks for details about chocolates. This ensures that when the user chooses only flowers, they won't see or be prompted for information about chocolates. This ensures that when the user chooses only flowers, they won't see or be prompted for information about chocolates.

Field Rule:
Condition: If Include Flowers (form field) is selected
Action: Hide Select Chocolates (subform field)

Field Rule with Subform field

When using a form field in the condition and a Subform field in the action, the Field Rule evaluates the condition based on the the form field, and then the action is performed on all rows of the subform.

Note: When using 2 rules to execute action on a subform field, the rule with the form field in the condition takes priority and is evaluated first.

Points to remember

  1. A Condition field must be placed prior to the Action field.
  2. If a Formula field is used in the rules, field(s) involved in a formula must be placed prior to the Formula field in the form.
  3. Once you choose a particular action (Show/Hide) for a field, you will have to continue using the same action on that field in any rule elsewhere. For example, if you choose to Hide the Phone  field, you must use the Hide action to use the Phone field elsewhere in the Then section.
  4. Rules are case-sensitive which means the conditions trigger actions only when the case of the text in the defined condition matches the case of the respondent input. Check out an example to understand this better.
  5. A rule condition cannot include fields from multiple Subforms of the same form.
  6. If you use a Subform field in a condition, only the fields of the same subform can be used in the action of that rule.
  7. If all of the fields used in a condition's rule are form fields and do not involve any subform fields, you can use any subform's fields in the rule's action.
  8. The Subform field used in the condition must be placed prior to the subform field used in the action of that rule.

    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









                                            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

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      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 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 ...
                                                                                                              • Subform

                                                                                                                Table of Contents Overview Adding a Subform Subform Entry Limit Validate Duplicates in Subform Serial Numbers for Subform Entries Sum of Field Entries in Subform Types of Subform Overview A Subform is a secondary form that lets you add multiple line ...
                                                                                                              • Form Rules

                                                                                                                With the Form Rules, you can choose to trigger different actions upon form submission if the defined conditions are satisfied. You can automatically trigger emails, assign tasks, decide on the Thank You page to be displayed or redirect the ...
                                                                                                              • Advanced Fields

                                                                                                                In your form builder, Advanced fields list certain complex fields that help you perform calculations, collect Payments, capture digital signatures, and more. The fields listed in the table below are available under Advanced Fields . The table column ...
                                                                                                              • Field Properties

                                                                                                                Table of Contents Overview Dynamic Field Labels Rename Uploaded Files Assign Values to Choices Group Choices Overview You can set the properties to customize each field added to your form. To do so, click the field on your form builder. Under ...
                                                                                                                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