I created an App which I wanted to distribute to various users on the following way:
App managed centrally
The Google Sheet used as DB should be locally stored in the various Google Drives of the End user including the upload of pictures and documents
Some Appscripts are attached to the Google Sheet for some daily runs to load mails etc.
There are three possibilities for me:
Ask every end user to copy the application including the Google Sheet → No Central App Management anymore
Declare all Data bases as Private tables cutting my Google Sheet in various Google Sheets one per Tab → Central App but Appscript does not work anymore
Using partitions where depending the User eMail a partition is selected
What is the best way or do somebody knows a better way?
The best way is to have a single data source, where all user’s records are in the same table(s), and use Security Filters and/or Slices to only load/show records to the appropriate users.
I would only ever use Partitions or Private Tables if you fully understand what they are for, and have a really good reason to. I’ve actually never used them on a live app, only to experiment with.
thanks for the replay. The idea was to use Private Table due the fact the application will manage private informations and this increases the security and privacy of informations.
You cannot under any circumstances add, remove, or reorder columns in the table once the table is first created. You have to ask the user to delete the table (and all its data) and recreate the table with the new columns, or you have to add a new table and migrate the data from the old table to the new one.