Different data source for each user

Robert_Cooke · 10-25-2020 10:12 PM

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.

Aleksi

Hi, may I ask what is the purpose for this?

Robert_Cooke

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.

Aleksi

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?

Robert_Cooke

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.

Aleksi

May I ask how much you will have data? How many records for example after a year?

Robert_Cooke

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.

Aleksi

Yes it sounds SQL is needed as a data source. Then you can use security filter and only one app is needed.