Syncing linked record fields from one base to another while maintaining relationships

Hey there,

Assume a contact management base where we have a Contacts Table and a Companies table.

The Companies table has a Company Contacts linked record field that lists all contacts in that company.

When syncing both tables to another base, the Company Contacts linked record in the target base is displayed as a text field, not a linked record field and looses the linking between records.

Any plans for airtable to maintain the connection between linked records when both tables are synced to the same base?

When trying to recreate the link using a new linked record field and a script, I found out that the getCellValue method only returns the linked record name, and does not return the linked record id.

Any plans for the airtable scripts and blocks apis to return the record IDs of synced linked records, not only text?

My workaround, for now, will be to:

  1. Add to both source tables a formula field that return the RECORD_ID().

  2. Add a lookup field to the Companies table that displays the contact record ids

  3. In the target base, use the synced record id fields in an automation to recreate the linked records in a new Company Contacts linked record field.

Anyone with a better solution?

Thanks,
Ronen

2 Likes

Hi @Ronen_Babayoff , were you able to make this work? Thanks!

Thank you, your workaround is working quite well for me! Though I would obviously also like to have this available out of the box.

Although I didn’t have to create a new formula field to return the record ID – it was selectable already in the Automation dropdown.

Would you be able to share how you did this with a little more detail built into the steps 1-3 you laid out please? I’m having a little of a hard time following and would love to use your method!

Thanks :slight_smile: