AnsweredAssumed Answered

Auto loop script using field value

Question asked by CompassAFM on Feb 2, 2017
Latest reply on Feb 2, 2017 by philmodjunk


I currently have a manually triggered script that checks if a job or jobs from a contractor (chosen from a drop down menu - value list) are overdue and then sends the chosen contractor an email with the list of overdue jobs attached as a .pdf file. The value list gets its data from a field in a different table (contractors).


I want to automate this as a script loop, so that the script starts with the first field (contractor name) and then works through all the contractor records until the last record. If jobs are overdue an email is sent, if not it skips to the next contractor name and so on.


Many thanks