# Calculate price from the form - How can I achieve it?

**URL:** <https://community.glideapps.com/t/calculate-price-from-the-form-how-can-i-achieve-it/72428>\
**Category:** Ask for Help\
**Created:** [April 9, 2024, 4:13pm UTC](https://community.glideapps.com/t/calculate-price-from-the-form-how-can-i-achieve-it/72428 "2024-04-09T16:13:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Huzefa\_Mithaiwala](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/huzefa_mithaiwala/32/73322_2.png) [@Huzefa\_Mithaiwala](https://community.glideapps.com/u/Huzefa_Mithaiwala)\
**Post date:** [April 9, 2024, 4:13pm UTC](https://community.glideapps.com/t/calculate-price-from-the-form-how-can-i-achieve-it/72428/1 "2024-04-09T16:13:57Z")

</div>

I want users to select from existing records and retrieve price value from the same table

 ![Screenshot 2024-04-09 at 7.08.15 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/ca77b528dc97b3e3b9991c3e993e4b7f7c46a25a.jpeg)

 ![Screenshot 2024-04-09 at 7.09.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/efef895474848713ca45fa3b1d64cfc8e9fc7785.png)

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [April 9, 2024, 11:01pm UTC](https://community.glideapps.com/t/calculate-price-from-the-form-how-can-i-achieve-it/72428/2 "2024-04-09T23:01:23Z")

</div>

Hello Huzefa 👋

- To calculate, use the math column.
- To lookup a column based on data in other columns (which is what you seem to be doing), use a one-line table with a query column and filters in that query column.

> **[Math Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/math-column)**
>
> Perform instant calculations using the data in your app.

> **[Query Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/query-column)**
>
> Create complex relations in your data with conditional filtering, sorting, and limits.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 9, 2024, 11:54pm UTC](https://community.glideapps.com/t/calculate-price-from-the-form-how-can-i-achieve-it/72428/3 "2024-04-09T23:54:21Z")

</div>

Are those pre-calculated prices? Is there a general formula so you can use a math column instead?