Forum Discussion

Copper Contributor

Aug 30, 2017

Is this possible /Google to Office

Our current set up is as follows : 1. Customers fill out Google Forms ... which creates automatically a 2. Google Sheets spreadsheet... which using a add on (Ultradox, Autocrat) automatically ge...

Copper Contributor

Aug 30, 2017

Thank you again! Just briefly going over it, its very simular to Google Form.

My big question is, as I see you can have the responses go to spreadsheet just like with Google, but is there something to trigger documents to automatically be generated from templates as the responses come in?

Aljohn Bonifacio

Iron Contributor

Aug 30, 2017

For the auto-generated responses, you can see it under Responses tab in Forms and it will help you to visual feedback in real-time. For the automatic creation of documents from templates, I haven't tried it and read similar feature like that with Forms but the closest thing is the integration on Excel spreadsheet.

Lalla Lilley
Copper Contributor
Aug 30, 2017
Yes, I understand the responses can be seen in Forms, but I am referring to when the response automatically goes into the Excel spreadsheet.
Currently, when the responses comes in, it goes to spreadsheet (Google Sheets) and as soon as it hits that spreadsheet its a trigger to generate the documents. In Google Sheets this is where add-on comes in that lets you set the trigger and it auto generates. Problem is, its not always reliable anymore and too many gitches with no customer service.
Is this possible here in MS ???
- jcgonzalezmartin
  MVP
  Aug 30, 2017
  I think Forms don't have this feature but I also think this is something that can be done with some programming