# About Math Column

**URL:** <https://community.glideapps.com/t/about-math-column/58858>\
**Category:** Ask for Help\
**Created:** [March 7, 2023, 4:52am UTC](https://community.glideapps.com/t/about-math-column/58858 "2023-03-07T04:52:34Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![atiwat\_tangchaiwatta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atiwat_tangchaiwatta/32/22191_2.png) [@atiwat\_tangchaiwatta](https://community.glideapps.com/u/atiwat_tangchaiwatta)\
**Post date:** [March 7, 2023, 4:52am UTC](https://community.glideapps.com/t/about-math-column/58858/1 "2023-03-07T04:52:34Z")

</div>

I am trying to use Math Column to be simple calculator for my worker , I can’t call it in my Form Screen . I already made Math column in my sheet , please 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:** [March 7, 2023, 5:02am UTC](https://community.glideapps.com/t/about-math-column/58858/2 "2023-03-07T05:02:36Z")

</div>

Are you wanting to use form values in a calculation and display the results _before_ the form is submitted?

That is not possible, because form values are not written to the underlying table until _after_ the form is submitted.

To do this, you would need to use a [custom form](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014).

Can you describe your use case in a little more detail?

---

<div class="post-metadata">

**Author:** ![atiwat\_tangchaiwatta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atiwat_tangchaiwatta/32/22191_2.png) [@atiwat\_tangchaiwatta](https://community.glideapps.com/u/atiwat_tangchaiwatta)\
**Post date:** [March 7, 2023, 5:06am UTC](https://community.glideapps.com/t/about-math-column/58858/3 "2023-03-07T05:06:47Z")

</div>

Thanks for your reply , my case is I trying to create form that my worker to submit total amount of arrival materials  
Example

1. Material A , one box contains of 50 pcs( a) , and there will be some remaining (b )  
So my Math column 2 is (50\*a) + b  
There are about 5 Material so i trying to make 5 Math columns

---

<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:** [March 7, 2023, 5:11am UTC](https://community.glideapps.com/t/about-math-column/58858/4 "2023-03-07T05:11:43Z")

</div>

The important question is - do you actually need the results of the math columns _before_ the form is submitted, or can you just apply the calculations to the submitted data and use it afterwards?

---

<div class="post-metadata">

**Author:** ![atiwat\_tangchaiwatta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atiwat_tangchaiwatta/32/22191_2.png) [@atiwat\_tangchaiwatta](https://community.glideapps.com/u/atiwat_tangchaiwatta)\
**Post date:** [March 7, 2023, 5:19am UTC](https://community.glideapps.com/t/about-math-column/58858/5 "2023-03-07T05:19:49Z")

</div>

Oh , sorry for misunderstanding

1. Yes , my first plan is to show before sunmit
2. Another question, example i got 15 kinds of material but each day not all kind of material to deal with .  
Example
3. Today only 7 kinds of material come , after submitting form I want table only the 7 material ( any material that value is not zero) if it possible to make table like that ?

---

<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:** [March 7, 2023, 7:19am UTC](https://community.glideapps.com/t/about-math-column/58858/6 "2023-03-07T07:19:08Z")

</div>

> [@atiwat\_tangchaiwatta](#):
>
> Yes , my first plan is to show before sunmit

Okay, so my original answer stands. The only way to do that is to use a custom form.

> [@atiwat\_tangchaiwatta](#):
>
> - Another question, example i got 15 kinds of material but each day not all kind of material to deal with .  
> Example
> - Today only 7 kinds of material come , after submitting form I want table only the 7 material ( any material that value is not zero) if it possible to make table like that ?

How are you currently recording this?  
Can you show me what it looks like inside the Glide Data Editor?

---

<div class="post-metadata">

**Author:** ![atiwat\_tangchaiwatta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atiwat_tangchaiwatta/32/22191_2.png) [@atiwat\_tangchaiwatta](https://community.glideapps.com/u/atiwat_tangchaiwatta)\
**Post date:** [March 7, 2023, 7:25am UTC](https://community.glideapps.com/t/about-math-column/58858/7 "2023-03-07T07:25:07Z")

</div>

![11111](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e08814af7893a1afcd0f96ecad954aab8150cb01.jpeg)  
 ![1111](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d16108f5bc155078c6845099a15c721ded8b94e6.jpeg)  
Ok , like these
