How would I go about creating a unique key in the format A001, A002, ..., A999, B001, ..., Z999.
I came across this video:
https://www.youtube.com/watch?v=JFOueW2l4_Q
Which I believe will help with incrementing the numbers, but I don't now how I would go about changing the letter. So for example when B999 id exist therefore next id created would be C001.
If anyone has any tips I would greatly appreciate it!
Thanks in advance!