I have a synced table.
In the destination base/table I have created additionally a single select field => this should represent the status of the record.
Target: Change the created single choise, based on the condition that one of the synced fields has some specific text inside. => And this for each record.
I set up an automation:
- When a record matches conditions
–> when “Synced_Field_in_Table” contains “xyz”
- Update Record
–> RecordID => Record ID from step 1:Trigger
=> Tests run successful & it did do it => But only for this one field.
Whereas I wanted it to do it for all records matching that conditions (& there are quite few more).
Is there a “loop” that can be triggered or something else I am missing.
I would like to make this automation go through all records.
Thanks in advance