Skip to content

Set the value of a column

The value of a column can be set in the Report Editor:

  • Layout
  • Mappings
  • Rows (only for position "after each new item" and "before each new item")

To use the value of other columns the syntax is: {{column name}}.

Tip

Please be careful here. You must write the exact same name of the column as it is written in the tab Layout. Pay attention to the spelling and spaces! The safest way is it, to copy and paste the name from there.

Access any other column you selected in Selection. For example - you selected these fields:

example-selection

Then you can use the value by surrounding the name with {{ }}.

Here is an example of the usage in Layout:

use-value

Here is an example of the usage in Mappings:

use-value

Here is an example of the usage in Rows:

use-value

For a deeper understanding of the functionality please follow this tutorial: Combine address lines

Evaluate math expressions

To write math expressions the syntax is: "[[math expression]]".

There are (nearly) no limits. Here are some examples:

[[ 1.2 * ( {{Line items: Weight of product variant}} + 4.5) ]] 
[[ sin(45 deg) ^ {{Line items: Quantity}} ]]  
[[ {{Line items: Total price}} - ({{Line items: Total discount}}/1.2) ]]

If you need more complex functions, take a look at the function library we use.

Use DataChamp functions

Right now there is only one function - more are coming:

  • Output the date of today: Date(%Y%m%d)

Tip

Please check the Date Format options

An example would be to use the function to fill the date of today into custom column for every line of your export:

example

Back to top