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

    Record Numbering



      Record Numbering




      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?




        • 1. Re: Record Numbering

          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.)