Basic Columns

Add columns to your sheet from the data editor

Basic Columns are distinct from User-specific columns as they can only hold one value. Basic columns can live in Google Sheets and Glide Tables.

You can view and edit your app's data in your Google Sheet or in the Data Editor.

Glide creates different column types in the data editor based on the types of data it finds in your sheet. You can see the result of this in the column icons of the data editor.

Above we can can see: Audio, Date, Number, Rich Text & Link column types.

Formatting Basic Columns

Some column types like Date & Time or Number allow you to format your data.

Adding Basic Columns

You can use the data editor to add columns to your sheet by selecting 'Basic Column' in the add column dialogue.

This can also be useful if you don't want to leave the data editor but is also beneficial if you want Glide to recognize a column type when that column doesn't have data in.

For example - below we create a new image column and go straight to the data editor. Because the data editor recognizes that column as an Image Column - we can use the built-in image picker.

Making Basic Columns User-specific

You can also make basic columns you add in the Data Editor User-specific. This means that the column won't live in your sheet anymore, but allows the data in that column to be specific to each user. Read more 👇