# Forms help

**URL:** https://community.glideapps.com/t/forms-help/75102
**Category:** Ask for Help
**Created:** [July 23, 2024, 9:37am UTC](https://community.glideapps.com/t/forms-help/75102 "2024-07-23T09:37:29Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Joao\_Santos\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joao_santos_ferreira/32/40525_2.png) [@Joao\_Santos\_Ferreira](https://community.glideapps.com/u/Joao_Santos_Ferreira)
#### Post date: [July 23, 2024, 9:37am UTC](https://community.glideapps.com/t/forms-help/75102/1 "2024-07-23T09:37:29Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 23, 2024, 10:08am UTC](https://community.glideapps.com/t/forms-help/75102/2 "2024-07-23T10:08:35Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Joao\_Santos\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joao_santos_ferreira/32/40525_2.png) [@Joao\_Santos\_Ferreira](https://community.glideapps.com/u/Joao_Santos_Ferreira)
#### Post date: [July 23, 2024, 10:21am UTC](https://community.glideapps.com/t/forms-help/75102/3 "2024-07-23T10:21:17Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 23, 2024, 10:23am UTC](https://community.glideapps.com/t/forms-help/75102/4 "2024-07-23T10:23:08Z")

</div>

Yes, that’s correct.

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [July 30, 2024, 10:23am UTC](https://community.glideapps.com/t/forms-help/75102/5 "2024-07-30T10:23:47Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.