Serialization configuration with two variables incrementing depending on each other

Max VH

• October 17, 2022 12:53

Hi all!

I'm trying to configure incremental increase with two variables.
Example:

001-01
001-02
etc.
001-10

002-01
002-02
etc.
002-10

etc.

100-01
100-02
etc.
100-10

So when "001-10" is reached, the next label has to be "002-01".

I have tried some things but I don't think this is possible with "standard" bartender configuration and perhaps needs some VB scripting. Any ideas? 

I'd really appreciate any assistance with this.

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • October 17, 2022 15:39

  There is no need for VB script for this, the simplest way would be to add the data as three embedded data substrings, one for each of the XX, the - and the YYY values.

  The XX should be set to Increment by 1 every label which resets after every 10 labels. I would also make this field have a minimum of 2 characters padding with a leading zero if below this (untick the warning).

  The - is just a fixed field and could also be added as either a prefix or suffix to one of the other fields if you preferred.

  The YYY should be set to increment every 10 labels. 

  

  and so you should get something like this

  

   

   

   

  0
• 

  Max VH

  ★ BarTender Hero ★

  • October 21, 2022 10:55

  Peter Thane Thank you so much! Managed to get it working now.

  0

Please sign in to leave a comment.