Profile

Cover photo
Christopher Evans
Works at Community ISD
Attended Texas A&M University - Commerce
Lives in Texas
220 followers|94,607 views
AboutPostsPhotosYouTube+1'sReviews

Stream

Christopher Evans

Shared publicly  - 
1
Add a comment...

Christopher Evans

Shared publicly  - 
1
Add a comment...

Christopher Evans

Problem/Coding Help  - 
 
We have a spreadsheet for device checkout. We scan the asset tags with a barcode scanner and it puts the ID number in the "Checked Out" cell for that student. We are about to check these in and want to expedite the process. Thanks in advance for any assistance. Here is what I want my script to do and it does not want to work:

We scan the device and the ID number goes in the "Checked In" cell. The script compares the value of the Checked In vs Checked Out. If In = Out make the cell green. If In != Out make the cell red.I want this to be automatic. Here is my code so far...

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getActiveRange();
var row = range.getRowIndex();
var Out_Cell = range.getCell(row, 3).getValue();
var In_Cell = range.getCell(row, 7).getValue();


function onEdit(e){
  verifyCheckIn();
}

function verifyCheckIn() {
  if (In_Cell = Out_Cell) {
    range.setBackground("#00FF00");
  }
  
  if (In_Cell != Out_Cell) {
    range.setBackground("#FF0000");
  }
}
1
Stéphane Giron's profile photoGene Raymond's profile photoDaniel Frost's profile photoChristopher Evans's profile photo
6 comments
 
So I got my code cleaned up and working. The only problem now is it is running on every edit meaning any changes made are color-coding the checked in cells. I know "IsBlank()" is a function but I am not sure how to code it. I need the color-coding part of the script to be ignored if the checked-in cell is blank. Thanks for the help.
Add a comment...
 
Shameless self promotion...check out my new bling. Passed my test and now I am a Google Certified Admin to compliment my Google Eduction Trainer.
2
Add a comment...

Christopher Evans

General Discussion  - 
 
Shameless self promotion...check out my new bling. Passed my test and now I am a Google Certified Admin to compliment my Google Eduction Trainer.
15
Margaret Kuzmicz's profile photoAndre Loi's profile photoChuck Williams's profile photoDiane Isbell's profile photo
5 comments
 
Congratulations!
Add a comment...
Have him in circles
220 people
Scott Monahan's profile photo
Robert Allen Moody (Doc)'s profile photo
David Cook's profile photo
Nicholas Helge's profile photo
Lyndsey Cartmill's profile photo
Geoff Gregory's profile photo
Sarah Johnson's profile photo
Active Buzz's profile photo
Matthew Switzer's profile photo

Christopher Evans

Shared publicly  - 
 
I just registered for early access to Canva for Work. Join the waiting list!
1
Add a comment...

Christopher Evans

Shared publicly  - 
1
Add a comment...

Christopher Evans

Shared publicly  - 
 
Shameless plug...Sort By Color just broke 1000 users! I am very proud of this little add-on. If you are using it and like it, please take a minute to rate it in the Chrome Store. Thanks for the support.
Sort your color-coded spreadsheet by CELL COLOR or FONT COLOR.
1
Add a comment...
 
Shameless self promotion...check out my new bling. Passed my test and now I am a Google Certified Admin to compliment my Google Eduction Trainer.
6
Patrick Reid's profile photoSharon Mcmichael's profile photoAnn Witherspoon's profile photoFaustina DuVall, Ed.D.'s profile photo
5 comments
 
Congrats!!
Add a comment...
 
Shameless self promotion...check out my new bling. Passed my test and now I am a Google Certified Admin to compliment my Google Eduction Trainer.
1
Christopher Evans's profile photoKatherine Webb's profile photo
3 comments
 
Thank you! 
Add a comment...

Christopher Evans

Shared publicly  - 
 
Shameless self promotion...check out my new bling. Passed my test and now I am a Google Certified Admin to compliment my Google Eduction Trainer.
1
Beth Weeks's profile photo
 
Next on my to do list is Google Education Trainer!
Add a comment...
People
Have him in circles
220 people
Scott Monahan's profile photo
Robert Allen Moody (Doc)'s profile photo
David Cook's profile photo
Nicholas Helge's profile photo
Lyndsey Cartmill's profile photo
Geoff Gregory's profile photo
Sarah Johnson's profile photo
Active Buzz's profile photo
Matthew Switzer's profile photo
Work
Occupation
Educational Technology
Employment
  • Community ISD
    Network Services Specialist, 2013 - present
  • Mabank ISD
    Teacher, 2007 - 2013
  • Texas A&M University - Commerce
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Texas
Previously
Arkansas
Story
Tagline
Try not. Do. Or do not. There is no try.
Introduction
Husband. Father. Educator. Podcaster. Mason. GET. GCA. Johnny Storm. Lucas Lee. Steve Rogers. Casey Jones. Jake Jensen. \m/ \m/
Bragging rights
Google Education Trainer. Google Certified Administrator. Technical Director, Executive Producer, and Co-Host of Too Nerdy For TV. www.toonerdyfortv.com
Education
  • Texas A&M University - Commerce
    Educational Technology Leadership
  • Texas A&M University - Commerce
    Radio-Television
  • Henderson State University
Basic Information
Gender
Male
Apps with Google+ Sign-in
  • Power Rangers Dash
Christopher Evans's +1's are the things they like, agree with, or want to recommend.
Create first page headers on Google Docs | The Gooru
www.thegooru.com

MIGRATECOMPLETE GUIDE TO GOING GOOGLE. Getting Started · Why Google Apps · Cost of Google Apps · DIY vs. Assisted Migration · Google Apps Mi

Everything I Learned About Education, I Learned From Watching The Prince...
www.thenerdyteacher.com

It has been a long time since I have done one of these posts. Almost two years to be exact. Sometimes we let life get too busy and you forge

Understanding Chrome Extensions
edtechnut.blogspot.com

I was doing a Chrome extensions training last week and I made a fatal mistake. I took for granted that not everyone out there knows the purp

Adjust Color and Add Filters to Images in Google Slides | Google Gooru
www.thegooru.com

MIGRATECOMPLETE GUIDE TO GOING GOOGLE. Getting Started · Why Google Apps · Cost of Google Apps · DIY vs. Assisted Migration · Google Apps Mi

Merge Cells in Google Docs Tables | Google Gooru
www.thegooru.com

MIGRATECOMPLETE GUIDE TO GOING GOOGLE. Getting Started · Why Google Apps · Cost of Google Apps · DIY vs. Assisted Migration · Google Apps Mi

StackSocial
plus.google.com

Apps + gear to make you better, faster, more awesome.

Prevent Files From Being Downloaded in Google Drive | Google Gooru
www.thegooru.com

MIGRATECOMPLETE GUIDE TO GOING GOOGLE. Getting Started · Why Google Apps · Cost of Google Apps · DIY vs. Assisted Migration · Google Apps Mi

R10 Tech
plus.google.com

Instructional Technology Support and Training for the Region 10 Area in Texas.

Ferb, I know what we're gonna do today!
geekintheheartoftexas.blogspot.com

There's 104 days till Survival Race Dallas And I’m too out of shape now to own it So the imminent problem for my overweight @$$ Is finding a

Too Nerdy For TV
plus.google.com

Starring @bjdev, @chrisevans17, @ErikH1981, and @MikeAD2005

Savage Race Texas 2014
www.active.com

Savage Race is more than just a race. It is designed to be the experience of a lifetime. We feature some of the biggest and most badass obst

DON'T PANIC - towel messenger bag
nerd-by-night.blogspot.com

"A towel, it says, is about the most massively useful thing an interstellar hitchhiker can have. Partly it has great practical value - you c

BBC Radio Play Based on Pink Floyd’s The Dark Side of the Moon Streaming...
www.openculture.com

We told you all about it last Friday. The BBC planned to air a radio play written by Sir Tom Stoppard based on The Dark Side of the Moon, Pi

How to Cook a Pork Roast > Start Cooking
startcooking.com

posted in Main Dishes by Kathy Maister Difficulty: previous | blog index | next. Many people just learning to cook are often a bit hesitant

*BLEEP* just got real
geek-in-the-heart-of-tx.blogspot.com

I have decided to take this blog in a much more personal direction. When I launched it I did not intend on it being a fitness blog, but it h

*BLEEP* just got real
geekintheheartoftexas.blogspot.com

I have decided to take this blog in a much more personal direction. When I launched it I did not intend on it being a fitness blog, but it h

Friendly. Helpful. Clean unit. Even helped me decide the most cost-effective truck rental for my move. Would recommend to anyone.
Public - 9 months ago
reviewed 9 months ago
1 review
Map
Map
Map