Hi Guys,

I use Zoho Creator to run a runner ranking program.

The idea is that runners submit their timings for a particular distance (they can choose from a total of 6 different distances).

For a given distance, i need a 'rank' assigned to each runner. Right now, i do it manually i.e. export the data and sort the entries and then assign ranks (which will be displayed through a view).

I know i can auto-assign serial numbers (by using counters), but can't seem to get a solution for assigning ranks real-time.

The idea is to assign a rank to a new record based on where that timing stands, and then subsequently change the ranks of the entries already existing accordingly.

Any help will be appreciated!

Thanks!