rgallini

Thanks guys. This is what I wound up doing: Using a CSV for states, I added a second column: one column for Label and one column for Value. The label has first row “Select” and value is blank. The rest mirror the state abbreviation for Label and Value. Then set DS Dropdown to use Value column for Values, Label for texts, and select Value to return. Then, when State is a required field, the value will be blank when the text shows “Select”.

Correction: DS Recordset ignores the blank field. Sorry for the confusion.

I had a request from someone to explain how I use this with Silverpop (SP). (Most were co-workers as someone has a crazy idea we should document stuff…)

This is assuming you know how to create a landing page in SP and have installed the CF7 & Form: 3rd-Party Integration plugins in your WP site.

In SP:
1. Create a landing page with input fields and check the mailing lists. Save it
2. On the page properties, there are links for a URL, iframe and External Form Post (EFP). Grab the data from the EFP and paste it in Notepad or your favorite text editor.
3. Parse the HTML tags by finding every <input …> tag and putting it on its own line so its easy to read. The tags you care about begin with “form” and “input”. Inputs should look something like:
<input type=”text” name=”First Name” id=”control_COLUMN1″ label=”First Name” class=”textInput defaultText” style=”margin: 0 3px 5px 3px; height: 20px; width: 294px;”>
You care about the tag parameter “name=”, that is the field name.
4. You will also notice some “hidden” fields. These are the mailing lists and control fields SP uses. Example:
<input type=”hidden” name=”Our Newsletter” id=”control_COLUMN99″ value=”Yes”>
<input type=”hidden” name=”sp_exp” value=”yes”>

In CF7
1. Create a form
2. For every input field on your SP form, create a field on the CF7 form. To make life easy on yourself, use the input parameter names from above. Don’t make fields for inputs of type=”hidden”.
3. Add the form to a page for testing.

In 3rd Party Integrations:
1. Go to the “3rd Party Services” tab under Contact
2. Click on the plus sign to create a new service
3. Give it any name you want
4. For the submission URL, find the <form…> tag use the url after action=. Remove the quotes from the URL. Include the pageID, siteId and parentPageId with the quotes intact.
5. Map the input fields from the CF7 form to SP input fields. Use the CF7 field name not display name (i.e. FirstName, not “First Name”). For the SP name, find the name= and use that without quotes. For example, these are the four entries for the example above:

Is Value?: leave unchecked
Label: “Contact first name” (3PI doesn’t use the first column.
Form Submission Field: FirstName (CF& usually truncates the fields to remove spaces).
3rd-Party Field: First Name (no quotes)

Now for the hidden fields:
These are usually the lists you want to add someone to, but also some are used by SP to validate that you are using the form properly. For each hidden field, enter these in the mapping columns:
Is Value?: check
Form Submission Field: value= parameter from SP input (without quotes)
Label: Anything
3rd-Party Field : name= parameter from SP input (without quotes)

Example from the above input parameters:
Is Value?: check
Label: Our Newsletter
Form Submission Field: Yes
3rd-Party Field: Our Newsletter
Is Value?: check
Label: sp_exp
Form Submission Field: yes
3rd-Party Field: sp_exp

Save the integration. Go to the test page and submit a test. In SP I created a view using the form submission to see who had submitted an entry. If all of the fields are mapped right, the submissions from the CF7 form should appear almost immediately after being submitted.