Weight calculation based on quantity Follow
A client of mine recently had some major changes to their label structure requested by a major supplier and because of certain current restrictions put in place it suddenly became my job to help get this sorted before deadline. They were previously using some ancient label software which didn't quite cut it so i started playing around with Bartender which i found to be very helpful! I have managed to sort the labels but am trying to make printing easier by utilizing vb script to help minimize user input. Here is one of the issues:
We have a static value of "BoxWeight" for each product which is stored in our excel file database for our labels. When printing, the user is prompted for a quantity of boxes which is displayed on the final label. There also needs to be a "NetWeight" displayed on the label which is BoxWeight x QTY. This "NetWeight" needs to be displayed in 2 different formats: One is for the barcode and the other as text on the label. The format for the barcode is strangely xxxxxx but with a decimal point. So for example 54kg equals 054.000 when entered by the user (but is displayed as 054000 in the barcode). Currently i have a form which prompts the user to input the data in this format, whilst also asking for the weight in a different format i.e. 54.0 so that it can be displayed as readable text.
My question is: How can i prompt the user just for the quantity so that the net weight is just calculated via vb script (as BoxWeight x QTY) in 2 different formats to be displayed on the label?
Any help would be greatly appreciated! Stay safe