Working With Transform Functions
You can use the following transform functions to map data types between Salesforce and Max.
Function
Description
Formats an address and gets a constructed address array.
Returns a value at the specified index of an array.
Returns an external ID for Owner fields in Job records.
Joins a specified non-null value to a string and returns it.
Transforms non-null values into integers.
Transforms currency ISO code and amount values to currency amount datatype values.
Inversely transforms currencyString to currency values.
Adds or subtracts time periods from dateTime and transforms values to ISO date-time format.
Adds or subtracts time periods from dateTime and inverse-formats values in yyyy-MM-dd HH:mm:ss format.
Transforms a specified non-null object value into a JSON string and returns it.
Transforms Salesforce latitude and longitude fields to geographic coordinate pairs.
Gets the property for a specified non-null value.
Gets the external ID for a specified relationship.
Gets the value of a specified relationship field.
Returns values based on whether a specified condition is true or false.
Formats dates to either include or exclude time values.
Inverse-formats a specified date value.
Returns a mapped status value that meets a specified condition which includes two statuses.
Returns a mapped status value that meet a specified condition which includes a single status.
Returns a value calculated by multiplying or dividing the input value by the target value.
Transforms a specified value to the Service Board interval datatype.
Inverse-transforms a specified value to a numerical value.
Generates a random password that contains uppercase and lowercase letters, digits, and special characters.
Gets a random string of a specified length.
Returns a formatted time value.
Makes formatted numerical values consistent.
Unescapes values that contain entity escapes to strings that contain the actual Unicode characters.
For more information:
Was this helpful?