Label View Formatting: Convert and Adjust Formula From Label View 8 to Label View 12

Posted on

In this post we show you how we can manually adjust label view formatting from version 8 to version 12 so we can print the barcode label.

We have a buyer who always send us data in format label view 8 while we have label view 12. There are some formats that need to be adjusted manually to make it work in label view 12.
Label view is a software to design and print barcode sticker with certain format and complexities. It can contain style, price, size and other necessary information in a garment.

The wrong formula

Below is a sample of a formula that need to be adjusted manually. There is “Circular reference” error in the formula. The formula is:

if(PRODUCT_CD=”P”,B_PANTS_Formula,if(search(“23OR”,PRODUCT_CD,”1″)>0,B_SZ1_ALT_SZ_Formula,B_OTHERS_Formula))
The highlighted formula is the wrong section.

wrong label view formula

The correct formula for label view 12

After looking into labelview 12 manual we found (actually my colleague Nandi) that we have to add double aposthrop to the formula so the correct one is:
if(PRODUCT_CD=”P”,B_PANTS_Formula,if(search(“23OR”,PRODUCT_CD,”1″)>0,”* B_SZ1_ALT_SZ_Formula”,”B_OTHERS_Formula”))

correct label view formula

This post is made to remind us if we found similar problem in the future.
Again we can compare the wrong formula format:

 if(PRODUCT_CD=”P”,B_PANTS_Formula,if(search(“23OR”,PRODUCT_CD,”1″)>0,B_SZ1_ALT_SZ_Formula,B_OTHERS_Formula))

and the correct formula format:

if(PRODUCT_CD=”P”,B_PANTS_Formula,if(search(“23OR”,PRODUCT_CD,”1″)>0,”* B_SZ1_ALT_SZ_Formula”,”B_OTHERS_Formula”))

Hope this simple post help you if you have the same problem with us converting data from label view 8 to label view 12.

Read post about printer Zebra ZM 600 quality issue.

 

Facebook Comments