How to track course progress in Memberstack using an external database instead of JSON? Answered
Hey guys, new to memberstack! Can memberstack track course progression per user?
Hey guys, new to memberstack! Can memberstack track course progression per user?
Comments
6 comments
Hey, I‘m just a normal user but I would do it in a combination between a make.com or Zapier workflow and memberstack.
Hey Zack Fowler, +1 to what Felix Gräf said.
If you want to build it yourself, you need to use some custom flow & element to make this possible which can be integrated with Memberstack for user data.
I have implemented a similar feature for one of my clients and if you want to show the progress for users on the site, you can store users as a collection in Webflow CMS and can link the progress of the user in the webflow CMS as a percentage. You can have a custom HTML progress bar based on your design which is linked to the field created in webflow CMS that has the progress value. You can make the updates for a user via Make / Zapier. This approach is when you want to track the course progression by video API etc.
In case, you want users to have the ability to mark a lesson complete and handle the progression automatically, then you might want to check out this template, you can test it out to see how a user can mark a lesson complete and the tracking is handled on the back-end so the user can see progress of the course chapter wise automatically.
Hope this helps.
Hello everyone here !
How are you doing ?
I used the Premium Course template to build a portion of my platform and I used the system that tracks course progression in a Memberstack JSON.
It’s kind of limited for my usage, I was wondering if anyone has already created/worked on a system that saves progression in a external database (airtable, xano, etc…)
Thanks a lot !
Hey Théo Roland, yes I had worked on a similar system and integrated the course progress for each user in Airtable. I had integrated the video API (since my client was using Wistia) via back-end and set up an automation to track the progress and integrate it with Airtable and Webflow CMS. However, I did not have this template, so I had to take a custom approach.
In your case, since you have the template and the user can mark the lesson as complete from their end, you won't need complex api logic. If you don't want to save the progress in Memberstack JSON, you could link the button to a webhook and have some hidden elements in the form which passes the logged in Member ID, email, video ID etc. and have an automation in Make / Zapier to integrate this progress with the Airtable / any database that you prefer. Hope this gives you some idea.
Perfect, thanks for your explanation !!
Love this idea of a form button passing all the infos via Make !
Would you mind sharing how you structure the two tables (Users / Lessons) in Airtable ? It would help me a lot understand if I need to add a Relation Field !
Yes sure, so create two tables in Airtable Users and Lessons (I had also created a Course table), Have a linked field between Course and Lessons, and you could have a linked field between Users and Courses, and Users and Lessons (while you could have a lookup field, but since you need to manage the progress, having a direct link between Users and Lessons will do the trick). I can't share the exact structure, since it is the client's database 🙈
However, this is the rough idea to have links between the relevant tables and manage them via automation. Hope this helps.
Please sign in to leave a comment.