function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
LeeCLeeC 

Auto Number / workflow Increment

Hello,

 

We have 4 sales staff who need their own auto number. Every time one of them creates a case I need a unique number generated.  I cannot use just one auto number field as it is possible that each member has the same auto number (The unique field will be added in front of the generated number i.e.).

 

Bob - T10 - (Autonumber) 0000

Fred - T20 - (autonumber) 0000

 

I have tried using different record types but every new case I create updated all the auto number fields. I was thinking about using workflows but I cannot figure out a way to get the number to increment correctly, as it resets its self with every new record.

 

Has anyone come across this problem before? any help would be great!

 

Thanks,

 

Lee

FromCRMWonderlandFromCRMWonderland
You need to write trigger to achieve this requirement.
LeeCLeeC

I have never created a trigger, does anyone have the code to do this?

 

Thanks,

 

Lee