Hi,
Im getting closer to being at the final publishing stage of an app that we have designed for our business. This app is basically a collection of apps that are used as sections to form a main dashboard… these are fed by various spreadsheets stored on the cloud.
We are also looking at distributing this to a wider audience, one idea is to clone each app to a new appsheet account that we set up for each business that wish to buy it… duplicate our background spreadsheets and then replace the data with theirs. We would then manage their licences and this would be used as a web based app.
What Im wondering is, is there a way to not have to clone the app(s) and simply clone the spreadsheets and change to their data, then when the new client logs in they only see their data set?
Probably clear as mud the way Ive described this!
2 Likes
I have a similar situation. I have security filters set up to filter the data on each table based on the user email and the associated company that their email belongs to. This is achieveable if you have one of the normal AppSheet plans.
This post by @MultiTech will show you how to do it.
How to use Security Filters to allow multiple companies to use the same app
But wait, there’s more! If you have an Enterprise plan there are ways to partition across multiple workbooks.
Scale using data partitions - see below for specific relevent text:
Data partitioning: Other scenarios
While data partitioning is primarily a feature to improve performance at scale, it can also be a convenient mechanism to handle deployment scale in a relatively common scenario. It is sometimes the case that data sets needs to be maintained in separate physical containers (tables of a single database or spreadsheet files accessible by a single Google account source) for reasons other than performance. For example, if an app is used by five different clients, it might be important to keep each client’s data in a separate sheet. However, if you want to build a single app that is used by all five clients, data partitions provide a convenient solution. You can build, maintain and distribute a single app, yet each client sees just their own data and the data sets for each client are all kept physically distinct.
1 Like