Member of the month

[another]

There are members (users), who have one common field, “total_credits”.

How to display current user, fitered by “total_credits” [within a current month]?

To show throughout a month, current “member of the month”.

[adamhholmes]

You’ll need to have some way of storing the credits along with the date info for them…

One fairly simple way would be to create a datatype of user_monthly_credits, associated with a User and a particular month, which can store the number of credits within a given month. Each month create a new one.

Then it will be very fast and simple to see how many credits a user has for a particular month, and therefore to find which user has the most credits (i.e. search for user_monthly_credits: constrained to the current month: sorted by total credits: first item's User).

Another way would be to just have a datatype for ‘credit’ with a User and a Date field. Then you could just search for credits within the current month to find which user has the most. But I suspect that would be much slower and less performant once you have a lot of data.

[another]

Can we create a workflow mechanism to be triggered by Loaded page, or even better a condition for (user) Data source?

Without extra data, rather by using a User list and “User’s total_credits”?

[adamhholmes]

@another

Can we create a workflow mechanism to be triggered by Loaded page, or even better a condition for (user) Data source?

Yes, a search on the datasource would be the easiest way: search for user_monthly_credits: constrained to the current month: sorted by total credits: first item's User

Without extra data, rather by using a User list and “User’s total_credits”?

Sure. You won’t be able to constrain it by month, but if you just want to show the User with the highest Total number of credits (for all time) then you don’t need any additional datatypes.

Alternatively, if you don’t need to know about previous month’s credits you could just have a single field on the User datatype for credits_this_month, and reset it to zero each month. you could still have another field for total_credits as well.

[another]

Will need to see this “constrained to the current month” part more clearer

Never mind, (and now in the meantime) have just found a solution that will solve more problems around.

Having Rg list Users sorted by total credits (yes), and then from there we can send direct User data, in my very case it becomes better UX.

Someone who needs to work independently, this solution wont work. Thanks to @adamhholmes!