Reminder workflow not working

d.hickey

I have a workflow specific to a rush order. When rush order is stared on the form, the workflow triggers to run hourly. Then there is a condition "If rush order is "checked" and status is "submitted" instead of accepted or declined it sends a reminder to the approver. The alert works once but doesnt continue to send reminders like I want it to.

Paul Newcome

Ok. So the trigger is the issue. You have it set to only grab rows that have been added or changed within the past hour.

My suggestion (tedious but effective) is to adjust the trigger to be daily (date based with custom selection of every 1 day) and run at a specific hour with the same conditions.

Duplicate the workflow and adjust the hour to be the next hour. Duplicate again and adjust the hour. So on and so forth for each hour that you want to run the workflow on (this allows you to restrict it to only during business hours so someone isn't getting a ton of emails all about the same thing while they are sleeping).

Paul Newcome

Are you able to provide screenshots of the automation?

d.hickey

Certainly, here you go.

Paul Newcome

Ok. So the trigger is the issue. You have it set to only grab rows that have been added or changed within the past hour.

My suggestion (tedious but effective) is to adjust the trigger to be daily (date based with custom selection of every 1 day) and run at a specific hour with the same conditions.

Duplicate the workflow and adjust the hour to be the next hour. Duplicate again and adjust the hour. So on and so forth for each hour that you want to run the workflow on (this allows you to restrict it to only during business hours so someone isn't getting a ton of emails all about the same thing while they are sleeping).