Multiple duplicate apps pointing at different tables

I have an app designed to present information to the user from google sheets.

We have lots of different client tables with unique data but the same column format. I cannot merge tables for security reasons (i.e. I canโ€™t make one master table then partition within AppSheet). Currently I am copying the app, renaming it and pointing it to a different table in google sheets as a way of creating new apps for different clients. This clearly isnโ€™t a scalable solution as if i want to make changes to the app, they all must be done separately.

Is there some way of making a โ€˜Masterโ€™ app, where the โ€˜daughterโ€™ apps will inherit any changes to the master?

Or is there some way of the user selecting which table the app should point to, from an option of โ€˜allowedโ€™ tables as defined for each user by the administrator?

Any other advice on other ways to tackle this issue in a scalable manner would also be much appreciated.

0 1 177
1 REPLY 1

Worth reading the app scaling from here.

Top Labels in this Space