Filtering a reference or choice column’s dropdown list is very useful in a variety of use cases. In May, we showed you how to write dropdown condition formulas for the most common scenarios.
Timestamps
02:22 - Grist Card Tip #1 - space bar
02:52 - Grist Card Tip #2 - raw data config
05:38 - Beginning of Webinar and review of examples
08:35 - Example #1 - Country and City Data (San Jose)
09:14 - Reference Examination and Reminder
10:23 - Record ID Refresher
11:25 - Continent Reference Column Sub Example
13:30 - Dropdown Condition for Country
15:20 - User Question Regarding Non-Matches
17:05 - Example #2 - Gig Staffing
17:42 - Dropdown Condition for Roles (Purposely incorrect)
19:30 - Dropdown Condition for Roles (Correct)
20:07 - Example #3 - Expert Witness Database
21:48 - Dropdown Condition for Primary Fields
23:30 - Dropdown Condition for Roles
25:55 - Review of Country Dropdown Condition
29:30 - Reference Shortcut/Tip
Useful Links:
- Webinar Template #1: 5-16-24 Population Rankings - Grist
- Webinar Template #2: Expert Witness Database - Grist
- Webinar Template #3: Gig Staffing - Grist
- Grist: https://www.getgrist.com/
- Community Forum: https://community.getgrist.com/
- Discord Server: Grist
- Help Center: https://support.getgrist.com/
Other Links Mentioned:
- Column Types Webinar: Grist Webinar - Understanding Column Types and Version Control
- Reference Columns Guide: Reference Columns Guide - Grist Help Center
- Filter Reference Choices in a Dropdown: Reference columns - Grist Help Center