JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Copy of Playground Doc - [SHARED]
About
Table Sort Control
One Click Timer
Time in 1/100 second
Button to log time
Click Thru Button
Working Days Remaining
Working Hours
Delete Empty Rows
Multiple Ranked Lists
Three Most Recent Rows
Search with Regex
Search with Clear Search Button
Search with Accuracy Meter
Find Tags in a Post
Language Translations
Split First and Last Names
Mark Row as Opened
Project Tasks for CAD
Random Numbers
In List 1 not in List 2
Custom Units
Reverse a String or Number
Barcodes / Check Digits
Luhn Algorithm
vCard QR Code
Scientific Notation Display
Lookup Column Schema
Price by Date
Time Zones
Pixel Image
More
Share
Explore
Lookup and Select List Column Schema
This schema helps to narrow down a dropdown list to relevant items, while still maintaining the "a change here affects everywhere" benefit of lookups.
Initial table for the top level items.
Categories
Categories
0
Category
Category
1
Fruit
2
Number
3
Car
There are no rows in this table
Secondary table that further breaks down the top level items.
Sub Categories
Sub Categories
0
Category
Sub Category
Category
Sub Category
1
Fruit
Apples
2
Fruit
Oranges
3
Fruit
Bananas
4
Number
1
5
Number
2
6
Number
3
7
Car
Tesla
8
Car
Jeep
There are no rows in this table
The data table that puts the two together and uses a
Lookup
column for Category and a
Select List
for the Sub Category column.
Data Table
Data Table
0
Category
Sub Category (Filtered)
Sub Category (All)
Category
Sub Category (Filtered)
Sub Category (All)
1
Fruit
2
Number
3
Car
There are no rows in this table
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.