Whether you are creating your forms in Microsoft CRM using the Form Capture records or the Form Builder, you will start by creating Form Fields. If you have an existing web form, look at the forms on your web site and list all the fields that are used on these forms. If you are creating a new form using the Form Builder, make a list of the fields you want to include in your form. In CRM you will create a single Form Field record for each field.
IMPORTANT: Your CNAMEs and Domain records also need to be set up before creating your forms.
For example, if you use ‘First Name’ on multiple forms, you will need to create this as a Form Field only once in Microsoft CRM. Keep in mind that you'll always want to have an email field on the form so that if someone is already in your CRM and they fill out the form, the information will be mapped to that person's record. Whether the form is mapped to an existing person or not depends on the email field and if the email that they provide matches an email on an existing record.
NOTE: In order to map custom fields that you've added to your Contact and Lead entities, you must first publish your metadata on the ClickDimensions Settings page.
Goals
- Learn how to create a Form Field record
- Learn about the different kinds of Form Fields offered
- Learn about how to map Form Field data to fields on Lead and Contacts
Table of Contents
Create a Form Field
Navigate to ClickDimensions > Form Fields.
In the Form Fields grid choose New to create a new Form Field record.
The new Form Field record will appear.
On the Form Field record enter the following fields:
Name: This is a reference name for the form field in CRM. It is also what will show up as the default label when you build your actual form later.
Form Field Id: If you are planning on using the Form Builder, enter any value here, such as txtFirstName. If you plan on integrating your forms with a Form Capture record, enter the input id values used in your existing web form. To learn how to do this read the 2nd Step and the Important section of this article.
Type: Choose a value from the drop down list.
Form Field Types & Mapping
The types of Form Fields available to select are (alphabetically):
| Checkbox | Hidden | Text |
| Date | Integer | Text Area |
| Date/Time | List | URL |
| Decimal | Money | |
| Radio |
NOTE: In order to maintain compatibility with older versions of CRM, we do not map to the CRM multi-selection list box field type at this time.
Mappings: The mappings section is different for each type you choose:
- Fields that do not have predetermined options display lists of all of the fields of a comparable data type on the Lead and Contact records in your CRM and allow you to select which field the response should be mapped to. For example, the Mapping options for a Text field would only display Text fields on the Lead and Contact, not picklist fields or numeric fields. Date, Date/Time, Decimal, Email, Hidden, Integer, Money, Text, Text Area, and URL fields have this type of mapping.
- Fields with predefined options will require you to specify which options they should have then choose if the field will map to a Text Field or a Picklist Field in CRM. If a Picklist field is selected, every option in the Form Field will have to be set to map to the corresponding option on the Picklist. This mapping is discussed in further detail below. Checkbox, Hidden, List, and Radio-type fields have this type of mapping.
Type: Email
IMPORTANT: If you are creating an email field, make sure to choose the type Email not text. If you choose text for the type for a field used to capture a prospect's email address, ClickDimensions will not be able to know the field contains an email address and will not connect the Posted Form record with a Lead or Contact record.
Type: Text
Mapping to Lookup Fields
A lookup field is a field in CRM that allows you to connect one CRM record to another, such as a parent Account record to a Contact record. It is possible to map to CRM lookup fields using a text-type form field, but in order to map successfully, the value inputted into the text field during submission must match the corresponding value in CRM exactly. This is not case-sensitive, but symbols will not be considered. This feature is only available for users of CRM 2011 and newer. Click here to read more about Mapping to Lookup Fields.
Type: Text Area
Type: Integer
Type: URL
Type: Decimal
Type: Date
Type: DateTime
NOTE: The time chosen should be UTC time because it will translate to the CRM User's timezone when the data comes back into CRM.
Type: Money
Type: Radio
Type: List (Drop Down)
The question Would you like to map the posted values to picklist field or text field? refers to the field in the Contact or Lead record you want to map to. What type of field is it in the record: a Picklist or a Text Field? Lead Text Map and Contact Text Map will display lists of every field on the Lead and Contact entities to which this form field can be mapped. Choosing Picklist Field will cause the Lead Text Map and Contact Text Map fields to display a list of all Picklist fields on your Lead and Contact records. Choosing Text Field will instead display all Text fields and Lookup fields on your Lead and Contact records. The Publish Custom Fields button will sync ClickDimensions and CRM, which informs ClickDimensions of any custom fields that you have created in CRM. Doing this will cause the custom fields to appear as options in the Lead and Contact Map lists.
NOTE: If you choose Picklist Field you will have two more fields to fill out, Lead Picklist Value and Contact Picklist Value. These are shown in the next type, Checkbox, below.
Add each of the choices from your list to the box by clicking the green plus button. The Label field is how the item will be listed in the menu (this is what the prospect sees when he or she is fills out the form). The Value field is what will be placed in the lead or contact's record if they choose that item. The Lead Picklist Value and Contact Picklist Value dropdown menu items will appear in CRM so that it doesn't show the number Value; this will reduce confusion when receiving the Email Notification and Posted Form Excel Report.
When you are finished creating all of your choices, press the Save button in the Items box.
Type: Checkbox
This works the same as the List except you can only and must have two choices in box. In this example, Picklist Field is chosen, causing Lead Picklist Value and Contact Picklist Value to display. These drop downs show what you can map your items to in the lead and contact records. In this example, the details for the True option are shown. When someone checks the box, you want the picklist field to be Yes in their record, and if they don't check it, it will be No in their record. Any updates to the mappings for this field type will apply to all instances of the form field.
NOTE: If you include a Checkbox field on a form, be sure to check Override in CRM in the field's properties in the Form designer to ensure that the value maps properly.
NOTE: If your organization is on ClickDimensions version 9.2.0+ and is utilizing the ClickDimensions Opt-In Subscription Management style, you will see a Subscription List field in the Mapping tab for Checkbox and Radio Button Fields. Associating the Form Field with a Subscription List will allow you to record opt-in or opt-out Posted Preferences for the Subscription List. This can be set in addition to mapping the fields to a field on the contact/lead records.
Type: Hidden
To learn how to map a Hidden Field to a Lead's Topic field, click here. To learn how to map a Hidden Field to the Lead Source field, click here.
When you're done, chose Save and Close. Next, if you're creating a new Form click here to find out how, and if you're integrating an existing form click here.
Navigate to Settings > ClickDimensions > Form Fields.
In the Form Fields grid choose New to create a new Form Field record. 
The new Form Field record will appear.
On the Form Field record enter the following fields:
Name: This is a reference name for the form field in CRM. It is also what will show up as the default label when you build your actual form later.
Form Field Id: If you are planning on using the Form Builder, enter any value here, such as "txtFirstName".If you plan on integrating your forms with Form Capture record, enter the input id values used in your existing web form. To learn how to do this read the 2nd Step and the Important section of this article.
Type: Choose a value from the drop down list.
Tip: If you are creating an email field, make sure to choose the type Email not text. If you choose text for the type for an email field, ClickDimensions will not be able to know the field contains an email address and will not connect the Posted Form record with a Lead or Contact record.
Mappings: The mappings section is different for each Type you choose.
Type: Email
Type: Text
Type: Text Area
Type: Integer
Type: URL
Type: Decimal
Type: Date
Type: DateTime
NOTE: The time chosen should be UTC time because it will translate to the CRM User's timezone when the data comes back into CRM.
Type: Money
Type: List (Drop Down)
The question "Would you like to map the posted values to picklist field or text field?" refers to the field in the contact or lead record you want to map to. What type of field is it in the record? Once you've checked one or the other, the Lead Text Map and Contact Text Map values will change accordingly. In those drop downs are the choices like those in above types. The Publish Custom Fields button will sync ClickDimensions and CRM, which informs ClickDimensions of any custom fields that you have created in CRM. Doing this will cause the custom fields to appear as options in the Lead and Contact Map lists.
Note: If you choose Picklist Field you will have two more fields to fill out, Lead Picklist Value and Contact Picklist Value. These are shown in the next type, Checkbox, below.
Add each of the choices from your list to the box by clicking the green plus button. The Label field is how the item will be listed in the menu (this is what the prospect sees when he or she is fills out the form). The Value field is what will be placed in the lead or contact's record if they choose that item. The Lead Picklist Value and Contact Picklist Value dropdown menu items will appear in CRM so that it doesn't show the number Value; this will reduce confusion when receiving the Email Notification and Posted Form Excel Report.
When you are finished creating all of your choices, press the Save button in the Items box.
Type: Checkbox
This works the same as the List except you can only and must have two choices in box. Here, Picklist Field is chosen. Now Lead Picklist Value and Contact Picklist Value are available. These drop downs show what you can map your items to in the lead and contact records. In this example, the details for the True option are shown. When someone checks the box, you want the picklist field to be Yes in their record, and if they don't check it, it will be No in their record.
NOTE: If you include a Checkbox field on a form, be sure to check Override in CRM in the field's properties in the Form designer to ensure that the value maps properly.
NOTE: If your organization is on ClickDimensions version 8.2.2+ and is utilizing the ClickDimensions Opt-In Subscription Management style, you will see a Subscription List field in the Mapping tab for Checkbox and Radio Button Fields. Associating the Form Field with a Subscription List will allow you to record opt-in or opt-out Posted Preferences for the Subscription List. This can be set in addition to mapping the fields to a field on the contact/lead records.
Type: Hidden
For more information on using a Hidden Form Field, click here. When you're done, chose Save and Close.
Next, if you're creating a new Form click here to find out how, and if you're integrating an existing form click here.
| Feature Added: Original |
| Feature Updated: 8.14.0 |
| ClickDimensions Version Needed: 8.14.0 |