AnsweredAssumed Answered

Script - Identify Active files after 30 days

Question asked by guttermouth78 on Feb 26, 2016
Latest reply on Feb 27, 2016 by bigtom

Hello all - I am trying to write a script to do the following. I have a text entry field "Date Reported" that is generated once a new entity is created.

After 30 days I am wanting a script to perform a check of Active files only (Omitting the completed ones) in the database and generate a report / email alert that the report requires actioning.

Once this is emailed I do not want future reports on the outstanding file again. I am not sure but another hidden field may need to be created to assist in setting up another Omitting function.

Any assistance will be greatly appreciated.    

Outcomes