# Awarding Badges to Users!

**URL:** <https://community.glideapps.com/t/awarding-badges-to-users/4891>\
**Category:** Project Showcase\
**Created:** [February 24, 2020, 8:01pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891 "2020-02-24T20:01:15Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 24, 2020, 8:01pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/1 "2020-02-24T20:01:15Z")

</div>

Inspired by a request from @Temple_ISD_Digital_L, I created this functionality that will allow you to award and display badges to your users.

- Create a list of available badges
- Create a grid of earned badges for each user on their profile page
- Create a grid of players that have earned each badge

Take a look!  
[https://www.youtube.com/watch?v=MgZ3fAJyjAI](https://www.youtube.com/watch?v=MgZ3fAJyjAI)

* * *

**You can test out this functionality in my app here:**  
[https://itemstore.glideapp.io](https://itemstore.glideapp.io)

* * *

Try completing a challenge or chatting in the app to earn the respective badges.

---

<div class="post-metadata">

**Author:** ![gannonatwork](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gannonatwork/32/91717_2.png) [@gannonatwork](https://community.glideapps.com/u/gannonatwork)\
**Post date:** [February 25, 2020, 8:24pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/2 "2020-02-25T20:24:04Z")

</div>

@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! 👍

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [July 17, 2020, 1:09pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/3 "2020-07-17T13:09:01Z")

</div>

Where do you find the cool badge images?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 17, 2020, 5:10pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/4 "2020-07-17T17:10:40Z")

</div>

I make 'em of course! I like to dabble in graphic design.

---

<div class="post-metadata">

**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\
**Post date:** [July 17, 2020, 10:10pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/5 "2020-07-17T22:10:42Z")

</div>

With what

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 18, 2020, 2:14am UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/6 "2020-07-18T02:14:06Z")

</div>

Variety of sites/apps:

- Google Drawings
- Photoshop
- [https://www.accredible.com/badge-designer/](https://www.accredible.com/badge-designer/)
- Open Badges
- Credly

---

<div class="post-metadata">

**Author:** ![Steven\_Shields](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steven_shields/32/2630_2.png) [@Steven\_Shields](https://community.glideapps.com/u/Steven_Shields)\
**Post date:** [July 24, 2020, 8:30pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/7 "2020-07-24T20:30:49Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 24, 2020, 9:49pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/8 "2020-07-24T21:49:27Z")

</div>

Not at all! Ask away.

---

<div class="post-metadata">

**Author:** ![Steven\_Shields](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steven_shields/32/2630_2.png) [@Steven\_Shields](https://community.glideapps.com/u/Steven_Shields)\
**Post date:** [July 25, 2020, 5:20pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/9 "2020-07-25T17:20:05Z")

</div>

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/](https://astonishing-view-9881.glideapp.io/) is the app

1. For every student it seems like I must create their own badge row and subtask row?
2. How do I add the 3 subtasks together to auto complete the badge?

I’d contract help as well, I’ve been going in circles.my sheet is [https://docs.google.com/spreadsheets/d/1md0Csh-mLM7atFruUKrHkJYJdqSUpBkjy1og6wQ7wfE/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1md0Csh-mLM7atFruUKrHkJYJdqSUpBkjy1og6wQ7wfE/edit?usp=sharing)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 25, 2020, 7:58pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/10 "2020-07-25T19:58:34Z")

</div>

I’ll review this week and get back to you. Bookmarked your post for Monday if that’s alright.

---

<div class="post-metadata">

**Author:** ![Steven\_Shields](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steven_shields/32/2630_2.png) [@Steven\_Shields](https://community.glideapps.com/u/Steven_Shields)\
**Post date:** [July 25, 2020, 8:35pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/11 "2020-07-25T20:35:11Z")

</div>

Sure, thanks.

S

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [July 28, 2020, 12:20pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/12 "2020-07-28T12:20:35Z")

</div>

Check out this recent post of mine:

> [@How To: Build a Gamified Glide App (updated 10/6/20)](https://community.glideapps.com/t/how-to-build-a-gamified-glide-app/13102/18):
>
> Part 4: Badges and Leaderboards Create badges, automate the awarding of badges, create user leaderboards and guild leaderboards. [[Gamify your Glide App #4: Badges and Leaderboards] ](https://www.youtube.com/watch?v=vl_IcRNVreM)

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](https://community.glideapps.com/t/how-to-build-a-gamified-glide-app/13102/10)), 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).

Just thinking out loud.

---

<div class="post-metadata">

**Author:** ![Steven\_Shields](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steven_shields/32/2630_2.png) [@Steven\_Shields](https://community.glideapps.com/u/Steven_Shields)\
**Post date:** [July 28, 2020, 6:13pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/13 "2020-07-28T18:13:44Z")

</div>

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.

Thanks again.  
S

---

<div class="post-metadata">

**Author:** ![Nathalie\_Simons](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathalie_simons/32/10850_2.png) [@Nathalie\_Simons](https://community.glideapps.com/u/Nathalie_Simons)\
**Post date:** [August 19, 2020, 9:05pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/14 "2020-08-19T21:05:04Z")

</div>

sur pixabay tu as de chouettes images ou sur canva mais alors tu dois le faire toi-même.

---

<div class="post-metadata">

**Author:** ![Jamm\_Studios\_Doha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamm_studios_doha/32/19678_2.png) [@Jamm\_Studios\_Doha](https://community.glideapps.com/u/Jamm_Studios_Doha)\
**Post date:** [March 13, 2021, 9:57am UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/15 "2021-03-13T09:57:07Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\
**Post date:** [March 13, 2021, 10:41am UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/16 "2021-03-13T10:41:21Z")

</div>

Welcome on board the community @Jamm_Studios_Doha ! Happy to have you here !

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 13, 2021, 1:05pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/17 "2021-03-13T13:05:38Z")

</div>

Good call. I’m working out a way to do this efficiently in Glide tables. Stay tuned.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 13, 2021, 5:33pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/18 "2021-03-13T17:33:48Z")

</div>

Figured it out—should be scalable and uses ZERO spreadsheet formulas. It’s complicated on the backend though (uses the Pires-Petitto Trebuchet method) 😉

Video to come sometime soon.

---

<div class="post-metadata">

**Author:** ![Jamm\_Studios\_Doha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamm_studios_doha/32/19678_2.png) [@Jamm\_Studios\_Doha](https://community.glideapps.com/u/Jamm_Studios_Doha)\
**Post date:** [March 13, 2021, 6:22pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/19 "2021-03-13T18:22:11Z")

</div>

Really looking forward to seeing what you’ve discovered!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 13, 2021, 6:25pm UTC](https://community.glideapps.com/t/awarding-badges-to-users/4891/20 "2021-03-13T18:25:12Z")

</div>

### 😱 Snapshots of the backend…

 ![Screen Shot 2021-03-13 at 1.23.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc7e490edb5d321a8e4938db3f00df55791e2bc5.png)

 ![Screen Shot 2021-03-13 at 1.24.13 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/805eb0517389b2a0c0223dc150bd4bec8de2b01e.png)

[Next page](https://community.glideapps.com/t/awarding-badges-to-users/4891.md?page=2)
