3 Replies Latest reply on Dec 10, 2014 3:22 PM by philmodjunk

    Finding value in checkbox

    vickyn

      Title

      Finding value in checkbox

      Post

      I feel REALLY dumb for asking this, but what is the actual value of a checked checkbox (or an unchecked one)? I have to make a Hotlist checkbox field be checked if the Emergency field (another checkbox) is checked on. (But not the other way around.)

      I hate to give up on using checkboxes just because I can't remember what the actual checked value is. I've tried 1 and y--no luck.  Haven't tried "yes" yet.  FileMaker won't let me put in y.  Is it 0 (zero) for unchecked and 1 for checked? Or "y" for checked and "n" for unchecked? Meh.

      Vicky

        • 1. Re: Finding value in checkbox
          MarkGores

          A checkbox field is tied to a value list.  The field will be empty if no boxes are checked or have the value of the checked options from that value list.

          • 2. Re: Finding value in checkbox
            chihuas

            You have to assign a value based on a value list. on the inspector on the data tab there is a section called "Values from, clicking the pencil icon you can select or create a new value list which only needs to have one value (the checked value), I use 1, when you uncheck the field the value is empty.

            • 3. Re: Finding value in checkbox
              philmodjunk

              Actually, a check box field can contain data and yet all the check boxes will appear empty if the value in the field does not exactly match one of the values in the value list. This can happen if the data is imported into this field, edited elsewhere where a check box format was not used or if you later modify the value list without first updating the data in existing records.

              A good place to explore check box fields is in "Adventures in FileMaking #2 - Enhanced Value Selection". Several layouts in this file show the same exact field with and without check box formatting so you can watch the actual data in the field change when you select and clear values by clicking check boxes in the copy formatted to use check boxes. You can also easily do that experiment for yourself just by putting two copies of the same text field on your layout and formatting only one with check boxes.