​
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.
Transformer Closed Transformer opened

​
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

Transformed Value ResultDate Format in Enter Custom Value
2021YYYY
202108YYYYMM
2021-08YYYY-MM
8/5M/D
08/05MM/DD
20210805YYYYMMDD
2021-08-05YYYY-MM-DD
2021_08_05YYYY_MM_DD
2021.08.05YYYY.MM.DD
8/5/21M/D/YY
08/05/21MM/DD/YY
08/05/2021MM/DD/YYYY
05 Aug 21DD MMM YY
05 Aug 2021DD MMM YYYY
05 August 2021DD MMMM YYYY
Aug 5, 21MMM D, YY
Aug 5, 2021MMM D, YYYY
Aug 05, 2021MMM DD, YYYY
August 5, 2021MMMM D, YYYY
August 05, 2021MMMM DD, YYYY
202108051315YYYYMMDDHHmm
20210805_1315YYYYMMDD_HHmm
2021.08.05.1315YYYY.MM.DD.HHmm
2021-08-05-1315YYYY-MM-DD-HHmm
2021-08-05_1315YYYY-MM-DD_HHmm
2021.08.05.13.15YYYY.MM.DD.HH.mm
2021-08-05-13-15YYYY-MM-DD-HH-mm
2021-08-05 13:15YYYY-MM-DD HH:mm
2021-08-05 1:15 PMYYYY-MM-DD h:mm A
2021-08-05 01:15 PMYYYY-MM-DD hh:mm A
2021-08-05 @ 1:15 PMYYYY-MM-DD @ h:mm A
20210805131504YYYYMMDDHHmmss
2021.08.05.131504YYYY.MM.DD.HHmmss
2021-08-05-131504YYYY-MM-DD-HHmmss
2021-08-05_131504YYYY-MM-DD_HHmmss
2021-08-05_1315.04YYYY-MM-DD_HHmm.ss
2021.08.05.13.15.04YYYY.MM.DD.HH.mm.ss
2021-08-05-13-15-04YYYY-MM-DD-HH-mm-ss
2021-08-05 13:15:04YYYY-MM-DD HH:mm:ss
2021-08-05 13:15.04YYYY-MM-DD HH:mm.ss
2021-08-05 1:15:04 PMYYYY-MM-DD h:mm:ss A
2021-08-05 01:15:04 PMYYYY-MM-DD hh:mm:ss A
2021-08-05 @ 1:15:04 PMYYYY-MM-DD @ h:mm:ss A
We Aug 5 21dd MMM D YY
Wed Aug 5 21ddd MMM D YY
Wed Aug 5 2021ddd MMM D YYYY
Wed Aug 05 2021ddd MMM DD YYYY
Wednesday, Aug 5 2021dddd, MMM D YYYY
Wednesday, August 5, 2021dddd, MMMM D, YYYY
Wednesday, August 05, 2021dddd, MMMM DD, YYYY
1:15 PMh:mm A
01:15 PMhh:mm A
@ 1:15 PM@ h:mm A
Wed Aug 5 21 1:15 PMddd MMM D YY h:mm A
Wed Aug 5 2021 1:15 PMddd MMM D YYYY h:mm A
Wed Aug 05 2021 1:15 PMddd MMM DD YYYY h:mm A
Wednesday, Aug 5 2021 1:15 PMdddd, MMM D YYYY h:mm A
Wednesday, August 5, 2021 1:15 PMdddd, MMMM D, YYYY h:mm A
Wednesday, August 05, 2021 1:15 PMdddd, MMMM DD, YYYY h:mm A
Wed Aug 5 21 01:15 PMddd MMM D YY hh:mm A
Wed Aug 5 2021 01:15 PMddd MMM D YYYY hh:mm A
Wed Aug 05 2021 01:15 PMddd MMM DD YYYY hh:mm A
Wednesday, Aug 5 2021 01:15 PMdddd, MMM D YYYY hh:mm A
Wednesday, August 5, 2021 01:15 PMdddd, MMMM D, YYYY hh:mm A
Wednesday, August 05, 2021 01:15 PMdddd, MMMM DD, YYYY hh:mm A
Wed Aug 5 21 @ 1:15 PMddd MMM D YY @ h:mm A
Wed Aug 5 2021 @ 1:15 PMddd MMM D YYYY @ h:mm A
Wed Aug 05 2021 @ 1:15 PMddd MMM DD YYYY @ h:mm A
Wednesday, Aug 5 2021 @ 1:15 PMdddd, MMM D YYYY @ h:mm A

​
New Data Transformer Options

​
String Sanitizer

The String Sanitizer transformer tool allows users to manipulate of the stored value to keep characters, numbers, and to remove special characters. String Santizier opened

​
Prefix or Postfix

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