Let the Mule do the work
The formMule Add-On for Google Sheets has become one of my favorite add-ons. “formMule sends targeted, personalized emails from a Google Sheet. Run as either a manual email merge or — more powerfully — as a triggered merge that runs automatically on form submit.”
This year UCET will be using formMule to help us with the conference credit we award after the conference. Based on your request you will receive an email specific to SUU Credit, USOE Credit or Licensure points.
Check out the video to see how formMule works.
Here are some of the suggested uses of formMule.
“Build your own self-correcting Google Forms assessments that auto-send results and/or learning resources upon form submit.
Set up a website contact form that uses branching logic to reach the correct person's inbox depending upon the nature of the request.
Manage registrations, signups, or other workflows where you need to move lots of people through a multi-stage process using email reminders and Form submissions.
Create a student referral system with branching logic, e.g. different email templates and recipients for different referral types.”
Tricia Jackson has worked for Park City School District since 2005. In July 2013 she moved from Education Technology Specialist to Online Learning Administrator. She has been a member of the Utah Coalition for Educational Technology (UCET) Board since 2008; becoming Past President in 2015. She obtained her bachelor’s degree in Information Systems and Spanish at Utah State University. Lesley University awarded her a Master of Technology in Education in the spring of 2011.
Over the last few years, Tricia worked on the Awards, Grants, Program, Conference Credit, and Registration committees for UCET. This work includes: streamlining communication methods, implementing folder structures and naming conventions, using Add-ons in Google Spreadsheets to review and process member submissions to reduce paperwork, continuing refinement of the program creation process via Sched, creating participant and vendor registration forms via BlackPlum, and updating various ucet.org webpages. She was also instrumental in bringing Jay McFarland and Vicki Davis to UCET 2015 as Keynote Speakers. Tricia enjoyed presenting on time management at SUECON 2015 (http://ucet.org/back-to-suecon-2015-thoughts/).