From FM9 to FM11 I have manually assigned a rank after sorting sports carnival results for each event.

Is there a way of automating the rank once a results is entered in a time/distance field in the rank field? Can it also trigger a predefined lookup script for rank results?

Scripting I must admit is my weakness - single step scripts are fine.

looks like all you need is a simple loop script

For example to perform on a found set:

Set Variable[$rank; 1]

Loop

Set Field [Rank; $rank]

Go to Record/Request/Page[Exit after last;Next]

Set Variable [$rank; $rank + 1]

End Loop

Or to perform on a portal:

Set Variable[$rank; 1]

Go To Portal Row [first]

Loop

Set Field [Rank; $rank]

Go to Portal Row[Next]

Set Variable [$rank; $rank + 1]

End Loop

You can even add find and sort steps before the loop to further automate it. Also make sure to use the freeze window command

See:

http://fmforums.com/forum/showpost.php?post/241386/

http://fmforums.com/forum/showtopic.php?tid/201199/post/317490/#317490