Auto-enter customized unique ID
Hi. Is it possible to a unique ID like R001M whereas :
'R' is from the first alphabet of my name
'001' is the first number of person with 'R' alphabet. The other patient with 'R' alphabet will be 002 and so on.
'M' is the gender of the person. 'M' for male and 'F' for female.
Is there any calculation that can do this? or do I need to relate any script?
Thanks in advance :)