Autocrat for Excel?

[Sapph Espinoza]

Hello,

I have been using Autocrat for creating printable forms from data in Google Sheets, from a Google Form.  I currently have about 20 teachers using this Form, Sheets, Autocrat system.  However, I am in a Microsoft district and there has been a request for me to move the process to using Microsoft forms and Excel.  Is there compatibility with Autocrat and Excel?  If not, is there a similar product which can be used with Excel?

[Joseph Schmidt]

Autocrat will only run on a Google Spreadsheet.  If you want it to run on a Form trigger, it has to be a Google Form.

I have no knowledge of the Microsoft world as I am 100 Google.  

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Tue, Jun 7, 2022 at 9:21 AM Sapph Espinoza <cob...@gmail.com> wrote:

Hello,

I have been using Autocrat for creating printable forms from data in Google Sheets, from a Google Form.  I currently have about 20 teachers using this Form, Sheets, Autocrat system.  However, I am in a Microsoft district and there has been a request for me to move the process to using Microsoft forms and Excel.  Is there compatibility with Autocrat and Excel?  If not, is there a similar product which can be used with Excel?

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/2dad7db8-2051-4cca-a9f1-87493cdbcdc9n%40googlegroups.com.

[Dimu Designs]

I have a question for the OP. What does it mean to be "in a Mircosoft District"? Is a school in a Microsoft District limited to using Microsoft only products?

[ete...@gmail.com]

You should be OK to replicate the functionality using Microsoft products using Power Automate (Flow) to do the work. Use the form to input the data, then look to Power Automate to get the new item from the Excel sheet and map the values/populate a word template that Power Automate can then email out. I'm having to look at the same exercise but for me I'll be using a Power App to write to a Sharepoint list, then getting Power Automate to get the new list item, populate the template and send the email.

[ldu...@nyccatteam.org]

I've been looking into this as well and it does seem possible to generate a Word document. The tricky part is in creating a PDF file from the data. There is a Power Automate tool for that however it is a premium feature. As a work around, I saw an article about using a flow that takes the generated Word document in OneDrive and converting it to a PDF. If you don't need PDF formatting then Power Automate should work. I personally found it to be buggy and not as user friendly as Autocrat.