Excel Dropdown Box - Script Error In Bt-Wps 关注
Hello,
I have been working on a bartender project that links an Excel sheet to bartender. Using other forum topics, I have been able to successfully link the Excel file to a dropdown list on the data entry form. From within Bartender (Office Automation 10.1), I am able to view the dropdown data.
I have two problems, however. When I try to print an individual record by File > Print. I can successfully print the records I want using "Selected" under Queried Records. If I try and pick the record to print from the drop down list, I get the sample data. I cannot get it to print the data from the spreadsheet.
Also, when I use the bt-wps website, I get a "Script Error" in the dropdown list when attempting to print this label.
Any help you can give me would be greatly appreciated.
4 评论

Shotaro Ito
Hi Fosterjl,
VB Script as listbox / dropdown source on Data Entry Form (Prompt) are not supported in Web Print Server as shown below.
http://www.seagullscientific.com/label-software/whitepapers/web-based-barcode-and-label-printing.pdf
PromptingWhen a BarTender label format is selected with one or more substrings that havethe Prompt at Print-Time option enabled, a Data Entry panel is displayed by the WebPrint Server in the “Print” page. This panel is an HTML version of the “PromptDialog” that would be seen when printing from a full copy of BarTender. The PromptDialog design view in BarTender can therefore be used to customize this form. If nosubstrings have Prompt at Print-Time enabled, and the prompt dialog does not haveany controls on it, then this panel will not be displayed.The following limitations currently apply when using the Prompt Dialog in the Printpage of the Web Print Server:• Substring types that are sourced from a database may not also be set toPrompt at Print-Time. You may specify substrings to be sourced from adatabase or prompted for at print time, but not both.• VB Scripting as a source for list boxes is not supported.• When restrictions on data entry are specified in the Data Source, MoreOptions dialog of BarTender, and the user violates those restrictions, pop-upwarning messages are not at this time displayed in the web browser (as theywould be if printing from within BarTender). However the specified restrictionsare enforced and you can use the Update Preview function on the Print pageto see the resulting data as it would appear if you printed the label.
Currently we don't have a simple alternative. You could create custom web application to take over data entry form - however that would requires additional custom programming for each BarTender document.
There's web label print sample application coming with BarTender .net Print Server SDK.
http://forums.seagullscientific.com/index.php?/topic/83-code-samples/?p=157
The attachment has detailed explanation with screenshots. You can refer to it.
PS: I'm short on time to attach images and explain :).
There are multiple ways in which you can create a dropdown list in Excel.Data ValidationForm Control (Combo Box)ActiveX Control (Combo Box)But of these methods, Data Validation is the most used method, for its simplicity.1) Select the Cell (or) set of Cells in which you want to see the dropdown.2) Go to “Data” Tab –> Data Validation –> Data Validation3) Select List in the “Allow box”4) Just enter the names you want to see in the dropdown list in the “Source” Box
The attachment has detailed explanation with screenshots. You can refer to it.
PS: I'm short on time to attach images and explain :).
请先登录再写评论。