It would be a very nice incentive for people to add a profile picture if they would be granted a first-steps-badge when they do it the first time.

Adding a profile picture is part of the Autobiographer badge: https://meta.discourse.org/badges/9/autobiographer

Hi, I am not sure this works, I have 159 users who do not use the default avatar (from data explorer) and 16 only that got the Autobiographer badge. Shoul’dnt they be 159 with the badge ?

I said having an avatar is part of the badge. How many of the 159 users added information about them in the “about me” field in their profile?

Firstly, it was a hint that there is already a badge that can be triggered when uploading an avatar. So if you want to add your own SQL-triggered badge, you might want to disable it so that the user doesn’t receive two at once. Secondly, you can use the query for the badge as an example to create a badge just for saving the avatar. [תמונה]The default badge queries :3rd_place_medal: Autobiographer SELECT u.id user_id, CURRENT_TIMESTAMP granted_at FROM users u JOIN user_profiles up on u.id = up.user_id WHERE bio_raw IS NOT NULL AND LENGTH(TRIM(bio_raw)) > 10 AND uploaded_avatar_id IS NOT NULL AND (:backfill OR u.id IN (:user_ids) ) Run revocation query daily :white_check_mark: Query targets posts Trigger When a user is edited or created

Very interesting source for querying, thanks !

Add badge for adding profile picture

תמיכה

patrickemin (Patrick EMIN) 25 באוקטובר,‏ 2025,‏ 11:34pm 5

Got it, avatar and profile data are two different things, but that means that badge does not answer the initial query ?

נושא		תגובות	צפיות
The default badge queries Data & reporting reference , sql-triggered-badge	1	1141	27 באוגוסט,‏ 2023
Badges based on User Custom Fields? Data & reporting sql-triggered-badge , user-custom-fields	21	775	13 בנובמבר,‏ 2020
Creating custom badge with custom rules Data & reporting sql-triggered-badge	10	1948	14 במרץ,‏ 2023
Badges for 'post in specific category' and 'filled in bio fields' Data & reporting sql-triggered-badge	6	252	8 במרץ,‏ 2016
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	13333	27 באוגוסט,‏ 2014

Add badge for adding profile picture

נושאים קשורים