Hi @Vignisson and welcome back to the community!
Yeah, I helped a company with this type of process a while back. I don’t recall all of the details and it was a very secure project (security and surveillance company) but I used the MemberStack API with Airtable and it resulted in an ideal and near-real-time handoff of data from tables to the dashboard.
In that case, there were a number of analytics that could not be easily calculated in Airtable rollups and summary views so we had to performs a number of computation processes in the integration layer.
One of the questions when pairing Airtable with any API is to determine what the middle-tier will look like and how much It will cost. This can be done in NodeJS pretty cheaply in Heroku although, without event handlers in Airtable, you have to rely on MemberStack to trigger the update requests. Alternatively, Google Apps Script is an option because it’s near-free and supports timely triggering.
Lastly, the new scripting action feature for Script Blocks could provide a way to push updated from Airtable directly into MemberStack.
