Skip to main content

You Can Now Validate Data Submitted Through Google Forms

Google Forms have come a long way the last few years. Early forms were simple affairs with limited support for data types and data fields. Google Forms today can be designed into advanced data gathering tools with support for more data types, and the ability connect multiple online apps, create multi-page surveys with conditional redirects and more. A recent update to Google Forms added four new features to it.

Progress Bar

When you create surveys on Google Forms spanning multiple pages, it’s a good idea to include a progress bar to give respondents a sense of how much of a survey still needs to be completed. You can now turn on a progress bar in your form by just checking the progress bar box in the Form Settings tab.


Data validation

With data validation you can validate whether the data entered in the filed is really the type that was asked for. 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 bounce-back messages.


You can carry data validation on text, numbers as well as regular expression. For numbers, you can check whether the entered number is greater than, less than, equal to, not equal to, in between or not in between to some values you specify. In case of text, you can check whether the entered string contains or does not contain specified characters, or whether it is an email address or a URL. Regular expressions can be checked against some patterns you specify.

If data validation fails, you can show the respondent a custom error message.

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. Google offers a suggestion where it might come useful:

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.



Popular posts from this blog

How to Record CPU and Memory Usage Over Time in Windows?

Whenever the computer is lagging or some application is taking too long to respond, we usually fire up task manager and look under the Performance tab or under Processes to check on processor utilization or the amount of free memory available. The task manager is ideal for real-time analysis of CPU and memory utilization. It even displays a short history of CPU utilization in the form of a graph. You get a small time-window, about 30 seconds or so, depending on how large the viewing area is.

Diagram 101: Different Types of Diagrams and When To Use Them

Diagrams are a great way to visualize information and convey meaning. The problem is that there’s too many different types of diagrams, so it can be hard to know which ones you should use in any given situation. To help you out, we’ve created this diagram that lays out the 7 most common types of diagrams and when they’re best used:

How to Schedule Changes to Your Facebook Page Cover Photo

Facebook’s current layout, the so called Timeline, features a prominent, large cover photo that some people are using in a lot of different creative ways. Timeline is also available for Facebook Pages that people can use to promote their website or business or event. Although you can change the cover photo as often as you like, it’s meant to be static – something which you design and leave it for at least a few weeks or months like a redesigned website. However, there are times when you may want to change the cover photo frequently and periodically to match event dates or some special promotion that you are running or plan to run. So, here is how you can do that.