Sep 13, 2020 03:29 PM
I have differnt bases for diffent types of leads, like LA leads in one base,
NY leads in one base.
I Wanna be able to see all the nation leads in one base so as to eliminate duplicate records or do more research because two leads can be of same company and I want the records at same location to quickly do some research.
Sep 13, 2020 05:51 PM
Is there any particular reason your setup involves multiple bases, instead of a single table with multiple views?
Sep 13, 2020 06:24 PM
Yes I like to separate the stuff.
Sep 13, 2020 07:46 PM
In that case I doubt its worth it to keep things in separate bases, especially since you want everything to end up back in one table anyway.
Using multiple filtered views on a single table in a single base you can look at LA leads and NY separately. In addition, you could have an unfiltered view in that same table to look at all leads nationwide.
Using views is going to save you the incredible headache of trying to do duplicate-detection across multiple bases. There isn’t a native way to sync multiple bases in Airtable, to do that you’ll need to setup a (probably) complicated Zapier integration or use another 3rd party integration like miniExtensions.
Sep 13, 2020 08:06 PM
I don’t want things end up in one table,
But I need the ability to merge various tables to do my research & then let go.
Please let me know.
Jay
Sep 13, 2020 08:16 PM
^ I took that to be literal, and extrapolated that if you’re trying to do duplicate-detection the easiest way to do it is with working with a singular table.
If you’re steadfast in constantly merging tables from separate bases into one base, you’ll need a Zapier (or Integromat or Parabola) integration or miniExtensions integration as mentioned above.
Sep 13, 2020 09:11 PM
I upload new records each day. Many of them may have same records in differ they bases but I don’t wanna waste my time on duplicates. So how do we handle this situation ?
Jay
Sep 13, 2020 09:33 PM
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:
If you go with Zapier, this process might be made easier by On2Air Actions, which is another 3rd party integration.
Sep 13, 2020 09:54 PM
I don’t like zapper. It sounds scary to me.
Sep 13, 2020 10:14 PM
A Zapier integration (likewise with similar services such as Integromat and Parabola) would be difficult to set up to accomplish what you’re asking for. That’s why every one of my replies starts with a push to do it the easy (and free) way of using a single table.
Or you can hire an Airtable expert to do all the setup for you.
Sep 14, 2020 07:03 AM
Well in an incredible bit of cosmic timing, Airtable just released the ability to sync records across bases so here you go:
Sep 14, 2020 09:29 AM
Awesome!
I think they did a minor mistake, it should be available to all plans. Could you please check whats going on here ?
Jay
Sep 14, 2020 09:48 AM
I don’t know what you mean by mistake. Also, I don’t work for Airtable, so I can’t just “check what’s going on” any more than you can.
If you’re trying to say “I want more syncing capability for free plans” that’s not something I or anyone else can help you with. If you’re tying to say “syncing hasn’t been made available for my bases yet” they may still be rolling out the feature to all users throughout the day.
Sep 15, 2020 05:32 PM
Ooh, I hadn’t heard about Parabola until you mentioned them! Looks like a great service, and they even cover a few services that Integromat and Zapier don’t cover — such as DocSpring, which creates PDF files from a template.
Very cool! Thanks for the heads-up! :slightly_smiling_face: