Drew Rowland {dot} com

Education, Tips, Tech, & Other Things

Menu Close

HTML Scavenger Hunt – Google Form

I’ve done what I said I would never do – started teaching a class! I’m now teaching coding to 20 middle school students. Below is a basic HTML Scavenger Hunt that you might find useful if you’re teaching coding 101. If you want a copy of this form just let me know and I’ll share with you so you can edit.

Link to form

Google Drive: Copy A Folder

Have you ever been working within the Google Drive web interface and you think; “hey, I really wish I could make a copy of this whole folder and everything it contains”. Yeah, me too. Doesn’t that seem reasonable? For Google, I guess not. Today I’m going to show you a workaround to make a copy of a folder in Google Drive.

1. Login to Google Drive. Find the folder you want to make a copy of. Below you’ll see we’re going to make a copy of the folder I titled “sub-folder” original, eh?


2. Right Click on the folder you want to copy & then click “download”


3. Decide where you want to save the folder on your local machine.


4. Navigate to the downloaded folder. Right Click and Extract all the files.


5. Open up your favorite web browser, Google Chrome. Navigate to Google Drive and drag and drop your extracted folder to the Google Drive web interface. **remember to edit your conversion settings to your preferences before uploading your folder**



UUID On Gravity Forms Gets A Plugin

David Smith who apparently wrote the code we used to explain how to implement UUID on your Gravity Form here has written a plugin to make UUID even easier in Gravity Forms!

Check out GP Unique ID for Gravity Forms here: http://gravitywiz.com/documentation/gp-unique-id/

How To Install The Google Drive Plugin For Microsoft Office

Google launched a super rad plugin today for Microsoft Office. It could not have come at a better time as we roll-out Microsoft Office locally to all of our staff! The plugin allows you to save and open files directly from your Google Drive in Microsoft Office. Below is a guide on how to install the plugin.

1. Navigate here: https://tools.google.com/dlpage/driveforoffice and click on the big (appropriately) blue Download button.


2. Read and Click the Blue Button to accept the terms.


3. Choose where you want to save the file. I choose Downloads for mine.


4. Navigate to where you saved the file & double-click the install file to begin the install process. It will not ask you any questions during this part of the install.

5. Once it’s finished, open up Microsoft Word or another Microsoft application. Click on the “Get Started” button on the Google Drive splash page.


6. You should now be prompted to sign-in to your Google account and verify permissions.


You can now save directly to Google Drive or open up files directly within the Office application from Google Drive by going to “File > Open > Google Drive”


BOOM! That’s it folks!


Google Administrators Documentation.

How To: Document Merge by Panda Doc

Below is a quick how to on DocumentMerge by Panda Doc. Enjoy!


DocumentMerge by Panda Doc

Force E-mail Logout from Google Apps Admin

It’s bound to happen, someone leaves or is terminated from your school, workplace, or organization. You’re responsible for changing passwords, but someone wants that account to not be suspended & for someone to still be able to log in, but just with a new password. If we suspend the account no one will be able to access, viola you’re all done. But how do I just change the password, but remotely log a user out via the Google Apps Admin? You’re in luck! Here is how you do it.

1. log in to GAS by going to https://admin.google.com

2. Search for the user you want to log out.

3. Click on their name to enter the account admin area.

4.  Click Account


5. Under the “Password” section click “Reset Sign-In Cookies”


6. Confirm that you want to “Reset sign-in cookies” & You’re done!


If you have any questions at all feel free to shoot me an e-mail.

Create Universally Unique Identifier (UUID) With Gravity Forms

**Please note an updated post has been posted here**

First & foremost this is my first rodeo with Gravity Forms. Yes, I know, I’m very late to the game. In the past I’ve either built custom forms or more recently, started using Ninja Forms. Ninja Forms is a pretty slick form builder & I love a lot of the out-of-the-box features. However, when it came to Payment Processing it fell short. We decided to go with Gravity Forms.

My client wanted to create a UUID every time the form was filled out and then send that ID to the user as a reference number of sorts.  I’ll describe the steps below.

1. Copy & Paste the below code into your functions.php file. You’ll need to edit lines 6, 21, & 22. Line 6 will create a alpha prefix that goes in front of your unique 8 digit number, you can put whatever prefix you want here. Line 21 should be replaced with the form ID of the form you want to create a UUID on. Line 22 should be replaced with the hidden field ID you create on your form.

/* -------------------------------------------------------------------------------------
  UUID for forms
  ----------------------------------------------------------------------------------- */
add_filter("gform_field_value_uuid", "get_unique");

function get_unique(){

    $prefix = "vbs15"; // update the prefix here

    do {
        $unique = mt_rand();
        $unique = substr($unique, 0, 8);
        $unique = $prefix . $unique;
    } while (!check_unique($unique));

    return $unique;

function check_unique($unique) {
    global $wpdb;

    $table = $wpdb->prefix . 'rg_lead_detail';
    $form_id = 2; // update to the form ID your unique id field belongs to
    $field_id = 122; // update to the field ID your unique id is being prepopulated in
    $result = $wpdb->get_var("SELECT value FROM $table WHERE form_id = '$form_id' AND field_number = '$field_id' AND value = '$unique'");

        return true;

    return false;

2. Go into your form & create a hidden field.

3. Name the field whatever you want. I use “Group ID”

4. Click “Advanced” and check: “Allow field to be populated dynamically”

5. Enter: uuid in the parameter name

6. Save & Update the form. Confirm it’s working.

That’s it. Now you have your forms creating a UUID on submission. My UUID’s look like this: rhino74852136

If you have any questions shoot me a message.


This post relies heavily on some code presented on the Gravity Forms Forum

How to bulk move users in Google Apps

Cleaning up your Google Apps Domain {GAD}, if it was not kept up, is not always fun is never fun. This week my goal was to organize our GAD to make implementing the new Google Vault service easier. The first thing you must do is consider how you want to organize your users. My tip is to only create Organizational Units {OU’s} for settings you might need to implement. My motto is the fewer OU’s, the better. Here are ours.

  • Admins
  • Students
    • Campus 1
    • Campus 2
    • Campus 3
  • Faculty & Staff
  • Former Employees

The one change I think i’d make to our OU’s as I think about it little more, would be to break the Campuses down by graduation year so bulk removal is easier. **project for tomorrow**

To do bulk editing I use a tool called Google Apps Manager {GAM}. GAM is command line based, but don’t be scared, it’s easy. However, this post is not going to go through the setup, or even how to get GAM working, but you can find all of that info here. Or, you can drop me a line and i’ll help you in any way I can.

Step 1 – Once you have GAM installed, running, and you’re in the Command Prompt the first thing I like to do is check to make sure we’re still connected to our domain by doing a: gam info domain

Step 2 – You need to create a txt file with each username you want to move on their own line. I find the easiest thing to do is pull this info from PowerSchool, or from GAD into a csv & paste into notepad. You’ll need to save that file as something easy to remember like staff.txt and save in the GAM folder.

Step 3 – Make sure you can access your org via GAM by typing: gam info org <org name> so if my OU is called staff I’d type: gam info org staff  if my org is accessible I’ll see “Organizational Unit: <name of org>” on the next line. Now we’re ready to rock and roll.

Step 4 – This is where the magic happens, not really, but kind of. You just need to type this happy little command: gam update org <org name> add file <filename.txt>  so, if we’re updating our staff OU with the staff.txt file we created in step two the command will look like this: gam update org staff add file staff.txt boom, done. The command will process through the file and you’ll be loved by all.

You can do tons of things with GAM, but I find this to be one of the most useful things I’ve used it for. I hope this makes your life a little easier. If you have any questions at all feel free to shoot me an e-mail.


Google Apps Manager: http://goo.gl/ZSctH

Google Vault: http://goo.gl/GLyw7k

Using Techsmith Snagit For Screenshots

I love screenshots as visual backup resources for my teachers and admin staff, they just work. For a long time I’ve been using the regular ol’ print screen & edit in Photoshop method to create feature rich screenshots and it works great. However, when I was at ISTE this year I learned about TechSmith’s Sangit. It’s a dual Chrome application & Extension that allows you to create screenshots & video screencasts all within the browser. Mind blown. It’s beautiful, simple, and way faster than my old print screen & Photoshop method. Alas, maybe not as feature rich, but it does everything I need it to do, plus it works on our ChromeBooks as well. Here’s short video on how it works.

Enjoy! If you have any questions drop me a line.

Snagit Chrome Application: http://goo.gl/77Zqk1
Snagit Chrome Extension:  http://goo.gl/3iJpQr

© 2015 Drew Rowland {dot} com. All rights reserved.