When pushing data to Salesforce such as a new lead or a contact update, the State/Province and Country fields may require specific data values to be accepted by Salesforce.
If the field value is incorrect, the record will fail to sync which can result in missing new leads or out-of-date contact information in your Salesforce account.
This error message may appear in your list sync report and/or your form push errors:
|
There's a problem with this state, even though it may appear correct. Please select a state from the list of valid states.: State/Province |
|
There's a problem with this country, even though it may appear correct. Please select a country/territory from the list of valid countries.: Country |
There are multiple solutions to this error, depending on what your organization needs.
| Solution | Pros | Cons |
|
Update the field(s) in your Act-On form(s)* |
|
|
| Disable State/Country Picklists in Salesforce |
|
|
Solution 1: Update your Act-On Form(s) to match Salesforce
Step 1: Correct the Act-On Form(s)
Ask your Salesforce administrator if you are using the default picklists for State and Country/Territory, or if these lists have been customized.
Default Picklists
Act-On has content fragments available which are compatible with the default settings on Salesforce State (US only) and Country address fields.
- To access these, go to Content > Catalog > Content Fragments.
- Download the Country Dropdown (full names) and/or State Dropdown (full names).
- Replace your Country and/or State field in the form with this content fragment.
Custom Picklists
If you are using a custom State and/or Country dropdown, or you need a State picklist for a country other than US, ask your Salesforce administrator to provide a listing of Country and/or State names and values in a two-column .CSV file (where column 1 is the Label that shows on the picklist and column 2 is the Value that goes to Salesforce). You can upload this to your form and create a custom picklist with ease.
As a best practice, create this as a Content Fragment for use in future forms.
Step 2: Recover Missing Leads
- Manually update the data values in the missing form submissions to match the values accepted by Salesforce.
- Push the Act-On form submission list to Salesforce for the missing leads to appear.
Solution 2: Disable Picklist in Salesforce
Step 1: Correct the Form push
This must be performed by your Salesforce Administrator.
- In Salesforce, go to Setup > Data Management > State and Country/Territory Picklists
- Click Disable
Step 2: Recover Missing Leads
The Act-On admin or marketing user may now push the Act-On form submission list to Salesforce for the missing leads to appear.