Using date last modified, trigger reminder email

  • 26 September 2022
  • 1 reply
  • 42 views

Hi all!

 

I have a form that is essentially an issue tracker and the manager of the group that is responsible for resolving these issues wants to be notified if an issue hasn't been touched/modified in 48 hours.

 

I tried using the Condition builder in NWC and the Modified column isn't available to set a condition on.  Any ideas on how to set up the workflow to only go out if a list item hasn't been modified in 48 hours?

 

Thank you!


1 reply

Userlevel 6
Badge +16

Hi @eculpepper 


 


Here is one possible way to approach this.


Create a NWC Nintex Scheduled Start Workflow that runs daily (say 8am)


1. Create a DateTime variable "EvalDate" and set its value to the current Date and Time



2. Use a "Add Time to date" to add -48 hours to "EvalDate"



3. Query your SP List when the Modified Date is before or on "EvalDate"



 


The Query List Output will be a list of Objects which Modified time is 48 hours or more hours


 


What to do next after you get this output result?


You can email the manager to inform his of the List of Items (Set 1 email)
or
You could trigger each List Item workflow

Reply