Options
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 14 subscribers
  • Views 237 views
  • Users 0 members are here
Related

Automatic alphanumeric numbering A000–Z999 in M-Files

Admir.MFiles

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...

Parents
  • +1 in reply to Admir.MFiles

    Based on the Compliance Kit documentation, sequence formats can be either numerical or alphabetical, but not a combination of both. I haven't tested this personally, though. Feel free to experiment with the module.

    As a first step, I'd recommend re‑examining the requirement to see whether this kind of custom sequence is truly necessary. The CK Utilities work well with more conventional sequencing formats and are much easier to maintain. Consider also that the final sequence can be composed from multiple elements, for example by combining a department abbreviation with a running number.

    If a mixed alphanumeric sequence format is a strict requirement, you would likely need to implement this logic yourself. In that case, I strongly recommend avoiding VBScript due to Microsoft’s deprecation plans and consider vault application development.

    If you need further guidance or development assistance, our consulting services can help assess the options and support the implementation.

Reply
  • +1 in reply to Admir.MFiles

    Based on the Compliance Kit documentation, sequence formats can be either numerical or alphabetical, but not a combination of both. I haven't tested this personally, though. Feel free to experiment with the module.

    As a first step, I'd recommend re‑examining the requirement to see whether this kind of custom sequence is truly necessary. The CK Utilities work well with more conventional sequencing formats and are much easier to maintain. Consider also that the final sequence can be composed from multiple elements, for example by combining a department abbreviation with a running number.

    If a mixed alphanumeric sequence format is a strict requirement, you would likely need to implement this logic yourself. In that case, I strongly recommend avoiding VBScript due to Microsoft’s deprecation plans and consider vault application development.

    If you need further guidance or development assistance, our consulting services can help assess the options and support the implementation.

Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.