Column Modifiers help format your text values from your feed when designing templates. To add a modifier, double click on the linked layer in your artboard and select + Add Column Modifier then select from the dropdown the modifier you'd like to add.
capitalizes all linked text
Shoes -> SHOES
lowercase all linked text
Shoes -> shoes
capitalizes the first letter of each word
The perfect running shoe -> The Perfect Running Shoe
strips all characters except for numbers and decimal places
99.95 USD -> 99.95
outputs the addition of the number by an input value*
99 Add  -> 109
outputs the subtraction of the number by an input value*
99 Subtract  -> 89
outputs the multiplication of the number by an input value*
99 Multiply  -> 990
outputs the dividend of the number by an input value*
99 Divide  -> 33
strips all characters and numbers except those to the left of a decimal place
99.95 -> 99
strips all characters and numbers except those to the right of a decimal place
99.95 -> 95
outputs only the currency symbol of the text
99.95 USD -> $
Format As Currency
will analyze the currency code and format the number as standard currency viewing
99.95 USD -> $99.95
*You can use math modifiers with other column values by inputting the column name without double curly brackets.
Each modifier you add will run off of the previous modifier's output. You can stack multiple modifiers together to create a formula. Below is an example of stacked modifiers which will output a percent value between price and sale_price:
The main column being linked here is
price. From there, we're subtracting the field
sale_price. Then we're dividing the output by the
price field again. This gives us a fraction which we'll want to turn into an integer. So we multiply this output by 100. The output will give us a value with two decimals. Two strip these, we take this output and set the numerical modifier.
Modifiers can also be added to templated text assets to add additional text outside of the formula templated text assets to add additional text outside of the formula.