Hello again, im confused about how these work when they have more than 2 variables. For example, when i have only 1 variable its plain easy since i can just use (fieldname3==’cat’?250:500) meaning that cat=250 and the 2nd variable=500.
But if i have 3 variable lets say, i cant do (fieldname3==’cat’?250:500:1000) [meaning that the 3rd variable i added equals 1000]. I cant do this because the formula wont work.
Now… after checking the “calculation with dates” example that the plugin has, i realized that i can easily give each dropdown/checkbox variable a value by just putting the # of the value next to the name at the fields, to make it more easy to understand this is what i mean: http://puu.sh/2Fjny.png
But my problem is i dont want the numbers to appear in the calculator, and they do appear if i do it the way “calculation with dates” do it.
So is there a way i can do it without the numbers showing? Maybe someway to “nest” the first formula i was trying (i tried to nest it, didnt work the multiple ways i tried). By first formula i refer to this: (fieldname3==’cat’?250:500)
Thank you very much!
- The topic ‘Values in Dropdown/Checkboxes fields’ is closed to new replies.