I’m currently building an app with Adalo but I’ve been stuck for a while with something I can’t get through with… and it’s a double feature!
First thing is, I don’t seem to be able to sort a list by a calculated formula. Is that right?
For example, I have a table o users, and a table of games, and they have a relationship so users can keep track of the games they own. So all I wan’t to do is have a list showing the users and sorting them by the “count” of games each user owns, but I just can’t see how. In the sorting options I can only see properties of the users (despite the fact they are related). The list would be a ranking of users with the most games f.i.
The second thing follows up to the first one. Now that you guys know I want to make a ranked list I’'m trying to figure out a way to make the position in the list appear as “magic text”. In that sense the first item of the list would be #1, second #2 and so on…
Any ideas on how to make this happen?
Many thanks in advance! The community here has been really helpful so far!