Document layouts
Do you have to update the document layouts for quotes, delivery notes, pick lists or identifications labels?
Follow the online course along with our layout expert and become the layout specialist in your company
Instructor Tom
"Have you ever wondered what your documents should look like? Take matters into your own hands and become the layout expert!
Cerm delivers a wide range of standard layouts, created in List & Label. But in order to adapt and convert them into the corporate identity of your company, you need both Cerm's and List & Label's knowledge."
Tom manages to explain seemingly complicated things and knowledge in a very simple and clear manner.
Tom manages to explain seemingly complicated things and knowledge in a very simple and clear manner.
Read LessA great training course, even for beginners with no SQL knowledge
A great training course, even for beginners with no SQL knowledge
Read LessIntroduction Document Layouts
Getting started
Create a new layout from scratch
Copy of an existing layout
Import a layout from the Cerm database
Delete a layout
Replacing layouts
Properties of a layout
Defining the printer choice per layout/user
Translations in layouts
Object list
Layers
Include logo layout
Variables
User variables
Preview
Insert text/line/rectangle/picture
Insert barcode
Insert PDF
How to test
Course 1: Cases
String functions
Numerical/Mathematical functions
Date functions
Concatenate
Appearance condition in a formula
Replacing a hardcoded text
Table contents
Line properties
Column properties
Group lines
Page number
Comment in a formula
Pre-printed stationary
Printing an additional packing label
Adding sales conditions
Case together - Logo of reseller
Course 2: Cases
Database explorer
SQL statements
Adding a new query
Adding variable to an existing query
Troubleshooting tips
Case together - Representative keyword on invoice
Course 3: Cases
Display all the SKU's in a box on the box label
Feedback
Multi-table layouts