If Field is blank I want to replace the value with another field

[Russ Pease]

About 90% of our part #'s have a UPC value that we use to print barcodes with, the other 10% do not have this value. When there is no UPC value present We need to print the Internal ID on the item instead. What is the best approach to substitute the Internal ID when needed.

 

[Joseph Kraebel]

Hi Russ,

If the internal ID is something that can be looked up while you are scanning you can probably use some sort of logic rule to place this field's value in your UPC field. IE a rule could be based on Lookup refreshed of the UPC field and if null set value of this field to the other field.