Resources on how to manage users on a single app (while receiving data from different spreadsheets)

AppSheet AppSheet Q&A
, , ,
1

Hi everyone! Hope your week is starting great!

Do you have any recommended resources regarding managing multiple users on a single app?

The app I’m building will support different users (require sign in):

  • Each user has a single spreasheet (database) which is used to calculate a couple of things. Then, this data goes to a few sheets inside the Appsheet spreadsheet, using the importrange() function.

What makes me worry is when I get more users (more than one). What would be the best option for me to manage this data from different spreasheets (different users) to a single Appsheet spreadsheet where the app user can only see his info?

Any tips or resources on that?

Also, let me know if anyone of you are up to a quick talk about it.
Thanks,
Jonas Emanoel

1 Like
2

Hi @jonas-sume ,

I think you are looking for User Permissions. We have a YouTube Webinar about this here: https://youtu.be/2Z2qUTtxNFA

AppSheet, also has documentation here: https://support.google.com/appsheet/answer/10104977?hl=en&ref_topic=10104784

Hope this helps!

Let me know if you have any other questions.

Thanks!

Austin from AppSheet Training

3

Limit users to their own data - AppSheet Help

4

I would go about migrating all your calculation stuff away from sheets, and into AppSheet.

In my years of experience, I’ve yet to find a data calculation that couldn’t be accomplished inside AppSheet.

2 Likes