Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

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

Posted

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.

Posted

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

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 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.