3 Replies Latest reply on Aug 22, 2014 3:28 PM by philmodjunk

    Interactive check box in portal?

    DonStein

      Title

      Interactive check box in portal?

      Post

           Hi all,

           I'm new to FM, so I'll need a pathetically basic explanation. If you're brave enough, read on.

            

           I'm trying to make an interactive check box for a Layout (none of the info is sensitive, so picture is attached). It's a pretty simple concept but I can't seem to make it work.

           I've made a portal and cobbled together a value list to populate it, but I can't select any of the check boxes. It's "frozen." 

            

           I must be missing something simple here, so please help!

      database.png

        • 1. Re: Interactive check box in portal?
          briancrockett

               Can I assume "The Sound of Music" and "Tintypes", etc.  are records in the portal and not values in the value list?

               If they are records in the portal you will need a dedicated field in that table for the checkbox to set. I'd make my value list with the single value "1" and name it "One" . (You'll probably need to use it again for some other checkbox in the future) 

               Put your new field in the portal and set it to a checkbox with value list "One" and shrink it down so only the check box is visible.

               If "Tintypes", etc. are values in the value list, you're going to have to rethink your structure.

               If this didn't help, maybe you could provide more information on how your tables are structured and how the portal was done.

          • 2. Re: Interactive check box in portal?
            DonStein

                 Shoot. They are values in the value list. Is there any way to rescue this? I need a means to select multiple "Use in Shows" boxes (potentially hundreds), but I can't make check boxes scroll. That's why I thought a portal might be the best solution.

                 Why can't there just be a scroll bar with check boxes!?

                  

                 What do you recommend?

            • 3. Re: Interactive check box in portal?
              philmodjunk

                   Check out this file: https://www.dropbox.com/s/ti8vep64h67mtj2/CheckboxWScrollBar.fp7

                   It's in the older file format, but users with FileMaker 12 or newer can open it using Open from FileMaker's file menu to get a copy of the file that is converted over to the newer file format.