New problems entering address?
This is in the NEW FORMS: When entering an address using the Full Address search it keeps putting the number AFTER the street: After choosing the top address in the list, it puts this into...
Forum Discussion
The problem is occurring when I have it set to US format and an automation tries to create a new record using the state name instead of the abbreviation:
"You must provide a valid choice for the field named "Full Address: State/Region" with field id 22." - It will not accept 'OR' and is expecting 'Oregon'
Edit: I realize I can add another step to format the state name, but it's ridiculous that I should have to do that at all. I would be using the international format since we use addresses in Canada and Mexico, but because of the problem in the first post of this thread, I cannot.
------------------------------
Jeff Peterson
------------------------------
One solution would go like this:
1) In your app, create a new table with two fields, the two letter code is one, the state name is the other. Both are required & unique. Call this table "State Lookup" or something similar.
2) In your pipeline, insert a new Query step which finds the record in the new table that has the two letter code, and returns that plus the state name.
3) In the existing step of your pipeline that creates a new address, use the state name that the new step found.
Alex