Layout


The layout tab allows you to

  • change the column order,
  • modify the settings of a column
  • and to add custom columns.

Modify column settings

Click on the settings icon next to a column. There are different options depending on whether a column is a number or a text type:

column-settings

Click "Test settings" at the bottom of the settings page to see your changes live.

Add custom columns

For fixed value columns just add a column like in this example:

add-column

You can use the values from other columns: The syntax is: "{{column name}}". Please be careful here. 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!

Further you can write math expressions. The syntax is: "[[math expression]]".

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

* [[ 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.

Example: formular-variables

Date Formatting Options

Convert date values to any format you need. Set this value only if you need to get formatted date values (e.g. CSV files). Note that if a format is set, the column is formatted as text in Excel (and no longer as a date). To return to the default, simply empty the field.

Here are two examples for a "Date Format":

date-format-example

date-format-example

Use these "tokens" to build your own formatted date:

TokenOutput
MonthM1 2 ... 11 12
Mo1st 2nd ... 11th 12th
MM01 02 ... 11 12
MMMJan Feb ... Nov Dec
MMMMJanuary February ... November December
QuarterQ1 2 3 4
Qo1st 2nd 3rd 4th
Day of MonthD1 2 ... 30 31
Do1st 2nd ... 30th 31st
DD01 02 ... 30 31
Day of YearDDD1 2 ... 364 365
DDDo1st 2nd ... 364th 365th
DDDD001 002 ... 364 365
Day of Weekd0 1 ... 5 6
do0th 1st ... 5th 6th
ddSu Mo ... Fr Sa
dddSun Mon ... Fri Sat
ddddSunday Monday ... Friday Saturday
Day of Week (Locale)e0 1 ... 5 6
Day of Week (ISO)E1 2 ... 6 7
Week of Yearw1 2 ... 52 53
wo1st 2nd ... 52nd 53rd
ww01 02 ... 52 53
Week of Year (ISO)W1 2 ... 52 53
Wo1st 2nd ... 52nd 53rd
WW01 02 ... 52 53
YearYY70 71 ... 29 30
YYYY1970 1971 ... 2029 2030
Y1970 1971 ... 9999 +10000 +10001
Note: This complies with the ISO 8601 standard for dates past the year 9999
Week Yeargg70 71 ... 29 30
gggg1970 1971 ... 2029 2030
Week Year (ISO)GG70 71 ... 29 30
GGGG1970 1971 ... 2029 2030
AM/PMAAM PM
aam pm
HourH0 1 ... 22 23
HH00 01 ... 22 23
h1 2 ... 11 12
hh01 02 ... 11 12
k1 2 ... 23 24
kk01 02 ... 23 24
Minutem0 1 ... 58 59
mm00 01 ... 58 59
Seconds0 1 ... 58 59
ss00 01 ... 58 59
Fractional SecondS0 1 ... 8 9
SS00 01 ... 98 99
SSS000 001 ... 998 999
SSSS ... SSSSSSSSS0000.. 0010.. ... 9980.. 9990..
Time ZoneZ-07:00 -06:00 ... +06:00 +07:00
ZZ-0700 -0600 ... +0600 +0700
Unix TimestampX1360013296
Unix Millisecond Timestampx1,36001E+12