Dropdown List Box Data Lookup

Legacy Poster

• November 06, 2014 19:24

I have a simple label which requires the user to select one of about ten static address "codes", and I need the address to populate in the label.

 

For example, the user clicks print, the data entry form asks which to print, the user picks "Dallas" from the dropdown, and the label populates with

"Dallas Distribution Center

200 Park St.

Suite # B

Dallas, TX 64635"

 

While I know that I can create a a database or excel sheet with the addresses and handle it that way, I was hoping there was a way to just save the static data in the Bartender label to reduce complexity drastically.

 

Thanks!

   Trav-

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • November 07, 2014 02:28

  Data entry form's Dropdown can separate display text and datasaource - which enables you to select "Dallas" and input "Dallas Distribution Center 200 Park St. Suite # B Dallas, TX 64635".

  However you cannot enter newline (<<CR>>) in dropdown value.

  You can replace specific character such as " | " by carriage return <<CR>> in Search and Replace transform.

  To enter <<CR>>, click little triangle button at the right of text box.

   

  see attached sample.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • December 09, 2014 22:15

  Shotaro,

       Thanks for the workaround and sorry for the gigantic delay in reponding. I tried your suggested method, and although it definitely can work, ultimately it fell a bit short in my scenario, as I needed to utilize the address data in multiple places on the label (for instance, using the zipcode in a 128 barcode as well as the printed address) and I could not perform separate data transforms on the same data to try to strip the rest of the address away. My plan for this label design was somewhat of a stop-gap measure anyway, so I can live without this functionality. Thanks for your time-

   

  Travis-

  0

Please sign in to leave a comment.