# User Differentiation

**URL:** <https://community.glideapps.com/t/user-differentiation/27672>\
**Category:** Ask for Help\
**Created:** [June 5, 2021, 11:46am UTC](https://community.glideapps.com/t/user-differentiation/27672 "2021-06-05T11:46:01Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yugant\_Nayak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yugant_nayak/32/25958_2.png) [@Yugant\_Nayak](https://community.glideapps.com/u/Yugant_Nayak)\
**Post date:** [June 5, 2021, 11:46am UTC](https://community.glideapps.com/t/user-differentiation/27672/1 "2021-06-05T11:46:02Z")

</div>

I am working on a model where I need to take inputs from the users and there will be different inputs from the users.

How do I implement this functionality in Glide where different users can see different outputs based on a single Google spreadsheet?

---

<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:** [June 5, 2021, 12:00pm UTC](https://community.glideapps.com/t/user-differentiation/27672/2 "2021-06-05T12:00:50Z")

</div>

You probably want to take a look at [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns)

---

<div class="post-metadata">

**Author:** ![Yugant\_Nayak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yugant_nayak/32/25958_2.png) [@Yugant\_Nayak](https://community.glideapps.com/u/Yugant_Nayak)\
**Post date:** [June 5, 2021, 12:26pm UTC](https://community.glideapps.com/t/user-differentiation/27672/3 "2021-06-05T12:26:32Z")

</div>

Will that help to capture the different inputs users give in the app?

---

<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:** [June 5, 2021, 12:30pm UTC](https://community.glideapps.com/t/user-differentiation/27672/4 "2021-06-05T12:30:47Z")

</div>

It can, yes.  
But it would probably help if you can explain a bit more about your use case.

---

<div class="post-metadata">

**Author:** ![Yugant\_Nayak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yugant_nayak/32/25958_2.png) [@Yugant\_Nayak](https://community.glideapps.com/u/Yugant_Nayak)\
**Post date:** [June 5, 2021, 1:30pm UTC](https://community.glideapps.com/t/user-differentiation/27672/5 "2021-06-05T13:30:26Z")

</div>

My use case is like:

I have some inputs like Principal Amount,Years, Interest rate and the output will be shown on the page using calculation in Google sheet.

I want it to be different for every user and the user data entered by the user to be stored in my sheet?

How can I make it user specific inputs so that one user doesn’t affect the the inputs of other user?

---

<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:** [June 5, 2021, 1:36pm UTC](https://community.glideapps.com/t/user-differentiation/27672/6 "2021-06-05T13:36:16Z")

</div>

One further question:

- would each user only enter this data once, or could they enter it many times?
- and if many times, would you need to save multiple results for each user, or would subsequent entries just replace the first set?

---

<div class="post-metadata">

**Author:** ![Yugant\_Nayak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yugant_nayak/32/25958_2.png) [@Yugant\_Nayak](https://community.glideapps.com/u/Yugant_Nayak)\
**Post date:** [June 5, 2021, 1:52pm UTC](https://community.glideapps.com/t/user-differentiation/27672/7 "2021-06-05T13:52:14Z")

</div>

Yes, one user can enter multiple data and we would preferably like the latest entry to be stored in our sheet

---

<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:** [June 5, 2021, 1:56pm UTC](https://community.glideapps.com/t/user-differentiation/27672/8 "2021-06-05T13:56:21Z")

</div>

> [@Yugant\_Nayak](#):
>
> I have some inputs like Principal Amount,Years, Interest rate and the output will be shown on the page using calculation in Google sheet.

Just one comment in the meantime is that you might want to consider doing those calculations in Glide, rather in the Google Sheet. Most calculations and formulas that you can use in GSheets can also be done in Glide using computed columns, and here is why that is generally a good idea:

- When you do your calculations in the Google Sheet:
  - Your user enters data in your app, and submits
  - The data then needs to sync back to Glide servers
  - It then needs to sync to your Google Sheet
  - Then the calculations are performed
  - The results then sync back to Glide servers
  - And finally the data syncs back to your users device and the results become available

- All of that can take anywhere between several seconds and several minutes
- However when you do the calculations in Glide, everything is done on the users device, and results are available immediately

---

<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:** [June 5, 2021, 2:01pm UTC](https://community.glideapps.com/t/user-differentiation/27672/9 "2021-06-05T14:01:24Z")

</div>

> [@Yugant\_Nayak](#):
>
> Yes, one user can enter multiple data and we would preferably like the latest entry to be stored in our sheet

Okay, in that case it is fairly simple, and there are two main ways to approach it. Lets assume that you have a series of columns in your users table for accepting these inputs.

- The first method would be through the use of [Row Owners](https://docs.glideapps.com/all/reference/security-and-per-user-data/row-owners). Row Owners is a security feature that ensures that each user can only see their own data, so it becomes impossible for one users data to overwrite that of another.
- The other way is via filtering. If you have an input screen for accepting these values that is based on your users table, then you can filter that screen “where email is signed-in user” and that will ensure that each user is adding data to the correct row,

---

<div class="post-metadata">

**Author:** ![Yugant\_Nayak](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yugant_nayak/32/25958_2.png) [@Yugant\_Nayak](https://community.glideapps.com/u/Yugant_Nayak)\
**Post date:** [June 5, 2021, 2:17pm UTC](https://community.glideapps.com/t/user-differentiation/27672/10 "2021-06-05T14:17:46Z")

</div>

Thank you for your kind guidance…

Can you please share me any video or help me as to how I can implement row owners in Glide?

---

<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:** [June 5, 2021, 2:23pm UTC](https://community.glideapps.com/t/user-differentiation/27672/11 "2021-06-05T14:23:34Z")

</div>

The link is in @Darren_Murphy’s post above, but here it is again.

> **[Row Owners](https://docs.glideapps.com/all/reference/security-and-per-user-data/row-owners)**
>
> A secure way to restrict access to certain rows
