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.
Split Google Spreadsheet cell data from Address Map Locator widgetAsked by mackenzien on August 24, 2015 at 12:57 PM
I use the Address Map Locator plugin ( currently not working, but can be found here: https://widgets.jotform.com/widget/address_map_locator) on a form.
When it receives data, it stores it as a string with line breaks (which we store in a GoogleSheet). I was hoping to grab the Latitude and Longitude values from that string and put them each into their own field. Is that possible?
Unfortunately, you cannot separate each line within the form. But, you can separate the data in the Address Map Locator widget column on your Google Spreadsheet.
Suppose you already have your form integrated with Google Spreadsheet.
On the Google Spreadsheet shown on the image above, we need to separate the data in column E (Address Map Locator widget).
First, we need to have additional columns to the right of column E. Since we have 5 data(Address, Country, Province, Latitude and Longitude) that needs to be separated, we will add 5 columns to the right of Address Map Locator widget column.
Once you have additional 5 columns to the right, we can now perform the split.
To do that, click the cell F2, then enter =SPLIT(E2,"")
Now, on the formula that we have entered on cell F2, place your mouse cursor in-between "" and hit ALT+ENTER from your keyboard to set the delimiter as a line break.
So it should be, =SPLIT(E2,"[ALT+ENTER here]")
Once you have done that hit enter again to save the formula on cell F2.
And it should look like this after,
Now to copy the formula to each rows of columns F-J, you may refer to this guide: how-to-create-a-formula-for-every-row-in-a-column-in-google-spreadsheet
I hope this helps. Let us know if you need any further assistance. Thank you.