MuseForJews

muse: n. a source of inspiration

How to use Google Forms to create a merged product

Like lots of schools, we have a tracking sheet where we, well, track some kids in academic areas, like missing homework, test grades, etc. For some time we have used a PDF document that the teachers filled out electronically. With our move to GAFE. I wanted to create a Google Form that would then merge into a separate document for each child.

With autoCrat I’m able to do just that.

MissinghomeworkmergeI started with creating what I wanted the finished product to look like. Alternatively, you can start with the form itself. Let’s say we’re tracking a student’s missing homework assignments. The finished document might look like this:

Once you know what you want to communicate, you can create the form requesting the information.

Screen Shot 2014-09-30 at 12.14.35 PM

Now, take a look at the headers at the top of the response sheet:

Screen Shot 2014-09-30 at 12.17.23 PM

So now you want to add those column headers to the merge file in the appropriate places. The modified merge file looks like this:

Screen Shot 2014-09-30 at 12.24.22 PM

So now we’ve entered some data into the Google Sheet via the Google Form, and here’s what the Sheet looks like:

Screen Shot 2014-09-30 at 1.27.18 PM

To create the merge, you need to use autoCrat. You can find it here. Once it’s installed, go to Add ons and Launch it.

Screen Shot 2014-09-30 at 1.29.32 PM

Choosing a New Merge Job allows you to set parameters like the template to use, the naming convention, and output (PDF or Google Doc). You also need to make sure that the merge tags match your spreadsheet headers. Click on Run merge to create your files.

The only thing I don’t like is that it pulls the date including a timestamp even if I don’t want it, but I’ve remedied that by using timestamp and making sure to format it to date only. But other than that, it works great and now we have PDF files to send to the parents!

Advertisements

October 1, 2014 - Posted by | G Suite (GAFE) | , , ,

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: