Select Dropdown choice with IF

  • Resolved KevinX

    (@designcat)


    3 years, 5 months ago

    Hi, I was not able to find a documentation for Dropdowns: How can I multiply something with different numbers based on the selected choice?

    100 * IF(fieldname4 == "Text1", 1, IF(fieldname4 == "Text2", 2,1))
    This did not work.

    Thank you very much, Kevin

    • This topic was modified 3 years, 5 months ago by KevinX.
    • This topic was modified 3 years, 5 months ago by KevinX.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @designcat

    Every dropdown choice has associated two entry boxes for the choice’s text and value. The equations always use the choice’s value, not its text. So, you should enter the 1 and 2 as the values of the corresponding choices, and the equation would be:

    100*fieldname4

    However, if the values of the choices of the dropdown field were Text1 and Text2, your equation would be correct. Please, send me the link to your form to check its structure.

    Best regards.

    Thread Starter KevinX

    (@designcat)

    Hi @codepeople awesome it works with 100*fieldname4, I was just not smart enough to understand that the value behind the selection can simply be used for multiplying. ??

    Love your support and the plugin!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Select Dropdown choice with IF’ is closed to new replies.