1 Reply Latest reply on Apr 17, 2014 12:04 PM by philmodjunk

    Wresting With Check Boxes

    BrettSahler

      Title

      Wresting With Check Boxes

      Post

           So i have a field titled Mailing List (See Below) with 7 possible values.  This I have added to the basic Contact Database that comes with File Maker.  If I do a find for a selection of contacts and want to add an X next to the first name on all of the contacts but keep any other existing selections how can I do this?  If I use Replace Field Contents after adding an x it wipes out all other selections.

           Would there be a better way to set up a Contact to be added to multiple mailing lists?

      Screen_Shot_2014-04-17_at_2.03.27_PM.png

        • 1. Re: Wresting With Check Boxes
          philmodjunk

               Replace Field Contents can use the following calculation to add "Mark Tucker" but keep all other selections unchanged:

               If ( Not Isempty ( FilterValues ( YourTable::checkboxField ; "Mark Tucker" ) ) ; YourTable::checkboxField ; List ( YourTable::CheckBoxFIeld ; "Mark Tucker" ) )