- JohnschweighardtAsked on October 17, 2016 at 12:24 PM
I love the GeoCompleted widget but I need to use the data in a more traditional way,
As you know the data is all put into one field as followings:
Street name: Concerto Place House number: 2900 City: Apex State: NC Postal code: 27539
I am storing the data in a google sheet which will populate a SQL table using zapier.
I need each field broken out like this so I can map it to the fields in the table.
Address City State Zip
2900 Concerto Place Apex NC 27539
Any suggestions would be appreciated. Thanks
- JotForm SupportdavidAnswered on October 17, 2016 at 01:30 PM
All fields are captured into a single cell in spreadsheets. It is not currently possible to separate out parts of data from a field into separate cells when exporting. The only way to export the data in separate cells would be capture it in separate fields.