How can I get my glide app to show my users only the data they have added and not include the data of other users automatically? I set the row owners column but that would require me to manually include the emails of the author users on each row, and that is not only tedious but impossible.
I am building a personal budget tracker app, and I want each user to input their income and expense data without other users seeing it as every user has a different set of data, and the analytics for each user is different based on their individual data.
You don’t need to do that manually, it can be done at the same time the users add their data.
There is a special value you can use - signed in users email address. Include a column to hold that in the table where they enter their data, and populate that as part of the Add Row action.
Then when you build a relation back to your User Profiles sheet (where you have Row Owners enabled), the data will be protected.
For clarification, I would apply Row Owners to ALL sheets that contain private date and an email column. I don’t believe a relation from a row owner protected sheet (such as user profiles) to another sheet will necessarily protect the data in that second sheet. It will hide it, but not prevent it from being downloaded in the first place.