Reference Columns - June 20, 2024

Описание: 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/iCJe3a...
Reference Columns: https://support.getgrist.com/col-refs/
References and Lookups: https://support.getgrist.com/referenc...