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.