Skip to main content
Topics#Data ManagementPregunta de Kyle Winkler
Kyle Winkler preguntó en #Data Management
3 feb 2012, 00:02

Simple" Formstack intergration "data value too large" for address field error

I'm trying to do what I thought would be difficult,  but seems to hanging up on something that I thought would be simple. I have a form, on Formstack" that I want to add/ update information in Salesforce. Unfortunately the form kicks back the error "There was an error submitting the form. Salesforce error: Shipping

 

State/Province: data value too large: 123 South 14th St FictionalPlace, PA 11111 (max length=20). Any ideas? 

 

Form-  http://www.formstack.com/forms/?1060618-e7mjuGtfBL I suspect that it's a simple issue, but I'm suprised that I couldn't find any info on it. 
3 respuestas
  1. Matthew Lamb (10K Advisors)
    3 feb 2012, 04:23
    That error is tell you you're trying to insert the string "123 South 14th St FictionalPlace, PA 11111", which is 42 characters long, into the Shipping State/Province field, which is 20 characters long at maximum.

     

    Even though you see a nice combined Address field when you view a record in Salesforce, at the database level it's actually multiple fields. Shipping Address, Shipping State, Shipping Zip Code, etc. You'll need to break this address up and put it into it's respective fields correctly, rather than try to stick it all into the State/Province field.
Escribir una respuesta...
0/9000