Running A Script Depending On Serialization 追蹤

0

Hi,

 

How do I change a value of a field during print depending on value of "Number of serialized labels"?

 

The script I wrote below that is being called OnProcessData for the serialized Text Object, I cannot get the condition to return True.

Field 1 sets the "number of serialized labels" e.g. 11

Value is Text Object that increments by 1 on serialization (screen data, with serialization options)

I want to change a value on a separate field ("Field 8") on the last serialized label but I cannot get the conditional statement to return True.

 

If Value = Field("'sleevestickerS$'.Field 1") Then

            Field("'sleevestickerS$'.Field 8") = "1000"

End If

 

I hope I was clear on my explanation. I appreciate your advise.

4 意見

0
Avatar
Ian Cummings
版主
評論操作 永久連結

The field references are read only.  However, as they their ultimate purpose is to be used in a data source value of a label object you would instead set the value of the data source rather than the database field.  This is what your code should probably look like:

 

If Field("sleevestickerS$.Field 1") = X Then
     value = "1000"
End If

Where X is whatever value you are testing for.

0
Avatar
Legacy Poster
評論操作 永久連結

Hi,

 

The other issue I am having is I am trying to set X to be the serialized value that Bartender is generating, and then use this X in conditional statement as you pointed out. But I do not know how to do this or if Bartender can do this. I tried to use the lines of code, but failed:

 

Dim X

X = Format.Objects("Text 7").Value //issue here, how do I get the value of the current serialization number during print time? Text 7 is a screen data text object that increments by 1during print

If Field("sleevestickerS$.Field 1") = X Then

value = "last label"   //other calculation

End If

 

I have attached screenshot, csv and btw files of what I am trying to do.

Regarding the attached screenshot: what I am currently doing now is manually crossing out the last labels "Pcs in box" value and writing the remainder by hand...

 

Thank you for your advice,

0
Avatar
Legacy Poster
評論操作 永久連結

Hi,

 

I am trying to do exactly the same process.

Can anyone tell me how to read the value of the serialization so I can run use the serialization number in my calculations.

 

 

Thanks

0
Avatar
Legacy Poster
評論操作 永久連結

Hi I have now managed this.

 

Strange way of doing it but this seems to have worked.

 

Create a new Text Object on the label.

Use the VB "Event Control Scripts" Script for "ON Serialize Event"

Create a variable and set it as a counter

 

Dim BoxPos

BoxPos = BoxPos +1

 

You can now use this value in your calculations.

 

Hope this helps.

登入寫評論。