List should contain ONLY the highest value/user from all users

Dear All,

I am looking for help with lists and the updating the database. I think I have tried everything so getting very disappointed…

There is a form in my app where users can submit their results.
I would like to create a list where only the highest submitted result is displayed from each user.

To do that I have created a new collection for the submitted results. 1 separate collection (ranked_results) where I would like to create and then update 1 entry/user and update only in case the latest submitted result is higher than the current.

Would you have any idea how to set up the database proberly and the submission form itself?

Thank you,