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
Best practices

checked-checkbox

Practice with best practices.

If you haven’t yet watched it,
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 a quick to-do list:
Add a new page and title it Backend.
Type “/table” on this new page and name it Tasks.
Set the table up to have the following columns:
Task Name (this should be your display column)
Due date (change the column type to date)
Owner (this could be a text column type, but it really gets exciting if you make it a people column)
Done (change the column type to a checkbox or toggle)
Priority (change to a scale column type)
Add some sample tasks.
Return to this page and type “/Tasks” to create a view of your Tasks table.
Name the view Incomplete Tasks, then filter this view to show only incomplete tasks.
Now, mark a task Done.

Expand to reveal example.


A table like this should be on your Backend page:
Answer: Tasks
2
Task Name
Due Date
Owner
Done
Priority
1
Decide on lunch
4/5/2023
Adam Davis
2
Order lunch
4/12/2023
Alan Chowansky
3
Eat lunch
4/12/2023
Buck Dubois
4
Order Dinner
4/19/2023
Mary Jones
5
Eat Dinner
4/19/2023
Polly Rose
There are no rows in this table
⁠
⁠

A view like this of your Tasks table should be on this page:
Answer: Incomplete Tasks
2
Task Name
Due Date
Owner
Done
Priority
1
Order lunch
4/12/2023
Alan Chowansky
2
Eat lunch
4/12/2023
Buck Dubois
3
Order Dinner
4/19/2023
Mary Jones
4
Eat Dinner
4/19/2023
Polly Rose
No results from filter
⁠
⁠

Up next:
Patterns
⁠


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.