Database To Select Template
I have an Excel spreadsheet that has my label data in it with a column that will select the proper template based on the value of the field for that row. We use the same information to create a third label called a pn label. The other 2 are bag labels. I want to have on the data entry screen a checkbox or radio button that will allow the operator to choose if they want to print the bag label or the pn label for their selection. Need some direction on conditional printing based on data entry screen selection.
Thanks
Dave
-
Hi Dave,
A possible solution is this.
1) In your excel file you have a column that can contain values "Bag 1", or "Bag 2" or blank.
2) And in your BTW template you have 3 layers "Bag 1", "Bag 2" and "PN Label".
3) Create a Linked Data Source for the excel column with the layer values. You can do this by inserting the field onto one of the layers, chose Database Field and under properties Enter a Name. You can set the field to pre-printed so it doesn't print on actual layout.
4) On your data entry form, create a radio button list. Under List Items enter "Bag 1" "Bag 2" and "PN Label".
5) Under Linked Data Source select the Linked Data Source you created in step 3.
Now when the user prints by default the value of the radio button equals the value in the column but they have the option of changing it, to either a different bag label or pn label.
0 -
Thanks for the feedback, but I think I've left something out. Each PN will have a bag label AND a pn label. Depending on the part, there will be 1 of 2 bag labels but there is always a pn label. So, on the data entry screen, I'd like to have it so that it will default for the bag label (column in excel will determine which template to use) and then they can select the radio button for PN Label and it will pull the pn label template.
0 -
Can you attach the BTW file and sample excel file.
From my understanding there are at least 4 templates? At least 2 templates for Bag Label and at least 2 templates for PN label. Say if a quantity is 100.
Do you want to print:
a) 100 bag labels then 1 single PN label
b) 100 bag labels then 100 PN label
c) 1 bag label then 1 pn label until 100
0 -
Hi, See this you will need BTW 10 up.
You can use two templates. 1 Template for Bags 1 Template for PN (each template can have multiple layers) Create 2 datasources for PN and Bag. Set it in the Data Entry Form. Bag is from Database and PN is embedded so selected at time of print.
Using the two templates you can Print PN after Bag 1 at a time OR you can Print a Single PN after the Bag. I am not sure if you can print multiple PN after the Bags, pleas let me know if you find a way.
0 -
Through looking at your sample along with some other testing, I have what I need. I have attached my sample for others to learn from.
Prompts for the part number, then prompts for qty of labels and whether they want a bag label or a pn label. The bag label template is selected from the database file.
-1
请先登录再写评论。
评论
5 条评论