Serialized "New Record" Script

[ejpvi]

Hi,

I have a field that isn't serialized. I typically want people to manually enter their value into this field.

Usually these values are something like W0001, W0002, etc... so if I did serialize it, that is how I would set it up. I am not using this as an indexing Key, it is just the next available item number they would use. They can change this value if they wish, and the database stays connected, because I employ Master Keys.

But I have a scenario where they want to click a "new record" button, and it would give them the next available serialized variable, but with a D0001, D0002. So basically, I was thinking of a script that would tack on a "D" and then somehow find the highest "D" value so that I can increment it once. Make sense?

Anyone have a simple way to accomplish this?

[Sara Severson]

Actually, if you don't mind serializing the field, FileMaker will do this for you.

When defining the field, just put your alpha prefix in front of the number in the "next value" area, i.e. "D1005."

When the next new record is created, that field will increment up to D1006.