Hi guys, I’m making a simple app where sales people can track their number of calls and appointments every day, but I think I started the wrong way. I added a button “I made a call” which increments the number of calls by 1 and number of points by a random number between 90-110. Same button I made…

This might help: [image] How To: Build a Gamified Glide App (updated 10/6/20) Community Resources Learn to create a gamified Glide app from scratch! Complete with XP, in-app currency, ranks, progress bars, guilds, challenges, inventory and item stores. Part 1: …

Hi Robert! Thank you very much for the detailed guide :slight_smile: I think I watched all of your videos regarding the leaderboards, I even used your guide to build my first leaderboard. [image] What I’m struggling with is that I didnt think I will need a weekly leaderboard from the start. Shoul…

Awesome! I gotcha. Unless you’re capturing new point rewards in a log and capturing the timestamp of the reward, this will prove to be impossible. Are you capturing points in a log or hardcoding their points via increments?

Well, it seems that I’m hardcoding it :smiley: How do I make a log?

Instead of using increments to user profile, you’d write those values to a log along with a user ID and timestamp. Then you’d use a multiple relation from users table to log table and Rollup the point values. Only issue is that this setup will certainly eat into your row quota.

Could you please explain the multiple relation part?

Robert meant you should do a multiple relation using the “user ID” value. In the original table where you store all users, use a relation from the “RowID” column to the “user ID” column in the newly created Logs table, and make it a multiple relation. Then, you use a rollup column to get the total…

So far I understand (I think) :smiley: But how should I filter the items that were created on week 14, for example? And count only those items?

What’s your use case for filtering “Week 14”? Is it something you want users to filter on the front end?

Weekly, Monthly Leaderboard

Ask for Help

Robert_Petitto April 3, 2023, 9:12pm 2

This might help:

Topic		Replies	Views
Building a sales gamification platform, Day 1 Ask for Help	7	448	April 9, 2023
Why I can not see all the users Ask for Help	18	1499	December 21, 2021
📅 MORE Date Math incl. Weeknum! Ask for Help	14	1639	January 22, 2021
Assistance with App Ask for Help	7	22	January 21, 2026
Rolling point counter by date Ask for Help	3	385	January 17, 2024

Weekly, Monthly Leaderboard

Related topics