Profile

Cover photo
Karl Hehr
Works at Ames CSD
Lived in Ames, Ia
203 followers|13,143 views
AboutPostsPhotosYouTube

Stream

Karl Hehr

Shared publicly  - 
 
AMHA is hosting a high school hockey team from China and will be scrimmaging against them from 11:30-1:45 on Saturday January 30th
This Hangout On Air is hosted by Karl Hehr. The live video broadcast will begin soon.
Q&A
Preview
Live
Ames Varsity Hockey Scrimmage vs. Chinese Team
Sat, January 30, 12:30 PM
Hangouts On Air - Broadcast for free

1

Karl Hehr

Discussion  - 
 
Is it possible in a custom script to read info from another Gsheet? For example. I have a spreadsheet of class rosters. Depending on who is using the sheet (grabbing username as variable already) I would like the roster to show up in a ListBox. Thanks!
1
1
Finn Smith's profile photoKarl Hehr's profile photoPeter Apps's profile photo
9 comments
 
+Karl Hehr You could try a loop
for(var i=0,i<studentNames.length(),i++){
stuname.additem(studentNames[i]);
}
where studentNames is a list of all your names. (check out the getColumsData code from Google's tutorials http://goo.gl/WV5P50)

Looking at your sample sheet, you may need to slice your studentNames to get rid of the ID numbers as well.
ex: if your value is 123469 Dole Allsion .slice(7) returns Dole Allsion
Add a comment...
Have him in circles
203 people
Kim Curry's profile photo
Tom Thompson's profile photo
Scott McLeod's profile photo
Cynthia M Garrety's profile photo
Kaitlyn Wright's profile photo
Kathy Perret's profile photo
Kathy Hayes's profile photo
Brent Haage's profile photo
Besnik Zylka's profile photo

Karl Hehr

Shared publicly  - 
 
 
GAM - Google Apps Manager - got a new big feature yesterday.  

GAM version 3.51 adds the ability to delete email messages from user accounts in your domain.  You can specify which email accounts to look in, and you can search for messages to be deleted by using the same syntax as you would use in the Gmail search box.

GAM also now has several features related to Google Classroom.

Get the installation files and read installation instructions - https://goo.gl/0pVAZL
4 comments on original post
1
Add a comment...

Karl Hehr

Discussion  - 
 
AuroCrat Question:

With AutoCrat, Is it possible to have one spreadsheet that will put data into different templates based in data submitted to the spreadsheet?

Example:
I have a form that collects information and the first question sends the person filling out the form to a different set of questions based on their choice. (ie: I choose "Sawyer" and it takes me to questions related to "Sawyer"). In this form there are three initial options, so I would like AutoCrat to merge data into three different template GDocs.

Here is what I know (I think):
I can use the "Merge Condition" to only merge a certain selection. 
I can't filter the information into different tabs and then run AutoCrat on the tabs individually as the script is connected to the whole sheet and not the tab.

So where do I go from here. I would like this to be automated and generate the merged template on submit.

Thoughts? Possible?

--Karl Hehr
1
1
Karl Hehr's profile photoAndrew Stillman (Work)'s profile photo
3 comments
 
Yes, this is true -- formMule doesn't do Docs...
Add a comment...
People
Have him in circles
203 people
Kim Curry's profile photo
Tom Thompson's profile photo
Scott McLeod's profile photo
Cynthia M Garrety's profile photo
Kaitlyn Wright's profile photo
Kathy Perret's profile photo
Kathy Hayes's profile photo
Brent Haage's profile photo
Besnik Zylka's profile photo
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
Ames, Ia - Mason City, IA - Oelwein, IA
Links
YouTube
Work
Occupation
Technology Director
Employment
  • Ames CSD
    Technology Director, 2011 - present
  • South Hamilton CSD
    Technology/Curriculum Director, 2006 - 2011
Basic Information
Gender
Male
Apps with Google+ Sign-in
  • Clash Royale