Drew Rowland {dot} com

Education, Tips, Tech, & Other Things

Menu Close

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

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

Chomebook Updates On Our Network

The last two weeks we’ve started doing online testing for benchmarks. This is the first time we’ve done any online testing, chomebooks are new to us, and we’re trying to test hundreds of students at once. Best two weeks ever? Yup.

The only issue we’ve come across (surprisingly) was super duper slow internet speeds. We don’t have a ton of bandwidth, but surely we had enough to test our students. That brought me to our Merkai Dashboard. That’s where I found this.


Obviously our CB’s are eating up all of our bandwidth with Chrome Updates. Why didn’t we update Chrome when we rolled out? I have no idea, but we didn’t. First I had to figure out how to either limit traffic to Google, or spread these updates across multiple days. Guess what? Google already had this figured out for me. In the domain admin console you can spread your updates across multiple days. Thank you, Google. Here is the screenshot of our new settings.

2014-09-18_00-06-09After making these few changes our bandwidth usage dropped dramatically and now we’re updating across multiple days. If you have any questions about our current config drop me a line.


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