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:
Add to both source tables a formula field that return the RECORD_ID().
Add a lookup field to the Companies table that displays the contact record ids
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?