I’d like to build an e-Learning app with Airtable as my database for a lot of the student data.
Main functionality needed: for a user to be able create/edit AT records within Bubble, and the ability to show conditional content based on data in the user’s AT record.
Reason for using Airtable and not Bubble: I’d still like to use/manipulate/analyse the data using Airtable, and possibly link it to other apps/services in the future.
In my app, the experience for students will be customised depending on what their tutor has allocated for them.
One random example:
Let’s say for the ‘Basic Guitar Chords’ Topic, the Tutor notices the biggest thing the Student currently needs to improve upon is Topic Name ‘Finger Strength’. Once they submit this assessment, the Student gets (again, pre-defined) exercises, tips, images etc that display on their ‘Basic Guitar Chords’ topic page. Other unrelated info is not displayed.
I don’t need to do any fancy formulas with the options a Tutor chooses – I just need to display content for whatever learning point(s) is/are chosen for each Topic, and nothing else.
This requires Bubble to read the Airtable database (to display conditional content) and to write to it (e.g. when the Tutor submits a new student assessment).
I’ve been scouring the forum for mentions of Airtable and things look promising so far. I saw an old post mentioning Zapier but it looks like that isn’t really necessary as I believe that now there’s an API.
So for now, I have a few questions before I dive into this completely:
Does the Airtable API connection allow for immediate changes to AT & back?
Authentication & security, i.e.keeping database details private: what is there to consider here?
How easy is it to create API connections without being a coder? I’m new to Bubble but fairly tech minded (basic HTML/CSS knowledge), and am currently going through a Bubble course that includes API lessons.
I presume it’s best to connect through API rather than the Database Connector plugin?
Are there currently any major restrictions with the Airtable-Bubble API?
Can I do this on the Personal plan?
I thinks that’s it for now – a huge, huge thank you for any help (however brief).
And thanks for looking through this in the first place.