Forum Discussion

Jennifer Clark's avatar
Jennifer Clark
Copper Contributor
Aug 11, 2016

Forms and Excel

Please help! I am new to this community and in need of support. I have created a Form that will submit responses to an excel spreadsheet. From this excel spreadsheet, I am looking for it to automatically send data to a specific person. For example, if Sally completes the form, I'd like Sally's parent to be emailed. If Jimmy submits the form, Jimmy's parent is emailed. I know that this can be done, just stuck on how to do it.

  • Hi Jennifer , Thanks for taking the time and sharing your scenario list. Sharing of Form and Responses are currently at the top of our todo list. Would you be interested to have a skype call with us, it will be very useful for us to get detailed understanding of your form sharing scenarios and requirements.

    • Clint Jacobsen's avatar
      Clint Jacobsen
      Copper Contributor

      Has this moved along any further than this.   It's an app we could make use of.

    • Lisa Higgins's avatar
      Lisa Higgins
      Copper Contributor

      We are very interested in figuring out how to take information from a Form and having it emailed to an employee.

      • John Bimmerle's avatar
        John Bimmerle
        Brass Contributor

        It is available under 3 dot menu, settings, and the last option

  • John Bimmerle's avatar
    John Bimmerle
    Brass Contributor
    From the spreadsheet this could be done with mail merge, but of course the setup of tht would still be manual. An automated piece would be nice, just wanting to throw out the obvious since that is what i normally overlook.
    • Michael Hills's avatar
      Michael Hills
      Copper Contributor

      This is a feature that I would like to see to.  I have previously used Google Forms, Sheets and Docs to do exactly what is being asked for here.  Organising all this is an addon called 'autocrat' which is in the Sheets document.  I use this for gaining feedback on new students to my school from their previous teachers.  I am happy to continue using this Google feature, but my school is really pushing the use of Office365 so it would be great it this development could be made to Excel.  Look forward to hearing your thoughts.

  • Very exciting Nakul Madaan and Lana O'Brien! I current use Google Forms + Form Publisher for a range of workflows. Having forms do something similar with Excel/mail integration would be brilliant. I cannot wait for our skype call Nakul!
  • Hi Jennifer, integration with Excel is currently under development. Adding Nakul Madaan from the Forms team to help provide additional insight.