Thursday, April 6, 2017

Google App Scripts- Check Em Out

Confession time from this tech integration specialist.

I really can't code. I know enough to recognize CSS and HTML and can do some very simple things with them thanks to Code Academy. Luckily for me, I can read directions to write my own scripts and even better yet, I can cut and paste with the best of them! Control C + Control V to the rescue.

Google Apps Script Library gives me access to how to do things such as make my own March Madness bracket (save for next year) and remove duplicates from my spreadsheets. I have a massive spreadsheet that I am using in my out of school life and I needed to remove hundreds of duplicates from more than two thousand items. Going through this and deleting rows would have taken hours. But by running a script that I found in the Script Library and by opening it through the script editor in Sheets' Tools Menu, I was able to do this otherwise tedious task in seconds.


Familiarize yourself with Google Apps Scripts. A little bit of know-how will go a very long way.

No comments:

Post a Comment

Featured Post

Prezi Video

 Remember Prezi? Once upon a time it was all rage for students. I see very few students use this tool any longer. Prezi is back, though, wit...