I’ve heard some successful nocoders say that they use Bubble in conjunction with Airtable. What are some examples of why you would need/want to do that?
Thanks!
I’ve heard some successful nocoders say that they use Bubble in conjunction with Airtable. What are some examples of why you would need/want to do that?
Thanks!
We use Airtable + Bubble for a few reasons, mainly:
Are there any downsides? Yes! A couple are: you cannot use related things, the Airtable plugin won’t recognize them. And as your Airtable base becomes more complex and you start creating multiple tables and linking to data from one to another, you always have to use an additional field that outputs a linked field into formula text field as again, Bubble cannot read those linked fields.
@vincent56 is there any noticeable overhead in terms of retrieval time fetching data from airtable vs Bubble’s database?
Isn’t airtables api capped at 5 calls per second?
Yes its noticeable but it depends on what data you are fetching. If your Bubble data is poorly structured, it can take very long to load data from your DB and the same can be said for Airtable.
You are indeed limited to a rate limit of 5 requests per second, so you need to take that into account for what purpose you’re building.
It can be really useful for some categories of data as @vincent56 as really nicely outlined.
As an example, we store 10,000+ listings on Bubble’s database (because we need to do Geo search and a number of other things).
But the data relating to the suppliers who have those listings is on Airtable. Easier to Zap on there from Typeform etc and administer.
I also use AirTable a lot. Some set of data are exported, so admins can explore the data easily. The “group by” feature is great, filters are more powerful than Bubble constraints thanks to “any of”.
However the AirTable plugin is a bit painful to use. Each time you initiate your table schema, you must start over and link again again the different tables together.
thanks everyone. this is all extremely helpful.
Hi Vincent,
What you are talking about is very interesting, could you detail this solution?
which solution exactly ?
@vincent56 about your post when you say “use extra field that returns linked field in formula text field like again”, how do you do this?
Hi guys ! Interesting conversation, let’s keep this one flowing
Hello Vincent
We are planning to use airtable for data analytics. Is there a way through which we can keep bubble and airtable data in sync in real time or through a scheduler.
Do we need to call modify API everytime a data is modified in Bubble?