Google Forms is an integral part of Google Spreadsheet. Its primary use is to collect user responses.
2
votes
2answers
160 views
Is there a way to link a “Choose from a list” style question in a Google Form to a list of data (e.g. in a spreadsheet)?
Would really appreciate some help from any experts in Google Forms.
Is there a way to link a "Choose from a list" style question in a form to a list of data (e.g. in a spreadsheet)?
This would mean ...
2
votes
1answer
177 views
Calculate monthly sum() on pivote table
I have a Google Form. Upon submit following fields are populated:
Timestamp
Product Description
Unit Price
Quanitity
I have generated a pivot table from this data, in a Google Spreadsheet. The ...
3
votes
1answer
37 views
How to report which checkboxes were left unchecked on a Google Forms submission?
I have a Google form that stores its responses in a Google spreadsheet. It's set up so that whenever someone submits the form, I receive an email report of the responses. There are many places in the ...
5
votes
1answer
236 views
Creating a troubleshooting tree in Google Forms, but it can't embed images or links
I tried creating a troubleshooting tree in Google Forms but appear to be unable to embed either pictures or links.
I wanted to create a tree wherein users get directed to different nodes with ...
3
votes
1answer
1k views
Figuring out who is the owner of a Google Spreadsheets form
I have noticed that Google spreadsheet form's have URLs in the form of http://spreadsheets.google.com/viewform?formkey=.... I don't see anything that relates to the Google account in the URL. There ...
4
votes
2answers
949 views
Creating an online form - by Importing the questions from a spreadsheet?
I've got a spreadsheet where each row of the first column is a question, and the next 4 columns are the optional 4 answers to that question.
I want to turn these questions into an online form (like ...
8
votes
3answers
9k views
When sharing a Google form, how can recipients see the form and not the spreadsheet?
I'm using Google Docs to build a survey as a form for various recipients to take. The form itself is built and, as a form, functions magnificently. (Seriously, it's a work of art. I'm really good at ...
0
votes
1answer
137 views
Google Spreadsheet: Adding formulas to Google Forms
I have a sheet with form data in several columns, say A:G. Some of the data are numerical and I'd like to have some calculations done on them, e.g. in columns H through J. I have already found out any ...
2
votes
6answers
7k views
How to print a Google form?
I made a neat questionnaire Form in Google Docs. I want to print it for hand outs to my testers IRL.
But I cannot find a way to print it to paper, or even export it to PDF. There are not many buttons ...
1
vote
0answers
42 views
Google Spreadsheet: the script enabling email sending to a cc list doesn't always work
We have a Google Forms that, when filled, is sending out a list of people put on cc. This doesn't always work.
How can this issue be solved?
0
votes
0answers
48 views
What is the better way to collect ordinal data for top three activities from a list
What might be the preferred way to post a list of 24 activities and then ask visitors to choose their 1st, 2nd & 3rd favorites? They were to provide a response: Why are you choosing this? What is ...
1
vote
0answers
93 views
Single Response Spreadsheet (with multiple sheets) from multiple forms
I have four surveys (google forms) from which I want responses to go to a single response spreadsheet (each on a different sheet). It appears in the form view that I can select to have the response ...
1
vote
1answer
172 views
How to setup form for multiple answers for one question
I want my google docs form to allow up to three days to be chosen by our users for lab reservations. I've tried allowing them to enter text, but they make errors. I have tried putting 1-31 as list ...
1
vote
1answer
510 views
How do you add a date created to Google Forms / Google Spreadsheets
We have a Google Spreadsheet
It has a few columns
Issue
Raised By
Date Raised
We've turned this into a Google Forms which we want anyone in the business to be able to answer.
The problem is ...
2
votes
0answers
343 views
Google Spreadsheets: add unique QR code field to a spreadsheet based on a form in google docs using Script Trigger
At the end of each row filled in, using a custom Google Form, I'm adding three more columns:
Date of creation
Unique ID
QR code (it is a list of computers)
Unique ID and QR code are unique. QR ...
