Generate Serial Numbers from 1 daily?

[James Chung]

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

[Raybaudi]

Hi

give a look at this custom function:

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

[James Chung]

Thank you so much, you save my life.

Best Regards,

James

[comment]

The usual warning:

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

[James Chung]

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

[JesseSFR]

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.

[Raybaudi]

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

[James Chung]

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

[Raybaudi]

OK

Here there is a modified version for your problem.

The CF now has a prefix parameter

ModifiedDailySerial.zip

[James Chung]

:laugh2: Thank you so much. You are the great.

Sincerely,

James