Hello Community,
I've been tasked with implementing a badge and score system for our forum website, similar to the one used in the Microsoft Power Pages community based on user posting activity (e.g., new visitor, regular visitor, superuser, etc.). I'm unsure how to approach this request. After searching the Contact table, I couldn't find any fields related to badges or scores. I'm considering creating a new table called "Badges" and linking it to the default Contact table via a foreign key. This would allow me to assign badges to users and store relevant information, such as the badge name, description, and criteria for earning it.
Is this approach recommended? Additionally, how can I display the badge beside the user's name in the forum, such as in their profile or next to their posts? I'm looking for guidance on the best way to implement this feature.
Thank you for your help and support!
Best regards,