# Multi User Calculator

**URL:** https://community.glideapps.com/t/multi-user-calculator/14452
**Category:** Ask for Help
**Created:** [August 23, 2020, 12:44am UTC](https://community.glideapps.com/t/multi-user-calculator/14452 "2020-08-23T00:44:09Z")
**Posts on this page:** 13
**Page:** 1

<div class="post-metadata">

### Author: ![Koenner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/koenner/32/12354_2.png) [@Koenner](https://community.glideapps.com/u/Koenner)
#### Post date: [August 23, 2020, 12:44am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/1 "2020-08-23T00:44:09Z")

</div>

My goal is to have a simple gSheets based calculator that is publicly available and usable by multiple users simultaneously. I am open to different ways of doing this, but my approach so far is like this:

-Have 3 unique numerical input fields  
-Have 1 numerical output field

The issue I am having is that:

1. Input from one user overrides the input from another user, so it can only be used by one user at a time.
2. The output field is very slow to update. It takes about 6 seconds to multiply 3 triple-digit values together on the Glide portal. Note that the output field in gSheets updates instantaneously.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [August 23, 2020, 12:59am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/2 "2020-08-23T00:59:21Z")

</div>

Hi,

Take a look at this demo [https://multicalc.glideapp.io](https://multicalc.glideapp.io) and use it

Saludos

---

<div class="post-metadata">

### Author: ![Koenner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/koenner/32/12354_2.png) [@Koenner](https://community.glideapps.com/u/Koenner)
#### Post date: [August 23, 2020, 1:41am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/3 "2020-08-23T01:41:53Z")

</div>

Is there a way to do this without generating a new row each time the calculation is performed? The app may have several thousand users.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [August 23, 2020, 2:20am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/4 "2020-08-23T02:20:20Z")

</div>

Yes, of course!

Sorry, I didn’t remember that this APP was using the old way/technique.

Now using the user-specific columns you can do it in the way you want.

Saludos

---

<div class="post-metadata">

### Author: ![Koenner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/koenner/32/12354_2.png) [@Koenner](https://community.glideapps.com/u/Koenner)
#### Post date: [August 23, 2020, 2:35am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/5 "2020-08-23T02:35:14Z")

</div>

In the Basic Table component, how were you able to create those math functions? I would need to create a Trig function.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [August 23, 2020, 2:53am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/6 "2020-08-23T02:53:25Z")

</div>

Using a Math column you can create basic math operations (addition, subtraction, multiplication and division).  
Something like this

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2402b4da412786dddb7cc455afddc87a3210e3d4.png)

Create 2 new user-specific columns to save the values there and later, use a Math column to get your operation by using them.

Chao @Koenner

---

<div class="post-metadata">

### Author: ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)
#### Post date: [August 23, 2020, 11:38am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/7 "2020-08-23T11:38:19Z")

</div>

Just wrote about this use-case exactly, for a client:

> <https://twitter.com/sardamit/status/1297484538768003072>

---

<div class="post-metadata">

### Author: ![Koenner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/koenner/32/12354_2.png) [@Koenner](https://community.glideapps.com/u/Koenner)
#### Post date: [August 24, 2020, 5:43am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/8 "2020-08-24T05:43:18Z")

</div>

Is there a way for the calculations to be done in gSheets without a ~6 second delay for the results to show on Glide. It seems like it would be preferable to do it that way, if you’re limited by what math functions are available. My calculator requires inverse tangent and a multi-variable equation, which is quite easy to do in gSheets.

---

<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: [August 24, 2020, 10:10am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/9 "2020-08-24T10:10:19Z")

</div>

There must be a sync back and forth to update it, so I don’t think there’s a way.

---

<div class="post-metadata">

### Author: ![Koenner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/koenner/32/12354_2.png) [@Koenner](https://community.glideapps.com/u/Koenner)
#### Post date: [August 31, 2020, 7:34am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/10 "2020-08-31T07:34:16Z")

</div>

Any thoughts on how to truncate a math value from 4 significant figures to 3 sig. figs? The value must be 3 sig. figs. and not just displaying 3 sig. figs. The function library really needs to grow!

---

<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: [August 31, 2020, 9:41am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/11 "2020-08-31T09:41:21Z")

</div>

Use 3 significant figures for your math column, then use a template column referencing that math column to lock it in.

---

<div class="post-metadata">

### Author: ![Koenner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/koenner/32/12354_2.png) [@Koenner](https://community.glideapps.com/u/Koenner)
#### Post date: [September 1, 2020, 7:24am UTC](https://community.glideapps.com/t/multi-user-calculator/14452/12 "2020-09-01T07:24:56Z")

</div>

Brilliant! Thank you

---

<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: [January 27, 2024, 6:44pm UTC](https://community.glideapps.com/t/multi-user-calculator/14452/13 "2024-01-27T18:44:41Z")

</div>


