Discussions

Expand all | Collapse all

How to generate unique code AABBNNN for any record using a counter NNN instead of the Record id#.

  • 1.  How to generate unique code AABBNNN for any record using a counter NNN instead of the Record id#.

    Posted 08-04-2017 13:07
    How to generate unique code AABBNNN for any record using a counter NNN instead of the Record id#. This counter is incremental but its value set varies for different values of BB. (001 to 199 for 1 case, else 200 to 999)


  • 2.  RE: How to generate unique code AABBNNN for any record using a counter NNN instead of the Record id#.

    Bronze
    Contributor
    Posted 08-06-2017 18:33
    So, how many different values of BB will there be?


  • 3.  RE: How to generate unique code AABBNNN for any record using a counter NNN instead of the Record id#.

    Posted 08-10-2017 04:40
    4 different values of BB, and further NNN counter range depends on the same:
    Code (BB)= DP, NNN= 001 to 099
    Code (BB)= DN, NNN=100 to 299
    Code (BB)= PP, NNN=300 to 399
    Code (BB)= PN, NNN=400 to 999



  • 4.  RE: How to generate unique code AABBNNN for any record using a counter NNN instead of the Record id#.

    Bronze
    Contributor
    Posted 08-10-2017 17:02
    So, I assume you have a separate BB field and that the current value in that field would determine the valid range of NNN values, and then you want the next available NNN for that BB? What happens if you run out numbers within the BB's NNN range?

    Or do I have this backwards and you really want this to drive off an incremental NNN, and you want to set the BB values based on how high the NNN is? If this is the case, what happens when you go over 999?