Auto-fill/auto-populate form fields from Google Sheet

[ashleyt9641459]

Hello! Apologies if this question has been asked before.

I am curious if there is a way, either with Google Script or JavaScript (or both!), to auto-fill form fields in a PDF from user submissions on a Google Sheet. I only need to fill two fields, name and date submitted, so hopefully nothing too complicated.

I work for an educational organization offering continuing education credits, and we are trying to automate (as much as possible) the certificate creation process. We would just use Google Forms, but because the certificate has signatures and logos, we are trying to keep it a little more locked down.

Thank you in advance for your help!

Cheers,

Ashley

[ls_rbls · Accepted solution]

Hi,

Even though Google App Script incorporated javascript it won't work if it is applied on Acroforms and viceversa.

To import data from a Google Sheet into an Adobe Acrobat PDF form a few steps are required and it may or may not be a complicated task.

See here: https://stackoverflow.com/questions/17795433/map-or-export-google-form-responses-to-pdf-form-fields 

https://answers.acrobatusers.com/Can-I-populate-form-fields-Google-Docs-spreadsheet-q32724.aspx 

https://blogs.datalogics.com/2015/06/25/using-the-google-apps-script-to-populate-pdf-forms-with-the-... 

As you can see in the links above, it is possible, but that doesn't mean the workflow will be  entirely automated on a single click, and much less easier for a  user that doesn't know what tools can be used before data is actually imported from one form to the other.

See also here:

https://helpx.adobe.com/acrobat/using/collecting-pdf-form-data.html