Is it possible to schedule a workflow to run every...
# suiteflow
r
Is it possible to schedule a workflow to run every 3 hours? 🙃
a
It isn't unfortunately; only daily or every 30 minutes. This always frustrates me since scheduled scripts offer so much more flexibility for seemingly no reason.
r
Cheers for swift reply, I thought that... I have a workflow that runs a saved search criteria. I can see there is a option to run the workflow off a mass update but that is not possible since my workflow is dependent on the search! Disappointing ☹️
a
Well and you make a scheduled mass update but those are worse since you can only run them daily at most, and you don't get to pick the time they run at.
I have seen folks set up multiple "copies" of the same saved search and set up multiple alert emails or potentially multiple workflows to run at different times of the day to handle them, which is doable but terrible because you have to maintain multiple of basically the same object.
k
I mean, if you get creative enough you can make it work every 3 hours effectively.
Depends on what the workflow is doing
a
I suppose you could do something with the system time and a filter in your saved search, that's true - so the search returns 0 results unless the system clock is where you want it to be?
k
I was just going to say edit your date/time filters appropriately so that it groups it into chunks - and until that chunk is over a certain age - it doesn't meet the criteria
that said - your idea could work as well, only problem is that scheduled workflows often run in 15 minute windows as opposed to on the time frame exactly
a
right
as you said it really does depend on what the workflow needs to do
if it's doing something on a record, you could also store a custom field with something like "date/time the workflow on this record last did its thing" and check that in your search criteria - if it's been at least 3 hours, it enters the workflow and updates the field to the current time
k
again - probably need to know more about what the workflow is doing as to which option might work better.
r
The requirement is to run at the following 11AM 2PM 5PM 11:30PM They want the 2PM and 5PM so it’s kept as up to date as possible during work day. The workflow is for SuiteBilling Change Orders. I have put in a custom tick box to say “reviewed” and a custom dropdown “reviewed by” If the value is below a certain amount the workflow will automatically tick the box and set reviewed by as system on any change orders that meet the search criteria Since they will creating change orders every day, they want it to run often so it’s up to date and their dashboard only reflects the record that actually need their review etc
I was also thinking of the multiple workflow approach but thought it’s not very tidy 🧐
Also I can’t do a user event save because the Change Order value is being picked up by a dynamic field which populates after the record is saved etc.... so another hoop I had to jump was using the search approach with SuiteBilling 😁 now the problem is the scheduling đŸ˜