I am trying to build a form in Zoho Creator that firsts asks the user to choose one of three options from a drop-down menu, then assigns a value to that entry based on what the user chose from the drop-down menu.
I am currently using a conditional expression that looks like this:
- if((DropDown == "Option 1"),10,0)
The problem is that if the user picks anything but "Option 1" from the drop-down menu, the value assigned to that entry will be 0. I cannot find out how to use the "if, else if, else" expressions to assign different values to each of the three options.
Any help would be greatly appreciated!