Have you integrated your Airtable bases with a backend data service/database/or used Integromat to draw information for other bases? Can you help with the below?
We’re a GAAS platform that use Airtable to execute various company wide and customer requirements.
One of these specifically is how we execute growth projects for customers. We have a central project template with predesigned workflows that we rollout for each customer project. One problem here is that version control gets hard to manage given that Airtable doesn’t allow you to create parent/child templates, ie so you can deploy changes to a template to all active projects that utilise that specific template.
As a means to deal with part of this problem we’d like to build out a backend data service that would enable us to pull in generic information into a base and keep that part at least centralised.
An example use case:
In this case we would simply have a database or external data store of some description that would enable our team to update the ad platforms we use and then make those available to all project bases. We have a number of requirements for these sorts of use cases.
Have you ever setup a backend service to store and call in data within your Airtable bases? If so what does your stack look like and how did you achieve the solution?
Has anyone ever linked bases via Integromat? One such solution is that we can create 1 base and store all the centralised data there, then add Integromat to the template base so that we can call in data from the reference base.
Any advice from anyone who has solved this problem would be appreciated.
We have implemented both solutions in our system (i.e. backend and using Integromat). Here are a few tips:
Good luck and have fun,
If you want to pull data from a database or data warehouse (postgres, firebase, mongo, snowflake, etc.) into Airtable AND update your backend data store from Airtable, then you should check out Bracket. You just have to input your Airtable API key and connect it to your database. It handles syncs in just one direction or both directions at the same time.
There's also features that you can customize. If you only want to sync certain fields in two directions and make other fields read-only in Airtable, or if you want to write queries to make the data you pull into Airtable very customizable, then that's all possible!