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:
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 (