4 Replies Latest reply on Dec 19, 2008 1:26 PM by CountryBoy1

    GetNextSerialValue

    CountryBoy1

      Title

      GetNextSerialValue & Hidden Fields

      Post

      First Question: 

      Can't get GetNextSerialValue to work as a calculation value for a

      field.  (I also show this as a single field in the visible header). 

      Trying to get it to tell me the next serial number value of my

      key index. Have tried many different ways of calling it as a text

      (and even a number) return function.

        Second question: 

      Can I hide fields that I don't want to be seen ?  (I found that the
      field width (in table view) can be squeezed down to make it disappear,
      but then I can't expand it again in case I want to check it.)

      I use some fields as calculation values that are used for other

      fields.  These special calculation fields don't really need to be shown.

        Using Filemaker Pro 9 Advanced.  Thanks for your help.

       

       

        • 1. Re: GetNextSerialValue & Hidden Fields
          davidhead
            

          CountryBoy1 wrote:  

          Can I hide fields that I don't want to be seen ? 

           


          Sorry if I have misunderstood the question but it seems quite simple to me - go into Layout mode (Ctrl/Cmd-L), select the fields in question and press the delete key. Is that what you meant or do you need some kind of dynamic delete ability? 

           

          • 2. Re: GetNextSerialValue & Hidden Fields
            CountryBoy1
              

            Dear David:

                Yes, your method works OK.  I was just trying to have these "special" fields located to

               the far right on my table and have a way to conveniently hide them and unhide them as

               needed. Thanks for your help.

             

             

            • 3. Re: GetNextSerialValue & Hidden Fields
              raybaudi
                

              Hi CountryBoy1

               

              [...]
              Can't get GetNextSerialValue to work as a calculation value for a field.
              [...]

               

              Try this calculation:

               

              GetNextSerialValue ( Get ( FileName ) ; "the name of your key index field" )

              • 4. Re: GetNextSerialValue & Hidden Fields
                CountryBoy1
                  

                Dear Daniele,

                     Your method makes sense but I couldn't apply it correctly.
                  However, I did discover my mistake.  For the first argument,
                  I was giving it the name of the table and not the file.  They are
                  the same except the name of the file has an extra "A" on the
                  end of it.  The file has several tables, but the field that I want
                  is in the current table, so I didn't have to also give the name of the
                  table.  Also, it has to be in quotes.  Thanks for your help.