google form addons for conditional notifications

This is especially helpful with things like test scores or survey information.

Pivot - A pivot table lets you look at your data from a different perspective.

For example, you might use the filter option to hide quiz scores for your first and third hour classes so that you can review the scores from second hour.

Filter - Filter your sheet to isolate the information you want to see.

Sort - Sort a column in your spreadsheet to organize your data alphabetically or numerically.

Here are three things that you should know how to do in Google Sheets: Once someone submits a form, the information gets dumped into Google Sheets.and things get interesting!Ī spreadsheet is an amazing tool for collecting and organizing information. There are a LOT more add-ons, but those are some of my favorites! 4. I use FormMule when I need to run calculations on my form data before sending out an email.

FormMule is an email merge utility that you can use to send customized emails based on form responses.

Copy Down isn’t super exciting, but it’s very helpful! I use Copy Down to apply formulas to incoming form data to create automatic calculations.

Autocrat is one of my personal favorites! I use Autocrat to generate documents based on form data (certificates, invoices, meeting agendas, etc).

Use Email Notification for Forms to send out email or mobile phone notifications when a new submission is received.

Form Limiter will set limits on how long your form is available or how many responses a form will receive before it is turned off.

Great for sign-ups, volunteer opportunities, and reservations.

Choice eliminator removes MC options from your form after they have been selected.

I use a LOT of different add-ons for different situations. To become a true Form Fanatic you need to be familiar with add-ons for forms AND sheets.Īdd-ons will help you work more efficiently and create automated systems. Once you’ve mastered the essential elements of forms, you MUST dive into add-ons.Īdd-ons are like apps for Google Drive. The Emoji One Chrome extension is what I use to access emoji icons on my Chromebook (works on Mac and PC too!). I use the fire and right-pointing-hand symbols to emphasize important information or numbers in highlighted blocks if I have a set of steps I want to clearly explain. I discovered that the “ Leaderboard” template works really well with forms.Īnother trick you can try is adding emoji to your form questions and answer choices. I use Canva to create most of my form graphics.

Google form addons for conditional notifications