Sort Custom List by SUM Value not in Custom List Collection

I’m doing an app that runs a contest for users where the app has to sum points earned for each user. So, for the Leaderboard, I have a custom list of users which shows the username. For each username it sums their points.

Screenshot from 2020-09-09 10-53-52

Question: Is it possible for me to sort SUM of points in descending order?

Since the points aren’t in the users table, I don’t have the ability to easily sort by that field. The points are coming from a picks collection.

Unfortunately it’s not currently possible to sort by related properties. That would make for a great feature in the future though! Perhaps you could add a comment to this feature request? https://ideas.adalo.com/feature-requests/p/multiple-sorting-for-lists

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.