What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

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

    separate columns how how can i can
  • Profile Image
    JotForm Support

    Answered by david 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.