Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Sequential numbers for found set


This topic is 8540 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.