Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Open new record need running record #

Dan Decker

Recommended Posts

HEllo, I am having a problem with setting up a running record. What I want to do is when new record is selected I want a new record # for that particular entrie then I want it to start again on the new year eg: 03-0001 to 03-0500 and to change to 04-0001 on new year. Can anyone help?

Link to comment
Share on other sites

Hi Dan and welcome to the Café,


You can script the process of creating a new record to do what you want. You just need to ensure that users cannot create new records by menu selection or keyboard shortcut.


You would have a text field for the serial number that is set to auto-enter a serial number like 03-0001.


The script (New Record) looks like this:


New Record/Request

If ["Left(Serial, 2) Right(NumToText(Year(Status(CurrentDate))), 2)"]

Delete Record/Request [No dialog]

Set Next Serial Value ["Serial", Right(NumToText(Year(Status(CurrentDate))), 2) & "-" & "0001""]

New Record/Request

End If


See how you go with that.



Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use