How can we have the submitted address (country, town, road, post code) in only one excel field ?

  • Raslevol
    Asked on November 12, 2015 at 6:44 AM

    Hi ! :)

     

    Thank you for your help !!

     

    My submitted address shall go into a map, so for not getting problems, i will need to gather all the specified field (country, town, road) in ONE ONLY field. Then, my map will read the sheet without problem.

     

    Is it possible to do that ?

     

     

    THANKS.

  • Mike_G JotForm Support
    Replied on November 12, 2015 at 12:02 PM

    I understand that when you use the address field in your form 

    How can we have the submitted address (country, town, road, post code) in only one excel field ? Image 1 Screenshot 60

    and you download the excel file of the submission, you will have this: 

    How can we have the submitted address (country, town, road, post code) in only one excel field ? Image 2 Screenshot 71

    Actually there is a way for you to merge the input on the address on one field with the help of the Form calculation widget. 

    How can we have the submitted address (country, town, road, post code) in only one excel field ? Image 3 Screenshot 82

    As for the result,

    How can we have the submitted address (country, town, road, post code) in only one excel field ? Image 4 Screenshot 93

    Now, when you submitted the form and download the submission in excel file

    How can we have the submitted address (country, town, road, post code) in only one excel field ? Image 5 Screenshot 104

    I hope this helps. Let us know if you need any further assistance. Thank you.