ranking records

[randyinla]

hi there, i have a field called 'scores' with a numeric value. i'd like to create a calculation

field called 'ranking' which will assign a number next to a record based on results of a 'current find'

i.e., highest score='1', next highest score='2', 30th highest score='30'...

here's a link to give an idea of my dilemma...

http://tutsan.forest.net/ssv/FMPro?-db=ssvdb.fp5&-lay=master&-format=rankings.html&-Op=eq&Group=Adults&-Op=eq&Gender=M&-SortField=highscore&-SortOrder=descend&-Max=500&-Find

i'd appreciate any help, thanks!

[Garry Claridge]

Try [FMP-CurrentRecordNumber]

All the best.

Garry

[Vaughan]

There are a couple of ways of doing this, but I've never thought of using the Status(CurrentRecord) function before!

In the past I've done this by sorting, then replacing a field with a serial number (to generate the ranking 1, 2, etc). It works very well but the replace step could possibly fail in a multi-user environment due to record locking.

A process using the Status(CurrentRecord) won't have any problems at all with multi-user because it could do without the replace step. It will also work well over the web because all it needs is the sort -- it doesn't need a script at all.

The more I think about the Status(CurrentRecord) method the better I like it! Well done.

[Garry Claridge]

[FMP-CurrentRecordNumber] example:

<tr><td>Rank</td><td>Score</td><td>Name</td></tr>

[FMP-Record]

<tr><td>[FMP-CurrentRecordNumber]</td><td>[FMP-Field:score]</td><td>[FMP-Field:name]</td></tr>

[/FMP-Record]

I've never tried it, so it is only a guess!

Garry

[randyinla]

THANKS

thanks garrycl and vaughn, i'll try both your methods!