Count number of individual values from value list

[Shari]

Hello,

I have a value list that has 26 different comments. When a teacher updates the final class documentation they select comments about the student from the value checkbox. They can select any amount of comments per student. I would like to have a count per class on the comments selected. For example: Class 2

Comment 1 Total; Comment 2 Total; etc. What would be the best way to handle this calculation?

Thanks,

Shari

[Fitch]

Checkboxes stink when it comes to reporting. You'd need to create 26 calculated fields, e.g. PatternCount(comments, "comment 1") -- and then summarize them. So IMO you're better off to just use 26 separate fields in the first place.

[Shari]

Thanks. I was afraid of that.

[rangebob]

I'm trying to verify this. I have a intervention field that has about 12 different items in it. If I use check boxes there is no way to count each of the items.

Also I would like to say if any one of the items in the value list is checked I want to put a yes in a different field.

[Vaughan]

You need a related file to hold the comments (a simple one-to-many relationship). Make a portal that allows creation of related records, and use a pop-up list (not check box) to select the comments.

Your summary reports are done in the related comments file.

The only disadvantage is that it's possible to enter the same comment twice for a person.

Platform: / Version:

FileMaker Version: