@Robert_Petitto Great video and thanks for taking the time to share this with the Glide community! I know I can put this to good use in our app and appreciate you walking through the necessary steps to make it happen. Awesome job!
I’m using your spreadsheet logic for my team of students. They have 18 modules to complete, and a badge is earned when a student completes 3 tasks that when checked off, make up one module. So 54 total tasks for 18 badges(modules).
Mind if I ask a few questions?
Steve
I have a list of 10 students, they all must earn 17 badges in 4 years. Each badge requires the completion of 3 tasks.
I’ve watched your video, I’ve tried to set up my google sheet, but then when I create the app I can’t get it to function anything like your example shows. There are a few differences, but it should have been manageable. https://astonishing-view-9881.glideapp.io/ is the app
For every student it seems like I must create their own badge row and subtask row?
How do I add the 3 subtasks together to auto complete the badge?
I imagine that your subtasks are recorded to a log?..You could create condition that looks for all 3 subtasks per task and only then award the badge? If you prevent users from clicking a submit button more than once (explained here: How To: Build a Gamified Glide App (updated 10/6/20) - #10 by Robert_Petitto), then maybe you only need to record the main task ID and count how many times that task ID appears for each user (if 3 then award badge).
Thanks. As well I submitted a few call requests so I can get an estimate for this project, I don’t have the time to teach myself all I need to know at this point. I think you are available next week for calls if I remember correctly.
Hi Rob, I watched the longer version of this video in your gamify series too, but what is the solution when much of the data by which the criteria for earning a badge is generated inside the Glide data table? I.e. all my XP and Coins are generated from math columns, as well as conditions requiring to read ‘if then’ columns. All this data doesn’t appear in the Google Sheet, so I can’t test for it in my arrayformula… Is there a way to replicate this functionality using Glide data tables.
I also remember you saying that you found the arrayformula method inside Google Sheets to be better, why is that? What limitations are there with doing it in the Glide data table - and what would be the workaround for this functionality inside the Glide table?
Snapshots of the backend…
