Calculated field with special ID RRS feed

  • Question

  • I am looking to create an ID for our projects, here is the issue/ requirements.

    Must Start with a Letter

    Must be followed by 3 numbers

    Example A001, A002, B001

    SO the problem that I have is that you could have the same three numbers with different letters.  A001 and B001.

    Does anyone have a solutions for my problem or a link to a suggestion.   I know that you can have other lists and have these list calculate then next number with a workflow but the letters are really throwing me off.


    Thursday, October 11, 2012 7:40 PM