AppSheet App Editor Question

[Lindsey_Lindow]

I understand that changing column names in the backend should be avoided, but I need to change one column name in order to avoid confusion for Office/Accounting staff who can view the backend spreadsheet (they are not App users).

In the AppSheet Editor, is there a way to view a summary of all slices, expressions, views, behaviors and bots in the app where [COLUMN] is used?

[SkrOYC · Accepted solution]

---

@Lindsey_Lindow wrote:

In the AppSheet Editor, is there a way to view a summary of all slices, expressions, views, behaviors and bots in the app where [COLUMN] is used?

---

Yep

The same thing would be to type the following URL with your app's UUID:

https://www.appsheet.com/template/appdoc?appId=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX

[SkrOYC]

Also, check this comment by @Steve 

---

@Steve wrote:

When renaming a column, change the name in the spreadsheet, manually change the name in the app editor, then regenerate columns. This will preserve the column's configuration. Note that AppSheet won't care that the column name in the spreadsheet and the column name in the app don't match until you do a regenerate. You can even save with the name mismatch and AppSheet won't care. AppSheet accesses column data by column number, not column name; the names are just to setup the mapping.

You could copy the app and make your changes in the copy. When done and working, copy back to the original. This is cumbersome because you've potentially got a large set of changes that may take a long time.

You could copy the app, make one change in the copy, see what breaks and what's needed to fix, then make the change in the original, knowing what to expect. Good if you want to make incremental changes during a well-defined maintenance window.

You could add a column of the new name to the app, migrate to the new column, blank the old column in the spreadsheet and regenerate columns. This approach keeps the app working with the old column as you migrate and for users that haven't synced recently.

---

Solved: Re: Recommendations for changing column names - Google Cloud Community