export to Excel split cell

  • flouwrens1
    Asked on October 2, 2019 at 2:40 AM

    Good day

    I am testing out your system and at the moment I love it, however I have a few problems that I hove hoping you can assist with

    1. I have added a dynamic text box widget, when I export to excel all the information is in one cell, I need the information to be in its own cell one beneath the Other



  • ilkyaz Jotform Support
    Replied on October 2, 2019 at 5:07 AM

    Hi, 

    It's not possible to separate the values that are entered inside of the dynamic widgets.

    You can separate the data into different rows in Excel manually by using the "Text to Column" feature. Similarly in Google Sheets, you can do the same thing by selecting the "Split text to columns" option. 

    Let us know if you need any further assistance. 

  • flouwrens1
    Replied on October 2, 2019 at 7:46 AM

    Hi, OK I see,

    can the following be done?

    say now I am completing a booking however I want to submit a few bookings at the same time is there a way to duplicate my booking as most of the information will be the same?

    also when creating a form at the Thank you page, I would like to add a button " add new submission"
       

    can this be done

  • Girish JotForm Support
    Replied on October 2, 2019 at 9:20 AM

    Hello,

    I've moved your queries to new threads so that they can be handled separately. Please check the thread links below, which will be answered shortly:

    https://www.jotform.com/answers/1986015

    https://www.jotform.com/answers/1986016