FAQs | Conditional Formula - Zoho Forms

Performing Calculations using Formula Field

  1. Why do I get a 'Repositioning the field here will break the existing logic' error while I am designing the form?

    You will encounter this error when you try to position the conditional formula field above any of the fields involved in its configuration. Since,  the condition is checked based on the answers of those form fields, we restrict this action as it breaks the logic.

  2. Why do I get a 'Repositioning the page here will break the existing logics' error while I am designing the form?

    You will encounter this error when you try to reposition the pages that include the conditional formula field in such a way that the conditional formula is placed above the fields involved in its configuration. Since, the condition is checked based on the answers of the form fields in the page, we restrict this action as it breaks the logic.

  3. Why do I get a 'Configuring conditional formula for this field will break the existing logics' error?

    You will encounter this error when you try to set up conditional logic for an existing Formula field. This is because this formula field must be referred to another formula field in the form, which is explicitly positioned above. Converting this into a conditional formula field would break the logic because all the fields that need to be checked for the logic should be present first on the form. 

  4. I have configured one or more conditional formulas. How do I rearrange the form fields without breaking the logic?

    While rearranging the form fields, the primary condition is to ensure that you position the conditional formula field below all the fields it involves in its setup. The condition you have set up is checked based on the answers entered in those fields. For instance, if you are looking to give a discount of 20% upon the purchase of five or more t-shirts, then the form fields are arranged in such a way that the users answer to Number of Shirts field before they encounter the conditional formula field, so that based on the numbers the discount can be calculated. Now, if you try to rearrange it in a manner to bring the field below the conditional formula, it makes the logic invalid.

  5. What happens if none of the conditions I set up are met?

    If the user's answer does not meet any of the conditions, then a default expression will be performed. You will be asked for this at the time of creating a conditional formula setup itself. 

  6. How do I set my logic not to perform any discounts or alteration when none of the conditions is found to be true?

    For this, you need to set the default expression as the field's name whose value is returned when none of the conditions is met. For example, a Total Payment Amount field can be kept as the default expression when none of the discounts are processed.

  7. Can I apply logic for a formula field that is already configured with other fields?

    Yes, you can also ensure that you rearrange fields without breaking any logic. Refer to the FAQ (4) for how this is done.

  8. Can a conditional formula field be involved with another formula field?

    Yes. In the Formula field's setup, the conditional formula fields that are placed above this Formula field will be visible along with the other fields in order to pertain to the logic. 

  9. Why only specific fields are visible inside a conditional formula setup?

    In the conditional formula set up, only the fields that are positioned above this in the form will be shown for the configuration. For defining the mathematical expression, similar to the Formula field we support the listed fields:

    • Number
    • Decimal
    • Currency
    • Slider
    • Rating
    • Formula
    • Radio
    • Checkbox
    • Multiple Choice
    • Dropdown
    • Image Choice
    • Date
    • DateTime
    • Time

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

                  Zoho SalesIQ Resources

                      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

                                                          • Using the Formula Field

                                                            Overview Make your form a math wiz by allowing it to perform calculations. You can total up costs, process grade quizzes, apply discounts, and more!  Use the  Formula  field to set up any form calculation. When your respondents fill in the form, ...
                                                          • Using Conditional Formula

                                                            The conditional formula set up in Zoho Forms allows you to configure your form to perform certain calculations based on your respondents' answers. These predefined conditions are simple to set up and they will tailor your form to your user's needs. ...
                                                          • Field Properties

                                                            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 Properties , you can add or modify the following field properties: Field Label :  A field label denotes the name for ...
                                                          • Date Field

                                                            With the Date field in Zoho Forms, you can customize calendars to set the range of dates that you want to allow your respondents to choose from. You can set the starting day of all the weeks across the calendar, allow respondents to pick dates that ...
                                                          • 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 ...



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


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


                                                          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