Hi, I am looking to make a service app, ideally I would like users to connect their own Google Sheets, if that’s not possible I would like each user to read/write his own “sheet” inside my Google Sheet. I am currently thinking the only way is that I will have to duplicate my app for each user and …

[image] How to share apps with different values for each employee Ask for Help Here’s your options: Use row owners so each user can only access their own data in shared tables. Use filters, which are not nearly as secure as row owners. Build separate apps…one for each us…

Keep all users in the same sheet/table, and use Row Owners. [image] Row Owners A secure way to restrict access to certain rows.

Thank you Darren for the quick reply, I will have a look into it. In general, if users are row owners and they write data to my Sheet does that mean each row they are inserting makes them the row owners? if not, do I have to set this up? Alon

Make sure you have one column in the table that their email address is written into, and make that column a Row Owner.

@AlpacaPie FYI: all user data is saved to the Google sheet that is stored on YOUR Google drive. So you have their data. Better to use Glide tables that are saved to the cloud.

Yes I figured that will be the best thing to do in this case. Thank you very much guys.

Actually as more of a general question and I might start it as a topic, I am not looking for the app to be shared across the users, I am trying to make a service for each one individually. For that do you suggest making a Glide table for each user? Also, can I get rid of the “Users” tab in this ca…

Cheers everyone, if there’s any other way I can say thanks and promote you guys let me know. Great community and support!

Google sheets per user

Ask for Help

Jeff_Hager September 9, 2023, 6:03pm 8

Topic		Replies	Views
User Differentiation Ask for Help	10	305	June 5, 2021
Display a list of all users Ask for Help	7	497	May 30, 2023
Multiple apps - one sheet? Ask for Help	6	540	May 28, 2021
User Specific Data and Row Deletion Ask for Help	14	67	August 9, 2024
How to share apps with different values for each employee Ask for Help	6	312	December 24, 2023

Google sheets per user

Related topics