Save file to different google docs based on field response

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

  • Profile Image
    Welvin
    Answered 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.