Fire Event Through Business Rule When Planned Start Date Reaches 24 Hours

[tiguin2798]

Hello,

I have created a business rule on my change table that is firing a script that sends a notification. This is working as intended for the most part. My only issue is I cannot seem to get the business rule to fire the event when I want it.

Ideally, this should be firing when the current time reaches 24 hours before the planned start date. I tried to do planned start date relative to after 24 hours from now. I also tried to do planned start date is tomorrow as this would have worked as well. The issue is if I run the business rule after or before insert/update it ONLY runs when the record is updated. I would like for this to run on it's own without having to update the change records. How can I achieve this?

I am not familiar with java script, so if a script is needed can the code please be provided?

[Bert_c1]

Put your logic in a scheduled job.

[tiguin2798]

Trying the scheduled job method while waiting on responses below for the flow designer method. Can you please check my script below to verify this is how I would state the parameters on the change table? I am also not sure what the difference between the time and run time is if you could clarify?

[Swapna Abburi]

@tiguin2798 

Business rules get triggered when there is a server-side transaction such as Insert, update, query or delete. Hence for your use case, Business rules won't work. Instead, you can use Scheduled job or a Flow designer with trigger type as Scheduled. Scheduled job requires a bit of JavaScript but with Flow designer you may not need script to achieve your use case.

[Arya123]

Hi,

Using Scheduled job you can achieve the output or you can try using Flow Designer also.