Solved: Schedule daily consolidated email/file based on co... - Page 2

Nishit · 06-16-2022 12:40 AM

Hello anyone reading

I have made an app that allows users to make modifications to a text field. If user makes a change then a column which monitors changes in the sheet gets updated by a 'ChangeTimeStamp'

Now I need a daily file/email that consolidates all the changes that happened in the last 24 hrs in the entire app.

I have been semi-successful in this pursuit as I have been able to send emails for individual updates using scheduled event and 'ForEachRowInTable' but I want to do have a single email/file. Currently, I am bombarded with multiple emails (one for every change)

TIA

Aurelien

Perfect. Remove any libe break.

Like this:

Intent	Utterance	Response
<<Start: FILTER("Master Sheet",AND((TIMENOW() - [_THISROW].[Change Time]) < "024:00:00",(TIMENOW() - [_THISROW].[Change Time]) > "000:00:01",ISNOTBLANK([_THISROW].[Change Time])))>><<[Intent]>>	<<[Utterance]>>	<<[Response]>><<End>>

View solution in original post

Nishit

@Aurelien

It worked yet it didn't.

With this change I am able to create a report but the generated report is having an error.

Intent	Utterance	Response
<<templateReference:id=1>>

Searching for "templateReference:id=1", I find hits in this forum saying the reason for this is that there's no data which matches the filter condition.

After a lot of hit and trial the following did work

<<Start: FILTER("Master Sheet",AND((TIMENOW() - [Change Time]) < "24:00:00",(TIMENOW() - [Change Time]) >= "00:00:00",ISNOTBLANK([Change Time])))>><<[Intent]>>

So now I can schedule a daily file that contains those rows which changed in the last 24 hours.

Thanks for the help

View solution in original post

Schedule daily consolidated email/file based on condition