JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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
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.