Excel Dropdown Box - Script Error In Bt-Wps

Legacy Poster

• October 13, 2014 15:04

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.

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • October 16, 2014 00:25

  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • December 05, 2014 05:23
  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • December 05, 2014 08:29

  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • December 23, 2014 10:48
  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

   

   

   

  0

Please sign in to leave a comment.