I am looking to have a user be able to select from two drop down fields. Based on the combination of values that are selected from the fields above, a price/number is generated to the user. It is not a calculation - the value is static based on the combination selected in the first two fields.
For example:
Field 1 (dropdown): Olive Oil, Apricot Oil, Sunflower Oil
Field 2 (dropdown): 2 Fl Oz, 4 Fl Oz, 8 Fl Oz
If “Olive Oil” + “4 Fl Oz” then the result is $4
If “Olive Oil” + “8 Fl Oz” then the result is $7
If “Apricot Oil” + “4 Fl Oz” then the result is $10
If “Apricot Oil” + 8 Fl Oz" the the result is $20
Can this be done natively or with an app? I’ve tried using the “Calculator” apps, but since it’s not a true calculation is is proving difficult.
Thanks!