1 Reply Latest reply on Oct 12, 2009 12:01 PM by philmodjunk

    Record Numbering

    tpstangent

      Title

      Record Numbering

      Post

      Hi!

       

      I just got started with FileMaker and am creating a return authorization form. I want my records to display in a five digit format like "00001" instead of the default "1" when you insert @@. Is that possible?

       

      Thanks!

      ~TPS 

        • 1. Re: Record Numbering
          philmodjunk
            

          You probably should define a field with an auto-entered serial number instead of adding the text "@@" to your layout. The @@ text will report the current number of the record as it is currently sorted in the found set. The same record will show different values just by sorting the record or performing a find to pull up different groups of records. This is not likely what you want.

           

          To include leading zeroes, just add the leading zeroes to the "next value" box on the field options auto-enter tab. (Open Manage | Database | Fields and double-click the field.)