Notification

The AppSheet Help Center documentation can now be viewed in Japanese - AppSheet ヘルプセンターのドキュメントが日本語で表示できるようになりました。. Learn more

Add, reorder, or delete columns

As you customize your app, you might need to modify the column structure in a table to add, reorder, or delete columns in a table. You'll need to regenerate the table if you modify the connected data directly.

How to add, reorder, or delete columns

To add, reorder, or delete columns at the global level, do one or more of the following:

To add, reorder, or delete columns for a specific view, for a subset of view types you can control the column order in a view.

Modify the connected data directly

You can modify the connected data directly to add, reorder, or delete columns. For example, if in your original spreadsheet you have three columns and decide to add another column, as shown in the following figure.

Spreadsheet showing the Added Column

After modifying the column structure in your connected data, you need to regenerate the table in the app editor. If you don't regenerate the table, you might see an error similar to the following in the app preview:

Unable to fetch app definition: Error: There is a mismatch in the number of columns between the spreadsheet for Class Descriptions and the table schema. The table has 5 columns but the schema has 4 columns. Please regenerate the table column structure. 

Regenerate the table

Regenerate a table whenever you add, reorder, or delete columns directly in the connected data. 

The column structure will be regenerated and may impact the behavior of your app. Because all changes to your app will be saved, this action cannot be undone.
 
If you are using Google Forms as a data, review Regenerating apps built form Google Forms before regenerating your table.

To regenerate the table:

  1. Open the app in the editor.
  2. Go to Data  and select the table you want to regenerate.
  3. Click Regenerate schema  in the table header.
  4. Click Regenerate to confirm the action.
  5. Save the app.
Alternatively, you can go to Data, position your cursor over the table that you want to regenerate in the Data panel, and select More Three-dot menu vertical > Regenerate schema.
We've made some improvements to the app editor.
You are opted in to the new editor by default, but you can switch back to the legacy editor at any time.

If you are using the legacy editor

  1. Open the app in the editor.
  2. Go to Data > Columns
  3. Expand the table you want to view or edit.
  4. Click Regenerate Structure.
  5. Click Regenerate to confirm the action.
  6.  Save the app.

 When you sync in the app preview, you'll now be able to see your additional column in whatever view(s) you have set up.

Added Column (from spreadsheet) displayed in the app

Regenerate apps built from a Google Forms

If the app was built from a Google Form, the original form configuration will be stored in the response sheet in the form of notes attached to the header row. Regenerating will cause the columns to restore the settings contained within the notes, potentially overwriting changes you've made in the editor. To avoid this, remove the notes from the response sheet before regenerating. If you do accidentally regenerate with notes left in the sheet and lose your configuration, remember that you can restore an older version of the app using version history

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
15996067856517363459
true
Search Help Center
true
true
true