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

[jonas-sume]

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

[Austin_QREW]

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

[Steve]

Limit users to their own data - AppSheet Help

[MultiTech]

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.