Do when (need help)

Need help Database
1

Hi guys, This is my problem. I have a db called checkout. I want to go from first item to last item compating the creation date and the current day. if the result is 30 days I want to send and email. I want to send this email every time the condition happens. Tks in advance.

2

Have a look at “Schedule an API Workflow on a List”.

That should enable you to do what you want.

3

Tks Nigel. I will

4

Hi Nigel, sorry for bothering you. I can´t get the date comparision…

image
image1366×768 60.6 KB
. Any idea?

5

You haven’t finished the comparison. Basically, here’s what you’ve said:

  • When this checkout’s creation date plus 30 days

I think you want to say:

  • When (current date) is greater than or equal to (this checkout’s creation date plus 30 days)

Am I understanding correctly?

6

Yes. I think I got it. Do you know how often is this recurring event running in order to test if the email was sent?