Translations:Erweiterte Feldfunktionen/38/en

Example 1 ... If value of column 'Available' = no, write 0 - if value of column 'Available' = yes, write 1 - if both are FALSE, write nothing in the cell. {IF 'Available' == 'no'}0{ELSEIF 'Available' == 'yes'}1{ELSE}{ENDIF} Example 2 ... is a bit more complex. There are, for example, variant cells for clothing sizes. The following code replaces the size designations 36-54 from the import file (column name: 'Variation_Size') with the desired letter named sizes, for example, S, M, L, XL, etc.:

{IF 'Variation_Size' == '36'}XXS
 {ELSEIF 'Variation_Size' == '38'}XS
 {ELSEIF 'Variation_Size' == '40'}S
 {ELSEIF 'Variation_Size' == '42'}M
 {ELSEIF 'Variation_Size' == '44'}L
 {ELSEIF 'Variation_Size' == '46'}XL
 {ELSEIF 'Variation_Size' == '48'}XXL
 {ELSEIF 'Variation_Size' == '50'}3XL
 {ELSEIF 'Variation_Size' == '52'}4XL
 {ELSEIF 'Variation_Size' == '54'}5XL
 {ELSE}6XL
{ENDIF}