Address Field : Send data different cells when generating an Excel report

  • nousernamesleft
    Asked on January 23, 2016 at 8: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?

    Thanks

  • Kevin Support Team Lead
    Replied on January 24, 2016 at 10:52 AM

    Hi,

    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.

  • nousernamesleft
    Replied 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.

    Address Field : Send data different cells when generating an Excel report Image 1 Screenshot 20

    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.

  • Kevin Support Team Lead
    Replied on January 24, 2016 at 1:11 PM

    Hi,

    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.

    Address Field : Send data different cells when generating an Excel report Image 1 Screenshot 20

    Hope this helps.

    Thanks.

  • nousernamesleft
    Replied on January 24, 2016 at 1: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.