Web Collect and Smart Capture Fail if the Target Data Extension has a Phone Data Type
Trailblazer Community

Web Collect and Smart Capture Fail if the Target Data Extension has a Phone Data Type

Marketing Cloud Email Studio , Marketing Cloud Audience/Contacts , Marketing Cloud Pages/Sites

Last updated 2020-01-31 ·Reference W-7160752 ·Reported By 2 users

Fixed in version Marketing Cloud January 2020 Release Patch 2.6

Summary
In targeting a Data Extension with a Web Collect or Smart Capture form, if the target DE has a field that is a phone data type, on form submit it will fail and nothing will be added to the DE.

Repro
1) Create a DE with the following fields:
Field Name - Data Type - Nullable or Non-Nullable

SubscriberKey - Text - Non-Nullable
EmailAddress - Email Address - Non-Nullable
Phone - Phone - Nullable
FName - Text - Nullable
LName - Text - Nullable


2) Create a page with a DEManager Web Collect code whereby we pass a value from the form to the phone field of the DE created such as:

SubKey: <input type="text" name="SubscriberKey"><br />
Email: <input type="text" name="EmailAddress"><br />
Phone: <input type="text" name="Phone"><br />
First Name: <input type="text" name="Fname"><br />
Last Name: <input type="text" name="Lname"><br />


3) Load the page in a browser, fill out the form, and submit. All phone formats error:
1-111-111-1111
11111111111
111-111-1111
111111111
(leaving it blank or NULL also fails)

Workaround
There are a few workaround options:

1) Remove the phone field from either the DE and the form or just the form if the field is Nullable until this issue is resolved. With the workaround code sample, changing the code to this worked because the field is nullable:

SubKey: <input type="text" name="SubscriberKey"><br />
Email: <input type="text" name="EmailAddress"><br />
<!--Phone: <input type="text" name="Phone"><br />-->
First Name: <input type="text" name="Fname"><br />
Last Name: <input type="text" name="Lname"><br />

2) Delete the field from the DE and add a new one with the same name as a text data type. This will require better client side validation to ensure phone numbers are entered into the form.

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.