# Data showing problem! Help is needed!

**URL:** <https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917>\
**Category:** Ask for Help\
**Created:** [January 2, 2025, 2:55pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917 "2025-01-02T14:55:01Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![LAM\_DO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lam_do/32/79260_2.png) [@LAM\_DO](https://community.glideapps.com/u/LAM_DO)\
**Post date:** [January 2, 2025, 2:55pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917/1 "2025-01-02T14:55:01Z")

</div>

I have a helper table that having all computed columns has been set as in the picture. However, when I try to show it out on the component then the data is showing different. I tried lookup or query but it will return the same result. Is there anything i don’t know or is it a bug?

 ![Untitled](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/ae48a57771741a0a947d9b6047b32778423e002e.png)

---

<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:** [January 2, 2025, 3:32pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917/2 "2025-01-02T15:32:25Z")

</div>

Are you trying to pull in data from a table under row ownership? Are you trying to show data you do not own as the current user?

---

<div class="post-metadata">

**Author:** ![LAM\_DO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lam_do/32/79260_2.png) [@LAM\_DO](https://community.glideapps.com/u/LAM_DO)\
**Post date:** [January 2, 2025, 3:38pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917/3 "2025-01-02T15:38:43Z")

</div>

thank for replying!  
the data i pulled is from Attendance Helper table. there is no row owner on that one. but the Staff table has row owner. the data that I pulled is from their row ownership

Update. Here is the better screenshot

 ![Untitled2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f230aac4a1e8414300953d5bdf4a6ddd3733bd6.png)

---

<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:** [January 2, 2025, 4:16pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917/4 "2025-01-02T16:16:25Z")

</div>

If the data ultimately comes from a table under row ownership, you won’t have access to that data if you are not the owner. It may seem like you do in the data editor, but that is because it doesn’t filter out unowned rows. It can be a little deceiving.

Is this an admin role that should have access to all staff data? If so you may want to add another row owner to the staff table and populate it with an admin email or you can look into utilizing Role functionality if you have multiple admins.

---

<div class="post-metadata">

**Author:** ![LAM\_DO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lam_do/32/79260_2.png) [@LAM\_DO](https://community.glideapps.com/u/LAM_DO)\
**Post date:** [January 2, 2025, 4:44pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917/5 "2025-01-02T16:44:57Z")

</div>

I’ve setup 10 columns of row onwer for 3 different roles. I use admin role to sign in. the ultimate data is actually come from helper table.

I’ve created a working table which to get all the data that come from staff table. I think you said that is deceiving from the row owner is right because when I use different user to log in so I still see the other staff which is not under row owner.

However, the data i am trying to pull is just from their own row so that data i pull is what that the person owned. I just dm you to show you team viewer if you have time that’d be great!

---

<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:** [January 4, 2025, 9:54pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917/6 "2025-01-04T21:54:47Z")

</div>

> [@LAM\_DO](#):
>
> I’ve setup 10 columns of row onwer for 3 different roles

Not really important, but why would you need 10 row owner columns if you only have three roles? At most, I would think you only need 3 or 4 row owner column. Just curious.

I assume these row owner columns are within the Staff table?

> [@LAM\_DO](#):
>
> when I use different user to log in so I still see the other staff which is not under row owner.

Not sure I understand. If a table has row owners applied, and none of those row owner columns is assigned to any user, then nobody should have access to those rows. Maybe I misunderstood.

> [@LAM\_DO](#):
>
> However, the data i am trying to pull is just from their own row so that data i pull is what that the person owned.

So you are saying that the data you are showing in the helper table, and the data coming from the staff table, is only for the user that is signed in?

I think it would help to see more screenshots. Specifically, it would be useful to see if and how you have Role functionality set up in the user profile configuration. It would be useful to see what kinds of roles are assigned to your users. Can you clarify if the Staff table is the User table? It would be helpful to see how you have set up any Row Owner columns and the values you have in those row owner columns.

---

<div class="post-metadata">

**Author:** ![LAM\_DO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lam_do/32/79260_2.png) [@LAM\_DO](https://community.glideapps.com/u/LAM_DO)\
**Post date:** [January 4, 2025, 11:16pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917/7 "2025-01-04T23:16:57Z")

</div>

I’ve been working and realized that the way I setup was wrong. 10 columns of row owner (by email) will be replaced by 3 as you said. I’ve learned more about row owner and use 2 columns role and email on User table. In role column I have ADMIN and PN001 values for emails those are admin and location owner. These value which are refer for ADMIN acess column and Location Id on Staff table (also row owner table)

After figured out, I just deleted all email row owners and replace them with just 1 more column which is ADMIN on all rows. That works. However, I still thinking the way

The problem is caused by the query column that fetch all rows on the Staff table. The purpose is I want to setup a pos that employee can clock in. And also on their app they’re still see their attendance status and so they can do some action without using PIN screen. Is that possible?

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [January 11, 2025, 11:17pm UTC](https://community.glideapps.com/t/data-showing-problem-help-is-needed/78917/8 "2025-01-11T23:17:18Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
