I’ve put together a To-Do List that our company uses to track what everyone is working on. From top to bottom this is what is included on this page (I’ve included all the columns I normally hide to make it easier to see how the tables are working):
The buttons directly under this are a personal filter for the To-Do’s table. By using the Current User formula at the very bottom of the page, it will allow each user to have their own filter view of the To-Do’s table without affecting every other users view
You must make a row for each user, but each user can only see their row
This is done by Filtering the User column to Current User (I’ve turned this off so everyone can see the filter)
Each button will populate the Current Selection column, which the To-Do’s table is filtered off of (Using the Field(s) column)
With some conditional formatting, you can see which button is currently pressed
The User and Current Selection columns are hidden usually, as well as all of the headers and titles so that it just looks like a row of buttons
For the To-Do’s table, everything after Task Done is usually hidden
When you add a task, it will open a modal to fill out all of the information needed
Once all of it is filled out, someone can claim the task using the Claim Task button, which assigns the current user as the Task Leader
Once this button is clicked, it will send a message to a stand-up slack channel to inform the rest of the team what each member is working on. To see more about that notification, check the Description in the Example Task.
The link may not be working for this example because I used the specific one on our Coda page while adding in the row ID to change with each task
Once a task is complete, someone can press the complete button, which again sends a message to slack, updating the team on the task’s completion.
Everything under the To-Do’s table are just tables used to populate select lists in the To-Do’s table and the Current User formula for the filter table.