What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.

  • Profile Image

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

    Asked by Raslevol on November 12, 2015 at 06: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 ?




  • Profile Image
    JotForm Support

    Answered by Mike_G on November 12, 2015 at 12:02 PM

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

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

    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. 

    As for the result,

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

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