# Users table "Role" column values disappear

**URL:** <https://community.glideapps.com/t/users-table-role-column-values-disappear/61692>\
**Category:** Ask for Help\
**Created:** [May 12, 2023, 3:20pm UTC](https://community.glideapps.com/t/users-table-role-column-values-disappear/61692 "2023-05-12T15:20:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kiptoo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kiptoo/32/57036_2.png) [@kiptoo](https://community.glideapps.com/u/kiptoo)\
**Post date:** [May 12, 2023, 3:20pm UTC](https://community.glideapps.com/t/users-table-role-column-values-disappear/61692/1 "2023-05-12T15:20:45Z")

</div>

I have a “Team Members” Glide Table to store my user profile data. From the form, I can create records just fine. However, it appears that for the new records, the “Role” column values are set to empty at random, even after editing the user profile and _explicitly_ setting the role value. See this screencast: [Loom | Free Screen & Video Recording Software | Loom](https://www.loom.com/share/213926c657db482aa11e5c687c21de02)

The Role values also disappear when I refresh the browser page of my app editor. See here what happened when I created a new record and then refreshed the page: [Loom | Free Screen & Video Recording Software | Loom](https://www.loom.com/share/f108928a05b44801a96a80b3b565b337)  
… the “Admin” role got lost again

Has anyone ever experienced this, and what could be the cause/fix?

---

<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:** [May 12, 2023, 3:37pm UTC](https://community.glideapps.com/t/users-table-role-column-values-disappear/61692/2 "2023-05-12T15:37:04Z")

</div>

That’s correct and expected behaviour.

> **[Glide • Roles](https://www.glideapps.com/docs/reference/security-and-user-data/roles)**
>
> Define roles for your users and build different expereriences and permissions for those groups.

Roles can only be assigned when the user record is created, and only if the creating user has the same role.

Other than that, roles can be assigned via the Data Editor, or via the Glide API.

---

<div class="post-metadata">

**Author:** ![kiptoo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kiptoo/32/57036_2.png) [@kiptoo](https://community.glideapps.com/u/kiptoo)\
**Post date:** [May 12, 2023, 4:01pm UTC](https://community.glideapps.com/t/users-table-role-column-values-disappear/61692/3 "2023-05-12T16:01:47Z")

</div>

> [@Darren\_Murphy](#):
>
> Roles can only be assigned when the user record is created, and only if the creating user has the same role.

Oh whaat, really? Then how should we implement a hierarchical user/permissions system? In my app, I need various access levels:

1. Admins who can access everything (including other users) and perform all CRUD actions
2. Staff who can access anything that Admins allow them to access (mostly read, create, update, not delete)
3. Vendors and Agents who only access what is assigned to them

Are you saying that in Glide, Admins can only assign roles to other Admins and not to users “below” them?

---

<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:** [May 12, 2023, 4:10pm UTC](https://community.glideapps.com/t/users-table-role-column-values-disappear/61692/4 "2023-05-12T16:10:33Z")

</div>

You can do this, but you’ll need to use the Glide API if you want to do it in app. If you’ve never used the Glide API, this is a really good use case for the first time doing this. Here are two really helpful explainer videos:

- [How to Use the @glideapps Tables API (Getting Started in 2022) - YouTube](https://www.youtube.com/watch?v=mbtUy6mpbyY)
- [Glide API: Connect ANY platform to your Glide App! - YouTube](https://www.youtube.com/watch?v=bHidpKeQSAk)

---

<div class="post-metadata">

**Author:** ![kiptoo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kiptoo/32/57036_2.png) [@kiptoo](https://community.glideapps.com/u/kiptoo)\
**Post date:** [May 13, 2023, 4:11pm UTC](https://community.glideapps.com/t/users-table-role-column-values-disappear/61692/5 "2023-05-13T16:11:41Z")

</div>

Thanks for the insight and video links.

It’s just a pain that one has to be on the Pro plan to be able to try the API 🫤
