To only send a scheduled report a day after all additional data has been added

AppSheet AppSheet Q&A
1

Hi all,

Currently I have already created a report for my data. However, I am trying to only send out the report one day after the new additional data has been added. Appreciate some help on this

3X_5_f_5fcdc9c69eeca6763ac24778aee043478a8494a0.jpeg
3X_5_f_5fcdc9c69eeca6763ac24778aee043478a8494a0.jpeg1475×747 57.5 KB

God Bless
Janan

2

Workflow rules only trigger at the time the row change arrives at the server (i.e., when the app syncs); there is no way to schedule a workflow rule at all, let alone one day after a change occurs. The closest you can get is a scheduled report that somehow identifies the changes that happened within the last day that should trigger it and responds to them.

3

Dear Steve,

Thank you. However, I have already done a scheduled report. However, If there is no changes, I do not want it to be send out. I do not want to use a workflow trigger as there are multiple updates on the data everyday. Thus, wanting only one report to be sent out. In the data, I have a column for date input. Would like the scheduled report to be triggered when a date input is of the date is Today()-1. Just not too sure how to go about that.

God Bless
Janan

4

The report would target the entire table:

3X_6_d_6d1fb3a2a050fbeadebd956ba91ed7e65939f95d.png

Then set a Condition that is TRUE only when there is at least one row with a suitable Date column value:

3X_6_c_6cee868667b9907dd03cdc373b212b8dd0fc7088.png
3X_6_c_6cee868667b9907dd03cdc373b212b8dd0fc7088.png674×105 5.05 KB

The Condition expression might be something like this:

ISNOTBLANK(
  FILTER(
    "table",
    ([Date] = (TODAY() - 1))
  )
)

(replacing table with the name of the table)

Your report template would then use a <<Start>> tag to target only those rows:

<<Start: FILTER("table", ([Date] = (TODAY() - 1)))>>

(again with the table replacement)

5

Steve:

auto> ISNOTBLANK(> FILTER(> "table",> ([Date] = (TODAY() - 1))> )> )> >

Thank you so much. This solved my problem