6 Replies Latest reply on Jun 20, 2017 1:28 PM by lindseym

    Checkbox - limit combinations


      I have checkboxes set up. Is there a way to make it where you can limit the combination selections?


      Here is what I have


      Screen Shot 2017-06-16 at 10.42.46 AM.png


      Screen Shot 2017-06-16 at 10.56.28 AM.png


      I do not want the user to be able to select

      Locations, Message Schedule and LOC & MS




      Locations , Message Schedule




      LOC & MS



      There are a limited # of selection options:



      Drawings, Locations, Message Schedule

      Locations, Message Schedule

      Drawings, LOC & MS

      LOC & MS



      IF Drawing is checked, one of the following need to be selected: locations and message schedule or LOC & MS


      If Locations and message schedule or LOC & MS is checked Drawings does NOT need to be checked



      The only thing I could find online is advice to use radio buttons.... is this true? If so, is there a way to change the radio circle to a square and use a check instead? How do I make it where multi radio buttons can be selected?



      Thank you


        • 1. Re: Checkbox - limit combinations

          The complicated rules that you have make me wonder if this should all be input into a single field or not. To me, there's nothing in your interface design to guide the user in what selections may be made and which may not be made.  With the current design you either set up an "auto-correct" scheme where choices made by the user mysteriously change into a combination that is permitted, or you let them make a wrong choice and pop up an error message requiring them to make a correction. Neither seems ideal here.


          Maybe making this list of choices a button bar (or group of buttons in an older version of FileMaker) with conditional formatting to change color or Hide Object When making icons visible to both show which values are currently selected and which may be selected given the current selections.

          1 of 1 people found this helpful
          • 2. Re: Checkbox - limit combinations

            Thanks philmodjunk



            I think your second option makes the most sense. And would be the easiest to accomplish.


            I've been spending time trying to write script trigger of options, but that is exhausting in itself.

            • 3. Re: Checkbox - limit combinations

              How about a radio button with the choices as:


              Drawings, Locations, Message Schedule

              Locations, Message Schedule

              Drawings, LOC & MS

              LOC & MS

              • 4. Re: Checkbox - limit combinations

                Isn't checking both



                Message Schedule


                the SAME as checking


                LOC & MS ?


                Why even HAVE that option?  Without it, you just have a standard checkbox field situation.


                Am I missing something?

                • 5. Re: Checkbox - limit combinations



                  It's not the same for my purpose.


                  What the script is doing is creating cover sheets.


                  Drawings creates  1 sheet

                  Location Creates 1 sheet

                  Message Schedule Creates 1 sheet

                  LOC & MS creates 1 sheet


                  Sometimes 3 packets with 3 different covers are needed. Sometimes its okay to combine the info of Location and Message into 1 packet based on the client.




                  I just don't want radio.... I like the square and checkbox look (call me crazy-- I'm more designer than "coder")

                  • 6. Re: Checkbox - limit combinations

                    Screen Shot 2017-06-20 at 1.22.14 PM.pngScreen Shot 2017-06-20 at 1.22.40 PM.pngScreen Shot 2017-06-20 at 1.25.08 PM.png


                    I'm still working on the calculations.. but what I decided to do-- sorta based on all of the above, is to have the checkboxes and then set up box that will show hide and basically "deletes" the ability to select. And a note telling people what to do.