NickS Posted February 28, 2005 Share Posted February 28, 2005 How would I design a field that always numbered the record according to the sort order? Say in a bike race I show all the Women times from the shortest to the most. First being the least time and so on. I did want to thank every one for the help on the portal button a few days ago. Nick Link to comment Share on other sites More sharing options...
bikergeek Posted February 28, 2005 Share Posted February 28, 2005 Calc field Place=Get(RecordNumber) RecordNumber (as opposed to recordID) is dependent on the order of records in the found set, whatever that order is at the moment. Link to comment Share on other sites More sharing options...
NickS Posted February 28, 2005 Author Share Posted February 28, 2005 Thanks Link to comment Share on other sites More sharing options...
-Queue- Posted February 28, 2005 Share Posted February 28, 2005 Make sure it's set to 'do not store calculation results' also. Link to comment Share on other sites More sharing options...
NickS Posted February 28, 2005 Author Share Posted February 28, 2005 I tried what your suggestion but end up with ? in the field. I made sure "Do not store calc" was checked. What am I doing Wrong? Nick Link to comment Share on other sites More sharing options...
bikergeek Posted February 28, 2005 Share Posted February 28, 2005 If you're viewing these records in a portal, which you did not specify, that may be the problem. If so, you can specify the portal row sort order and display the portal row number by placing a text element containing '@@' in the portal. Together, those should make it work also. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6598 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now