Glide Library
Introduction to Data
Learn the basics of Glide's Data Editor
All software is powered by data. Data may sound like an abstract idea, but it’s just the 'stuff' your software is about: products, customers, staff, locations, etc...
Tables & spreadsheets are the best way to organize and think about data, so Glide lets anyone build software from spreadsheets and other data sources.
The Data Editor is where you manage your project’s data. You can edit in the data editor or wherever the data is stored. Everything stays in sync.
A view of the data editor, with a Google Sheet as the source

Data Structure

Before you start a project in Glide, it’s important to consider the structure of your data. In other words: what your project is about.
A team directory may be quite simple and only have two tables, one for people and another for locations.
But if you’re making a project to help with inventory management, it might well be more complex.
You’ll probably need tables for:
  • Inventory items
  • Customers
  • Suppliers
  • Orders
But maybe there’s a delivery aspect to it, in which case you might need tables for:
  • Deliveries
  • Drivers
  • Vehicles
  • Warehouses
You can add new tables whenever you want, but as you can see, it's worth establishing the most important tables upfront.
Within each table, the first row should be column names. These column names should describe the properties of your items.
For example, if you’re making a team directory for your company, the first row could contain column names like Name, Role, Title, Number, and Photo—because these are the properties that each person has.
After the first row, every following row should have values in each of those columns;
It's okay to leave cells empty. But if you leave big gaps between rows & columns, Glide may not pick up your data correctly.
Don't leave big gaps between rows & columns

Basic Columns

Basic columns live in your data source as well as the Data Editor
Basic columns are simple columns that just contain data. They're the same as the ones that live in a spreadsheet.
Any new column you make in your spreadsheet will become a ‘basic column’ in Glide. Glide will look at the data in this column and assign a type to that column.
For example, if you add a number column, you’ll be able to format those numbers – or if you add an image column, we’ll show you the image thumbnails, and you can even upload images or pick royalty-free ones from Unsplash.
You can preview images in the Data Editor
If you want to change the column type, you can click on the dropdown menu, click edit and change the column type.
You can create new basic columns at any time with the new column button. These will be added in your data source as well.

Computed Columns

In addition to the basic columns, Glide adds a special type of column called a Computed Column.
App & websites need to do things that aren’t easy or even possible to do with spreadsheets alone, so computed columns introduce new concepts on top of spreadsheets that allow you to structure and connect your data in powerful new ways.
For example, the distance column calculates the distance between two locations, and the template column lets you replace parts of your text with unique values from each row.
The template column replaces text with values in other columns
Read more about the types of computed columns here 👇
Last modified 1mo ago