After months of not needing to worry about this we are now in racing season and I think I figured this out utilizing the wappler visual tools.
I created a query which summarizes my results and has a sum field for points which I just called “Pts” as an alias.
I used the table generator to create a table from the data then added a state manager to sort my columns
back in the server action I just added my alias of “Pts” as the default and the order in DESC so when the page is open by default it is sorted by The highest points in DESC order. Why didn’t I think of that sooner?
