Converting text values to real values
-
Hello again!
In one of my dropdowns <%fieldname11%>, I have five different options:
[Text] Choose one… [Value] 0
[Text] First option [Value] firstoption
[Text] Second option [Value] secondoption
[Text] Third option [Value] thirdoption
[Text] Fourth option [Value] fourthoptionI need those text values to stay intact for later use, but I also need a calculated field to turn those text options into regular values like so:
IF fieldname11 is value 0 return ‘Please make an option’
IF fieldname11 is value firstoption OR secondoption return 10
IF fieldname11 is value thirdoption OR fourthoption return 20Cheers!
The topic ‘Converting text values to real values’ is closed to new replies.