Distribution of Apps

[Werni]

Hello

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:

1. Ask every end user to copy the application including the Google Sheet -> No Central App Management anymore
2. 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
3. Using partitions where depending the User eMail a partition is selected

What is the best way or do somebody knows a better way?

Thanks Werner

[Marc_Dillon]

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.

[Werni]

Hello 

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.

Thanks

Werner

[Steve]

Private tables are a bad idea.

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.

Do not use private tables.