Create new row in excel output based on answer in one field

  • Profile Image
    Burkhart
    Asked on July 20, 2015 at 08:27 PM

    We would like for our form to produce an extra row in excel based on a particular input. For example:

    If they answer "Issue#2", then we would like an extra row to be created in excel with the same "Address Field". Is this possible? They enter the address. Then, "Issue#1" with a yes or no answer. If there is more than 1 issue, we would like for JotForm to produce an extra row in excel but still carry the same address down.

    We are trying to eliminate the user having to fill out 3, or 4 forms for the same address. 

    Thanks,

    B

  • Profile Image
    Chriistian
    Answered on July 21, 2015 at 12:11 AM

    Hi Burkhart,

    Thanks for contacting us.

     

    Can you provide us more information regarding your concern? Are you referring to Google Spreadsheet integration or using the Spreadsheet widget? Please also provide to us the link or name of the form in question so we can further check the issue.  

     

    Do let us know if you need further assistance.

     

    Regards.

  • Profile Image
    Burkhart
    Answered on July 21, 2015 at 08:05 AM

    Well, let me ask one thing before we proceed:

    Is there a way we could put a "Duplicate form" on the bottom of the form where they could press it, and it would automatically duplicate what they have on the current form, and open a new window with the same form? Duplicate it, but they could still

    change an answer and then submit if they wanted to?
  • Profile Image
    Kiran
    Answered on July 21, 2015 at 11:31 AM

    This question seems to be a different one and shall be addressed on a separate thread shortly to avoid confusion.

    http://www.jotform.com/answers/615570

    Thanks!