1 Reply Latest reply on Feb 27, 2016 5:23 AM by bigtom

    Script - Identify Active files after 30 days


      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.