I have to set a max number for each category in a found set. I set up a script to handle adding in the max value of a found set but I would like for it to handle adding the max value for each found category. I have the category set as a value list. Is it possible to loop a find with the set max script to go through each of the values found in the value list? There are approximately 30 different categories, and I know that I could manually have it go through each of them, but I figured there must be an cleaner and more concise way.

An example would be there there are records in CategoryA that have a number field value of 2, 3, and 4. There is a field called maxNum. I have a script that will find the max value and add it to maxNum. So for CategoryA all maxNum fields has the value of "4". I would like to go through each category and set the maxNums per category.

Hope this is clear. Thanks for the help.

You can use a summary field for this - no need to loop or set anything.

How do I use a summary field for multiple instances? Right now the summary field finds the max for everything instead of grouping them by category.

Place it in a subsummary by Category part, and sort the records by Category.

Note:

In version 9 and earlier, subsummaries show only in Preview mode or when printing. If you want to view the values in Browse mode, define a calculation field =

GetSummary ( summaryField ; Category )

Yeah! That did the trick. This is awesome! Thanks for you help.