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.
Modifier | Description | Example |
Uppercase | capitalizes all linked text | Shoes -> SHOES |
Lowercase | lowercase all linked text | Shoes -> shoes |
Titlecase | capitalizes the first letter of each word | The perfect running shoe -> The Perfect Running Shoe |
Numerical | strips all characters except for numbers and decimal places | 99.95 USD -> 99.95 |
Add | outputs the addition of the number by an input value* | 99 Add [10] -> 109 |
Subtract | outputs the subtraction of the number by an input value* | 99 Subtract [10] -> 89 |
Multiply | outputs the multiplication of the number by an input value* | 99 Multiply [10] -> 990 |
Divide | outputs the dividend of the number by an input value* | 99 Divide [3] -> 33 |
Currency Dollars | strips all characters and numbers except those to the left of a decimal place | 99.95 -> 99 |
Currency Cents | strips all characters and numbers except those to the right of a decimal place | 99.95 -> 95 |
Currency Symbol | 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.
Stacking Modifiers
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:
Breakdown
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.