I have a field that can at times have existing linked records inside them. I have an automation that when a record matches conditions will input a linked record to that same field. The issue I am running in to is that it replaces the existing linked records in there. I tried doing a dynamic input on the automation to include the existing linked records then separating with a comma, but it fails when testing. Any idea how I can keep existing, but add a new linked record in that same field with the automation?
Are you creating a new record, or are you linking an existing record?
If you are creating a new linked record in a different table, you should be able to create and link the record in the same “create rd order” action. You put the id of the triggering record in the backlink field when creating the record. You do not actually have to edit the triggering record itself in the automation.
Thanks for the replies. To explain a bit further. When a record is created this field is tagged
I then have an automation to check another field for a specific keyword, in which if it passes should ADD another record to this field
As you can see I am trying to keep the existing linked record in the field, plus the new one I want to add which is written out.
The issue I am running in to is this
I am assuming its due to using a comma which I have seen in other instances on airtable automations allows for multiple inputs, but maybe not this one.
So any idea how I can keep the existing link plus add the extra link when the record matches conditions?
Im not looking to create a new record rather add a link to an existing record. I attempted using the find function and getting list plus adding the additional link, but it replaced the whole field instead of appending