I am trying to make a form in which liaisons can select a list of sites they oversee using linked records and then update those site record statuses. Sites can be listed as "Active", "Demobilizing", or "Inactive" in each of three appropriately named linked record fields on a report form. They can only see those which are in their assigned geography. I want the automation to trigger when the Report record is created, find each of the linked site records under each condition (for example, all records listed under the "Inactive sites" linked record field), then for each one on the list, update their status accordingly. Screenshot of the form is included. The automation is stuck on trying to find the list of linked records. I have tried to find record where record title is equal to the linked records list field, and I've also tried "contains." It errors that it cannot find matching records. I'm guessing becuase it is looking for a single site record containing the whole list of site titles rather than a list of records from the list of linked sites. I'm sure I'm over thinking this. Anyone have an idea?
