Formulas - How to convert your Field Mapping data?

The TRANSLATE VALUE formula returns the best matching value in the passed map using the field value as a key.

To convert some of your Fields Mapping data using the TRANSLATE VALUE function, you should follow these steps:

For instance, if you want to convert the data that would be assigned to the Lead Source field of your Destination you should click inside that specific field

Click on three dots near the field and select Add formula > UTILS » TRANSLATE VALUE
On the Field section, choose the value you want to filter from the drop-down

Following the example above, you should select the Source value that contains the Lead Source data that you want to convert before sending it to your Destination

Then fill the Map area using the following format: “pattern1;key1;pattern2;key2;etc”

For instance, if you want to convert each Lead Source that is named MyAprilForm into 202023 and each Lead Source that is named MyMayForm into 202024, you should type the following:
MyAprilForm;202023;MyMayForm;202024;

After that, click on Confirm
Finally, click on Save&publish to save your function setup and reactivate the Bridge.

In this way, you will be able to convert specific incoming data before sending it to your Destination.

IMPORTANT NOTES:

The UTILS » TRANSLATE VALUE function is case sensitive. It means that if you receive the source value MyDecemberForm as Lead Source and it was not added to the function as described in the sample above, the value won’t be recognized by the function.
If a Source value is not specified inside the function, it will be sent without any conversion. It means you’ll receive MyDecemberForm as Lead Source inside your Destination (because that specific value hasn’t been specified inside the function).
If you want the output value to be empty, you should type the word EMPTY in capital letters; for example: pattern1;EMPTY;.

Search