App badge feature with avatar list

i wanted to make a badge feature in the profile screen showing what badges have the users collected, ive been stuck in here for days and cannot figure out how to setup the database and avatar list
i have a database showing all the badges they can collect and a database showing the ones they have collected, i wanted to show the collected badges in the avatar list, but how do i add the badges to the collected badge database once the user have reached a certain requirement? and if i show all the badges users can collect in the avatar list, how should i setup the filter to filter out the ones they did not collect?

I think your setup here would be to have one Collection with all your badges in it (that’s the only badges Collection you need). That Collection will have a many-to-many relationship with Users. When a user earns a badge, have an action that adds it to their user. Then have a list that shows Logged In User > Badges.

Users Collection

  • Badges (many-to-many)

Badges Collection

  • Users (many-to-many)






ive added the relationship but it wont let me create collected badges data using the listing out all the badges database in the button click action

I don’t think you need a “Collected Badges” collection. You only need a Badges Collection, a Users Collection, and a relationship between them. Then you can add badges to users, and those are the ones they’ve collected.

needed it to add in app by a button click action, it doesnt allow me to do that

Here’s a quick example using the Collection system I posted above. Each user has badges and you can easily add and remove badges from them: badges.mov - Google Drive

i mean is there a way for the logged in users get the badges automatically once they have reached a certain requirement, like clicked on a claim button on a claiming page, not a box that allows any user to add any badge to themselves
like when a user signed up before a certain date, it’ll redirect the screen to a page with a claim button, when they click on the claim button, the system will add the [early supporter badge] to that signed up user
it works like discord, facebook badge system

The best, most performant way for you to do it might be to create admin-only lists of users where the list is filtered to only the eligible users based on some criteria, and then the admin goes through daily and gives folks their badges. You could use screen actions as a redirect but if you have more than 1-3 badges that’s going to get pretty crazy I think. Another option might be to render all the badges on your profile screen and use visibility rules to show only the ones the user has earned, but again, if you have too many badges you’re going to pull in so much data that’s not a great way to go about it. Out of the box, Adalo has no automated backend actions that happen at a time and date or given a criteria, but there may be a way to use Make/Zapier to get there.