Adapting from Spreadsheet to Database

On October 18th, 2021 we held our first Build with Grist webinar, focused on best practices to get the most out of Grist.

Grist CEO Dmitry Sagalovskiy shared tips on adapting data from a spreadsheet to a database using the DRY principle, and building dashboards using linked widgets.

Other topics covered include finding the most recent value from a list of historical records, filtering by several fields, understanding the lookup function and reference lookups, and more.


00:14 The Ceasar Cipher, encoding secret messages in Grist
04:05 The DRY principle – best practices in structuring your data
11:52 Importing spreadsheet data in Grist, and adapting it for a database
17:37 Creating a reference between related tables
19:59 Creating dashboards and linking widgets
27:00 Creating true/false conditional formula columns
32:07 Grist automatic backups, restoring and saving backups
35:44 Multi-line Python code
37:50 Importing Python libraries
39:10 Entering only times in datetime columns
43:08 Changing choice columns values based on selection in another column
46:28 Find the most recent value from a list of historical records e.g more recent product price
50:34 Filtering by several fields
52:22 Understanding the lookup function
56:30 Reference lookups