# Display the result of column math

**URL:** <https://community.glideapps.com/t/display-the-result-of-column-math/19884>\
**Category:** Ask for Help\
**Created:** [December 15, 2020, 5:16am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884 "2020-12-15T05:16:42Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [December 15, 2020, 5:16am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/1 "2020-12-15T05:16:42Z")

</div>

In a layout when you create a new item, Display the result of column math can be displayed, while the item is being created

---

<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:** [December 15, 2020, 6:24am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/2 "2020-12-15T06:24:48Z")

</div>

Your question (?) isn’t very clear. Are you able to expand a little bit, or perhaps provide a screen shot that helps to better explain what it is that you need help with?

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [December 15, 2020, 6:35am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/3 "2020-12-15T06:35:29Z")

</div>

![Captura](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d6555c059b70d8f560879ef41074eb21e2ac8f64.png)

---

<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:** [December 15, 2020, 6:45am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/4 "2020-12-15T06:45:17Z")

</div>

Okay, I see.  
So Total is a math column that sums the highlighted fields, yes?

I may be wrong here, but I believe that when using the form component, the new row isn’t actually created until the “Add” button is tapped and the form submitted. So while the form is still being filled in, there are no values in those columns.

What you could do is build your own form and temporarily store the values in user-specific columns. These would be populated immediately as the user enters the values and you could use them to calculate and display the total.  
Then when the user submits, you use a compound action to Add a Row and clear the user specific columns.

(NB. I haven’t actually tried using a compound action in this way, but I believe it should work)

---

<div class="post-metadata">

**Author:** ![Luis\_Siles](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luis_siles/32/9384_2.png) [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)\
**Post date:** [December 15, 2020, 6:55am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/5 "2020-12-15T06:55:00Z")

</div>

Ohh I see, que ok thanks let me try

---

<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:** [December 15, 2020, 7:26am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/6 "2020-12-15T07:26:45Z")

</div>

I just tested that quickly, and it does work as I described.

![Screen Shot 2020-12-15 at 3.22.04 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f07af22897fec8e903f72e672fb67813244c428.png)

Item 1 & Item 2 are the two user specific columns, and Total is the sum of those two.

 ![Screen Shot 2020-12-15 at 3.21.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/771460a70e299db05218ee7d13db3bf82d85f5c0.png)

In the layout, I used an Action Text component for the total. It’s initially hidden (because it’s empty), but as soon as you enter the Item 1 & Item 2 values it appears.

You would then add a button (or whatever) for submitting the form, with a compound action attached. That action would Add a new row to the appropriate sheet.

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [December 15, 2020, 8:21am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/7 "2020-12-15T08:21:30Z")

</div>

Maybe you could do that with a details view and add a number entry…right? That way, there’s no form and you’d get the results as you go. Am I right? Haven’t tested, I’m thinking as I write…

---

<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:** [December 15, 2020, 9:23am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/8 "2020-12-15T09:23:51Z")

</div>

This is true. You can only get live computations with user-specific columns so the way Darren noted above would be the only way.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 12, 2024, 2:03am UTC](https://community.glideapps.com/t/display-the-result-of-column-math/19884/9 "2024-01-12T02:03:39Z")

</div>


