Automatic alphanumeric numbering A000–Z999 in M-Files

Hi,

I'm trying to set up an automatic numbering property in M-Files that generates values in the format A000 through Z999.

The logic should be:

  • Start at A000 and increment up to A999
  • After A999, move to B000 and increment up to B999
  • Continue through the alphabet all the way to Z999
  • The value must always be exactly 4 characters – 1 letter + 3 digits (e.g. A001, B042, Z999)

Is there a way to achieve this in M-Files, either through:

  • VBScript
  • Compliance Kit Utilities/Sequences
  • Other application

My prefered option would be Sequences or using property calc but not sure it can solve this...