I am creating new product signs and want to add a line that dynamically calculated. i.e. different in original price and current in dollars, as well as a percentage savings. Is there a way to do this. Where are the fields with in label designer determined and can i edit them?
Thanks
*This post is locked for comments
you cant directly reference the table fields from the label design. Also the options for the field drop down is hard coded in the program business rules and not stored in a table.
You could prepopulate the detail1 field with the saving percentage though
something like this might work:
update item set item.SubDescription1 = ABS ((item.MSRP - item.price) / item.MSRP)
You might have to change it to suite your needs. Dont know if your are using the MSRP in the item properties. Also dont know if you want this for every item. I would suggest a where clause at the end of the update statement.
for reference. detail1 = dbo.[item],SubDescription1
detail2 = dbo.[item].SubDescription2
etc.
Do you know what table.field the items are that are listed in the field box. Some are obvious, others, like Detail1,2,3 are not and perhaps we could use those fields, but I can't find them in the tables. Thanks!
What you see is what you get.
Use an existing or create a new size label, select create an Object on the top and then select a type of object, Text, Field, Box, Line, Bar code or Picture, each option has their own possible selections.
As far as I know, you cannot add anything that's not there.
I would also appreciate any information about adding custom fields to Label Designer or what fields names are available and the format needed to edit them in a text editor.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154