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!
LinkedIn
Twitter
