With http://rewardnation.co built in @bubble, there's a need for me to sync data from @airtable - which is an amazing tool to manipulate data.
Here's a thread
on how I do it, along with some other tips.
#nocode #buildinpublic #data
Here's a thread

#nocode #buildinpublic #data
I chose @integromat to run the sync because sometimes native @bubble gets wonky at scale when running operations on lists of items.
I have 1000s of rows in my @airtable base so that's a large number!
Here's a screenshot of my Integromat setup!
#buildinpublic
I have 1000s of rows in my @airtable base so that's a large number!
Here's a screenshot of my Integromat setup!
#buildinpublic
Quick Tip:
Schedule large scale automated operations like these at a time when your Users are asleep. I typically schedule mine to run between 3 - 5AM.
This way, you're utilising your @bubble capacity during a down period of your app, and Users don't have to deal with lag!
Schedule large scale automated operations like these at a time when your Users are asleep. I typically schedule mine to run between 3 - 5AM.
This way, you're utilising your @bubble capacity during a down period of your app, and Users don't have to deal with lag!

In my @airtable I have a View labeled API. This is locked and uneditable by collaborators.
The Airtable API uses data from the API View to supply to Integromat, based on the "Last Modified Time". So every day at a fixed time (3-5AM), any records that have changes get updated!
The Airtable API uses data from the API View to supply to Integromat, based on the "Last Modified Time". So every day at a fixed time (3-5AM), any records that have changes get updated!

I'm lazy, so I chose to POST to Bubble with a #JSON String.
@bubble can detect all the fields automatically because they have a neat "Detect Request Data" feature!
This saves me the trouble of inputting Key-Value pairs one by one...
#api
@bubble can detect all the fields automatically because they have a neat "Detect Request Data" feature!
This saves me the trouble of inputting Key-Value pairs one by one...

#api

Was this thread useful?
1. Follow me @felixtanhm
2. Please RT the first tweet above!
Every bit of support helps! :)