Update Data Source on Copied App??

 Assuming all else is common (table names, structure, etc), is there a way to update the data source in a single place for all tables, as opposed to having to change the data source on each individual table, when copying an app and not copying the data?

More context:

 In our ecosystem, each of our clients runs on their own instance of an application.  When we deploy a new client, or add functionality to an existing version, we have the tedious process of changing each data source for each table in the new app.  
Our structure is like this:

  • Each client has their own sqlDB
  • Each DB is added as a team source in our appsheet account
  • Each client has their own appsheet app.
  • When we copy an app, we go into each table, storage, browse for more data, select the DB, select the table.

All DBs have identical structure - is there a way to deploy an app and set somewhere "use this DB/source" for all tables?

6 REPLIES 6

He man,

I think you posted your own solution 😆

"Each DB is added as a team source in our appsheet account"

You're welcome 😆

 

Denny - we still have to edit each table settings individually, change the source, find the table, then do it again to the next table.

No, there's no way to do that.

Appreciate the confirmation Marc! 

We're saddened at the prospect of outgrowing the platform.  

How about using partition functionality? Then you would not need to copy the app at all.

Separate apps are required for data security.  

Top Labels in this Space