How can i have the submissions go to different spreadsheets based on one field

  • Profile Image
    jlarosa
    Asked 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.

  • Profile Image
    sidharth_kch
    Answered 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
    jlarosa
    Answered 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
    jonathan
    Answered 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.