Hi,
Can I use a different data source for every signed-in user?
I want to give every user access to a different google sheet.
Or should I create a new app for every user?
If so, what is the maximum app limit?
BTW it doesn’t feel good to create a new app for every user.
Hi, may I ask what is the purpose for this?
In the current system, every user has access to their own google sheet.
The data is also very large and sensitive, so I can’t imagine merging it in one sheet.
Few options…
#1 - Filtering data and data amount with a security filter so others won’t see that data
#2 - If the data size is huge, use real Database like MySQL as a data source
#3 - Data partitioning is one option
#4 - Is the feature “Private tables” possible in your case?
Thanks, I will look at these options I have a feeling I need to use a real Database.
BTW I just learned about this project and it really looks great.
May I ask how much you will have data? How many records for example after a year?
It is now built to handle a few hundred users so that will be an equal number of sheets.
A single sheet doesn’t have that much data maybe max 1000 rows.
Yes it sounds SQL is needed as a data source. Then you can use security filter and only one app is needed.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |