I'm a little stuck and hoping someone can help. Let me start by explaining the issues, users are moving Job records to an existing record that has a status of "paid" or "invoiced". We have a script to move the content of the jobs to an an existing job record. I want to add an extra step in the script to check if the status of the existing job record users want to move the content to is either "paid" or "invoiced". If the status is "paid" or "invoiced", the job record cannot be moved to the existing job record.
I'm not quite sure how to go about doing a find on the existing job.
Thanks in advance.