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?
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.
1 Like
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?
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.
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!
1 Like
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.
3 Likes
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.
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?
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.
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.
Yes they will be creating new data entry rows through a glide form
Okay, see below:
1 Like
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?
Shouldn’t matter, they should be the same.
1 Like
I appreciate all your help SO much!!
1 Like