# Data in table is different from data shown in Glide Page

**URL:** https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758
**Category:** Ask for Help
**Created:** [February 10, 2023, 11:05am UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758 "2023-02-10T11:05:03Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [February 10, 2023, 11:05am UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758/1 "2023-02-10T11:05:03Z")

</div>

![Schermafbeelding 2023-02-10 om 12.00.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/98a19199a506fc4660271d3c75f6d505520f25a2.jpeg)  
Data in my table says the invitation has been accepted, while the app keeps showing pending …

Is there a sync procedure that should happen to show the data in the front-end?

---

<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: [February 10, 2023, 12:12pm UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758/2 "2023-02-10T12:12:07Z")

</div>

Can you explain a little about the “Accepted Pending” column?

ie. What type of column is it, what does it take as inputs, and how does it process the inputs?

I have two possible theories to explain what you see, but I’d like to learn more about that column.

---

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [February 10, 2023, 3:35pm UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758/3 "2023-02-10T15:35:04Z")

</div>

it’s an excel formula.

when a user is invited his/her email is stored in this referrals table.  
when someone with that email actually signs up it will also show up in the refferals table and the excel formula will determine that the referral has been acccepted.

 ![Schermafbeelding 2023-02-10 om 16.33.02](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb3ed49337002b12aedbdde96e915e6c849d0172.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: [February 10, 2023, 3:41pm UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758/4 "2023-02-10T15:41:42Z")

</div>

Okay, so that rules out one of my theories.

The other theory is related to the fact that I see that you are using Row Owners in that table.  
The simple way to test that would be to remove Row Owners and see if anything changes.

Just as an aside, that Excel formula could be replaced with a simple if-then-else column, ie:

- If Created user email is Invitee emailaddress, then Accepted
- Else Pending

---

<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: [February 10, 2023, 4:30pm UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758/5 "2023-02-10T16:30:42Z")

</div>

I’d also be curious to see if the table that the relation is pointing to has row owners. I suspect that the other table has a different owner.

Row owners are pretty much ignored when viewing data in the data editor. The app will respect them, but not the data editor.

---

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [February 12, 2023, 10:13am UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758/6 "2023-02-12T10:13:30Z")

</div>

Hi Gents,

Thank you for your feedback.  
Once I removed the row owners from the “users” table, this issue was solved.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6b1c9cb76a354e679bfb9df0c6561edb8821c0c.png)

However could this potentially raise a security issue, allowing other users inspecting the app seeing other users data?  
I don’t have a table exposing the users data apart from the user profile.

Many thanks for your advice!

Best regards,

Tim

---

<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: [February 12, 2023, 10:38am UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758/7 "2023-02-12T10:38:27Z")

</div>

> [@Tim\_Gestels](#):
>
> However could this potentially raise a security issue, allowing other users inspecting the app seeing other users data?

Yes, that’s correct.  
The way to address that would be to reapply Row Owners, but do it in a way that still allows all users to access the rows that they need to.

I’m not sure I have enough context to say exactly what needs to be done, but it could be as simple as including two Owner columns in your Referrals table - one for the Invitee and one for the Inviter.

You should keep in mind that once you reapply Row Owners to your Users table, then each user will only have access to their own profile row. So if there is additional user information required in the Referrals table, this would need to be added to non-computed columns at the point that each row is created. ie. you wouldn’t be able to access any User Profile data using relations and lookups (or any computed columns), except for that of the signed in user.

---

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [February 20, 2023, 7:22pm UTC](https://community.glideapps.com/t/data-in-table-is-different-from-data-shown-in-glide-page/57758/8 "2023-02-20T19:22:15Z")

</div>

> [@Darren\_Murphy](#):
>
> o if there is additional user information required in the Referrals table, this would need to be added to non-computed columns at the point that each row is created. ie. you wouldn’t be able to access any User Profile data using relations and lookups (or any computed columns), except for that of the signed in user.

Thanks Darren, I think indeed creating two tables would be the solution.

However currently I chose not to use the users table … since I don’t really need it anywhere …  
Only offcourse in the standard “user profile” tab this is shown.  
I assume that is an issue as well?
