We’ve talked before about the importance of having an autonumber for your workspaces. Today’s tip focuses on ways to configure autonumbers using the Sequencer workspace that is part of the base tenant (special thanks to Madhan T of Product Support – reusing his example. I’m in Oregon and we’re really big into re-use!)
Let’s say you want your autonumber to start at a particular value. Set up a sequencer (you can denote prefix, suffix, start position, step size, etc) and call that sequencer from a script. The image below shows you step by step how to do this:
1. Create a sequencer in the Sequencers workspace
2. Put the desired starting value
3. Make note of this system created ID – you’ll need to reference it in your script
4. Copy the ‘ItemSeqGen’ action script and modify with the Seq ID of your sequencer (remove any other unnecessary bits; update the header field as well – something not done for this example – oops!).
You can then add your script to be run at item creation. Note in the bottom browser window the new record for the DAN_Item workspace uses the defined sequencer for it’s number.
Hope this helps you! ^MS
Photo: Andres Rueda