Does the workflow work with date?

[Chengzhi-EXT_GU]

I have a app to send the notice email to user about the equipment’s inspection.

I set the first inspection date for each equipment, next I set the workflow to send out the email before 7 days, like as below.

Equipment 1:
first inspection date : 2019/05/20
workflow condition : Hour([First Inspection date] - Today() )/24 = 7

As per my understood, today I should received the notice email, but not.

Can someone help to check this problem?

I checked this problem in Appsheet website, found the below information:

Each Workflow or Report has three components:

1. When it should run (the triggering Event )
2. Whether it should be performed (the Condition )
3. What it should do (the Action )

In my workflow, there was not data change in the target data, maybe this is the root reason?

[Aleksi]

Are you trying to do this with the Workflow or Scheduled report?

[Chengzhi-EXT_GU]

Thanks for your reply.

Yes, I tried to do this Workflow in the app, but this workflow didn’t work, unless I changed one column’s data and synced it into Google(My data source) to meet the requirement of component 1,

" ***1. When it should run (the triggering Event )***"

According to the explain of WorkFlow in Appsheet website, the workflow just can be executed when data is changed.

So does this means, if I want to receive a notification email 7 days before a fixed date, because there is no actual data change in the data source.

[Aleksi]

For this kind of automatic process you would need to use Scheduled report, not the Workflow. Though you could use Workflow, but then you would need to modify that record before it can trigger your notification.

[Chengzhi-EXT_GU]

After the test with report, I received the notice email as per my setting.

Report is not just the “report”.

Thanks for your help.

[Aleksi]

You’re welcome