Hi I have a question about workflow. I am using a Timesheet app (based on the sample template) and I would like to generate a weekly summary of hours with different filters, ie., date, employee, job assignment. Is this only possible with the Report function or can I do this with a workflow rule?
Yes you can use both
@Aleksi_Alkio what would an expression look like for a workflow rule that would be sent weekly? With only data from the last week? I have been trying to find examples but no luck.
Something likeโฆ <<Start: ORDERBY(SELECT(Table[KeyColumn],AND(WEEKNUMBER([Date])=WEEKNUMBER(TODAY()-7),YEAR([Date])=YEAR(TODAY()-7))), [Date],FALSE)>> and possible other filters inside that AND expression.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |