If then logic in Smart Forms

While I am aware of functionality that certain fields can be hidden / unfilled / unrequired when an option on another field is not met, I am wondering if forms does have capability of if then logic.

For example:

  • If component RRH is chosen, email field is locked to abc@yahoo.com
  • If component ECS is chosen, email field is locked to xyz@yahoo.com
  • If any other component is chosen, email field is unlocked for entry

Any help you can provide would be much appreciated.

Answers

  • Hi @fahadskazi,

    I think you can do this in two ways but they are work arounds to what you are trying to do.

    1.) Have 3 separate columns, one for each email. When RRH is chosen then e a column field pops and the only option is abc@yahoo.com. Same for ECS. Then create logic in the form when something or than RRH/ECS is selected pop the third column field which allows the user to enter an email

    2.) Similar to above but with less columns, create logic in the form when something or than RRH/ECS is selected pop the column field which allows the user to enter an email. Then in the sheet it's self, write a formula in the email column that will populate it with the correct email when RRH or ECS is chosen in the form.


    Hope this helps!


    James