Transformations and Validations
Comprehensive list of transformations and validations available when exporting and importing data.
Basic documentation can be found in the import help article (opens in a new tab).
Transformation
| Type | Function | Input | Output | Applies To |
|---|---|---|---|---|
| Uppercase | Converts all letters to uppercase | lorem ipsum dolor. ALIQUAM sodales pellentesque. | LOREM IPSUM DOLOR. ALIQUAM SODALES PELLENTESQUE. | String |
| Lowercase | Converts all letters to lowercase | lorem ipsum dolor. ALIQUAM sodales pellentesque. | lorem ipsum dolor. aliquam sodales pellentesque. | String |
| Titlecase | Capitalizes the first letter of each word | lorem ipsum dolor. ALIQUAM sodales pellentesque. | Lorem Ipsum Dolor. Aliquam Sodales Pellentesque. | String |
| UCFirst | Capitalizes the first letter of the string | lorem ipsum dolor. ALIQUAM sodales pellentesque. | Lorem ipsum dolor. ALIQUAM sodales pellentesque. | String |
| Trim | Removed starting or training white spaces | lorem ipsum dolor. ALIQUAM sodales pellentesque. | lorem ipsum dolor. ALIQUAM sodales pellentesque. | String |
| Append | Attaches a string to the end of the field value | lorem ipsum dolor. ALIQUAM sodales pellentesque. | lorem ipsum dolor. ALIQUAM sodales pellentesque.(Element) | String |
| Prepend | Attaches a string to the start of the field value | lorem ipsum dolor. ALIQUAM sodales pellentesque. | (Element)lorem ipsum dolor. ALIQUAM sodales pellentesque. | String |
| Replace | Replaces a string with a specific string | lorem ipsum dolor. ALIQUAM sodales pellentesque. | lectus ipsum dolor. ALIQUAM sodales pellentesque. | String |
| Substring | Extracts the specific substring by character position and length | lorem ipsum dolor. ALIQUAM sodales pellentesque. | em ip | String |
| FormatDate | Changes the format of a datetime field. You can either select a format from the dropdown or enter your own using PHP dateformat parameters (opens in a new tab). To escape text, use a backslash \ | 2022-03-04T00:00:00+00:00 → F d, Y or Aug 8, 2023 at 5:55 PM → M j, Y \a\t g:s A | March 4, 2022 or 2023-08-08T17:00:55+00:00 | Datetime, Date |
Validation (Exporting or Importing)
| Type | Description |
|---|---|
| Required | The value is required for importing or exporting |
| Between | Only for importing |
| Min | Only for importing |
| Max | Only for importing |
| After | Only for importing |
| Before | Only for importing |
Validation for Field Management
| Type | Description | Applies To |
|---|---|---|
| Required | Always required | Boolean, Checkbox, Datepicker, Datetime, Select, Radio, Textarea |
| Required if | Required if certain conditions are met | Boolean, Checkbox, Datepicker, Datetime, Select, Radio, Textarea |
| Letter Only | Only letters are allowed | Textarea, Text |
| Numeric Only | Only numbers are allowed | Textarea, Text |
| Must be an email address | Textarea, Text | |
| Minimum Length | Minimum number of characters required | Textarea, Text |
| Maximum Length | Maximum number of characters allowed | Textarea, Text |
| Mask | Make sure the data is formatted a specific way | Textarea, Text |
| After Date | Make sure that a date is after a specific date | Datepicker, Datetime |
| Before Date | Make sure that a date is before a specific date | Datepicker, Datetime |
Was this page helpful?