Manage more than one application at once

[Kennedy]

Hello, I have a finished application and I wanted to make it available for sale to several potential clients, each with their own database. My question is how do I work with these various databases and update the application versions. That is, how do I have a production version to update all applications at once?

[WillowMobileSys · Accepted solution]

AppSheet does not support conditional switching of datasources - which is what you would need to have a single app for changes and maintenance but connect each client to their OWN database. 

But AppSheet CAN support multiple different clients in a single app using partitioning.  Partitioning is a way to break up a single datasource through filtering.  When a user logs in, their client affiliation is identified and the necessary tables are filtered to only the rows that belong to that tenant/client.

To learn more, check out this article:  Scale using data partitions 

If it is required that each client have their very own database, likely at different locations/servers, you will not be able to support them with a single app.  Each client would need to have their own app copy.  

I hope this helps!

[Kennedy]

Thank you very much for the clarification.