Manage an app's Data and File sources in one place

[Connor_Mooney]

When using the Manage > Versions > App Upgrade feature to update a deployed production version of an app with the newer test version of an app, you still need to drill into each table and reset their data sources from the test source to the prod source, and to update any file columns to point to the prod folder location instead of the test folder location.

This request is to build a menu that lets you update all of your data/file sources in one place. For Example, the Source column in the table below would show the source currently being used, and clicking the value:

Table Sources

Appsheet Table Name	Source	Sheet/Qualifier
Table A	test_spreadsheet1	tab_A
Table B	test_spreadsheet1	tab_B
Table C	test_spreadsheet2	tab_A
etc.	etc.	etc.

[Marc_Dillon]

Data sources are typically comprised of 2 items, a source (spreadsheet or database), and the actual table (sheet tab, database table, or database view). I'd modify your request to be able to set the source for the entire app. That way, assuming all of your tables are within the same source, you can quickly switch all tables at once.

But either way, yah, something like this would be helpful.

[Connor_Mooney]

Yeah, being able to change all sources for the entire app would be easier, but I wasn't sure if there would be scenarios where the table locations in the Production environment are different enough from the TEST environment that a single source update for the app would work all of the time.