App Connect Data Formatter Support Product Page

Converting "Math" Values in Select Form back to "Human Value"

Asked 01 Jul 2025 18:31:04
1
has this question
01 Jul 2025 18:31:04 Bobby Edgar posted:
I have select forms that work for calculations. Each option has a value of "x" that represents the label for that option.

Like: <option value="0.063">1/16in"</option>

Math works great, but I want to save the label to the database instead of the value because it's just for my statistical purposes.

I can create a hidden input and pull the value from the select and use the input for the database, but how do I reverse "engineer" the value?

Like: If select value == '0.063' then input value == '1/16in' || If select value == '0.125' then input value == '1/8in'

Reply to this topic