Peter Knowles Posted June 12, 2001 Share Posted June 12, 2001 I'm trying to set up a calculation field which creates a sequential series of data for all the records in a found set. I'll be using it to create numbered labels for test items in a printed test. Currently, after using a "find" function to create the list of questions I want to use in a test, I can manually type in 1, 2, 3, etc. into my "sequence" field. However, I'd like to harness FMP to do it automatically instead, to turn "seqence" into a calculation but am having trouble coming up with a calculation to do so. Now I'm wondering if I need to use a script with it (Find, then Sequence....) Any ideas, suggestions or calculation scripts would be wonderful. Thanks Link to comment Share on other sites More sharing options...
Chuck Posted June 12, 2001 Share Posted June 12, 2001 Use a script to loop through the found set. Chuck Link to comment Share on other sites More sharing options...
GregFM Posted June 16, 2001 Share Posted June 16, 2001 Insted of a loop script, how about using the comand Replace (found under records) and check sequence or calculation. I think it will run faster. Link to comment Share on other sites More sharing options...
LiveOak Posted June 16, 2001 Share Posted June 16, 2001 This might be a simple way (if it is what you want). If you find the questions want, and sort them in the order you wish, you can create a field defined as a calculation (unstored) equal to Status(CurrentRecordNumber). This is just the number of the records in the current found set in the current sort order. Its kind of like a line number in list view. It is not really attached to a record, just a numbering of the current found set from top to bottom. Once defined, no additional action would be necessary. -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8540 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