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?
Thank you all for your assistance! I think running it through a flow with the trigger as scheduled will work for my need. I do just have one more question. During my test I only received one notification where I should have received 2 for different change records and I think that is due to when it is looking up the record in the flow it states 'if multiple records are found action - return only the first record'.
How do I have it run this for each record? The only other option I see is to fail the step.
Edit: I realized I can do 'lookup records' for it to find multiple, but then it does not allow me to pull 'records' into the action to fire the event. I am still not sure how to have it fire the event for each record it pulls here.
