Quantities On Shelf Tags Seguir

0
Avatar
Legacy Poster

Hello. I am creating shelf tags for a grocery store. Up until now I haven't had any issues because the shelf tags were all items with a quantity of 1 so the price on the shelf tags was the price for that 1 item. Now we have a deal with a distributor of yogurt and we will be selling them 4 for $5.00. I would like to make shelf tags that say 4 / $5.00, but still print out just the price for items that have a quantity of 1. Bartender is connected to a database and the quantity and price are different fields in the database.

 

Basically is there a way to create a elseif statement for the quantity where it would display the quantity (4 in this case) followed by a / or just print nothing if the quantity is >1.

 

Thank you,

Todd Rabanus

8 comentarios

0
Avatar
Legacy Poster
Acciones de comentarios Permalink

You could do this with templates within a label document and drive the template choice by the value in the data source.

 

If the value is 1 use the original template if not use the one with qty.

0
Avatar
Ian Cummings
Moderador
Acciones de comentarios Permalink

Or you could use an event based VB script for the data source for the OnNewRecord event.  The classic If...Then...Else formulation should do the job.  Therefore, If the quantity field is greater than one then value equals "4 / " & Field("table.price") else value equals Field("table.price").  End If.

0
Avatar
Legacy Poster
Acciones de comentarios Permalink

You could do this with templates within a label document and drive the template choice by the value in the data source.

 

If the value is 1 use the original template if not use the one with qty.

i set up the 2 different shelf tags but can't figure out how to get it to choose which one. I decided to use your way first because i haven't written a vb script in years and figured i'd try this route first

0
Avatar
Legacy Poster
Acciones de comentarios Permalink

ok i made two templates, but in the page setup/ template tab there is no template selector option to set up the data source parameters. is it because i just copied the first template. should i start over and make them both from scratch?

0
Avatar
Legacy Poster
Acciones de comentarios Permalink

Which version of BarTender are you on?

 

I think this functionality wasn't introduced until 10.1

 

[attachment=1783:8-4-2015 3-41-25 PM.png]

0
Avatar
Ian Cummings
Moderador
Acciones de comentarios Permalink

Instead of using templates to do this, which does after all give you two different layout designs to play with, you might instead want to use multiple layers with "print when" conditionality applied.  Now I think about it, individual objects themselves have the same kind of "print when" functionality found in the top node of their properties.

 

Obviously the conditional use of layers and templates have a certain amount of overlap in terms of functionality, but in summary I'd say layers is best for conditionally printing fragment part of an overall label design, whereas templates allow for the conditional printing of radically different label designs.

0
Avatar
Legacy Poster
Acciones de comentarios Permalink

I'm using bartender 10.1 sr4 Automation still don't see anything like you have in the screenshot you posted slickson

0
Avatar
Legacy Poster
Acciones de comentarios Permalink

lol i figured it out. 2 days of frustration over nothing. the software was running professional simulated. i switched over to automated version and all those selector options popped up! funny how something so little changes a lot!

Iniciar sesión para dejar un comentario.