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:
- A user on the project team creates a new experiment within the relevant tab on a project base. They will then select an ad platform this experiment will run on. When they select the ad platform this information is pulled in from a backend data store and applied to the column.
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.
- Firebase backend service -
- Zapier based solutions. Given our use case here is solely one way this is another option however in the event we want to go two way we’re back to the drawing board pretty quickly.
Any advice from anyone who has solved this problem would be appreciated.