Automation to update multiple records (that meet certain conditions)

[Hannah_Oldorf]

Hello!
I’d greatly appreciate your help on the following automation/script.

I have updated a record’s status from “Available” to “Booked”. Now I want to update all records status to “Booked” for records that belong to the same bundle in the same calendar week (which is a linked field to my table)

Here my example:
If I change the status of any record, all other records - which have the same Option & CW value (column 3) should also change their status to “Booked”

[Kamille_Parks]

Is it possible to re-evaluate your base structure so that the Status field lives on the Bundle record, and the Status field you are showing in the screenshot is simply a Lookup? That way all the bundle sub-records stay in sync without needing an Automation or Script.