send an email notification who has updated the sub state on asset table after 5 days servicenow

[Srilakshmi7]

Hello Everyone,

Need to send a notification to the person who has updated the substate of the asset to 'IN transit' after 5 days. I'm not sure whether this will be possible or not. that's the reason I'm posting this question. Any expertise help will be appreciated in advance.

Thank you.

[Saurav11]

So just to be sure who should receive the notification the person who has modified it the first time to in transit or is it someone else?

If it is the first person does not matter how many times later the substate changes the email will be sent.

[Srilakshmi7]

The first person will be notified through the email.

how the system will store the value of the first person who modified the state to intransit

[Dr Atul G- LNG]

Hi @Srilakshmi7 

It is loop and loop and need to check the value change in logs and also imagine if in a day 500 assets get change and in last 5 days 100 times, how many loops it will run. 

[Saurav11]

Yes then you will need to create a new field and as soon as the substate gets changes to intransit first time  capture the value in that field.

Also if you want to run it only once for one record then set the value to once in the flow designer this will make sure the logic only runs once for one record:-

[Dr Atul G- LNG]

Hi @Srilakshmi7 

What will be the case if the state has been changes 3-4 times with in 5 days like

Day 1 - A change state to In transit

Day 2 - NO change

Day 3 -  C change state to XX

Day 4 -  D change state to In transit

In this case it is very complicated for system to keep track of all previous changes.