Currently, the built-in settings of scheduled reports only allow the app builder to trigger the reports at regular time intervals: hourly, monthly, etc.
However, you might also want to trigger reports automatically at predetermined dates obtained from the app's data. This can be done using the trigger condition of the scheduled report. The following example will illustrate how this can be achieved.
Suppose you have a table called "Tasks". Each row in this table is a task that you have to perform, and each task has a "Date" column that stores the date when you have to perform the task. You want to set up a scheduled report that will automatically send you an "alarm" message to remind you of the task at 7:00 am on the day the task is supposed to be carried out.
To do this, in the app editor, create a scheduled report. Configure the report as follows:
- Frequency: Daily
- Time: 7:00 am
- Time zone: set according to your time zone
- Trigger condition: TODAY() = [Date]
- For these rows: select the table "Tasks"
Here's how the schedule works. Every day, at 7:00 am, the schedule will go through each task in the table "Tasks", and check the date of the task. If the date of the task is in fact the current date, the schedule will be triggered, and an alert message will be sent.
By modifying the scheduled report in the example above, you will be able to set up your own reports that will trigger at dates stored in your app's data. It's important to note that this design will not work if you want to trigger reports at specific times (hours and minutes) obtained from the app's data.
Check out this demo on reports for more information: