BROADCASTS.com

In this episode of the TechEducator Podcast, we explore powerful Add-ons for Google Forms and Google Sheets. \xa0Also in this episode, we have a visit from Andrew Stillman, one of the amazing authors of these Google Add-ons.
The TechEducator Podcast is a weekly round table discussion about current topics in educational technology.\xa0\xa0For more information, please visit\xa0www.techeducatorpodcast.com.
Many great ways to participate in the TechEducator Podcast.
TechEducatorPodcast.com

Follow us Live on Video:\xa0http://www.TeacherCast.tv
Leave a Voice Mail:\xa0http://www.TeacherCast.net/voicemail
Email:\xa0feedback@Teachercast.net
Twitter:\xa0@TechEdShow\xa0(http://www.twitter.com/techedshow)
Hashtag: #TechEducator

Hosts:

Jeff Bradbury -\xa0TeacherCast.net\xa0-\xa0@TeacherCast
Jeff Herb -\xa0InstructionalTechTalk.com\xa0-\xa0@JeffHerb
Sam Patterson -\xa0MyPaperlessClassroom.com\xa0-\xa0@SamPatue
Jennifer Judkins -\xa0TeachingForward.net\xa0-\xa0@JennJudkins
David Saunders\xa0@DesignSaunders
Josh Gauthier\xa0@mrgfactoftheday
Jennifer Scheffer -\xa0JennScheffer.com\xa0@JLScheffer

Google Forms & Add Ons - Beyond the Survey


Using Google Forms for automated workflows


\u201cTool kit\u201d of Add-Ons for Forms & Sheets used for automation


Forms Add-Ons


formRanger\xa0- auto-populate a drop down list of response options from a spreadsheet


formLimiter\xa0- set maximum responses or close form to new submissions at specific time/date




Sheets Add-Ons


autoCrat\xa0- mail merge using spreadsheet data


syncData - pushes data from \u201cmaster\u201d sheet to other sheets


copyDown\xa0- Copy spreadsheet formulas down to any new rows that result in form submissions





Learn more about\xa0Data\xa0Validation\xa0in\xa0Google\xa0Forms\xa0-\xa0Blog\xa0Post

The TechEducator Podcast would like to thank\xa0Andrew Stillman\xa0for joining us on the program today.
Resources:


Google Forms Video Tutorials Playlist Anohttps://www.youtube.com/playlist?list=PL5ybNyowvZQcU-qr1QnAOxbMD-ZFbLq8V





Single-Approval Workflow w/ formMule Tutorial\xa0https://www.youtube.com/watch?v=zOOb7YxVNKI




Thank You For Your Podcast Reviews
Are you enjoying\xa0Educational Podcasting Today\xa0or other shows on the TeacherCast Network, please share your thoughts with the world by\xa0commenting on iTunes\xa0today. \xa0I enjoy reading and sharing your comments on the podcast each week.
Ask Me Your Podcasting or WordPress Question
Are you interested in starting your own podcast? Do you need help creating an awesome WordPress website? \xa0I am available for 1:1 consulting. \xa0Please visit my homepage and I will help you launch your personal brand today!
Contact Me

Host:\xa0Jeff Bradbury\xa0@TeacherCast
Email:\xa0info@teachercast.net
Voice Mail:\xa0http://www.TeacherCast.net/voicemail
YouTube:\xa0http://www.TeacherCast.net/YouTube
iTunes:\xa0http://www.TeacherCast.net/iTunes

Check Out More TeacherCast Programming

TeacherCast Podcast (http://www.teachercast.net/tcp)
TeacherCast App Spotlight (http://www.teachercast.net/appspotlight)
Educational Podcasting Today\xa0(http://www.educationalpodcasting.today)
The TechEducator Podcast (http://www.techeducatorpodcast.com)


View LIVE Professional Development from TeacherCast

Watch LIVE:\xa0http://www.TeacherCast.tv\xa0|\xa0Broadcasting Schedule\xa0(http://www.teachercast.net/showcal)
TeacherCast Broadcasting Community:\xa0http://www.TeacherCast.net/broadcastingcommunity

Need a Presenter?

Jeff Bradbury\xa0(@TeacherCast)\xa0is available as a\xa0Keynote Speaker, Presenter, or to\xa0Broadcast\xa0your conference LIVE!