# A silver badge for \_each\_ 5 bronze badges

**URL:** <https://meta.discourse.org/t/a-silver-badge-for-each-5-bronze-badges/283284>\
**Category:** Data & reporting\
**Tags:** sql-triggered-badge\
**Created:** [October 24, 2023, 3:33pm UTC](https://meta.discourse.org/t/a-silver-badge-for-each-5-bronze-badges/283284 "2023-10-24T15:33:49Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [October 26, 2023, 7:08pm UTC](https://meta.discourse.org/t/a-silver-badge-for-each-5-bronze-badges/283284/3 "2023-10-26T19:08:36Z")

</div>

> [@ganncamp](#):
>
> Also, it’s really not clear to me how the math happens so that my two users don’t get new badges every day (this will run on a nightly trigger) even if they haven’t gotten 5 new bronze badges.

Unless you tick ‘Can be granted multiple times’ then it shouldn’t be awarded more than once, even if they qualify for it a second (or more) time. 👍

* * *

Okay, I’ve re-read your post more thoroughly and I think I have a clearer idea of what you’re aiming for.

Based on the current SQL those users will only ever be awarded the Silver badge once, even if you allow it to be granted multiple times:

- I’ve created the relevant badges on my test site (including allowing multiple)
- Granted 5 of the Bronze and run the background job to grant the badge (Silver badge granted successfully 🥳)
- I then ran the `BadgeGrant` job again and they were not granted the Silver a second time
- I then pumped up their Bronze badges to 11 and ran the badge grant job again
- No second Silver badge was awarded

---

_[View the full topic](https://meta.discourse.org/t/a-silver-badge-for-each-5-bronze-badges/283284)._