Digital Inspiration: How to Add Options in Google Forms Questions from Google Sheets. “As with everything else in the world of Google Forms and Google Sheets, we can easily automate the process of adding question choices in Google Forms in bulk with the help of, you guessed it right, Google Apps Script.”
MakeUseOf: How to Use Google Forms to Get Updates From Your Remote Team. “Google Forms is a terrific and intuitive tool for gathering information from clients, customers, and employees. You can easily create and customize a form, share it in a few different ways, and then analyze the answers. If you’re in a work situation where you have a remote team, Google Forms can be an effective method for obtaining updates. You can use it for a specific project or simple work updates that you request daily or weekly.”
Digital Inspiration: How to Send Google Forms with Pre-filled Answers. “This step-by-step video tutorial explains how you can create pre-filled Google Forms with dynamic information from a Google Sheet. You can then use Mail Merge or Document Studio to automatically send the prefilled forms to your contacts in bulk with Gmail.”
Digital Inspiration: How to Use Formulas with Google Form Responses in Sheets. “When people submit your Google Form, a new row is inserted in the Google Sheet that is storing the form responses. This spreadsheet row contains a Timestamp column, the actual date when the form was submitted, and the other columns in the sheet contain all the user’s answers, one per column. You can extend the Google Forms sheet to also include formula fields and the cell values are automatically calculated whenever a new row is added to the sheet by the Google Form.”
Teacher Tech: 5 Ways Google Forms IMPROVES Learning. “Google Forms is the best thing since sliced bread. I cringe every time I still have to fill out a paper form. I’m thinking… someone has to try to read my handwriting and take the time to enter my data. Google Forms saves us from more than just doing data entry however! When we use technology we MUST ask the question ‘How does this make learning BETTER?'”
Make Tech Easier: How to Reuse and Combine Google Forms with FormRecycler. “FormRecycler is an amazing GSuite app that helps you populate form fields intuitively by reusing the questions from previous forms as much as you want. We’ll show in this article how it can be used to combine multiple Google Forms.”
How-To Geek: How to Create a Google Form with Branching Logic. “When you create a survey with Google Forms, you can use conditional questioning to send respondents to specific pages based on their answers. Here’s how you can use branching logic to send people to questions that pertain to their responses.”
How-To Geek: The Beginner’s Guide to Google Forms. “Are you just getting started with Google Forms? Never heard of it before? Either way, here are some tips to help you get going with Google’s powerful form tool and start building surveys and forms online for free.” Thorough overview with lots of screenshots.
More great stuff from Amit at Digital Inspiration: How to Track your Study Time with Google Forms and Sheets. “My kids are in middle/high school and I’ve been looking for a timesheet-style solution that would help me understand their studying patterns and learn how much time they spend on various subjects. There are quite a few apps available for time tracking but I was looking for something simple and Google Forms fit the bill perfectly.”
Digital Inspiration: How to Automatically Create PDFs with Google Form Responses. “When a user submits your Google Form, a row is added to the destination Google Sheet with all the answers. The tutorial explains how you can save your Google Form responses in a customized PDF file in Google Drive and have it emailed automatically to one or more recipients via Gmail.”
Digital Inspiration: How to Send Emails with Google Forms Based on User’s Answers. “With the Forms Email Notifications add-on, you can automatically send emails to anyone each time a user submits your Google Form. You can choose to notify the form owner, the form respondent, your team members or anyone else and the emails are triggered immediately after a form is submitted.”
Amit Agarwal keeps cranking out excellent tools. the latest from Digital Inspiration: How to Create Personalized Documents from a Google Spreadsheet in Minutes. “Introducing Document Studio, a powerful Google add-on that lets you effortlessly generate documents and reports using merge data stored inside Google Sheets. It can also create documents with live data from Google Forms submissions. The generated documents can be automatically sent inside personalized email messages using built-in Mail Merge.” This isn’t free, but the personal version is $29 a year.
Amit Agarwal: How to Receive Push Notifications for Google Forms on your Mobile Phone. “The notifications add-on for Google Forms add-on has been updated and it can now send push notifications to your mobile phones as well. That means when respondents complete and submit your online Google Form, you’ll get an instant real-time notification (sample) on your iPhone or Android phone. The notification text can also include answers from the Google Form.”
Google is offering some updates for Google Forms. “Google Forms makes it easy to collect information, plan events, solicit feedback, and more. Today, we’re adding new features and using machine learning to make Forms work better for your business.”
From Amit Agarwal (of course): How to Add a Picture Password to your Google Forms. “…Google Forms do not allow passwords or CAPTCHAs to prevent spam bots from filling your forms with random data. Google itself maintains the reCAPTCHA project but it is not known if integration with Google Forms is in the works. There is a workaround, though.”