Is this possible? I have a table called “SITES” and a table called “SERVICES” that are connected by a linked record field. A service can comprise one or more sites. In both tables there is a “status” single select field indicating whether the site/service is live or not. When a service is no longer live, then all sites linked to it also need to be marked as “ceased”. Likewise if a site ceases, and that site is the only site in a service, then by definition the service ceases as well.
I think it needs a three-step automation where the first step is finding the record matching certain conditions in sites, which then uses “find records” in step 2, to change the corresponding records in the linked table (SERVICES) in step 3.
Thank you very much for this. Automation 1 works perfectly, but for automation 2, the test fails on the last step. It needs to work so that the status of SERVICE changes to “Ceased” only when all sites linked to that service are marked as “Ceased” in the SITES table.
OK, things seem to be joining up now, but not working exactly as I need it to.
What I need to happen is when at least one site is live, the service is also live; and when all sites are ceased, the service is also ceased. But it still needs to allow for when one site is live, and another ceased, the service is still live. i.e. a service is only changed from “live” to “ceased” when all sites linked to it are ceased; but changing one site to “ceased” and leaving another as “live” does not change the status of the service if this is already marked as “live”.
Thanks very much for your help so far! :grinning_face_with_big_eyes: