JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Create new row in excel output based on answer in one fieldAsked by Burkhart 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 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.
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 stillchange an answer and then submit if they wanted to?
This question seems to be a different one and shall be addressed on a separate thread shortly to avoid confusion.