IF ({color} = “red”, “Tinto”, {color})
Explanation: If the color field contains the word red, then replace it with Tinto, if not then use the value of the colorfield.
IF ({product title} := “red”, REPLACE(“red”, “Tinto”), {product title})
Explanation: If the field product title contains the word red, then replace the red part of the field with tinto, if not then use the current value of the product title field.
REPLACE(“red”, “Tinto”, UNCASE_SENSITIVE)
Explanation: Replace the word red, every time it appears, with the word Tinto, regardless of whether red is written in uppercase or lowercase.
IF ({pallet} >= 10, MATH({pallet}*0.5), MATH({pallet}*1))
Explanation: If the value of the field pallet is greater or equal to 10, multiply the value of “pallet” by 0.5, otherwise multiply it by 1.
LOWERCASE({title})
Explanation: Take the value of the field title and convert it all to lowercase.
MATH({units}*12.5)+”€”
Explanation: Multiply the value of the units field by 1.25 and then print the result followed by the Euro symbol.
MATH({products.price_base}*{units})
Explanation: Print the result of multiplying the field price_base from the products table by the field units (this formula is based on the assumption that we are in a Variants field and are referencing the product to which the Variant is linked).
