3 Replies Latest reply on Nov 25, 2014 7:28 AM by philmodjunk

    Hide Fields

    JohnathanRainsforth

      Title

      Hide Fields

      Post

      Hello all!

       

       

      I basically have a database which is for creating cue sheets for theatrical followspots. 

      I have a layout where i input the information for each spot and a page where the data inputed. I want to have an option with each followspot to have an Active field. i.e. Yes or No and the answer to this would have each followspots fields hidden or shown in the data entry page?

      I hope this makes sense and your able to offer help.

       

       

        • 1. Re: Hide Fields
          philmodjunk

          What version of Filemaker are you using. v13 has options for this that older versions do not have?

          IF not using v13, what kind of layout view will you be using? Form, list or table?

          • 2. Re: Hide Fields
            JohnathanRainsforth

            V13.

            The layout view is form, I have found an option to hide if; I input to his if the field is 2 but it doesn't work.

             

            • 3. Re: Hide Fields
              philmodjunk

              Hide Object When is then the setting to use. It should work just fine.

              If you want a button to not be visible when Field1 = "No", then you would use:

              YourTable::Field1 = "No" as your hide object when setting provided that field1 is defined to be a text and not a number field and assuming that your value list enters the exact text "No" when that option is selected and not some other values such as a hidden field 1 value or the the text: "No " (extra space). Note that this expression will not hide the button if the field is empty.