Peter Knowles Posted June 12, 2001 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
GregFM Posted June 16, 2001 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.
LiveOak Posted June 16, 2001 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
Recommended Posts
This topic is 8601 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