We have a lot of one-to-many connections in our app. Some of the work we do involves performing updates to one record, then having it update connected records.
Currently, we have to use “Update connected records” → “Each Task connected to this record” to perform these updates. You can currently specify rules on the active record to control when the rule runs. It would also be incredibly useful if we had the ability to specify condition(s) that each connected record must meet to receive the update (using and/or logic for multiple conditions).
Let’s say I was updating a “shipment” entry and I link 12 vegetable crates, 5 fruit crates, and 4 dry goods crates to the shipment (stored as 21 records on a “goods” object linked to the shipment in a many to one form). If I needed to update shipment data, but only wanted to have it update goods that are “fruit,” currently I would not be able to perform this update and would have to go through the 21 records and update the fruit records myself. Being able to add a query condition of “good type is fruit” would be a humongous help, and would also assist us in de-complicating our app tenfold.