During November’s webinar, Anais discussed the difference between typical formulas and trigger formulas, and when to use which. She also shared some of her favorite formulas and dove deep into how to use reference columns in lookup formulas.
Timestamps
00:31 DnD Encounter template 00:50 Embedding iframes in custom widgets 02:55 The difference between trigger formulas and regular formulas 04:15 No code hiring template walkthrough 05:45 Auto-adding a date with trigger formulas 07:35 Auto-adding user information with trigger formulas 08:29 Data cleaning with trigger formulas 11:07 Understanding .format() formula 13:08 Reverse reference lookup – finding all the records related to a specific record 18:24 Looking up fields with a lookupRecords() function 18:34 Combining AVERAGE() and lookupRecords() 18:53 How to use IFERROR() 19:58 Formula challenge – funding duplicates 21:15 Changing the currency on the invoice template’s custom widget 23:24 Best way to learn Grist? 24:39 Comparing Grist and Airtable 28:40 Grist won Product of the Day on Product Hunt! Thank you!!
Recent Webinars
Building a complete app with Grist + MCP
See how Grist’s MCP server can create a full-blown data application in a single session. Also, learn how secure and sustainable AI workflows are on top of Grist’s stable structure.
How do I self-host Grist?
Join Grist developer, George, for a complete walkthrough of self-hosting Grist from scratch.
How Epoch8 uses Grist to make AI agents query client databases accurately
When the AI agent gets a query wrong, most teams add more prompt engineering and pray it holds. Here’s how Epoch8 built the metadata layer instead.
