- nousernamesleftAsked 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?
- JotForm SupportKevin_GAnswered on January 24, 2016 at 10:52 AM
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.
- nousernamesleftAnswered on January 24, 2016 at 11:56 AM
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.
- JotForm SupportKevin_GAnswered on January 24, 2016 at 01:11 PM
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.
- nousernamesleftAnswered on January 24, 2016 at 01:23 PM
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.