Transfer APP

[Maxwell_Smart]

I have an App and  I want to transfer this App ( maybe to another hundred Users - Companies ) quite automatically. If I make changes in my App - i would like to roll out ( automatically ) this changed app to ( eventually ) hundred of companies ( users ) is it possible, to do it automatically ? The App does not use the Appsheet Database.

[WillowMobileSys]

No...but maybe the terms you are specifying are not really what you mean. 

The term "transfer" to 100 companies implies that you want to make a physical copy of the app to provide to those 100 companies so that they have their very own copy - which by the way they can then change however they wish. 

I think what you want is a "tenant" based app.  A single app you control but enroll/register different Companies (and their employees) to use - as if they were using their very own app!  When you make changes, it is to a single app and everyone will get those changes simultaneously.

This you can do with some setup and the use of Security Filters to control which users see what data.  You can even segregate data using Data Partitions to ensure that business information doesn't cross over between Companies.

A good place to start are with these articles:

https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-use-Security-Filters-to-allow-multiple-co...

https://www.googlecloudcommunity.com/gc/Tips-Tricks/SUMMARY-TIP-User-permissions-roles-and-settings/...

I hope this helps!!

[Maxwell_Smart]

Thank you very much for the answer.
I have written a very, very extensive APP for a company.
In one year, about 6,000 rows of data have been collected.
I asked Google if I could scale this external data (sheets) now? on several farms ( and there could be hundreds of farms at some point ).
Google says, NO, because if I also had an enterprise license, there are data limits on the part of Appsheet in the sheets ( in the Appsheet's own database anyway ).
Google puts the data limit per app ( account ) at 100,000 rows. But this number is wrong, I was able to insert almost 400,000 rows with one test ( sheet ).

So it is the amount of data that forces me to take a different approach.
I would provide every company ( is like an organization ) in a large company, a copy of my Appsheet app. However, the app would not be changeable. In the app itself, no data is created in the app's own database.
So each company would have its own sheets and its own file system

So if at some point changes have to be made in the app ( be it due to errors, be it due to innovations ) I would have to change the app in every single app ( of every company ) (if there is no more automatic app transfer).
That doesn't even really work with 2 companies.

If I don't succeed in finding a solution, then I'll scrap my app and leave the Google universe (which I love very much).

I am therefore looking for a solution on how I can transfer an app to hundreds of other companies ( and that quite automatically )

[Maxwell_Smart]

Thank you very much
I have looked at all your documents, and many of the procedures that are
explained were already clear to me beforehand.
As I said, the problem is the amount of data in the individual tables. And
so each of my subcontractors would have to have its own sheets. Of course,
in the best caste scenario I would have 10,000 spreadsheets with the
individual sheets.
The only problem is that in Appsheet there is the sourceid for each table,
and I can't change it in runtime mode.
Last but not least, the number of users for Appsheet is also limited.
And so I came to the conclusion that I have many ( hundreds ) of the same
APPS.
Problem with this - to transfer the app, and 2. to change the SourceID of
the tables.