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

    Multiple Spreadsheets - One for Each Answer

    Asked by vvance on October 23, 2013 at 05:47 PM

    Is this possible? I have 4 options on the first part of my spreadsheet.

    opt1

    opt2

    opt3

    opt4

    Depending on which option was choosen, I want to combine the reply on different sheet.

    For example:

    Opt1 reply - Sheet 1

    Opt2 - Sheet 2

    Opt3 - Sheet 3

    Opt4 - Sheet 4

    All in all my worksheet will have 4 sheets once I integrate them with Google docs.

     

    Thanks,

    Vhiel

    create style size font different
  • Profile Image

    Answered by Cesar on October 23, 2013 at 06:15 PM

    Hello, 

    Just to make sure, you want for user to submit the form, when the form is submitted you need for each option on the form to be listed on a different sheet of the spreadsheet.

    Do let us know if this is what you would like to achieve. Thank you.

  • Profile Image

    Answered by vvance on October 24, 2013 at 10:08 AM
    Yes I want for each option to have a separate sheet on the same spreadsheet.
  • Profile Image
    JotForm Support

    Answered by KadeJM on October 24, 2013 at 11:32 AM

    Okay, Thank You for clarifying and confirming that. You are basically seeking this:

     

    Unfortunately I don't know of us having a feature to meet this demand just yet. So the only way I can imagine this might work right now is by using " Reference Commands " within your Google Spreadsheet itself which will send the Data to other Page Groups on your Main Spreadsheet.

    I believe it would look something like this using a Test Group of 3 Radio Buttons to transfer to Sheet2 on the spreadsheet in the Formula.

    Example:

    =Sheet2!A2

     

    I was able to get the data to be sent to a different Page. However, I have a limited knowledge on the use of SpreadSheet Formulas so I was having a little bit of trouble getting it to receive into the other SpreadSheet. I think this should work but it is not working for me at the moment. It may take a little bit more time but I will let you know once I know more about this.

     

    Resource: https://support.google.com/drive/answer/75943?hl=en