How To Change A Qty Field On The First Or Last Label Follow
I created two named data sources. one for the page number (PageNum) and one for the Total Number of Pages (TotalNumberOfPages). Both fields display correctly the current and total page numbers.
I would like to "Look" at the current page number and compare that with the total pages so I can modify my quantity field for the last label.
I have product that fits 100 per box. If I am shipping 350 parts - then I will need 4 labels. i.e. 3 boxes of 100 and 1 box of 50.
I was able to add a script to the Quantities in BarTender to calculate the number of labels.
However I don't seem to be able to detect the last page. When I try to reference the page number my logic does not work.
I created the page number field with:
LabelPageNum = Format.NamedSubstrings("PageNum").Value
Value = LabelPageNum
The formula I am using on the label is:
IF Format.NamedSubstrings("PageNum").Value = "4" Then
Value = "Hello"
Value = "Not There"
This formula always returns "Not There" no matter what page is being printed.
I have tried a number of String tests. i.e I see that the string has a length of 3. So I tried adding &CrLF to the test string however that did not work.
If there is anyone out there that has done this I would be gratefull for any advice.
Please sign in to leave a comment.