This little template can be paired with a master sprint plan, content calendar or general workspace dashboard if so desired. I would get creative with relations in this case. I have not implemented it as of yet into my work page due to a pause to my client work, but I will be using it in the future. This is something I’ve always wanted - an hours logged per task database. My log has only one property for hourly-rate of which requires an amount of money earned per hour input, however, I’m aware some freelancers have multiple hourly rates for certain projects. In this case I would turn the hourly-rate formula into an “IF statement” (example below).
Hours Logged Formula:
dateBetween(prop("Clock Out"), prop("Clock In"), "hours")
Pay-Out Formula:
prop("Hours Logged") * prop("Hourly-Rate")
Customize hourly-rate formula in relation to certain project type:
if(prop("Job") == "INSERT JOB HERE", #, if(prop("Job") == "INSERT JOB HERE", #, 0))