campaign

Join us virtually for a day of dev and community sessions at GristCon on September 18th!

Register now

Grist Secrets 🤫

In August, Natalie shared some not-so-secret secrets of Grist! Whether you’re a beginner or a seasoned user, you’re bound to discover something new in this webinar where we dove into corners of Grist that are as helpful as they are obscure. From handy shortcuts that save you time, to underused features for customizing Grist even further!

Timestamps

00:28 âť” User Question: Are there row style options beyond changing color? (âś… Answer: Yes! Row Height)
00:45 âť” User Question: Can Grist handle massive data? (âś… Answer: See Limits and Self-Hosted Grist)
01:26 âť” User Question: Can I copy the formatting of one sheet and then apply it on another that has the same data schema?
02:36 ❔ User Question: Any plans for an AI assistant to take a prompt and help create a data table? (✅ Answer: It already exists👍)
03:30 âť” User Question: How to connect a front end to a Grist based db? (âś… Answer: Not recommended)
03:46 Intro
04:45 Grist Home Page
— 04:50 Team Site Switcher
— 05:15 Viewing Grist Version
— 06:12 Creating a workspace
— 06:36 Setting icons for documents
— 07:11 Pinning / Unpinning documents
07:29 Profile Settings
— 07:49 Light / Dark Mode
— 08:13 Language Selector [CONTRIBUTE HERE]
08:50 Document Settings
— 09:08 Document Type
— 10:26 Formula Timer
— 11:58 Reload Data Engine
— 12:37 Attachment Storage
13:25 Raw Data (Usage)
— 14:34 Duplicating a table
— 15:43 Editing & Disabling Record Cards
18:40 Creator Panel – Table Tab
— 19:00 Widget Title & Description
— 20:33 Change Widget button
— 23:14 Grid Options / 🦓 Zebra stripes
— 23:45 Max Row Height
— 25:50 Hiding / Unhiding columns
— 26:20 Sort & Filter
—— 26:40 SORT: Use choice position
—— 27:25 SORT: Empty values last
—— 27:45 SORT: Natural sort
—— 28:37 FILTER: Pinning filters
30:44 Creator Panel – Column Tab
— 30:50 Column Label & Column ID
— 32:43 Column Description
— 33:46 Header and Cell Style
— 34:28 Conditional Formatting
— 35:43 Common v. Separate Settings
— 39:55 Apply Formula to Data
— 42:20 Applying colors to choice values
38:28 âť” User Question: Can you apply cell style or conditional style to the whole row? (âś… Answer: Yes!)
41:11 Using trigger formulas for data cleaning
43:34 Left-hand Navigation Panel
— 43:51 Nesting pages
— 44:54 Setting default state (collapsed v expanded)
— 45:52 Adding emojis to page names
46:45 Widget menu
— 46:55 Show Raw Data
— 47:27 Create a Form
— 48:14 Collapse Widget
— 48:36 Duplicate Widget
49:25 Updating an existing widget to ‘Select by’ another
50:30 F1 brings up the list of keyboard shortcuts!
51:26 ‘Use as table headers’
52:20 ‘Copy with headers’
53:25 ‘Filter by this value’
54:02 New Record Button [BETA]
56:00 Creating Popups

Useful links:

Other links mentioned: