This is my first time using app sheet. I have created an app using a test sheet so I wouldn’t mess up my data. I now have my app working how I want it to, so I want to switch my data source from the test sheet to the google sheet where my data is actually kept. My actual data has a slightly different column structure, and a different sheet name.
Is there a way that I can avoid having to re-format all of my columns for the new data to match my test sheet column structure? I also need to update all of my views and behaviors to apply to the new data, is there a simple way of doing this?
If you leave the app table name unchanged, this process is much easier.
If you save the changes now, the app may break if the number of columns in the new worksheet differs from the old. If so, users will not be able to access the app. If the number of columns is the same but the columns have been renamed, reordered, or replaced, the app will probably load, but the app will continue using the old column layout, which will cause confusion for both the app and its users.
The next step is to make the app aware of change to the table’s column structure. When you do so, configuration of columns with the same name both before and after will be preserved even if the column has moved. Configuration of columns with names that don’t exist in the new worksheet will be lost. New columns in the new worksheet will be added to the table.
If you have renamed columns in the new worksheet, also rename the corresponding column in the app table:
If you’ve renamed or dropped columns that are used elsewhere in the app, the app editor will inform after the regeneration is complete. This may produce errors that prevent users from accessing the app. Fixing the errors will restore service.
