Nov 09, 2022 08:16 PM
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?
Nov 09, 2022 09:25 PM
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.
Nov 09, 2022 09:44 PM
On the off chance kuovonne’s solution doesn’t work, could you provide some screenshots of your automation setup and the error message?
Nov 09, 2022 10:06 PM
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?
Nov 09, 2022 10:22 PM
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
Nov 09, 2022 10:57 PM
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
Nov 10, 2022 06:27 AM
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.