Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Merge 2 data of 2 or more fields on a synced table

Topic Labels: Community
254 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi everyone!

I am currently working with two tables (let's refer to them as A and B), wherein table B is synced to table A.

My objective is to deduplicate table A, but before doing so, I need to merge the information that is not synced in table B to prevent any data loss (essentially deduping without the deletion part).

Is there a method to achieve this?

I was contemplating using a script to handle the merge process, but I'm unsure if there's a way to identify whether a field in table B is synced or not.

Any insights or suggestions would be greatly appreciated!

Thank you in advance.

0 Replies 0