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
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.
Automations: The Beginning
Automations are here! Join us to learn how to automatically send email notifications when your Grist data changes.
How to set up Grist automations with n8n
Curious about setting up workflow automations? Join us as we look at helpful examples of Grist automations with n8n.
