?
Solved

How to use a google form template

Posted on 2015-01-16
2
Medium Priority
?
288 Views
Last Modified: 2015-02-09
I am trying to create an online job application and was hoping to use Google Docs. The only two important things I need are 1.) send an email when individual form is submitted, and 2.) organize the data of all submitted formed in a spreadsheet.

Think I should use Google Forms?

I am having trouble with the pre-built templates for the form. Every time I try to view the template it simply takes me to the spreadsheet and not the actual form. Any idea what I am doing wrong? I usually am much smarter than this... it's driving me nuts.

Thanks!

Chris
0
Comment
Question by:cansevin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
Brad Rubin earned 1000 total points
ID: 40563504
Google forms is a perfect application for what you are trying to accomplish if you can link external applicants to the form itself.

I need more information from you to help. If you edit a form it should allow you to manipulate the question fields, create new question fields or manage the existing template. I am not sure why you are going straight to the spreadsheet. It sounds like a permission issue, but I need you to describe the problem more.
0
 
LVL 5

Assisted Solution

by:Christopher Barnes
Christopher Barnes earned 1000 total points
ID: 40592889
Google Forms in their most basic parts consist of a HTML and a CSV file. Google create the webserver magic around the HTML file so that it can accept input and save the data. If you were to export your Google Form using Google Takeout, all you get is the layout in HTML format and a CSV file with the data.

Furthermore, Google do not provide an API to backup and restore Google Forms at the moment. Feb 6, 2015. But Google Takeout does help get your data out.

When you use the Pre-Built Templates from the Gallery, it is confusing because after selecting "Use this template" you are automatically placed/focused into the response file (spreadsheet). Just close the response file and look for the actual Google Form in your Drive, it will have a similar name.

I recommend you learn how to create your own Google Forms from scratch, it really is easy, you need to have a basic understanding of different data types and if/then statements but not much more.

Here are some useful learning links:

http://www.wikihow.com/Create-a-Form-Using-Google-Drive

http://www.makeuseof.com/tag/10-advanced-tips-tricks-for-google-forms/
0

Featured Post

Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steve Terp was featured in a video created by CRN about how "Channel Is Crucial To Market Disruption". Click on View source to see the video and article
First of all let me say that the only language that I speak is English, but in answering questions here I often come across people whose English skills are not the best and I’d like to be able to communicate better with them, and the following descr…
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small busin…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…
Suggested Courses
Course of the Month13 days, 11 hours left to enroll

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question