Automation to add linked record when linked records already exist in that field

[Chris_F]

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?

[kuovonne]

Welcome to the Airtable community!

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.

[TheTimeSavingCo]

On the off chance kuovonne’s solution doesn’t work, could you provide some screenshots of your automation setup and the error message?

[Chris_F]

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?

[TheTimeSavingCo]

Hmm, I would expect your automation to be set up more like this actually:

Here’s a base I put together for you to compare your automation against

[Chris_F]

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

[kuovonne]

Normally when you are adding to a linked record field you can enter the new value, a comma, and the existing value. (Notice that the new value goes first.)

However, I think the problem that you have is related to the fact that you want to keep a value that you added in a previous automation step, that did not exist when the automation was triggered.

Try adding both new values in the same update action. This may require some restructuring of your automation steps and conditions.

[Les_Gros_Becs]

Hello! I am encountering the same issue right now and I would need help. I'm using the trigger ''When a record is created'' with two main actions, which are ''Find records'' and ''Update record''. It does update my record, but it deletes any existing record in the linked field. I would need any existing records to not be deleted.

I'm adding some screenshots.

Thanks for the help!

[Les_Gros_Becs]

For anyone who would come across this thread, here's where you will find your answer : https://community.airtable.com/t5/automations/automation-to-update-record-removes-previously-added-l...