1 Reply Latest reply on Apr 6, 2012 10:18 AM by Brian Havlin

    Can the "IF function used in Microsoft Excel" be used in FormsCentral?

    jsamps28

      The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.

       

      For example: I want the person filling out my form to be directed to the proper next selection.

       

      Question: What type of vehicle are you interested in?

       

      Choices: Car, Truck, Bicycle

       

      If Car is selected, a drop down list of car manufacturers will appear.

       

      Choices: Ford, Chevolet, Toyota

       

      If Ford is selected, a drop down list of Ford cars will appear.

       

      Choices: Mustang, Fusion, Focus

       

      Thanks in advance for all who reply!

        • 1. Re: Can the "IF function used in Microsoft Excel" be used in FormsCentral?
          Brian Havlin Adobe Employee

          You can make form items conditional by clicking the "Show / Hide Item" checkbox in the property panel, highlighted in the following screenshot.

           

          showhide.png

           

          When you enable that option you will be presented with a dialog that allows you to specify the conditions that control the visibilty of the item.

           

          rule.png

           

          In the screenshot above, you can see that the rule has been configured to show the "Select the car manufacturer" field if the user selects the "Car" option in the "What type of vehicle are you interested in?" field.

           

          Regards,

          Brian