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'