AnsweredAssumed Answered

Checkbox set help, please

Question asked by cfanta on Dec 11, 2013
Latest reply on Dec 17, 2013 by TSGal


Checkbox set help, please


FileMaker Pro



Operating system version

Windows 7

Description of the issue

Hello all! I'm trying to create a report using checkbox sets. I'm not exactly sure how I should explain this, but I'll give it a go (kinda new to the whole FMP programming thing).

I have a checkbox indicating certification scopes for our clients. The checkboxes (5 values) can all be simultaneously checked at once or only one checkbox can be checked.

My problem is that I need to provide a report indicating, yes - the crop box is checked in one data field, no - the livestock box is not checked in another data field, and so on.

Steps to reproduce the problem

I've tried using the following calculation to get a yes/no result in a new data field:
If (not IsEmpty (FilterValues (ODAS::Certification Scope; "Wild Crop")); "Yes"; "No").
Even if "Wild Crop" is checked in OSDA::Certification Scope, then the new data field is still showing no, and I need it to show yes.