I have a table with the hours I work on a project.
It contains date, project and worked hours.
It also has the month as calculated field. (201902)
Using Page Designer block, I want to create invoices.
I created an Invoice table. It has the customer info etc. Now I need a field in that invoice table (probably a link to another table, to be created) where get 1 record per project I do for that customer, with the sum of hours.
But I don’t know how to get the sum of hours, grouped by month and project. (I do know how to get that in a view, but I cannot use that in another table)
Is there a way to do this?