Add value in field and show different content on front end

[Saima_Gul]

In the Tax Value field, I want to add 2 values in the sheet as shown in the image, but on the front end, I want to add the title "Tax option 1" for 0.02 and "Tax option 2" for 0.03

[TeeSee1 · Accepted solution]

One way you can do it is 

• create another field of type ENUM with values, Tax Option 1 & 2. Show this in your UX
• create a field that holds the real tax value with an AppFormula (i.e. SWITCH) that calculates the appropriate value based on the selection of the first field. You can hide this field from your UX