In June, we learned what references are, how reference columns work in Grist, and explained how to use them to build productive dashboards using the Event Speakers Template.

Timestamps

00:15 User question: How to create a Markdown custom widget with Total Sales? ✅ See Answer
03:58 User question: Forms questions
07:00 Intro
07:23 Event Speakers template walkthrough
09:23 Importing data into Grist
10:31 User Question: Does each row have a unique ID and can we use it as an identifier?
11:30 D.R.Y. Principle (Don’t Repeat Yourself)
12:51 Creating a reference
15:16 Record Cards
16:17 Adding more data from the referenced table
19:13 Dot Notation
20:55 User Question: What’s the UUID?
22:09 User Question: How to book one speaker for several events?
22:50 Linking widgets
26:48 Reverse lookups and lookupRecords
33:53 Tip: Use toggle column when working with true/false values
34:31 Tip: Change the toggle color using Cell Style
38:03 User Question: I have table of Projects and table of Partners. I want to add a partner to a project from both Projects table and Partners table.
40:18 User Question: I have an Event table, Donation table (linked to Event), and a Person table (link to Donation), how do I create a dashboard where I would select an Event and see all Donations, then total donations from each Person. A person can make multiple donations for a single event. Would also like to see total donations for a single event.
45:37 User Question: Do you and the devs follow the Community posts? (Answer: YES! 🎉)
46:24 User Question: Is it possible to have a 1-to-1 relationship?

Links:

• Community Forum: https://community.getgrist.com/
• Discord Server: https://discord.gg/MYKpYQ3fbP
• Help Center: https://support.getgrist.com/
• Event Speakers Template: https://templates.getgrist.com/iCJe3aXg7Ha4/Event-Speakers/
• Reference Columns: https://support.getgrist.com/col-refs/
• References and Lookups: https://support.getgrist.com/references-lookups/
• Record Cards: https://support.getgrist.com/record-cards/
• 📺 Markdown Widget Magic 🧙‍♂️ Webinar: https://www.getgrist.com/webinars/markdown-widget-magic/
• 📺 Forms Webinar: https://www.getgrist.com/webinars/form-widget/
• ✅ Including a Sum in a Markdown Widget: https://community.getgrist.com/t/including-a-sum-in-a-markdown-widget/5394