​

Data Transformer

​

What is a Data Transformer?

Pingtree’s data transformer refers to a mechanism or process used to manipulate or transform data between different formats, structures, or systems. Specifically, in field mapping for lead generation, a data transformer ensures that data collected from lead forms or other sources is transformed and mapped accurately to the desired fields in a database, CRM system, or other destination.

For example: In certain verticals, buyers may only accept values in a particular case-sensitive format. If your form question “Do you own the home?” returns “yes” or “no,” but the buyer only accepts “Own” or “Rent,” Pingtree’s data transformer can convert “yes” to “Own” and “no” to “Rent.”

​

Applying the Data Transformer

The data transformer is applied within a given endpoint in the Lead Routing section:

1. Click the + icon next to the field mapping.
2. A transformer UI appears below the field.
3. Your source field (e.g., home_type) appears on the left; the target field (e.g., homeType) is on the right.
4. Choose the Data Type (String, Number, Date).
5. Map each source value to its transformed target value in the table.
6. Click Submit to save the transformations.

![REPLACE HERE: Data Transformer UI]

​

Using the Data Transformer for Date Formatting

Date fields require a preset mask in your form builder (Webflow 2.0):

• DD-MM-YYYY
• MM/DD/YYYY
• YYYY-MM-DD

In the transformer tool, select Date as the data type, then choose one of:

• ISO 8601
• Short Date
• Unix Timestamp
• Custom Format: Enter your own format string.

​

Common Custom Formats

​

New Data Transformer Options

​

String Sanitizer

The String Sanitizer transformer tool allows users to modify or remove specific characters on initial ingestion of data.
Example: ![REPLACE HERE: String Sanitizer UI]

​

Prefix or Postfix

The Prefix or Postfix tool allows users to prepend or append strings to transformed values.
Example: ![REPLACE HERE: Prefix/Postfix UI]