I have created a picklist with 5 sports (named "Sports"), I would like to use the sport I selected in the picklist to then be the start of a unique account code.
For example:
If I added an account for a cricket club I would want the club code to be CC/0001
For a hockey club I would want HH/0001
(where the 4 numbers are automatically assigned buy ascending order dependent on when the account was added)
Does that make sense? Not sure if I have explained it very well!!
I have created a picklist with 5 sports (named "Sports"), I would like to use the sport I selected in the picklist to then be the start of a unique account code.
For example:
If I added an account for a cricket club I would want the club code to be CC/0001
For a hockey club I would want HH/0001
(where the 4 numbers are automatically assigned buy ascending order dependent on when the account was added)
Does that make sense? Not sure if I have explained it very well!!
