Excel Dropdown Box - Script Error In Bt-Wps 关注

0
Avatar
Legacy Poster

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 评论
0
Avatar
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

Prompting
When a BarTender label format is selected with one or more substrings that have 
the Prompt at Print-Time option enabled, a Data Entry panel is displayed by the Web 
Print Server in the “Print” page. This panel is an HTML version of the “Prompt 
Dialog” that would be seen when printing from a full copy of BarTender. The Prompt 
Dialog design view in BarTender can therefore be used to customize this form. If no 
substrings have Prompt at Print-Time enabled, and the prompt dialog does not have 
any controls on it, then this panel will not be displayed.
The following limitations currently apply when using the Prompt Dialog in the Print 
page of the Web Print Server:
• Substring types that are sourced from a database may not also be set to 
Prompt at Print-Time. You may specify substrings to be sourced from a 
database 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, More 
Options dialog of BarTender, and the user violates those restrictions, pop-up 
warning messages are not at this time displayed in the web browser (as they 
would be if printing from within BarTender). However the specified restrictions 
are enforced and you can use the Update Preview function on the Print page 
to 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

0
Avatar
Legacy Poster
评论操作 固定链接
There are multiple ways in which you can create a dropdown list in Excel.
Data Validation
Form 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 Validation
3) 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 :). 

0
Avatar
Legacy Poster
评论操作 固定链接

There are multiple ways in which you can create a dropdown list in Excel.
Data Validation
Form 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 Validation
3) 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 :). 

0
Avatar
Legacy Poster
评论操作 固定链接
There are multiple ways in which you can create a dropdown list in Excel.
Data Validation
Form Control (Combo Box)
ActiveX Control (Combo Box)
But of these methods, Data Validation is the most used method, for its simplicity. Later on, I’ll explain the pros and cons of each method, so that you can choose the best method among these for you.
 
Before going to explain how to create a dropdown list, let me tell you what a Data Validation is? It controls the type of data or the values that users enter into a cell. For example, you may want to enter only positive values in a cell, only ‘time’ in a column, or a text below the specified length. You can define all these conditions through Data Validation. Even dropdown list is a data validation where you’re constraining the user to use only those set of words in that cell. Again, in creating a dropdown list through data validation, there are different ways in doing it.
 
Writing the complete list in the Source Field
1) Select the Cell (or) set of Cells in which you want to see the dropdown. 2) Go to “Data” Tab –> Data Validation –> Data Validation 3) Select List in the “Allow box” 4) Just enter the names you want to see in the dropdown list in the “Source” Box
 
 
 

请先登录再写评论。