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”