We have a lot of Grist templates, but we’ll never be able to build one for everything. Generating the basics is something that AI does really well. We began with a blank page and ended with a custom foundation for a specific use case, with Grist’s Assistant doing all of the heavy lifting. A simple, practical look at what AI can (and can’t) do with relational spreadsheets.

Timestamps

00:10 🚨 NEW FEATURE ALERT: Date helpers
02:03 💡 Tip: ‘View As’ feature for Access Rules
02:52 💡 Tip: ‘Only show documents’ on Grist home page
03:38 Introduction
05:02 Getting started with the Assistant
06:27 Adding sample records
06:50 Fixing a reference column
07:28 Fixing a date column
08:33 Adding and modifying a choice column
09:47 Adding another table
10:16 💡 Tip: Add sample records to confirm everything works as expected!
12:35 Adding a formula
15:52 Filling in data
16:06 Creating a trigger formula
16:48 Error handling
19:18 Updating Year column to run from Dec 25 through Dec 24 of following year
21:35 Renaming a column
22:33 Building a dashboard with a summary table
24:13 Renaming a page
24:30 💡 Tip: Add an emoji to the page name to replace the box icon
24:45 Adding linked widgets
28:02 ❔ User Question: Will it make the initial frontend that the end user sees to add kids, behaviors and tasks, etc.?
28:43 Clearing sample data
28:50 ❔ User Question: You have multiple pages, a user could get confused. How to create a single data entry screen?
28:57 Add widget descriptions
31:19 General information about the Assistant

Useful links:

• Assistant: https://support.getgrist.com/assistant/
• GetGrist.com | Resources | Webinars: https://www.getgrist.com/webinars/
• Community Forum: https://community.getgrist.com/
• Help Center: https://support.getgrist.com/