I have a field - Item #, which is calculated based on some criteria - item code, and next item #

next item # is a number in format 0001

for example an item # could be: A0001 - arising from item code & next item #

now, when i increase next item # (by next item # + 1) it goes to 2, instead of 0002 and subsequent item #'s become A2 instead of A0002.

how can i do this increment without losing the formatting I have assigned?

I think there is a function just for that - I can't remember the name of it though. I think it is something like: IncrementSerial.... I was close: http://www.filemaker.com/11help/html/func_ref3.33.83.html

I think there is a function just for that - I can't remember the name of it though. I think it is something like: IncrementSerial.... I was close: http://www.filemaker...ref3.33.83.html

Thanks Dan!

"0001" is not a number , at least without some manipulation. 1 is a number.

Incrementing '00001' when it is defined as a text field will maintain the formatting. This is commonly done when creating serial numbers that need leading zeros for padding (because, for example, that format is required for export or whatever.)

Cheers

Stanley

Incrementing '00001' when it is defined as a text field will maintain the formatting. This is commonly done when creating serial numbers that need leading zeros for padding (because, for example, that format is required for export or whatever.)

Cheers

Stanley

Cool, thanks for the tip. Both options seem viable!