Mapping syntax:
<field name in pdf template> := <@formula>
Mapping examples:
- D8256:=D8258_1
- D8284:=D8284
- CompanyDetails:=@Company("name")+" - "+@Company("address")+" - "+@Company("zip")+" "+@Company("city")+" - Phone "+@Company("phone")+" - VAT "+@Company("vat")+" - "+@Company("www")
- D8183_1:=@If(D8183_1<10;@Round(D8183_1;1);@Round(D8183_1;0))
- #LOGO:=37:775:200:100
- #K"PackagingMarkedLabelAccreditationCodeList_Denmark":D8007:=240:520:0:40:1:5
- #1:=37:640:250:100
- Contained_in:=@Parent("D8165")
PDF Images
- #LOGO:=x:y:width:height:page
Insert company logo at position x, y at size widthxheight on page number 'page' - #1:=x:y:width:height:page
Insert image from URL in D8350_1 from the Base Unit. '1' is the grid row number - #P:=x:y:width:height:page
Insert image from URL in D8350_x from the Base Unit where "Is primary file" D4277 is Yes.
If no primary file is set, then it uses the first available image. - #<@formula>:=x:y:width:height:page
Use an @formula to evaluate the URL.- Example: #@GetEx("D8350_1"):=x:y:width:height:page
- #K<keyword list name:keyword value(s)>:=x:y:width:height:page:x padding:y padding
Insert image from keyword list with keyword name from master.- Example: #K"PackagingMarkedLabelAccreditationCodeList":D8007:=x:y:width:height:page
- #Barcode:=x:y
Insert EAN 13 barcode with GTIN from the base unit at position x, y.
Auto scale: set width and/or height to zero
PDF functions
- #TextWithAllergensInBold:=field name:field name for language:language:font size:x:y:margin:page
Inserts a paragraph in the PDF with the text for the chosen language with allergens marked in bold (based on the allergen filter). The paragraph uses the font size and is inserted at x:y with a margin on the selected page.
Example:
#TextWithAllergensInBold:="D8179":"D8180":da:10:225:140:30:1
Other functions
See the Microsoft Excel Templates article.