# Any thoughts on a Glide version of calculator?
**URL:** https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919
**Category:** Ask for Help
**Created:** [March 26, 2020, 8:22pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919 "2020-03-26T20:22:26Z")
**Posts on this page:** 18
**Page:** 1
### Author:  [@gangyao](https://community.glideapps.com/u/gangyao)
#### Post date: [March 26, 2020, 8:22pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/1 "2020-03-26T20:22:26Z")
Hi folks,
I tried to build a Glide version of calculator, with a particular formula I predefined. Basically, I would like to see each user can input numbers in cell a, b, c, d respectively. And then the built-in math function of Glide (see the predefined formula below) will automatically return two values like in the picture below.
I know how to use the math function to do the division and multiplication. I can obtain the two values.
But I have no idea how to make sure each user type in their own numbers and return their own values, as in the screenshot all numbers that I typed in will show in the devices of other users. Any expert know how to let each user deal their own numbers?
Any thoughts or comments are greatly appreciated!
Cheers,
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 26, 2020, 8:41pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/2 "2020-03-26T20:41:26Z")
You’d have to make sure users sign into the app. Then, on the homepage, import the emails from the App: Logins sheet. I use:
`=ARRAYFORMULA(LOWER(UNIQUE('App: Logins!B2:B')))`
On the home page, filter the page where email is signed in user.
---
### Author:  [@gangyao](https://community.glideapps.com/u/gangyao)
#### Post date: [March 26, 2020, 10:17pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/3 "2020-03-26T22:17:42Z")
Thanks for your reply! So there is no way to do that if users don’t sign in? I guess email sign-in would scare them away 😅 The purpose of my app is make the calculation easily accessible for everybody: use and go.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 26, 2020, 11:01pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/4 "2020-03-26T23:01:26Z")
Right…I mean, if they made their own copy of the app for their own personal use, no problem.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 26, 2020, 11:37pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/5 "2020-03-26T23:37:15Z")
> [@gangyao](#):
>
> So there is no way to do that if users don’t sign in?
Not quite yet. Hopefully soon
> [@Per User Checkboxes on Page Layout](https://community.glideapps.com/t/per-user-checkboxes-on-page-layout/5893/2):
>
> Not quite yet, especially if you want to keep your app public, but there is a new feature in the works that I hope is getting closer to release. It’s a User Specific Data column type that would store unique values for each user in the same column. I’ve been anxious about this one, because it would make things so much easier.
---
### Author:  [@gangyao](https://community.glideapps.com/u/gangyao)
#### Post date: [March 26, 2020, 11:59pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/6 "2020-03-26T23:59:38Z")
That would be fantastic @Jeff_Hager Let’s hope so 😀
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [March 28, 2020, 5:50am UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/7 "2020-03-28T05:50:49Z")
@gangyao
As Robert wrote, you must use the user email to get it so far but in addition, you need to create and reserve a space to each user and his operations.
The trick is to create a form at 1st time and later, use other number entry fields to modify your fields’ value and carry out the operations internally.
Here is my multiuser calc demo to help you to understand what you have to do.
> **[Multiuser Calc](https://multicalc.glideapp.io/)**
>
> A Calc that doesn't forget its users
I hope it can help you and any other one
Saludos, te cuidas!
Gavp
---
### Author:  [@gangyao](https://community.glideapps.com/u/gangyao)
#### Post date: [March 28, 2020, 12:07pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/8 "2020-03-28T12:07:18Z")
Hola, Gustavo:
Thanks for your reply! I know it can be achieved through single user sign-in, but as I said before, this would probably scare users away. By a quick googling, you will find loads of online calculators, and they don’t ask for any login. The only originality, if you allow me to say, I hope to achieve is a portable version of online calculator, without any login of course 😉
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [March 28, 2020, 3:17pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/9 "2020-03-28T15:17:30Z")
Hola @gangyao
I know what you mean, sure!
The problem begins with the Glide design, altought any APP can open several instances, there is no an _isolation space_ to work/save the new data generated by each user in run-time.
You will never have problems with data/info set to “read” but those “writable” for input fields are visible for all users. Only a form’s input fields have this _isolation space_ while they are activated.
A classic problem is given by **Choice component** for example, you can’t use it outside of a Form because, you will see how its value changes and everyone will see the same value, the same scenario of your calc.
My idea is the workaround so far to avoid it using Glide’s Apps unless I see another better (I’d hope so!)
Saludos de nuevo, un abrazo.
Gavp
---
### Author:  [@gangyao](https://community.glideapps.com/u/gangyao)
#### Post date: [March 28, 2020, 6:05pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/10 "2020-03-28T18:05:03Z")
Hola de nuevo,
I agree with you! So far it’s hard to achieve my goal in Glide, but let’s hope the upcoming features will solve the problem.
Abrazos,
---
### Author:  [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)
#### Post date: [May 5, 2020, 12:27pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/11 "2020-05-05T12:27:21Z")
Hi - Interested in the reply that you are advising to allow each visitor to be able to see only their answers.
I am working on a fees calculator for my colleagues, so email sign in is not an issue.
My issue is that my sheet - row 1 has titles and row 2 has calculations that link to another sheet that has fairly complex calculations.
So If the idea is to add users from a login page how - how does that work, is there a tutorial and how do I replicate the calculations on row 2 for the lines for each user?
Any chance you could take a look as it is at the moment and suggest how I could make it work - ?
I have been chatting with Gustavo Valero, but did get a bit lost!
Very much appreciated.
[22dem.glideapp.io](http://22dem.glideapp.io)
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [May 5, 2020, 1:05pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/12 "2020-05-05T13:05:08Z")
Without seeing your sheet, it will be a bit difficult to recommend a solution. Hypothetically, could your sheet contain an email (user) per row and a replication of your row 2 calculations per user? If so, I could craft a solution for you in minutes.
---
### Author:  [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)
#### Post date: [May 5, 2020, 1:09pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/13 "2020-05-05T13:09:37Z")
Thank for your reply
Here is the link - [22dem.glideapp.io](http://22dem.glideapp.io)
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [May 5, 2020, 1:32pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/14 "2020-05-05T13:32:31Z")
Hi Mike,
So, not as simple as just adding arrayformulas. Your spreadsheet would need to be reworked to be compatible with Glide. Very doable (would take just a couple hours probably).
---
### Author:  [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)
#### Post date: [May 5, 2020, 1:37pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/15 "2020-05-05T13:37:16Z")
Hi Robert,
Thanks for looking. Would you be interested in taking this on as a [pay for] project.
Altough I have lots of time at the moment, I have no idea what I would need to do to make it work!
Mike
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [May 5, 2020, 2:02pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/16 "2020-05-05T14:02:28Z")
Would be happy to! I’ll DM you the details.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [May 5, 2020, 3:53pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/17 "2020-05-05T15:53:36Z")
Saludos @Mike_Greene
Sorry if I didn’t follow your work and this post, there are so many posts daily that I get lost if I don’t receive a message or warning from Glide forum.
Try to tag me (or anyone) next time as I do with you in this message to create a warning in our profile.
Let me see your APP to understand your case although I saw Robert taking it and helping you.
Feliz día Mike!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 27, 2024, 6:45pm UTC](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919/18 "2024-01-27T18:45:20Z")