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. 00:15 User question: How to create a Markdown custom widget with Total Sales? 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? Useful Links: - Grist: https://www.getgrist.com/ - Community Forum: https://community.getgrist.com/ - 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/