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

    Save file to different google docs based on field response

    Asked by ADFPortland on May 05, 2017 at 06:48 PM

    I see that you can send an email to different people based on a field response.  

    How-to-Send-Email-Based-on-User-s-Answer

    Is it possible to have a form saved to different google docs based on a field value that someone selects?

    Thanks,
    Ken

    Page URL:
    https://form.jotform.us/71240987579167

  • Profile Image
    JotForm Support

    Answered by Welvin on May 05, 2017 at 11:09 PM

    I'm sorry, but this is not possible in our Google Spreadsheet integration. A workaround would be to create a filter in the integrated sheet, a filter that would copy the row into another spreadsheet row based on a column data. 

    You can do this with ImporRange function: https://support.google.com/docs/answer/3093340?hl=en

    Let us know if you need further assistance.