From time to time we engage external consultants on various job, and we have a catalog item for this request.
The RITM will be closed once the tasks related to setting up the account (onboarding) are all closed complete. We would like to automate the approval for extension process using the variable to create a request at a later date, i.e. the Contract end date.
Automated extension (2 reminders)
1 week before expiry date to send an email notification to Requester’s manager checking if the account is still required. -> If yes, either create a RITM to extend the expiry date for a period specified: Referring to the current RITM number.
If no approval was received, then send an email notification to Requester’s manager 2 days before expiry date to seek approval -> If yes, either create a RITM to extend the expiry date for a period specified: Referring to the current RITM number.
I have tried Flow Designer but in Condition it does not have an operator like 1 week before or 1 day after, but only the generic ones:
I have also tried adding a Yes/No field for Contract length is over 3 months as a variable to trigger the actions in the flow. So far I have not been able to make it work.
I aim to make it as simple as possible with the current ServiceNow functionality, instead of using scripts.
Appreciate any suggestions.
