Send Email notification for every three days until a condition is satisfied

kuttti
Kilo Guru

Hello,

I have the following challenge: I have a date field in a table, once the date field in a record is filled and saved, an email notification is sent every three days until a field called "Number" is filled out. It should check on every record in a table. Can anyone please help me out with this?

Thanks!

7 REPLIES 7

Tony Chatfield1
Kilo Patron

Hi, if you want to trigger the email every day you will either need to use a workflow per record that contains a loop triggering the notification until condition x is met IE the number field is populated, or you will need a daily scheduled job that triggers an email via a sysevent for every record in the table that meets the trigger conditions, but not the stop conditions.

Ankur Bawiskar
Tera Patron
Tera Patron

@kutti 

you can use flow designer based approach with no script

refer below link for example and help

reminder email

Regards
Anukr

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

kuttti
Kilo Guru

@Ankur Bawiskar 

From the video, I am confused on how to create a subflow for "Wait for certain amount of time"

@kutti 

You can easily do this using Do Until Flow Logic

sharing link from docs for your help

Do the following until flow logic

Remember there might be performance impact if the do until runs many times

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0827663

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader