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.
Its a little confusing what's going on, but you will need some sort of flag field to note that a record has already been processed.