Can one form be integrated with multiple Google docs spreadsheets?

  • Profile Image
    DTelegram
    Asked on September 01, 2017 at 12:42 PM

    Is it possible to integrate the same form to two different google sheets?  We're currently integrating our form (we use it as an insertion order for our sales reps ads) to google sheets and it's working beautifully.  I'd like to integrate the same form to google sheets but for our billing clerk to use it.  I'd like to hide some columns on her google sheet, so I can't have her use the same one our creative team is using.  Please advise as soon as you can.  

    Thank you!

  • Profile Image
    david
    Answered on September 01, 2017 at 12:51 PM

    It is not currently possible to integration the same form with two different spreadsheets.  It is, however, possible to import the data from the integrated sheet to another sheet using the import rage function:

    https://support.google.com/docs/answer/3093340?hl=en

  • Profile Image
    DTelegram
    Answered on September 08, 2017 at 12:54 PM

    Thank you.  The issue with that is that I need to send department specific information from the jotform to two separate departments.  In other words, one department needs information from the form that the other doesn't.  So, I'm not sure if I can do that with what you've suggested.  Any ideas?  

  • Profile Image
    david
    Answered on September 08, 2017 at 01:03 PM

    All form data will be populated into the integrated sheet.  You could create two more sheets and import only the data from the integrated sheet to the two other sheets.