We’ve been working with our clients and we’ve come across the issue that a very popular use-case is to have the databse in Airtable, but perform all the front-end actions in Bubble.
This can technically (to an extent) be done with simple Airtable plugin, but if there’s quite a bit of data, the loading speeds end up being very slow, there’s a limitation of 5 requests/second. You also cannot use basic Bubble native features such as searching, filterting, etc.
We’ve come up with a solution to have a two-way sync and implemented it already. It works so that once you update the data in airtable, it gets modified (or created) in the Bubble database. Likewise if data from a specific database in Bubble is created/modified, it is updated/created in Airtable.
We’re planning to make this into a plugin - would you find this useful? Or have you found other ways to overcome this?
We are looking to do the exact same thing. We would like to synchronize our Airtable database with Buble because Airtable is limited to 5 requests second.
We’ve managed to make it work and made it a plugin now, but let’s say it’s in alpha stage right now, so probably needs a good week’s of work (so realistically may take about a month to release it).
I’ve managed to do a LOT of this leveraging a tangled web of direct API calls, the Airtable native integration, and Integromat. Would love a central source to sync the data, especially if it allows me to pick and choose the tables/fields to sync.
I also run the Bubble UI directly off of Airtable calls via the integration in many cases too (Airtable outages have caused problems in the UI because of this obviously).
Does it automatically create the same structure in Bubble, I assume?
Also very interested in learning more about this. We’re already using Airtable API calls to push changes over in real-time, having an app manage two-way sync would be better.