Find on checkboxes shows other checked checkboxes

How do I do a Find on a checkbox where it only shows records with that one checkbox checked but not other checkboxes that might also be checked?

For example, if I do a find on a checkbox "Admin", FileMaker finds all Admin checkboxes but it also shows other checkboxes checked that were also checked when Admin was checked.

I only want to "find" the checkboxes with Admin, but not Admin with other checkboxes checked.


A way that comes to mind is to make a find layout where the field uses radio buttons instead of checkboxes.

Hope this helps.

  1. Use more than one find request.

In the first find request, select Admin. In the next find request, select one of the other options and omit. This is ok for one or two options but it’s tedious if there are many.

  1. Provide different entry options in find mode. Simplest is a plain text field that allows you to enter anything. In your case “==Admin”.

  2. you might have a script trigger that only runs in find mode that prepends “==“ to an entry.