Hi there,

Is there a way or a script that could edit a serial number? I have a field that increments by one for every new records. When I duplicate a record, a serial number is missing. If the current serial number is 005, the next serial number will be 007 after duplicating 005. Is it possible to set up a script that will change 007 for 006?

Thanks for your help

When I duplicate a record, a serial number is missing. If the current serial number is 005, the next serial number will be 007...

This seems not the true...

There is some strange calculation on your autoenter serial number ?

I tried to make it simple because my auto enter field is edited by a script when a duplicate is created. The real issue is whether or not the serial number can be changed through a script.

When duplicating a record, the serial number increments by one. I don't want that to happen. If the current serial number is 005, when creating a new record, it should be 006 even if the user created a duplicate prior to this action.

The real issue is whether or not the serial number can be changed through a script.

This isn't a problem because there is a script step that can do what you want:

Set Next Serial Value [ YourField ; YourCalculatedResult ]

When duplicating a record an auto-entered serial number should NOT be duplicated, FMP should give the record the next available number.

This is what Daniele was referring to.

I carefully checked my script and the incrementation goes up by one when duplicating a record but fortunately your script solved my issue

thanks