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.
Address Field : How to send data on different cells when generating an Excel report ?Asked by nousernamesleft on January 23, 2016 at 08:06 PM
I re labelled the address fields in my form & these appear correctly in the submissions but not when saved in excel or exported to google spreadsheet?
How can this be & how can I correct it?
Thank you for contacting us.
I checked your form and was unable to find the Address field : http://www.jotformeu.com/form/60224212745345
Could be possible to get some screenshots ?
This guide will help you to upload your images with your answers : https://www.jotform.com/answers/277033-How-to-add-screenshots-images-to-questions-in-support-forum
We need to see how the field is named on your form and how it's being sent to your spreadsheet.
We will wait for your response.
Thanks, I've since deleted the address fields as another support person said that this method isn't recommended. Below is a screen shot of how it was.
I have now used a multi field widget to create a similar layout. However, this doesn't create separate cells in excel. Instead it puts them in the same cell.
I am now working out if I can filter this in a spreadsheet. If you have any better ways of producing multiple fields (or a table) in a form that produces single cells in excel, please let me know. Thanks.
Thank you for providing us more information about your question.
If you use the Address field or a Widget to get multiple entries, always the data will be displayed in the same cell, the only way to display the data on different cells is by using the Text Box field, add it and then your data will be in different cells.
Hope this helps.
Thanks but this doesn't resolve the issue of requiring three data entries for each product (or multiple fields). If they are entered separately then they are not labeled correctly in excel.
Go you know if its possible to filter the data within a cell in a spreadsheet? Thanks.