Jump to content
Sign in to follow this  
anniee

HELP!

Recommended Posts

i have a very basic problem that i'm sure someone can fuguer out immeditaely....i don't have custom formatting option...but i want to generate 'workorder' numbers that corespond to the record number BUT i want the number to be 00001, 00002, 00003 etc....how do i tell filemaker to treat the record number as a 5 digit number?

thank yo so much i know this is too easy!

Share this post


Link to post
Share on other sites

...how do i tell filemaker to treat the record number as a 5 digit number?

Hello anniee,

If the "record number" you're referring to is generated as an auto-enter serial number, you will be able to specify leading zeros simply by entering them into the "next value" field on the Auto-entry panel of the Options dialog for the serial number field.

Alternatively, If you already have the numbers (but they're not 5-digit) or you want to generate the numbers in some other way (eg using the Get(RecordID) function), you can add the leading zeros with a formula along the lines of:

Right("00000" & Get(RecordID); 5)

BTW, the Get(RecordNumber) function, is probably not a good choice for this purpose, as the numbers change when records are sorted or deleted etc.

Share this post


Link to post
Share on other sites

thanks so much!..is there a way to add text to the front of auto generate serial # or put auto generate in the 'specify calculation'?

so it would look like ANN07-00001, ANN07-00002

Share this post


Link to post
Share on other sites

thanks so much!..is there a way to add text to the front of auto generate serial # or put auto generate in the 'specify calculation'?

so it would look like ANN07-00001, ANN07-00002

Yes. Auto-enter serials can include leading text characters. Just enter them into the "next value" field in the Options dialog and FileMaker will use them when generating serial values, in the way you've described. :wink2:

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.