Hi Gliders! Just thought I’d share a quick video showing one of many ways you can introduce “user streaks” into your app. For example, you could use this in a Workout app where you reward members for logging workouts on a daily basis. I’m sure there are better/more resource efficient ways of getti…

Creative, nicely done :+1: I think the only thing I would do differently would be to use JavaScript to calculate the streak, rather than calling an external script. I’d also pass the dates as integers - just makes them easier to work with as you can do direct numerical comparisons. Another option w…

Thanks Darren! During the live Q&A itself I attempted to use the Javascript column but didn’t spend enough time tweaking to get it up & running… Then for some reason after the session I decided to try using a script and it worked so I kinda just rolled with it :sweat_smile: But I agree, using the …

Yeah, I think it’s generally better to keep everything self contained if you can. I used to use a lot of Apps Script when I first started with Glide, but these days I try to avoid it and will only use when absolutely necessary. In fact, my preference these days is to build exclusively with native ta…

[image] Darren_Murphy: I think the only thing I would do differently would be to use JavaScript to calculate the streak, rather than calling an external script. Agreed. You present a tidy solution within Glide itself, but I prefer to avoid scripts if I can. As @Darren_Murphy mentions, keeping…

What’s the Google Script link?

In case you wanted to see a rather complex solution that doesn’t involve Google scripts, this might work for you: [Glide: Calculating Current and Longest STREAKS] Warning: @Loqode ’s solution is MUCH more elegant, but this variation is all contained within Glide tables.

Hi Rob, Thank you for the video. Helped a lot @Robert_Petitto I have a quesrion, What if in same dates there are multiple records, Thtne the count streak logic will show wrong values right? Because on same day there will be two, WHen we do relation then itll show wrongly 2, While on same day same…

Ya, the logic assumes one entry per day. Might need to add a array → unique elements column in there somewhere. Not sure about the bug. There might be a better way to achieve streaks nowadays. I’d need to tinker.

🔥 User Streaks (Gamification)

Community Resources

Robert_Petitto April 8, 2024, 10:52pm 7

In case you wanted to see a rather complex solution that doesn’t involve Google scripts, this might work for you:

Warning: @Loqode’s solution is MUCH more elegant, but this variation is all contained within Glide tables.

5 Likes

Topic		Replies	Views
Streaks on glide Ask for Help	5	718	June 2, 2023
Help me spreadsheet jedis. You’re my only hope Ask for Help	12	806	May 2, 2020
⚡ Gamification: Streak Counter! Community Resources	5	1195	April 27, 2025
Calculate a "streak" Ask for Help	4	1003	December 27, 2020
Need help counting Curent Streak and Longest Streak Ask for Help	13	326	November 1, 2023

🔥 User Streaks (Gamification)

Related topics