# Private users not able to access data

**URL:** https://community.glideapps.com/t/private-users-not-able-to-access-data/44742
**Category:** Report a Bug
**Created:** [July 18, 2022, 6:23pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742 "2022-07-18T18:23:05Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![can\_man](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/can_man/32/28618_2.png) [@can\_man](https://community.glideapps.com/u/can_man)
#### Post date: [July 18, 2022, 6:23pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/1 "2022-07-18T18:23:06Z")

</div>

I have a an app with private users. For some reason, today when adding new users, the data that they should have access to is greyed out in the data editor view.

They have correct user roles that are working for older accounts, and if I give them one level up (Admin), they are able to access the data. Any Ideas? This is super frustrating.

 ![Screen Shot 2022-07-18 at 11.20.06 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/529fb7f2c32645a8de0306e4a81c7253d7d6ef4d.png)

---

<div class="post-metadata">

### Author: ![can\_man](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/can_man/32/28618_2.png) [@can\_man](https://community.glideapps.com/u/can_man)
#### Post date: [July 18, 2022, 7:21pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/2 "2022-07-18T19:21:34Z")

</div>

Only workaround I was able to find was adding a new Owner Row Column and adding a custom value for the specific users. This is not an acceptable solution.

---

<div class="post-metadata">

### Author: ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)
#### Post date: [July 18, 2022, 9:22pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/3 "2022-07-18T21:22:44Z")

</div>

Have you made any changes to how you add users from the ones that are working to the ones that are not?

Also, can you show how the row owners feature is implemented with the roles in the table that’s not working?

---

<div class="post-metadata">

### Author: ![can\_man](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/can_man/32/28618_2.png) [@can\_man](https://community.glideapps.com/u/can_man)
#### Post date: [July 20, 2022, 6:44am UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/4 "2022-07-20T06:44:07Z")

</div>

@NFNHello Yes, here are the sample owner roles. As you can see, the rows are all greyed out even though they share zip code owner role 94507 and 94526.

I have not made any changes to how I add users. Adding a 3rd owner column where I can set an additional role such as ‘Bypass’ works. It seems to be the zip code role that is not working for some reason. Unfortunately, being able to hide results based on zip code is the preferable capability. As you can imagine it would be nice to be able to give users access only to rows that have a certain zip code.

 ![Screen Shot 2022-07-19 at 11.42.54 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/ba298559d70fd3ffa710c7240e148f0876294fb0.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: [July 20, 2022, 11:07am UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/5 "2022-07-20T11:07:04Z")

</div>

Gonna need more information here, such as how the roles are set up on the user profile table. How do have it set up so each user can have multiple roles?

---

<div class="post-metadata">

### Author: ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)
#### Post date: [July 20, 2022, 12:19pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/6 "2022-07-20T12:19:04Z")

</div>

It’ll be helpful to see how these roles are set up on the user table. Because of the multiple roles, I’m guessing you are using a Google Sheet, so a screen shot of the user table there too would be helpful. Aside from a configuration issue (wrong table, wrong column, wrong setting, etc.), there might be an issue with the values. Do you have any trailing spaces on the ones that don’t work?

---

<div class="post-metadata">

### Author: ![can\_man](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/can_man/32/28618_2.png) [@can\_man](https://community.glideapps.com/u/can_man)
#### Post date: [July 20, 2022, 4:02pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/7 "2022-07-20T16:02:33Z")

</div>

Here’s the user table. The Roles column is an array, formed from the values from several google sheet column values.

 ![Screen Shot 2022-07-20 at 8.58.41 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/ddd7abd555152b0b14618f4ca22d9244875eb42e.png)  
 ![Screen Shot 2022-07-20 at 9.01.50 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/00ed90f7987a33d0a253b2fb3c6bae590e164717.png)  
And yes, I have checked that there are no trailing spaces. I also copied and pasted from the cells that are working!

---

<div class="post-metadata">

### Author: ![can\_man](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/can_man/32/28618_2.png) [@can\_man](https://community.glideapps.com/u/can_man)
#### Post date: [July 21, 2022, 9:23pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/8 "2022-07-21T21:23:40Z")

</div>

@Jeff_Hager @NFNHello any thoughts with the new images provided?

---

<div class="post-metadata">

### Author: ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)
#### Post date: [July 23, 2022, 6:45pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/9 "2022-07-23T18:45:55Z")

</div>

A copy/paste from the working cells is a good idea to rule out issues with the values themselves. It seems like you’ve done this before. 🙂

Unfortunately, I don’t see anything obvious that might be causing your issue. At best, I can share how I might troubleshoot:

- I see that you have multiple Row Owners. You might discover something by removing one of the Row Owner columns and validating how the others work.
- Or, by the same logic, remove one of the Role columns to see if there is an obvious one, when removed, that resolves the problem.
- Is it possible that the users that are not working just didn’t have time to sync with Google Sheets?

If all else fails, you might benefit from contacting Glide support directly at [support@glideapps.com](mailto:support@glideapps.com)

---

<div class="post-metadata">

### Author: ![can\_man](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/can_man/32/28618_2.png) [@can\_man](https://community.glideapps.com/u/can_man)
#### Post date: [July 27, 2022, 3:23pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/10 "2022-07-27T15:23:35Z")

</div>

@NFNHello I have narrowed down the problem, but still believe it is a bug.

It appears that glide is not able to properly compare strings that consist only of numbers. As I mentioned above, using the role 94507 does not work, however I am able to get it to work by appending ‘a’ to the string.

94507 doesn’t work ❌

 ![Screen Shot 2022-07-27 at 11.12.40 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94d55e410ebb88683aa7f74cad5b9cf6ac61330a.png)

94507a works ✅

 ![Screen Shot 2022-07-27 at 11.12.14 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0cd986151387ba14c92becf78be0a954cd3dc2fb.png)

Based on this, it sounds like I should send this to Glide support.

---

<div class="post-metadata">

### Author: ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)
#### Post date: [July 27, 2022, 3:56pm UTC](https://community.glideapps.com/t/private-users-not-able-to-access-data/44742/11 "2022-07-27T15:56:08Z")

</div>

How interesting! Maybe it has something to do with the column type? Definitely open a support ticket.

It’s nice to narrow down the problem too, that’ll help Support a bunch. 🙂
