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 | |
29 | |
23 | |
17 |