1 Reply Latest reply on Jul 17, 2014 1:56 PM by philmodjunk

    Hide/Show Field with Check Box Value List



      Hide/Show Field with Check Box Value List


           I'm  trying to have two fields hide/show when certain check boxes are checked in a value list.

           I have been using "the hide object when" option using this calculation

           Filter ( Customer Market::Found by  ; " Other" )≠" Other" or Filter ( Customer Market::Found by  ; " Recommended By" )≠" Recommended By"

           but this only works when one check box is check not multiples values.

           I was looking into this Calculation below but this is wrong some where

           FilterValues(ValueListItems("Customer Market::Found by";"How you Found Us");" Recommended By")≠" Recommended By"

           I have added a screen shoot of my check box value list to help clarify


        • 1. Re: Hide/Show Field with Check Box Value List

               When clicking multiple checkboxes for a field, FileMaker stores the values as: "First Value Clicked"¶"second value clicked"¶"Third value...

               IsEmpty ( FIlterValues ( Customer Market::Found By ;"Other" ) )

               Can be the "Hide Object When expression for the Found Other field.

               IsEmpty ( FIlterValues ( Customer Market::Found By ;"Recommended By" ) )

               Could be used for the Found Other field.

               All of these functions can be looked up in FileMaker Help if they are unfamiliar.