I’m trying to generate a block of text with totals of hours summed by “task” from a set of linked timesheet records.
As a really simplified example, suppose I have the following timesheet table linked to my invoice record:
Hours Task Link
2 Work InvoiceXX
5 Play InvoiceXX
1 Play InvoiceXX
5 Work InvoiceXX
3 Sleep InvoiceXX
In my InvoiceXX record, I want to generate a list like this with sub-totals by task for the Page Designer block:
I’m guessing I need to rollup the unique task name values and use those to conditionally sum my hours, but I don’t see how… (I guess I need more sleep.) Is there an example base here that tackles this?