Dec 05, 2023 01:55 AM
Hi, I need help with an automation that I can't get to work. I have set up 2 separate automations, both triggers "when record matches condition" (different conditions) one adds one linked record, to field "work" and the other automation adds another linked record to the same field. However, they seem to overwrite the existing linked record. How do I avoid this? I tried setting it up so that I pull in the actual linked record field and then separated by a comma the record id, but that made the automation pull in 2 different linked records, when I only wanted the one 🤔
Any tips? Not a super advanced builder 😅
Dec 05, 2023 07:34 AM
Are you putting in the existing value for the linked record field as well as the comma and the new record you want linked?
Dec 07, 2023 04:27 AM - edited Dec 07, 2023 04:29 AM
I think I have, but guessing I am doing something wrong.
Update record -> Specific fields -> Field to update, choosing the linked records field "Service" then adding the field "Service" then a comma then the record id of the record I want to link.
However, when separating these two by a comma it says "Could not find matching rows for string", but when I skip the comma it works in the way that it does update, but it overwrites.