Again, you’d save a lot of time if you put everything in one table; Airtable has a DeDupe block made specifically to merge duplicates. Even same base, different tables would be far less time-consuming using a fairly simple script.
Once more, if you’re going to maintain separate bases, you’d need need a Zapier/Integromat/Parabola integration which:
- “Listens” for a new record in any of your multiple bases
- Searches each of your multiple bases for a record which matches a unique key (like an email address, phone number, etc.)
- Copies the field values from the trigger record to the field values of the duplicate found in your other bases.
If you go with Zapier, this process might be made easier by On2Air Actions, which is another 3rd party integration.