# Row owners for department column

**URL:** <https://community.glideapps.com/t/row-owners-for-department-column/78379>\
**Category:** Ask for Help\
**Created:** [December 5, 2024, 6:50am UTC](https://community.glideapps.com/t/row-owners-for-department-column/78379 "2024-12-05T06:50:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/as1/32/82773_2.png) [@AS1](https://community.glideapps.com/u/AS1)\
**Post date:** [December 5, 2024, 6:50am UTC](https://community.glideapps.com/t/row-owners-for-department-column/78379/1 "2024-12-05T06:50:18Z")

</div>

I have transactions, staff and departments tables in Glide database. I have departments column in transactions table, I want to make it row owner so that, staff can only see transactions linked to their department, but it is not working, how do I do that

---

<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:** [December 5, 2024, 7:30am UTC](https://community.glideapps.com/t/row-owners-for-department-column/78379/2 "2024-12-05T07:30:05Z")

</div>

You need to configure Roles in your User Profile, and then give each User a role name that corresponds to the appropriate department.

If you’ve done that and it’s not working, please show me screen shots of:

- Your User Profiles configuration
- Your Users table
- Your Transactions table

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 6, 2024, 12:37am UTC](https://community.glideapps.com/t/row-owners-for-department-column/78379/3 "2024-12-06T00:37:30Z")

</div>

Here’s a sample of what it can look like:

**Staff table** :

| Staff ID | Name | Department ID (Role) |
| --- | --- | --- |
| S001 | Alice | D001 (Sales) |
| S002 | Bob | D002 (HR) |
| S003 | Charlie | D003 (Marketing) |
| S004 | David | D001 (Sales) |
| S005 | Eve | D002 (HR) |

**Department table** :

| Department ID | Department Name |
| --- | --- |
| D001 | Sales |
| D002 | HR |
| D003 | Marketing |

**Transactions table** :

| Transaction ID | Amount | Date | Department (Row Owner) |
| --- | --- | --- | --- |
| T001 | 1000 | 2024-12-01 | D001 |
| T002 | 500 | 2024-12-02 | D002 |
| T003 | 300 | 2024-12-03 | D001 |
| T004 | 1500 | 2024-12-04 | D003 |
| T005 | 1200 | 2024-12-05 | D002 |
| T006 | 800 | 2024-12-06 | D003 |

You set the Department ID/name in Users table as a Role.

Then set the Department ID/name in transactions as Row Owner.

---

<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:** [May 30, 2025, 9:23am UTC](https://community.glideapps.com/t/row-owners-for-department-column/78379/4 "2025-05-30T09:23:06Z")

</div>

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