With mappings you can customize the output of any column.
There are three sections:
The "If section"¶
Use this section in the same way as "filters". Set up the condition when the mapping should be used.
The "set section"¶
Set which column should be set by the mapping. You can also use the "Add your own custom columns" function in the "Layout" tab to define additional columns that can be set here.
The "to section"¶
As the last step you have to configure the content.
You can use the values from other columns: The syntax is:
You must write the exact same name of the column as you can see it in the "Layout" tab. Pay attention to the spelling and spaces!
Here is an example of a mapping which adds the "Shipping Address: Address second line" to "Shipping Address: Address first line":
Use math expressions¶
Further you can write math expressions. The syntax is: "
There are (nearly) no limits. Here are some expressions:
If you need more complex functions, take a look at the function library we use.