Skip to content
Gallery
Kirk - DOCtorate Capstone
Introduction
Job Tracker
Freelancers
Helper Tables
Share
Explore

icon picker
Introduction

Kavan Kirk

Welcome to my Task Manager Coda DOCtorate Capstone Project!

I have changed the subject material to protect our company data. In this Doc, our project is to re-rate the top 100 movies of all time (taken from imdb.com). In order to accomplish this, we will be sending out 3 types of jobs to freelancers:
Summary
Ratings
Blog Posts
In the Job Tracker, it starts with a button:
Add 7. Gone with the Wind
⁠
⁠
This button is looking at our list of movies (
Movie Profiles
⁠
) and adding the next one that is not on the table
This is accomplished in the
Helper Tables
⁠
page
Using Variable Table, it will check if “n” exists in the Original Rank column and if it does, it will allow you to press
Job Tracker While Loop
⁠
, which will update the variable “n” in the table as well as all of the reference cells that come above the table.
These reference cells are used to populate the label of the button as well as the starting info once a row is added. They use the “Fetch Cell Data” function from the Google Sheets Pack.
If we come across a movie we would like to add that is not in the original top 100 list, we can use the next button:
Add New Movie Not On List
⁠
which will allow us to insert any movie we choose.
Once a movie is added into our table, it will mark our 3 jobs as “Not Started”, enabling the “Start Job” button to be pressed. All this button does is mark each job as “Ready to Send”
Now that a job is marked as “Ready to Send” it will allow us to push the button “Send ___________ Order” where the blank is any of our 3 jobs.
We are sending these orders to freelancers/coworkers in Slack. The full list of people to send orders to can be found in
Freelancers
⁠
⁠
This table houses information like which job they work on, their rate of pay, their current orders, etc.
They are then separated into tables in
Helper Tables
⁠
by their jobs
These tables are filtered to only show people who currently do not have a job in progress.
When the “Send ___________ Order” button is pressed, it will pull someone from this list and send them a Slack message to the channel in
Freelancers
⁠
that says something along the lines of “Hello, we have another job for you here” and then further elaborate on the job.
It will also update the Date Sent to Now() and the Status to In Progress
While the freelancers are working, nothing on the table will change. Once they are done, they will check a box on the “Mark as Done” sheet and list their billable hours for the movie they worked on.
Doing this will alert Coda through FetchCellData() and change the value of Mark as Done from FALSE to TRUE - enabling the Mark as Done button to be pressed.
Pressing the Mark as Done button will change the status to Done, the Date Done to Now() and populate the Hours column, which will in turn populate the Cost column
It also allows freelancers to get sent another job
There are so many buttons to provide the capability for automation. I have a simple one going on here that will just press all non-disabled buttons every hour
The last thing on this table is a Progress Bar that is summing the “Progress Values” of each status as it changes and compares it to the total amount of Progress Values that a row could have.

One thing I did not include here is editing. This will account for the last status “Processed”. We have a Cross-Doc table currently set up for our editor which uses the Cross-Doc pack to push a button letting us know when the subject matter has been edited. The editors table is filtered down to only jobs that are marked “Done”. If anyone is interested, let me know and I can make an example for how to make that page.
Another thing that is not in this project is a Payroll table. It is basically a template that takes a job that has a “Date Done” that falls within a certain payroll week and sums the total amount we owe each freelancer. Again, if anyone is interested I can make another Doc.



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.