# User Specific Data and Row Deletion

**URL:** <https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503>\
**Category:** Ask for Help\
**Created:** [August 8, 2024, 12:13am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503 "2024-08-08T00:13:23Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![morganaf417](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morganaf417/32/61057_2.png) [@morganaf417](https://community.glideapps.com/u/morganaf417)\
**Post date:** [August 8, 2024, 12:13am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/1 "2024-08-08T00:13:23Z")

</div>

I am creating an app to document user-specific events. I currently have each column in the table set up to be user-specific so one user doesn’t see the evens documented by other users. I have 500 rows of unique data input. When I switch to another user, the columns are empty, but they also have 500 rows of blank data. I would like for them to start with 0 rows of data and just input their own unique number of rows. Is possible?

---

<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:** [August 8, 2024, 1:14am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/2 "2024-08-08T01:14:19Z")

</div>

It sounds like you’re approaching it incorrectly. What you should do is have a table with basic columns, not user-specific columns, and use row owners/roles to secure data.

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc5bc22c1cf4493a04d0a5b9c9d427898fe6bf68.jpeg "Glide: Row Owners and Roles DEMYSTIFIED") ](https://www.youtube.com/watch?v=RmMLZINOwjQ)

---

<div class="post-metadata">

**Author:** ![morganaf417](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morganaf417/32/61057_2.png) [@morganaf417](https://community.glideapps.com/u/morganaf417)\
**Post date:** [August 8, 2024, 2:43am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/3 "2024-08-08T02:43:10Z")

</div>

But can the row owners be dynamic so that each user becomes the row owner of the entire sheet?

Attaching a picture of my table. It is very simple, but I do not want any row of the table to be shared with any other user, but they need to be able to own every row in the same table that has their own unique data in it. Does that make sense?

 ![Screenshot 2024-08-07 224019](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/90c4ba7ffd86cf3003f88f4b664475a3180e2a67.png)

---

<div class="post-metadata">

**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\
**Post date:** [August 8, 2024, 3:06am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/4 "2024-08-08T03:06:57Z")

</div>

I think I understand what you’re aiming for but I can only see this being achieved if each user has a table dedicated to them. Not sure if that is manageable… Maybe you can create an app template and allow each user to copy your template… In other words, allow many duplicates of your app that a single person can own entirely.

---

<div class="post-metadata">

**Author:** ![morganaf417](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morganaf417/32/61057_2.png) [@morganaf417](https://community.glideapps.com/u/morganaf417)\
**Post date:** [August 8, 2024, 3:22am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/5 "2024-08-08T03:22:09Z")

</div>

Yes that is what I was afraid of. This is more of an idea for an end user app, so might have to find a developer to do it for me!

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [August 8, 2024, 3:38am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/6 "2024-08-08T03:38:32Z")

</div>

Have you tried ThinhDinh’s advice and switch all your columns to basic ones and use row owners/ roles?

Have you watched the video he attached?

Your screenshot still shows user specific columns.

This can be done with basic columns and row owners.

> **[Roles | Glide Docs](https://www.glideapps.com/docs/roles)**
>
> Define roles for your users and build different experiences and permissions.

---

<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:** [August 8, 2024, 9:30am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/7 "2024-08-08T09:30:46Z")

</div>

> [@morganaf417](#):
>
> But can the row owners be dynamic so that each user becomes the row owner of the entire sheet?

Why do you need each user to own the entire sheet though? You should aim for a table that houses all events for all users, and secure them with row owners/roles.

---

<div class="post-metadata">

**Author:** ![morganaf417](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morganaf417/32/61057_2.png) [@morganaf417](https://community.glideapps.com/u/morganaf417)\
**Post date:** [August 8, 2024, 2:11pm UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/8 "2024-08-08T14:11:39Z")

</div>

There will not be any shared data between users. I am essentially trying to just provide a blank space for people to document their events.

I did get the functionality to work using row owners, though. My question is - is there an automatic way to set a row owner without having to input the email address into every new row created?

---

<div class="post-metadata">

**Author:** ![morganaf417](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morganaf417/32/61057_2.png) [@morganaf417](https://community.glideapps.com/u/morganaf417)\
**Post date:** [August 8, 2024, 2:13pm UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/9 "2024-08-08T14:13:12Z")

</div>

Yes got this to work! My next task is to see if there is a way to automatically assign row owners when new rows are created without having to input email address into every row.

---

<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:** [August 8, 2024, 2:20pm UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/10 "2024-08-08T14:20:08Z")

</div>

Do users add new rows via a Glide Form?  
If so, you can pass the users email address as a special value with the form.

---

<div class="post-metadata">

**Author:** ![morganaf417](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morganaf417/32/61057_2.png) [@morganaf417](https://community.glideapps.com/u/morganaf417)\
**Post date:** [August 8, 2024, 2:51pm UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/11 "2024-08-08T14:51:09Z")

</div>

Yes they will be creating new data entry rows through a glide form

---

<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:** [August 8, 2024, 2:54pm UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/12 "2024-08-08T14:54:05Z")

</div>

Okay, see below:

> **[Values | Glide Docs](https://www.glideapps.com/docs/reference/values#user-profile-values)**
>
> The different types of values you can work with in Glide.

---

<div class="post-metadata">

**Author:** ![morganaf417](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morganaf417/32/61057_2.png) [@morganaf417](https://community.glideapps.com/u/morganaf417)\
**Post date:** [August 9, 2024, 12:45am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/13 "2024-08-09T00:45:49Z")

</div>

Thank you so much! I think I’ve got it to do exactly what i needed it to.

I noticed when adding the button to the form to input user email, there were two options - app user email or email from user profile. Does it matter which one you use?

---

<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:** [August 9, 2024, 12:59am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/14 "2024-08-09T00:59:05Z")

</div>

Shouldn’t matter, they should be the same.

---

<div class="post-metadata">

**Author:** ![morganaf417](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morganaf417/32/61057_2.png) [@morganaf417](https://community.glideapps.com/u/morganaf417)\
**Post date:** [August 9, 2024, 1:27am UTC](https://community.glideapps.com/t/user-specific-data-and-row-deletion/75503/15 "2024-08-09T01:27:01Z")

</div>

I appreciate all your help SO much!!
