The EZ Query Add-on for Google Sheets is the perfect add-on for when you want to have information automatically transferred from the main sheet onto another sheet based on certain criteria. This add-on works best when you use multiple choice or dropdown style questions, as the data must match exactly in order for the transfer to work. For names, I suggest automatically capturing their username because if you have them write their name and they accidentally misspell it or don't capitalize the name then the add-on will not recognize it as an exact match. Step 1: Add the EZ Query add-on
Step 2: From the Google sheet, click on Add-on, and select Create Sheet.
Step 3: Choose 'Single sheet' or 'Unique from column' (and select the column that would have the unique data) Step 4: Enter the name for the new sheet Step 5: Choose which columns you want the data to transfer to the new sheet
Step 6: Create a filter by clicking on the + and setting the criteria for the new sheet. The information you enter must match the data in the column exactly (spelling and capitalization counts)
Step 7: Add another filter (optional) or click 'Create'
Here is my example:
Now every time some one submits an entry that matches your filter, it will automatically transfer to the new sheet you created.
I am so excited that Google added the 'Expiration Date' feature in Google Drive and even more excited that it is finally available in our district. The latest update to sharing will now allow you to remove access to a file from those whom you give commenting or viewing rights. The feature is only available for Google Apps customers, so don't go looking for this in your personal Google account. It is available for all Drive files, except for Drawing (which I personally hope comes soon). This feature will come in extremely hand when sharing files with students, parents, student teachers, and teaching fellows.
Revision history gives teachers and students a record of the additions, changes and deletions that are made on a Google document, spreadsheet, slide, or drawing. You must be an owner of editor of the file in order to access revision history. Here is a quick demonstration on how it works:
