Counting "Other..." values

[lrcarey]

Hello all,

When users create a new record they are asked to assign the record to one or more categories using checkboxes. There is an "Other..." option so they can assign their own categories if necessary. I have a tally sheet set up in a related file that counts the number of times each category was selected. Now the users want to be able to also see a list of the values entered into "Other..." and have a count of each value in that list. Is this possible? I'm stumped.

Thanks (yet again!) for your help,

Leah

[djgogi]

One way for doing it could be:

1) for the list of non standard entries:

If the number of standard categories is not to high use the following calc otherwise use an looping script

otherEntries=Substitute(

Substitute(Substitute(//as many times as is number of standard categories, iow those assigned with checkboxes//(Substitute(checkBoxField,MiddleWords(ValuListItems(Status(CurrentFilename), "standardCategoriesList"),1,1),""),MiddleWords(ValuListItems(Status(CurrentFilename), "standardCategoriesList"),2,1),""),MiddleWords(ValuListItems(Status(CurrentFilename), "standardCategoriesList"),3,1),""),...MiddleWords(ValuListItems(Status(CurrentFilename), "standardCategoriesList"),n,1),""),

"