Hi I have a question about workflow. I am usi...

(Eli) #1

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?

(Aleksi Alkio) #2

Yes you can use both

(Eli) #3

@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.

(Aleksi Alkio) #4

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.