One of the requirements for a project was for the system to generate a unique ID for each of the members coming in. The logic of the unique ID is slightly complex. The unique ID will take the first alphabet of the surname and increment the number after the alphabet. Example John Tan, membership number will be T001 (Tan is his surname). Another example Ryan Tay, membership number will be T002 (Tay is his surname). If name if Tristan Ram, membership number will be R001 (Ram is his surname).
Just wondering whether is this possible? And how can I create such custom logic in CiviCrm?