You are viewing limited content. For full access, please sign in.

Question

Question

Drop-down values can't repeat values

asked on April 23, 2020

I created a drop-down list where each choice has a corresponding numeric value representing an hourly rate. For example, if you pick "Engineer" the rate is $70/hour, so the value is 70. We then multiply the value by another field, the number of hours. It all works well with the built-in formulas in Forms. The problem is that you can't give more than one choice the same value. If you try to give another choice a value of 70, it automatically changes to 70_1, then 70_2, and so on. This will cause the calculation to fail.

 

Is there any way this can be handled without using JavaScript? I've already worked around this restriction by removing the drop-down values, handling them with an if-else statement, and doing all the math for the form in JS but it took a lot more time than I hoped to spend on this.

 

Thanks

0 0

Answer

SELECTED ANSWER
replied on April 23, 2020

Try using "70" then "70.0" and "70.00" etc. You may need to use VALUE() if you're not already.

2 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.