- Prism2016Asked on April 05, 2018 at 10:44 PM
I am using the autocompleted address widget to verify addresses and book our sales reps in for appointments. The function is great and we MUST use this as there is too much room for human error with manual entry.
My issue is that I have integrated the form with Google Sheets and when I open them in google sheets all the information from the address are lobbed into one cell. This is very problematic as when we assign appointments they are assigned based on postcode and cities so i need to be able to sort through them.
If this issue can be overcome, I will be expanding my license requirements with jotform as we need about 600 submissions per month. If there is no workaround, I will have to go elsewhere.
Please can someone help with this issue or provide me an alternative?
- JotForm SupportNik_CAnswered on April 06, 2018 at 03:26 AM
Unfortunately, widgets, like Autocompleted address widget, will take one cell in Spreadsheet or in Excel since widget is one field for Spreadsheet integration. And that cannot be changed at this time I'm afraid.
Widgets are working pretty much the same as any other field, in terms of integration, it will be passed to integration as one field. We see the issue with multi-line widgets that will take one cell so we could forward this to our backend team for a possible implementation.
We'll wait for your response.
- JotForm SupportNik_CAnswered on April 06, 2018 at 03:33 AM
Also, I'm afraid that there is no alternative since we don't have a field with Autocomplete option that will take multiple cells in Spreadsheet integration.