I really like the Address field type in SmartSync. I want my users in future to be able to enter single-line addresses and have those address autocompleted/validated as they enter them. Major plus for SmartSuite.
But before I get there, I have to import old data from another database platform. And I can't seem to do it.
I've created two test target fields in my SmartSuite table: "Address1Line" and "AddressMultipart" (with the appropriate option in SmartSuite selected for each). My source file is a CSV with five different fields:
Street
City
State
Zip
AddressFull
I was thinking I could import source field #5 ("AddressFull") into the field Address1Line, and import Street, City, State and Zip into the AddressMultipart field's elements. Simply cannot make it work. Well, not entirely true: I can import source field AddressFull into SmartSuite Address1Line. The data does come into the field. But apparently it hasn't been validated. I'm unable to write a formula field that pulls (say) the City value from the Address1Line field after the data has been imported.
ASking my client to retype thousands and thousands of addresses is a non-starter. Please tell me what I'm missing here!
William