# How to auto calculate with unique formula/math equation after choices selected

**URL:** <https://community.glideapps.com/t/how-to-auto-calculate-with-unique-formula-math-equation-after-choices-selected/67594>\
**Category:** Ask for Help\
**Created:** [November 7, 2023, 5:32pm UTC](https://community.glideapps.com/t/how-to-auto-calculate-with-unique-formula-math-equation-after-choices-selected/67594 "2023-11-07T17:32:14Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shaffizan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shaffizan/32/66173_2.png) [@Shaffizan](https://community.glideapps.com/u/Shaffizan)\
**Post date:** [November 7, 2023, 5:32pm UTC](https://community.glideapps.com/t/how-to-auto-calculate-with-unique-formula-math-equation-after-choices-selected/67594/1 "2023-11-07T17:32:14Z")

</div>

How to auto calculate with unique formula/math equation after choices selected

Hello, I notice some topic covered already. But I’m not sure if its really what I need.

Anyway, this is what I plan

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4abd1bb5700246c27c835403468ee5ca244053dc.png)

After user keyin number in (1), make choice of option in step (2), and all the column in (3) will automatically calculated accordingly.

of course when the same choice have been made the selected column in step (3) will use the same value as keyin, instead of using the formula.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9a68e95220afbbedcfeb9dfbffadf8af94ebd0a0.png)

please help

---

<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:** [November 7, 2023, 11:28pm UTC](https://community.glideapps.com/t/how-to-auto-calculate-with-unique-formula-math-equation-after-choices-selected/67594/2 "2023-11-07T23:28:15Z")

</div>

Can you explain more about how the choice in step 2 will affect the number in step 3?

---

<div class="post-metadata">

**Author:** ![Shaffizan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shaffizan/32/66173_2.png) [@Shaffizan](https://community.glideapps.com/u/Shaffizan)\
**Post date:** [November 8, 2023, 3:11am UTC](https://community.glideapps.com/t/how-to-auto-calculate-with-unique-formula-math-equation-after-choices-selected/67594/3 "2023-11-08T03:11:29Z")

</div>

Hi, thanks for reply.

for example as image below

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/85a4934443bec25d3aa21f3722b4abc010b6628c.jpeg)

Let say i put number 250 in the entry box, and choose ‘relong’. All the sqft, sqm, acre and hectare will automatically calculate as it change units.

when i put 250 and click ‘relong’, meaning, this 250 is in relong unit. so the field area above will maintin the 250 for relong table. While the sqm, acre and hectare will calculate accordingly base on formula i set up later.

same goes if I click sqft. so i write down 250 and click sqft. Meaning, right now 250 is in sqft unit. Table field above will maintain the 250 sqft and relong, sqm, acre and hectar to calculate accordingly as the 250 in different units.

---

<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:** [November 8, 2023, 3:14am UTC](https://community.glideapps.com/t/how-to-auto-calculate-with-unique-formula-math-equation-after-choices-selected/67594/4 "2023-11-08T03:14:02Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a967c2363154902184ecbbac80d291ff7b46a378.png)

Got it, you should do this instead.

Set the right column to the “from” part, the “to” unit will be static.

---

<div class="post-metadata">

**Author:** ![Shaffizan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shaffizan/32/66173_2.png) [@Shaffizan](https://community.glideapps.com/u/Shaffizan)\
**Post date:** [November 8, 2023, 2:09pm UTC](https://community.glideapps.com/t/how-to-auto-calculate-with-unique-formula-math-equation-after-choices-selected/67594/5 "2023-11-08T14:09:01Z")

</div>

Hello, how can I make it visible on front end?

I paste the link from glide plugin already as below

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9de53c6bb79bcc286b878545ac9cf04d371efa58.png)

but compenent should I select to show it

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3a34b1f96d49de1c742ea6816d8536e187e24fd.jpeg)

please help

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 8, 2023, 2:13pm UTC](https://community.glideapps.com/t/how-to-auto-calculate-with-unique-formula-math-equation-after-choices-selected/67594/6 "2023-11-08T14:13:06Z")

</div>

That column should be added to your ‘Sizes Calculator’ table and used to convert the number before using it in your calculations.