WorryFree Computers   »   [go: up one dir, main page]

Cross-posted from the Google for Work Blog

90,000 hours. That’s the amount of time the average person spends working during their lifetime. To put that in perspective, if you spend 90,000 hours watching movies and did nothing else — no sleep, no breaks — you would be watching for 10 years non-stop.

Since you spend so much time at work, we want you to have the latest Google Apps updates when they're available to make working easier. That means your apps are constantly being updated with new and helpful features almost every week to ensure you have the latest tools, security updates and speed improvements — as soon as they’re ready. And that applies across the Docs editors as well. So as a busy 2014 comes to a close, we want to highlight a few of the new ways get things done with Docs, Sheets, Slides, Drawings and Forms.

Work with any kind of file
You come across all types of files all day. The last thing you want to worry about is what software you need in order to view or edit these files. For this reason, we made it so you can open and edit Office files directly in Google Docs, Sheets and Slides, on your desktop, phone or tablet.

Make suggestions
Editing files in real-time with others is a great way to work together across the Docs editors, and many of you asked for the ability to suggest changes in other peoples’ documents, rather than making edits directly. Now you can do just that with Suggest Edits in Docs. Make suggestions that can be accepted or rejected with a single click. And when you convert a Word file to Docs or vice versa, your tracked changes will convert as well.
Work on any of your devices. We created new mobile apps for Docs, Sheets and Slides across Android and iOS, where you can edit your documents, presentations and spreadsheets on the go. While working in the cloud means you have access to your documents on any of these devices, you can still access or create documents even if you don’t have a data or WiFi connection.

Edit your images directly Sometimes the best way to convey a thought is visually and you need your images to look just right, which is why we made it easier to edit and adjust images. You can now crop your images, even masking the crop to specific shapes, and add borders in Docs, Slides and Drawings. Plus, you can connect objects and images in Slides and Drawings, recolor and change opacity of images in Slides, and even add effects.

Get things done faster We want to help you take care of your common tasks. And you know what lots of people make in documents? Bullet lists. So now, just type an asterisk (*) and it will automatically become bullets in Docs and Slides. Nobody likes having to do the same thing twice (unless you’re Santa) so just copy and paste your charts between different spreadsheets in Sheets. For all the regression lovers out there, you can also add trendlines, and to further visualize trends, you can add miniature charts, or sparklines, into individual cells.

Get answers to your surveys Forms is a great way to gather information, and across 2014, we added lots of new ways to ask questions and get answers. You can customize themes in Forms to add your own flare and create short URLs that are easier to share. There are also lots of new question options, like limiting one response per person and shuffling the answer order.

Add tons of functionality from 3rd parties Add-ons for Docs, Sheets and Forms are tools created by developers that help you do those extra things you need help with, whether it’s printing mailing labels or adding MLA-approved citations, right from your document.

Let there be tables You can add borders and backgrounds to your tables, and merge cells together to get your tables to look just how you want. And when you convert your legacy files to Docs, the table cells and borders will still be there so you can keep working. And let everyone, including blind and low-vision users, get work done Across Docs, Sheets, Slides, Drawings and Forms, it’s much easier to use a screen reader, with better text-to-voice verbalization and improvements to keyboard navigation. You can now use braille support to read and enter text in Docs, Slides and Drawings. And you can collaborate easier with others in Docs, Sheets, Slides or Drawings because screen readers announce when people enter or leave the document, and you’ll hear when others are editing alongside you. We’ll continue to make a ton of updates behind the scenes to ensure everything keeps running faster and smoother next year. Four cheers (Docs! Sheets! Slides! Forms!) for a happy work life in 2015.

Posted by Ryan Tabone, Director of Product Management, Docs editors

The Docs editors don’t just make things easier at work—they’re handy for helping you get stuff done at home too, especially around the holidays. We’ve rounded up five ideas to help you focus on the cheer—we’ll take care of the rest.

1. Sending holiday cards? Refresh your address book first. 
Use Forms to make it easy for friends and family to send you their most recent mailing addresses. Just create a quick form and email it out or post the link on social media. Everyone’s addresses will be neatly added to a private spreadsheet.
2. Now that you’ve got your addresses up to date—print out mailing labels. 
Use the handy Avery Label Merge add-on to pull your holiday card addresses from Sheets into an Avery label template in Docs. Pop your labels into the printer, hit print and start sticking!
3. Send a digital, collaborative holiday letter with Docs. 
 If you’d rather send holiday letters instead of cards, Docs can let everyone in the family contribute, no matter where they are in the country or the world. Just create a doc, give everyone edit access and write your card together (and leave your thoughts and opinions with suggested edits & comments). When it’s ready to go, you can publish it and share a link, or go old school and print and mail it out.
4. Give your documents and presentations a holiday touch with royalty-free images. 
Choose from a bunch of free holiday-themed images in Docs and Slides to make your holiday projects a little more festive. Just click Insert > Image > Search > Stock images to browse.
5. Create visual wishlists to share. 
Have a bit of fun with your family's holiday wish lists by making Slides for Santa. Share these visual wish lists with anyone who’s looking to pick up something for your family.

Google Forms is a free and simple way to collect information--from quickly polling your friends about who'll be attending your trip to the haunted hayride, to getting thousands of responses to an awareness survey for work.

Over the last few months, Forms has been getting a bunch of updates to help you make good looking surveys, like new theme choices and the ability to create your own personalized themes.

To give you even more flexibility and options, we’re introducing add-ons for Forms—new tools, created by developer partners, that deliver even more features to your surveys (just like add-ons for Docs and Sheets).

Add-ons bring handy extras to your survey building experience, like setting a survey end date, sending custom emails based on responses, storing lists of choices that you frequently add to questions, and more.

You can access add-ons from the “Add-ons” menu in Forms, or by directly visiting the Forms add-on store.
Here are just a few of the growing list of add-ons that you can use today with Google Forms:
  • formLimiter: Close your survey automatically, after a maximum number of responses is reached, or at a date and time of your choosing. 
  • Ultradox Trigger: Create custom emails, reports, invoices, newsletters, etc., based on information that people enter into your form. 
  • Form Values: Store and pull from lists that you use regularly in Forms, like a list of staff, students, rooms, resources or anything you want. 
We hope these new tools make your Forms creation process even easier and more useful--and stay tuned for more--our developer partners will be launching even more add-ons in the coming weeks. 

PS: If you’re a developer with ideas for creating your own add-on for Forms, here’s some documentation to get you started.

Posted by Saurabh Gupta, Product Manager

Earlier this month, Google Forms got snazzed up with new customizable and pre-designed themes that let you easily create beautiful surveys—and today’s updates give you even more ways to build and share those surveys.

Find what you’re looking for 
Similar to Docs and Slides, you can use the “Search the menus” shortcut to get quick access to nearly all the features in Forms, without having to dig through the different menus at the top of the page. To find a feature, simply press Alt+/ or look under the Help menu.
New ways to manage your questions 
You’ll also be getting new tools to control how your survey questions appear to others. For example, you can now:
  • mix things up by randomizing the order of questions on quizzes or surveys with the new “shuffle questions” option. 
  • make sure you only get one answer per person by turning on the “only allow one response per user” feature in settings. 
  • limit people to one response per column for grid-style questions using the new option under “advanced settings.” 

Get the word out with shorter URLs 

And of course, what’s the point of creating a survey is you can’t share it with others? To make this easier, now when you click the “Send form” button, you’ll see a checkbox for creating a tidy URL to share. 
Learn more about all the ways you can use Google Forms at google.com/forms/about and stay tuned to our +page and Twitter account to follow along with the latest updates for all the Docs editors.

Posted by Elynn Lee, Software Engineering Intern

Cross posted on the Official Google Blog

Imagine trying to keep track of another person’s real-time edits in a document—using only your ears. Or trying to create a table from spreadsheet data—without being able to clearly see the cells. Whether you’re backing up a file in Drive or crunching some numbers in Sheets, it should be easy to bring your ideas to life using Google’s tools. But if you’re blind or have low vision, you may need to rely on assistive technologies such as screen readers and Braille displays—and that can make working in the cloud challenging. While screen readers can parse static webpages (like this blog) relatively easily, it’s much harder for them to know what to say in interactive applications like Google Docs because the actions they need to describe are much more complex.

With these reasons in mind, today we’re announcing some improvements to Drive and all our editors—Docs, Sheets, Slides, Drawings, and Forms—specifically designed with blind and low-vision users in mind.
Improved screen reader support in Drive and Docs 
In June, we introduced a new version of Drive that’s sleeker, easier to navigate and much faster. But just as importantly, the new Drive also includes better keyboard accessibility, support for zoom and high-contrast mode and improved usability with screen readers.

Across Docs, Sheets, Slides, Drawings and Forms, you’ll find that it’s now much easier to use a screen reader, with nicer text-to-voice verbalization and improvements to keyboard navigation. You’ll also notice other updates, including:

  • Support for alt text on images in Docs, so you can tell a screen reader what they should say to describe an image 
  • Better support for using a keyboard to edit charts and pivot tables in Sheets 
  • Additional screen reader improvements specifically for Docs, Sheets and Slides, including support for spelling suggestions, comments and revision history 
  • The ability to quickly search the menus and perform actions in Docs, Slides and Drawings (and soon Sheets and Forms)—even if you don’t know the action’s key sequence 
Collaborating with others is easier too: in Docs, Sheets, Slides or Drawings, screen readers announce when people enter or leave the document, and you’ll now also hear when others are editing alongside you.

Refreshable Braille display support 
If you use a Braille display, you can now use it to read and enter text in Docs, Slides and Drawings. Even if you don't use a Braille display, with Braille support, your screen reader’s settings for character echoing are automatically followed. Enabling Braille also dramatically reduces the lag between when you press a key and when it’s announced by your screen reader, and improves the announcements of punctuation and whitespace. Learn how to enable Braille support in our Help Center.

Get up and going faster
The first time you use a screen reader or a Braille display, getting up to speed can be a daunting task. But it’s simpler with new step-by-step guides for Drive, Docs, Sheets, Slides, Forms and Drawings.
You can also access the in-product “Help” menu at any time without interrupting your work, or use the updated shortcut help dialog to easily search through keyboard shortcuts if you don’t remember them.

Finally, we’re offering phone support for Google Drive accessibility questions. If you get stuck, visit support.google.com/drive to request a phone call and someone from our team will reach out to you.

What’s next
Referring to recent updates to Google Drive, Dr. Marc Maurer, President of the National Federation of the Blind, said at this year’s National Convention: “The progress...during the last few months has just been positively extraordinary.” We’re pleased the community has welcomed these improvements, and will continue to work with organizations like the NFB to make even more progress.

Everyone, regardless of ability, should be able to experience all that the web has to offer. To find out more about our commitment to a fully accessible web, visit the new Google Accessibility site at www.google.com/accessibility.

Posted by: Alan Warren, Vice President, Engineering

Starting today, things are about to get cleaner—and more colorful—in Docs, Sheets, Slides, Drawings, Forms and Apps Script. First, you’ll notice each editor’s product icon displayed in the header, which doubles as a quick link back to all your files in Drive. Next, you’ll see that the header is more streamlined and compact, helping you to focus on what matters most—your content.

We hope these updates make your creation and collaboration experience just a bit more delightful. Enjoy!

Posted by Sarah Cooper, User Experience Designer

From classroom pop quizzes to RSVPs for your family reunion, you can use Google Forms in tons of different ways -- which is why it's important to be able to customize each form to fit your needs. Starting today, you’ll be able to take advantage of four new features to create your perfect form: progress bars, data validation, embedded YouTube videos, and custom messages.

Guide respondents through your survey with a progress bar
Sometimes it’s helpful to give respondents a sense of how much of a survey still needs to be completed, and now you can by turning on a progress bar in your form.
To turn it on, just check the progress bar box in the Form Settings tab.
Get results the way you want them with data validation
Let’s say you’re using Forms to collect sign ups for an email newsletter. With data validation, you can now ensure that the email addresses are formatted correctly, and consequently avoid those unpleasant bounce-back messages.

To get started, create a new Text question in Forms, then click on the Data validation tab. Click the checkbox and select “Text,” then “Email address,” and voila, the survey taker will see an error message if they don’t enter an email address.
You can also set up data validation for maximum character count, numbers, zip codes, and more.

Embed YouTube videos
You can now embed a YouTube video right inside a form -- perfect if you want to get feedback or ask questions about a video.  

This works really well for quizzes in class, especially if paired with data validation and the progress bar. Embed a video and then use data validation to give hints when students enter incorrect answers, and add a progress bar so they know how far along they are in the quiz.
Add a custom message to closed forms
Sometimes when a form is closed, you still want to make information available for respondents who weren’t able to complete it in time.
After you’ve switched your form to “Not accepting responses,” you can now add your own message and instructions for follow up.

Posted by Elynn Lee, Software Engineer

Guest posted by Alex Nagourney

Alex Nagourney is a 2013 graduate of Wellesley College. She was a 2011 Google BOLD intern and a Google Student Ambassador from 2011-2013. She currently lives in New York City.

Summer is coming to an end, which for college students usually means the end of a grueling internship, a road-trip or cross-country flight back to campus, embracing friends you have not seen in months, and, oh yeah, that other tiny detail: the start of classes.

With so much else going on — friends, extracurriculars, sports — students today need to be as efficient and productive as possible when they dedicate time to studying and doing homework. In this age of internet transformation, Gen Y is more tech savvy than ever before, and we expect online education to meet our technology standards.

The purpose (and hope) of this blog post is to give a few examples of how I used — and benefitted from — Google Docs, Slides, and Forms in college.

Example 1: Have a group project? Stay calm, cool, and collected. Docs make collaboration easy!

If you have ever had to work on a group paper or project, you know how cumbersome and inefficient the process can be. There are two ways to go about accomplishing this task: (1) your group sends 173 emails trying to coordinate a time at which everyone is available to meet or (2) each person writes a portion of the paper and the group tries to synthesize uncoordinated chunks of different writing styles into one cohesive paper, which always ends with one Type A student editing the entire thing. Luckily, there is now an option 3, and it’s called Google Docs.

To start using Docs, just open a doc, share it with the group members, and write. It’s that simple. Having the ability to work together in the cloud means no coordinating schedules, no wasting time on multiple revisions, and no unequal division of group member contributions.

For example, when I had to complete a group paper for an Economics class, my two groupmates and I decided we would each write one-third of the paper. We put our respective portions into a single document and then went through each other’s writing, adding comments and correcting errors when necessary.
Example 2: Google Slides. Enough Said.

Presentations are an inevitable college assignment. Whether you are a history or physics major, you cannot escape this task. Before using Slides, the process of creating presentations was inefficient, awkward (so...what should we put on this slide…?) and time-consuming.

For one of my physics laboratory experiments, my partner was an exchange student from France. While we understood each other in the lab by scribbling Greek letters and numbers to solve problems, at times it was difficult to communicate since English wasn’t her first language. So when we had to create our presentation, it sounded like a grueling task for both of us.

We decided to use Slides, divide the work, add notes, and edit together from within the presentation. Our communication was clear and efficient when we typed comments to each other since we could take our time to be articulate, which virtually dissolved our language barrier. In the end, creating the presentation was quite enjoyable; we were proud of the final product and our professors were impressed by how well we worked together.

Example 3: Using Forms to organize information and make it universally accessible and useful...sound familiar?

Being a full-time student and an active member of an extracurricular activity (sport, club, fraternity/sorority, etc.) can sometimes feel like a full-time job. It requires teamwork, organization, time-management, and dedication.

Being the leader of a group demands more: writing agendas, scheduling meetings, organizing fundraisers, and sticking to a budget. Keeping track of all of these items can be difficult, as each task requires different resources — email, documents, spreadsheets, polls, and more.

As the house president of a 165-student residence hall for two years, I struggled to keep track of it all, but after switching to Forms, the whole process became seamless.

For our fundraiser, my house sold over 300 t-shirts to the student body. Because of the high quantity, we utilized a pre-order process in which students could order their size/color and pay in advance. Before we had Google Forms, we used a paper form to collect pre-orders (I still try to block out all those hours spent inputting the paper orders into my computer!).

Not only did using a form make it easier to collect pre-orders, it also made it easier to distribute the order form. As a result, our pre-orders increased by 40% in one year! The form did all of the heavy lifting for me. Orders were seamlessly filed into a spreadsheet, and I simply had to click “Show summary of responses” to place the order, making my job easier and freeing up time so that I could focus on other aspects of my role as a leader.
So there you have it, three examples of how using Docs, Slides, and Forms in college made me more efficient, saved me time, and increased my productivity. For those of you about to begin a new semester, good luck!

Posted by guest blogger Wendy Gorton

Wendy Gorton is an education consultant for organizations around the world. She’s a former classroom teacher, Google Certified Teacher and Trainer, and is passionate about creating learner-centered environments using tools like Google Apps for Education

Follow the Drive Google+ page this and next week for daily tips and suggestions for using Drive in the classroom.

Google Drive is the all-in-one tool I wish I had my first year of teaching. It not only keeps all of your lesson plans, activities, and research organized, but it's an outstanding way to engage your students, give them feedback, and give their writing a real audience—like their peers or classrooms around the world.

Here are 3 tips to help teachers prepare for going back to school with Docs, Sheets, Slides, and Forms

1. Use Slides to get to know your students 
A great first-week introductory activity is to create a single slide deck, and then invite each of your students to share a bit about themselves on their own personal slide. It’s a fantastic get-to-know-you activity for the first week of school and you’ll be amazed by the creativity that comes out of your students! 

The screenshot below shows how Google Student Ambassadors from 9 different countries used Slides to introduce themselves before gathering to meet each other at an event in Indonesia this summer.

Want to get this going with your students? Easy—create a new Slides deck on the first week of school, click the blue Share button to invite your students, and give them a little direction for their individual slide by adding comments.

2. Use Docs to create a classroom “Bill of Rights” 
The first week of class is that precious transition from the “honeymoon” period of angelic children to learning the norms of your classroom culture. Help start the year off right by inviting students to co-create their ideas of citizenship and a happy learning environment, Docs style.

Start by creating a copy of this template and then invite students to join in with you to add their ideas, ratify by adding a comment, and use their editing prowess to come up with a final copy to live by for the coming year.

3. Use Forms to get to know your students (and their prior knowledge!) 
Get to know your classroom as soon as possible, using Forms to gather information about their needs, interests, and abilities beforehand. Consider creating a simple Form for a survey for your students (and for your parents!) and have fun showing the data on your projector and learning about your class as a whole.

Forms can be used as a very quick getting started activity before any lesson as well—take this example from a social studies classroom before talking about population. By placing a quick Form on your classroom site or emailing your students the Form, you can quickly grasp your students' prior knowledge—before you start teaching.

In this case, our team was a bit off, but helped us not only talk about population but estimation and numbers in general (answer? 7.1 billion and counting. My favorite answer? One ‘goggle.’)
One last tip: Google Apps for Education
You know this is way easier when your school has its own Google Apps for education set up, right? It’s free, and no technical expertise is needed to get started.

I hope you give one of these ideas a try and let me know how it goes on my Google+ page.

With Google Drive, you can do more than just create, store, and share stuff. A variety of apps can help with everything from editing spreadsheets to signing documents electronically.

Forms let you easily create questionnaires and automatically collect responses in a spreadsheet. Today a new version launches, rebuilt to bring you a faster, cleaner, and more collaborative experience.

Now with collaboration 
Create a form faster than ever. Just as with Docs, Sheets and Slides, you can now collaborate with others in real-time. If you need to work with two colleagues on a survey, all three of you can work on the same form simultaneously and even have a group chat on the side, without leaving the form.

Better editing 
Even if you’re working solo, some new changes will make creating and editing forms easier. All your changes are auto-saved and you can quickly undo/redo edits. Improved copy-and-paste will let you copy a list of bullets from the web or multiple rows of text from a spreadsheet; then, when you paste into a form, each line will be appear as an individual answer. And you can use keyboard shortcuts to get things done more quickly.


Some things unchanged 
With the new Forms editor, you can continue using all the features you’re already familiar with:

  • Scale: Whether you’re collecting responses from ten friends for a baby shower or ten thousand attendees at a conference, you can count on Forms to reliably collect data for any number of responses. 
  • Analyzing: See the responses you’ve received right in Google Forms or collect them neatly in Google Sheets. And you can now download a .csv file for more detailed analysis and reporting. 
  • Sharing: If you share a form directly in Google+, anyone in your circles can respond without leaving their stream. Or if you send a form via email, respondents can submit their answers right from Gmail.

This update to Forms will roll out over the next few days. You can create forms directly from Google Sheets or Drive, or install the Chrome Web App for easy access from your browser. Also check the Google Drive +page all week for tips and tricks.

Posted by: Nick Santos, Software Engineer

Chances are that many of you lucky readers will be unwrapping new computers, mobile phones, and tablets this holiday season. Here are a few quick tips on how you can smoothly transition all of your stuff from old devices to new ones using Google Drive.

For laptops & desktops 
First, you’ll want to get all your files from your old computer into Google Drive. To do this, download Drive for Mac or PC on your existing computer. To upload your files to Drive, simply drag-and-drop all your files and folders (up to 5GB free) into the new Drive folder on your desktop. Then you’ll be able to access everything on the web from any computer, including your new one. Or you can download Drive again on your new computer to sync your files and automatically store them on your new computer.
For mobile phones & tablets
Upload all of the photos and videos on your old device with the Drive mobile app for Android or iOS. Install the Drive mobile app on your new device and all your stuff will be there -- and also available to you on the web from any device.

More holiday tips & tricks 
For those of you planning to do any holiday cooking, here are a few other ways Drive can help you in the next few weeks:

  • Scan or snap a photo of a classic family holiday recipe and upload it to Drive for safe keeping and sharing. 
  • Search for recipes that you’ve already stored in Drive. You can even search for keywords inside PDFs and photos
  • Jot down a new delicious recipe right from the kitchen with Docs in the Drive mobile app for Android and iOS. 
  • Use Sheets for your grocery shopping list. Create it on your computer at home, then pull it up on your phone at the grocery store and cross of items as you go. 
  • Create a quick form to invite friends to your holiday get together and figure out who’s coming, what they’re bringing, etc. 
Happy holidays!

Posted by Michael Bolognino, Product Marketing Manager

One of the best things about working on web apps like Google Docs is that it gives us the flexibility to frequently bring you new features and improvements. Starting this month, we’re going to make some small changes to how we communicate what’s been happening in the world of Docs. Instead of writing blog posts for each and every minor update, we're going to try bundling them together monthly to give you a detailed overview of our favorite features and a short list of other notable changes to make sure you don't miss out on anything new.

On that note, we’ve got a bunch of new features that launched today, as well as some great things that improved over the month of January.

Customizable styles in documents
Giving your document consistent and beautiful formatting should be easy. Before today, if you wanted to update all the Subtitles in your document to look a particular way, you had to change each of them one at a time. That’s too many steps. Now you can restyle all your regular paragraphs, headings, or titles with just a couple clicks. For example, if you want to update all the Subtitles in your document to be a particular size, set one Subtitle to that size, select it, right click and choose Update Subtitle to match selection. This will change all the Subtitles already in your document and automatically update the style for any new Subtitles you create. Plus, with the new Options menu in the styles dropdown, you can set the current document’s styles as the default for new documents or you can load your default styles into the current document.

Sparklines in spreadsheets and more charting options
In Google spreadsheets, we’ve added more charting options and support for sparklines to make it easier to communicate data. The new options give you a bunch of tools to create more sophisticated charts including different Y-axes on either side of the chart, formatting options for the axis and title text, and all sorts of other customization for how your lines, bars, or pies are displayed. We’ve also added sparklines, which let you display line or bar charts inside of cells and are handy for presenting and comparing data in a simple, bite-sized way. In the example below, we’ve used sparklines to plot currency exchange rates over a 30-day period.


Sharing forms on Google+ 
Sharing the forms you create in Google Docs with the right people shouldn’t be a hassle. Today we added a Google+ share to the form editor so that you can share your forms directly with your circles with just a couple clicks.


And there’s more… 
On top of today’s new features, here are some changes from January that you may have missed:
  • Adding images to your docs from a high quality stock photo gallery. Simply go to Insert > Image, select Stock photos, and then search for the images that you want.
  • A more streamlined format for document discussion notifications that batches multiple discussions into a single email.
  • Quickly opening and selecting items from specific menus with keyboard accelerators. For example, when using Google Chrome, Ctrl+Option+E on a Mac and Alt+E on Windows or Linux will open the Edit menu.
  • Copying and pasting via the context (right click) menu in documents when you have the Chrome App installed.
  • Easily adding Google drawings or Google Groups discussions to a Google Site from the Insert menu.
  • Progress bars while uploading files to Google Sites.
  • Searching for text inside of PDFs in your documents list using Optical Character Recognition
If you’d like to learn more about what we’ve been up to in January, I’ll be doing a Hangout On Air later this week this to talk about these changes and listen to your feedback. Stop by our Community Manager Teresa’s Google+ page on Thursday, February 9 at 12 p.m. EST to tune in.
Posted by: Jeff Harris, Product Manager

This season, brighten up your holiday celebrations with some of our fun and festive Google Docs templates.


If you’re hosting a gift exchange with your friends, family, or colleagues, try our new Secret Santa gift exchange template by following these instructions. This template will allow you to quickly send out a form to collect the necessary information from participating guests. Then, using a Google script, the form will assign Secret Santas and send automated emails to guests with all the details - no folded paper scraps necessary.

Here are a couple of other ways to make your holiday planning easier:
Browse the template gallery for more ideas, or submit and share your own templates for others to use. Wishing you the best this holiday season!

A few months ago, my colleague Julia and I were at a technology conference for educators. Teachers were very enthusiastic when we demonstrated working together on documents at the same time and were really excited about how they could use it in their classrooms. What surprised us though, was how many of our favorite features - like working together at the same time - were brand new to them.

We knew we wanted to share that same excitement with even more people. Inspired by the Search Stories videos, we set off to tell a story using Google Docs. The result is this video:



We hope you enjoy seeing some of the cool features Google Docs offers in action. And if you think your friends would like it, show it to them too!

Today, we’re excited to announce that we’ve expanded our logic branching capabilities in Google forms. Previously, a form creator had to add an extensive amount of multiple choice questions to the form to ensure that respondents were directed to the correct pages of the form. Form creators can now use a simpler page navigation feature to direct respondents to relevant pages regardless of their answers. Instead of using “dummy” multiple choice questions, form creators can now use “Go to page based on answer” multiple choice questions in conjunction with the new page navigation capabilities to make a simple, easy-to-follow form.

Let’s say you want to write a choose your own adventure story using Google forms (The Hunt for the terrible Dr. von Schneider). First, create a form and give your adventurer a difficult choice to make in a multiple choice question.


Next, check the box next to Go to page based on answer while editing the question. This enables the option for your form respondents to be directed to different pages of your form. In the drop down menu next to each answer, select the corresponding pages they should be directed to based on their answer.


Using page navigation, you can redirect form respondents previously split apart back to the same page. Under the Add Item menu, select Page break. Then, select what page you’d like your form respondents to be directed to under the drop down menu in the page break.


With page navigation selected, form respondents who landed on pages two and four of your form will both be directed to page five, where their adventure ends ... or does it? Find out here.

Try it out using another template we’ve created or share your own in the Google Docs template gallery.

Today, I’m happy to announce that we’ve added 24 new themes to Google forms, which take advantage of the new Google Font API and images from iStockphoto. As a reminder, when you're editing a form, click the Theme button to find the right theme and apply it to your form.

I first got involved with themes at Google when I designed a few templates for the Google Page Creator launch in 2006. Since then, I’ve worked on a number of theme projects in my 20% time, as they presented a far different design challenge compared to my regular projects as a webmaster at Google. You can see my “Spring/Zen Branches” in a number of products.

When I learned about the Google Font API, I wanted to give it a test drive by creating some new Google forms themes. Forms seemed like a good place to start, since they have a pretty standard structure, which makes them fairly simple to style. Initially I was just playing around with different font combinations, but when we added in imagery from iStockPhoto, things really took off. For example it made sense to create a wedding theme using cake imagery and the script font Tangerine, or a digital theme using binary number imagery and the monospaced font Inconsolata. And what better way to present a stack of old books than a font like Crimson Text, which brings to mind classical serif fonts from print? I had a lot of fun combining imagery, colors and font styles to match each other, and I hope you have fun using these themes on your forms.

Since launching Google Docs forms last year, we’ve enjoyed seeing people use them for everything from wedding guest lists and party invites to surveys and scorekeeping for Oscar parties. We’re hard at work improving this feature, and we want to know more about what you think.

We recently added a new section specifically for forms to our Product Ideas for Google Docs page. Head over and tell us what you think we should do to make forms better, and see what others have to say as well. If you come across other ideas you like, vote them up.

Don’t forget, we’re still looking for feedback about documents, spreadsheets, and presentations too. We’ve already implemented six of your ideas, including shared folders, a web clipboard for better cutting and pasting between applications, and an increase in file size limits for uploads to your Docs List.

We look forward to hearing what you have to say, and stay tuned for more updates on implemented ideas.

Last year, I planned an OSCARS® viewing party with my friends. To add some friendly competition and figure out who was coming, I collected people's predictions for the winners and their RSVP information with a Google form ahead of time. I found the process really easy, so this year I created a Google form for the 2010 OSCARS® and made it a template that anyone can use to plan their own viewing parties:


If you're getting together with friends for OSCAR NIGHT® tomorrow, check out this template in the Google Docs Template Gallery. Happy viewing!



“OSCAR®,” “OSCARS®,” “ACADEMY AWARD®,” “ACADEMY AWARDS®,” “OSCAR NIGHT®,” “A.M.P.A.S.®” and the “Oscar” design mark are trademarks of the Academy of Motion Picture Arts and Science.

The Google Docs team is celebrating the holidays, and over the next week, we'll be highlighting some of our favorite holiday templates.

If you're planning a holiday party this holiday season, this Party RSVP form template makes it easy to gather the info you need without having to email back and forth with each person you've invited. As with all forms in Google Docs, your guests' RSVPs are automatically recorded in a spreadsheet connected to your form.



If you want to use a different theme for your RSVP form, you can start from this template, and if you're planning a company party, try this template out.

Have you ever wanted to create a form that changes which questions to show next based on an answer received earlier in the form? The two features we launched today make that easy. First, we've added one of the most requested features for forms: page breaks. Now it is easy to create a form with multiple pages by going to "Add item" and selecting "Page break."

We've also added another highly requested feature, logic branching. Once you've created a form with multiple pages, you can select "Go to page based on answer" to control the flow of your form based on the user's answers. For example, you can create a form asking the person to select their language and then direct them to a form in the correct language.


If you want to see both of these new features in action, let us know what your favorite holiday is.

Page breaks and go to page open up a whole new realm of possibilities. For example, you can create a product survey that asks a different set of questions based on whether someone has used the product before or a conference feedback form that branches off based on the session someone attended. You can even create your own interactive murder mystery or adventure using a Google form, share it with your friends and publish it in the public templates gallery. We hope you enjoy these new additions to forms!