Jump to content
Sign in to follow this  
James Chung

Generate Serial Numbers from 1 daily?

Recommended Posts

Hi, I am new here. Could anyone tell me how to write the scripts that generate the serial numbers from “1” everyday? For example, “20070717-001”, “20070717-002”, “20070717-003”, “20070718-001”, “20070718-002”, “20070718-003” and so on. (2007 is the year, 07 is the month, 17 is the day. and the -00X is the serial numbers.)

Thanks

Share this post


Link to post
Share on other sites

Hi

give a look at this custom function:

http://www.briandunning.com/cf/386

Share this post


Link to post
Share on other sites

The usual warning:

http://fmforums.com/forum/showpost.php?post/258882/

Share this post


Link to post
Share on other sites

Thank you for your help. Could you make a sample for me so that I can understand this function more. Because this is the first time I am using this function.

Best Regards,

James

Share this post


Link to post
Share on other sites

James, I would definitely heed comments warning because you could be opening a can of worms for yourself. If you can, just stick with the serial number approach.

Share this post


Link to post
Share on other sites

Ok, this is an example.

N.B.;) the Id number must be generated by FileMaker and it is the lonely that you have to use for relationships

DailySerial.zip

Share this post


Link to post
Share on other sites

Thank you for your fast responses and help again. I am starting to understand this function and your help is very useful. But if I want to put some fixed letters in front of it with "-" and with "-" plus 3 digits, what should I do? For Example, [color:red]ABC-20070720[color:red]-001.(ABC- is the fixed letters, 20070720 is the current date, and -001 is the daily number.)

PS: if is possible, could you explain how you control those parameters more. Because I am not so sure that my comprehension of the parameters that you use in this function is correct or not.

I am sorry to trouble again and thank you for your great help.

Best Regards,

James

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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