(Updated on 3/21/2017 - triggers have been moved!) ( I just created a new related post on how to create a multiple choice question on the form that a bit simplified - takes the "other" answers in a multiple choice question on a form, and updates the multiple choice options with those as options.) I guess it was only a matter of time before I ended up dabbling with Google Scripts. Today I was asked by a teacher how he could populate a drop-down list on his Google Form from data on a spreadsheet - and have it update as he changed the data. Not finding an add-on for this (why recreate the wheel? :-) I explored creating a script. And...discovered that this task is not too hard! To do this yourself - 1. Create your form. Really important step. Make sure to create your drop-down item and give it a title, but you do not need to add any options to it (because later you will populate it from the spreadsheet). 2. Create the spreadsheet whe...
In a prior post (from 2 years ago!), I shared how you can add an event to your calendar from email . Today I noticed a nifty little change in a calendar event that I had added this way. It now has a Source link that links back to the the originating email the date was in. I don't know how long it has been there, but it sure is a nice piece of information to have!
If you are looking at the summary view of the results for some Form data you have collected, you can copy a chart or diagram that you want to use elsewhere very easily and quickly. Simply hover over the chart or diagram, and a copy icon will appear in the upper right corner of it. Click on that - You will get a message that it has been copied to to the clipboard in the lower left corner - You can then paste it into the location you want to use it. Here's an example in a G Doc - I also pasted it into: Slides, an email, a Sites webpage, in my Blogger. A nice feature addition that saves time from taking screenshots!
Google Calendar provides a couple ways you can share your calendar. The first way you will see below provides a link that lets another person subscribe to your calendar. They will need to be logged into their Google account, and it will display YOUR calendar along with their own. (Personally, I find this method the best for adding my kids' and husband's events so I see our families events all in one calendar.) The second method displays your calendar in a browser window. This is probably the preferred Teacher method for sharing with parents. (Here is a video on How to Share Your Calendar Via a Link .) When in your Google Calendar: Click on the Options menu (stacked dots) for the calendar you want to share - Select Settings and sharing - Click on Access permissions on the left side - Click on the Get shareable link - Note that who can see the calendar with this link depends on the access permissions you have set right above. For example...
So my #MACUL16 Tipsheets generated some ideas from all of you! Here's a bonus tipsheet with your ideas - Bring a power strip to make new friends at crowded outlets. ~Carol Isakson Get to your sessions early. Once a session is full, the doors will be closed and a “Session Full” sign should be visible. If you see a session full sign on a door or a representative tells you it is full, please respect that and do not enter. Don't try to fill every session slot . Spend an hour in the exhibit hall or just sitting and reflecting on other sessions. Your brain and your feet both need a rest sometime. ~Andy Losik Wear your badge . The badge holder and lanyard will be in your conference bag. You will pick up your bag after check-in. Before you arrive at the conference stop by the store and grab some easy to eat bananas, granola bars, etc. ~The President (?? Not sure which president!) Come celebrate our 40th anniversary with us on Thursday night! The MACUL party wil...