How can I store the GeoCompleted widget data into separate columns?

  • Johnschweighardt
    Asked 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

  • David JotForm Support
    Replied on October 17, 2016 at 1: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.