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 i have the submissions go to different spreadsheets based on one field

    Asked by jlarosa on June 04, 2013 at 03:36 PM

    Say i have a drop down that selects the applications being "tested"  Can i have a spreadsheet for one application, another for another and so forth, that way we do not have all of the submissions for different applications on only one spreadsheet.

     

    Let me know if you need more information.

    Page URL:
    http://form.jotform.us/form/31545031906145

    Submissions different
  • Profile Image

    Answered by sidharth_kch on June 04, 2013 at 04:28 PM

    @jlarosa

    Unfortunately, we do not have such feature. When a form is integrated with google spreadsheet, it creates one spreadsheet and all submissions will only be  saved in this spreadsheet. 

    Thanks,

    Sidharth

  • Profile Image

    Answered by jlarosa on June 04, 2013 at 04:31 PM

    Is there any way that we can have one main form branch out to other forms that each would have a separate integrated spreadsheet?

     

    Say if i choose "VT" it sends me to the form that will save to the VT spreadsheet, if i choose "webpay" it will send me to a webpay spreadsheet.  Is there something similar to this that I can do? 

     

    Thanks for your quick response.

  • Profile Image
    JotForm Support

    Answered by jonathan on June 04, 2013 at 07:36 PM

    Hi,

    It may be possible, albeit a bit coarse... like this.

    ---

    You will need multiple forms and this guides

    1. Smart-Forms-Using-Conditional-Logic

    Change Thank You URL after submission
    Redirect to a different thank you page according to the form submission. Let’s say you have many PDF whitepapers. You can keep them in a dropdown list and depending on which whitepaper user selects redirect him/her to that particular whitepaper after the form is submitted.

    2. Prepopulating-the-fields-to-your-JotForm-via-URL-parameters

    3. Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

     

    Integrate each answered forms separately to google spreadsheet (it should work for each)

    Here is a demo form you can test submit http://www.jotformpro.com/form/31547174020950? 

    Hope this help. Inform us if you need further assistance.

    Thanks.