Skip to main content

Automation to update multiple records (that meet certain conditions)

  • November 15, 2022
  • 1 reply
  • 0 views

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”


1 reply

Kamille_Parks11
Forum|alt.badge.img+15

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.


Reply