Introduction
The Personalisation tab lets you add personalisation fields to the segment. For database source segments with activation platform Sendingly, it is possible to modify the format of a field.
Modify the format of a field
To change the format of a personalisation field:
- open the personalisation edit page;
- click on the Edit icon of the field in question;
- click on Add format;
- define the field label: prefer a label that is explicit about the field's content and format (e.g. FIRST_NAME_UPPER)
- select the desired formatting function.
- for the date format function: select the desired date format
- for the add space function: fill in the number of characters between spaces
- click Confirm to validate format editing: the initial field (without format) remains present and cannot be deleted.
- click Confirm to validate the addition of this edited field to the segment;
Formatting functions
| Function name | Description | Example | Compatible with type field |
| Lowercase | Changes string to lowercase. | Segment -> segment | string |
| Shift | Changes string to uppercase. | Segment -> SEGMENT | string |
| First letter capitalized | Puts the first letter of the string in uppercase and the rest in lowercase. | MY SEGMENT -> My segment | string |
| First word in uppercase | Puts the first letter of each word (separated by spaces) in uppercase and the rest in lowercase. |
MY SEGMENT -> My Segment but MY-SEGMENT -> My-segment |
string |
| Date | Changes the format of a date by applying the selected format. |
format dd-MM-yy 2023-10-24 10:30:18 -> 24-10-23 |
date, timestamp, string (if convertible to date) |
| Date in formal letters | Changes the format of a date by applying the selected format. Available languages are English and French. |
format day DD month YYYY 2024-01-01 -> Monday, January 1, 2024 |
date, timestamp, string (if convertible to date) |
| Add space |
Add spaces every X characters starting from the left. with X variables to be filled in |
X = 2 0625040589 -> 06 25 04 05 89 |
all field types |
| Format for price | Add spaces every 3 characters from the right before the Comma. |
10599,99€ -> 10 599,99€ /!but also segment -> s egm ent |
all field types |
If a formatting function is applied to a field with a non-compatible type, no formatting will be applied to the field.
/!\ Special case: if the date format function is applied to an integer or decimal format: then segment sharing will leave in error.
A field added with a date format is converted into the time zone of the campaign recipient according to the rules defined.
The formatting feature is only available for segments shared on Sendingly.
Result
The new version of the field with the selected formatting is added to the segment.