Autofill Serial Number Range and then reset?

[hartmut77]

Hi

My friend has an event which he gives out nametags to. He wants to give everyone a unique nametag in a range from 001 to999 and at that time it needs to reset back to 001 again. How can this be done in the specify calculation area of the options in define fields?

Thanks

[ernst]

Hi Hartmut,

I think he could use two fields.

One that auto-enters a serial number

A second one that is a cal field with definition Mod(Field_One, 1000)

Ernst