Forms help

[Joao_Santos_Ferreira]

Hi All,

I’m a newly user of glide, I’m creating a new app for own use. but I’m facing an issue that I can’t solve.
My app have some forms, and in one of the form the user should choose a specific item (with a choice component) and I want the value to be recorded in the form column is the correspondent value (like price) of that item.

imagine I have a table with:
apple → 1€
orange → 2€
banana → 3€

in the form the user chose banana and quantity. The value that should be stored after submit in the “purchase order” will be:
item - price - quantity
banana - 3€ - 1

is there a way to achieve this?

Thanks for your help.

[Darren_Murphy]

Will the prices change?
If not, then you can just store the item and quantity, then use a combination of relation, lookup and math columns to calculate the amount.

[Joao_Santos_Ferreira]

Thanks @Darren_Murphy

So, if I understood well, the relation, lookup and math will be done on the purchase order. In the form, user will choose the quantityand item. It will store into the purchase order and then the formulas will do the rest. Am I right?

[Darren_Murphy]

Yes, that’s correct.