Glide Library
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.

Adding Basic Columns

You can use the data editor to add columns to your sheet by selecting 'Basic Column' in the add column dialogue.
Adding a Basic Column
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.
Adding an Image Column

Changing Basic Column Type

You also have the option to edit the column type of your basic column.
To do this, click on the drop-down button to the right side of the column header and click on Edit. From there, you can change the column type to any of the basic column options provided.
Changing the Basic Column Type

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 ๐Ÿ‘‡

Date & Time Column

When you enter a date, a time or a date + time in your sheet, Google Sheets will recognize this format and automatically apply the right format to that cell. Read more here.โ€‹
The Data Editor will also recognize this format and automatically assign a Date/Time Column type.
When the Data Editor recognizes a column as a date, a time or a date + time you get access to the Date/Time formatting settings.
Last modified 1mo ago