AnsweredAssumed Answered

Reporting on checkbox values

Question asked by JG on Mar 26, 2013
Latest reply on Apr 10, 2013 by JG

Title

Reporting on checkbox values

Post

     I've been using a checkbox set for a field to make it easy for users to keep the data consistent in a situation where any combination of items is allowed. For example:

     Event Table --> Module Field. Module Field has checkboxes for user input, and the checkbox list provides: Module A, Module B, Module C, etc up to Module F as options. User must tick at least one, and up to 6 (all) of the options.

     However, I now want to create a report that counts how many times each module has been run over a month/year. Since the checkbox turns the input into a text list, I'm getting results that don't let me pull that information out cleanly. For example:

     Event 1: Module A
     Event 2: Module B
     Event 3: Module A, Module B

     I want a report that tells me Module A has been run twice and Module B has been run twice. However, Filemaker treats this as Module A once, Module B once and Module A, Module B once. Which is correct as far as the checkboxes go, but not actually what I'm looking for. Especially since any combination of the 6 modules is allowed and expected.

     Is there some way I can separate the info in Event 3 easily in a report layout? Or is there a better option than using checkboxes for this kind of data?

Outcomes