Skip to main content
Question

Workflow to run on the due date


Forum|alt.badge.img+3

is it possible to run a workflow on the due date and time? 

trying to provide flexible automation so that the helpdesk team can own the offboarding process, and make adjustments if anyone asks for a small change to one of the offboarding tasks timing. 

trying to use the due date to kick off workflow automation that kicks off powershell scripts. 

how can i get a datetime based event trigger? 

 

Did this topic help you find an answer to your question?

8 replies

Daniel Söderlund
Skilled Expert
Forum|alt.badge.img+14
gdavid16 wrote:

is it possible to run a workflow on the due date and time? 

trying to provide flexible automation so that the helpdesk team can own the offboarding process, and make adjustments if anyone asks for a small change to one of the offboarding tasks timing. 

trying to use the due date to kick off workflow automation that kicks off powershell scripts. 

how can i get a datetime based event trigger? 

 

Have you looked att the scheduled worksflows?


afautley
Skilled Expert
Forum|alt.badge.img+11
  • Skilled Expert
  • 194 replies
  • May 15, 2024

I agree, scheduled workflows would work need to see if it can interact with due date, if not then ask fresh to add it. 


Daniel Söderlund
Skilled Expert
Forum|alt.badge.img+14

 

diffInDays('{{current_date_and_time_iso}}','{{ticket.due_by_time_iso}}') <= 30

That is if it’s less then 30 days. you could change it to static 10 days.  == 10 
 

 


Daniel Söderlund
Skilled Expert
Forum|alt.badge.img+14

It’s this as well I think. The wording is a bit off 

 


Roxwell
Contributor
Forum|alt.badge.img+9
  • Contributor
  • 225 replies
  • May 15, 2024

So what i normally do with auto leaver, is say If “Leaving Date” is Less than today, then run at the scheduled time. 

 

I find due date on a ticket to be a little fussy with triggers and setting automatically, but you can use any date /time field on a ticket, as the trigger for a Scheduled workflow. 


Daniel Söderlund
Skilled Expert
Forum|alt.badge.img+14
Roxwell wrote:

So what i normally do with auto leaver, is say If “Leaving Date” is Less than today, then run at the scheduled time. 

 

I find due date on a ticket to be a little fussy with triggers and setting automatically, but you can use any date /time field on a ticket, as the trigger for a Scheduled workflow. 

ya, it can shift if the ticket set on hold, Better to use the date field on the service item. 


Roxwell
Contributor
Forum|alt.badge.img+9
  • Contributor
  • 225 replies
  • May 15, 2024
Daniel Söderlund wrote:
Roxwell wrote:

So what i normally do with auto leaver, is say If “Leaving Date” is Less than today, then run at the scheduled time. 

 

I find due date on a ticket to be a little fussy with triggers and setting automatically, but you can use any date /time field on a ticket, as the trigger for a Scheduled workflow. 

ya, it can shift if the ticket set on hold, Better to use the date field on the service item. 

Yes, I would agree with you. Either using the specific Leaving date on the off boarding ticket, or the custom field on the service item. And then using tags or status to control things flowing. 


Forum|alt.badge.img+4
  • Skilled Expert
  • 24 replies
  • August 28, 2024

Trying to do this, too. I just get an error. I set it to 0 because I want the offboard to fire once the date and time is exact. What am I doing wrong? Says “Invalid Syntax - invalid return type for expression” - changed to Output = Boolean will work, but how does 12 days help, don’t we want it to be 0 so that it will do it on the exact date/time?