Skip to content
Databases 101 companion doc
Databases 101 companion doc
Sample databases
Coda tip: Importing data into Coda
Best practices
Patterns
Translating from a spreadsheet
Troubleshooting
Coda tip: Referencing a row
More
Share
Explore

icon picker
Patterns

checked-checkbox

Practice with patterns

⁠
Open the lesson video
⁠
in a new tab. Then, follow the steps below to put that learning into action. Once you’ve completed the tasks (or if you’re stuck), you can check your work by expanding the example dropdown.
Create another view of your Tasks table (type “/tasks”).
Add a column called Team.
Make it a relation column, create a new Team table when prompted, and put that table below your newly created View of Tasks table.
Add some teams in your Team table.
In your View of Tasks table, assign some teams to tasks.
Back in your Team table, used a linked relation column to pull in the tasks assigned to each team.
Count those tasks in another column in your Team table.

Expand to reveal example.

Answer: View of Tasks
2
Task Name
Due Date
Owner
Done
Priority
Team
1
Decide on lunch
4/5/2023
Adam Davis
Design
2
Order lunch
4/12/2023
Alan Chowansky
Sales
3
Eat lunch
4/12/2023
Buck Dubois
Design
4
Order Dinner
4/19/2023
Mary Jones
Sales
5
Eat Dinner
4/19/2023
Polly Rose
Marketing
There are no rows in this table
⁠
Answer: Team Table
0
Team
Tasks by team
Count of tasks
1
Design
Decide on lunch
Eat lunch
2
2
Sales
Order lunch
Order Dinner
2
3
Marketing
Eat Dinner
1
There are no rows in this table
⁠
⁠

Up next:
Translating from a spreadsheet
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.