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
How Dotphoton built a fully traceable QA system for the European Space Agency
Bruno Sanguinetti of Dotphoton shows how his on-prem QA traceability system that meets the standards of the European Space Agency.
MCP + Grist: A First Look
Join co-founder Stan for a sneak peek at Grist’s official MCP server, making it easier than ever to connect AI tools with Grist.
Vibing with Grist: AI Assisted Custom Data Interfaces
Use AI to bring your data to life. Build dynamic visualizations with Vibe View and interactive widgets with the Custom Widget Builder.
