Hi,
I think my question has already been answered, but I can’t find the solution.
I want to add a contact name to my Company table. With the Update a record module in the “Related contacts” field, the record is overwritten when I want it to be added. I’ve tried several formulas, but I’m a beginner and I’ve been struggling for 3 hours 
Hi Stephanie, could you record a loom showing the challenge you’re experiencing ?
Hi,
SOrry for my english and this is my scenario
Hi @BARRET_STEPHANIE ,
In the 19th module, where we search for enterprises, you can retrieve the values that already exist in the Contact Lies column.
If there is more than one value in that column, please use the map function to extract all the IDs.
For example:
join(map({{19.contactlies[]}}; 1); ,)
This will convert all the values into a comma-separated string of IDs.
After that, add the ID you want to include by appending it with a comma.
For example:
`split(join(map({{19.contactlies[]}}; 1); ,), {{11.id}} ; ,)
Once this is done, all values will be added to the column without missing any existing ones.
Please give this a try and let us know.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
Hi Stéphanie,
Please see the post below to see how to add/append to the record instead of overwriting it:
If you need help, feel free to reach out to me. I’m certified in make.com and Airtable. Happy to do a quick call for free.
Best regards,
Shuaib Nuruddin
Automation Freelancer
You’re using the Airtable upsert module instead of update.
Upsert overwrites the row.
If you only want to update, use update instead.
Hi Stephanie, welcome to the community.
This is a very common issue with linked record fields, so you’re not alone.
What’s happening is that Update a record replaces the entire linked field by default. To add a new contact without deleting existing ones, you need to append, not overwrite.
At a high level, the fix looks like this:
• Retrieve the Company record first using Get a record
• Extract the existing Related contacts record IDs
• Add the new Contact record ID to that list
• Send the full combined array back into Update a record
The key thing to note is that Airtable linked fields only accept record IDs, and Make will overwrite unless you send the complete list each time.
If you want a cleaner beginner friendly approach, this usually involves a Get a record + array handling before the update.
If you’d like, I can walk you through this live. You can book a quick call via my booking link, or check my website portfolio for similar Airtable and Make setups I’ve handled.
If you decide to move forward officially, we can also wrap everything up neatly inside my Fiverr workspace.
You can reach me directly at folafoluwaolaneye@gmail.com.
Best regards,
Folafoluwa