Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Automation to update multiple records (that meet certain conditions)

Topic Labels: Automations
156 1
Showing results for 
Search instead for 
Did you mean: 

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”

Bildschirmfoto 2022-11-16 um 00.09.26

1 Reply 1

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.