Automatically generated sequence scenario for custom object
in Sales
Summary:
We are in a unique situation for generating the sequence for custom object in a specific format.
Content (please ensure you mask any confidential information):
Business Need:
- The sequence must be 7 digit RANDOM number (
no sequentialnumbers, can contain 0 in the start like 0000012) - The sequence must be UNIQUE.
- We have a legacy data as well to import. (about 2 million records)
We look at the options:
- Automatically generated Sequence — NOT USEABLE here (since we can not randomize it)
- Use of Groovy, to generate random number — HOW TO MAKE SURE IT IS 7 DIGIT and IT IS UNIQUE (recall the script if not unique?)
Tagged:
0