Questions tagged [google-forms]

Google Forms is an integral part of the Google editors' suite. Its use is to collect responses. It can work with or without Google Sheets.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
17 views

Inserting responses

I am using Google Form to capture a survey. I have about 7 questions regarding a conference lecture. I want to use Google Forms and was wondering if I can manually insert the responses?
user avatar
  • 1
1 vote
0 answers
164 views

Can Google Form send email automatically based on entered field?

I would like to use Google Form as a help desk, hoping to find a script that can send email of the submitted form responses to different people depending on their option in one of the question? i.e. ...
user avatar
1 vote
1 answer
368 views

Google Forms sending me duplicate email on automatical email

So, I've used this code, just reworked for my needs: Can Google Forms send emails automatically? The problem I have is that the account that sends those emails also receives them. Is there a way to ...
user avatar
  • 11
-1 votes
1 answer
736 views

How to re-calculate a Google Sheet every time a Google Forms questionnaire is submitted?

I used Google Forms to create a questionnaire, and I created a formula for Google Forms answers using Google Scripts. After that, I want to re-record the calculated result on the Google Sheet every ...
user avatar
1 vote
1 answer
257 views

Populating alternatives in question 2 based on answers in question 1

I have ten people who sell something to companies, and I want to track what they do IN GOOGLE FORMS. Every agent has his own 10 companies that he contacts. So, in Question 1, I will have a drop-down ...
user avatar
  • 11
0 votes
1 answer
130 views

Google Form reply to form respondents from a @domain email

I'm using Google Forms to create a survey but the auto response email has my personal email account in it. How can I change it so the from: is, for instance company@company.com instead of company@...
user avatar
1 vote
1 answer
2k views

How to upload a photo from mobile phone to Google Forms as an answer?

One can choose file upload to Google Forms, but when answering in form option only opens Google Drive upload dialog. Is there any way to upload photo from mobile phone as an answer? E.g. is it ...
user avatar
0 votes
1 answer
1k views

How to use the "Make a Copy" trick when sharing a Google Form?

I want to share a Google Forms file with customers and, when each one of them open it, I want the file to automatically ask them if they want a copy of the file in their own directory.
user avatar
-1 votes
1 answer
32 views

Active Survey Modification

I have a live survey via Google Forms. I want to edit one of the multiple choice questions. What will happen to the existing data? Will I lose the previous answers? Is it safe to modify one of the ...
user avatar
  • 1
2 votes
1 answer
873 views

Share Google Form's result publicly with a link

I would like that the user who completed the form can share the answers to his questions with a link, and anyone with that link can see the answers. Is it possible?
user avatar
1 vote
0 answers
25 views

When importing a Google form submission to a spreadsheet, how do I automatically change the time format from "d-m-yyy" to "dd-mmm-yyy"

I am importing information from a Google form into a spreadsheet. It imports live. It creates a time stamp. There are also several other dates in the form (when you type it into the form there is only ...
user avatar
2 votes
1 answer
4k views

Show quiz result on the same page in Google Forms

Google Forms allows to create questionnaire and make it like a quiz in order to get score to correct answers. I created a quiz in Google Forms but after submitting answers to all questions it shows a ...
user avatar
  • 171
1 vote
1 answer
11k views

Submit another response missing from Google Form

If I create a new Google Form, and leave the "Limit to 1 response" option unchecked: At the end of the form, the user will see a "Submit another response" link: However, I have an existing Google ...
user avatar
  • 30k
1 vote
1 answer
4k views

Use Google Forms to allow updating of old data and linking to correct record

I organise a small holiday programme which requires quite a bit of information about the children who attend (to ensure they are safe). This information splits into two types: Information that never ...
user avatar
1 vote
1 answer
5k views

Google Forms - Responses Chronological Order [duplicate]

Can my form's responses populate in chronological order upon submission somehow automatically? I just did a test response with my co-worker and her 'order' was placed at the bottom, which I now have ...
user avatar
  • 11
1 vote
0 answers
30 views

Automatically generate diagram based on respondent's answers in Google Forms [closed]

I have a questionnaire in Google Forms, where respondent answers some questions about his physical shape. All answers are taken in numbers. My goal is to interactively generate a visualization ...
user avatar
1 vote
1 answer
739 views

Google Forms to spreadsheet edit responses and new responses on the top

I've created a Google form and I want to be able to drag the rows into categories below it, but I want the new responses to always show up at the top. Instead, it follows the previous row. For ...
user avatar
0 votes
1 answer
95 views

Need to trigger form submit when data is already populated in Google Sheet from another source

We have tried many thing to do a job basically we have a Google Sheet to collect information from Google Form once the form is submitted the data get inserted into the sheet and document studio start ...
user avatar
0 votes
1 answer
80 views

How to calculate hours per date

I am trying to use A Google Sheet generated by Google Forms to track total attendance time in lab for a robotics team. I have created a form with the following questions: Checking in or Checking out ...
user avatar
  • 101
0 votes
1 answer
31 views

Can a Google form be locked temporarily for maintenance?

Can people be presented with a "form is down for maintenance" message just temporarily until the form is ready again?
user avatar
  • 1,008
5 votes
2 answers
14k views

Link Google Form responses To Already Existing Google Spreadsheet Tab

I have a Google Form. I had all of my Google Form responses linked to a specific tab in my Google Spreadsheet. Somehow my form responses were unlinked from my tab. When I go to re-link my form ...
user avatar
0 votes
2 answers
856 views

Scanning a column and partitioning information to other sheets in Google Sheets

I am a membership manager in an international organization and I was hoping to get some help optimizing our members' contact list. There are three kinds of members, NCs, LCs, and IMs. I have a ...
user avatar
  • 1
0 votes
1 answer
428 views

Fetch Random String From Array For Each New Form Entry

!Sheet1 is populated with entries coming from a Google form !Sheet2 has an array of 12 employee names in array A2:A13 How can I automatically populate the cell on the right column of every new line ...
user avatar
2 votes
1 answer
28k views

How do I find out who created a Google Form

I opened a Google Form and can't find it on any of my Google accounts - perhaps a colleague created it. Students have responded, but I can't find the original to see the responses. Is there any ...
user avatar
4 votes
1 answer
821 views

Google Forms: Number Ranges Appear as Dates

I have a Google form intended to be filled out by teachers. One of the questions is about student ages. The choices are checkboxes with age ranges, so [ ] 0 - 5, [ ] 6 - 11 and so on. The two ...
user avatar
  • 165
0 votes
1 answer
2k views

How to print a report for each row?

How do I print a report of a spreadsheet such that row n is all printed on a single page. That is, row 1 is on page 1, row 2 is on page 2, etc. The issue is that some columns have large amounts of ...
user avatar
  • 664
7 votes
2 answers
63k views

How to undo/ go back to a previous version in a Google Form

I deleted a certain section on my Google Form which has resulted in the deletion of the entire form. Does any one know if there is a way to fix this? Undo button is not working nor is the back button. ...
user avatar
0 votes
1 answer
3k views

Searching dropdown list in Google Forms

Is there a way to search for items in a dropdown list in Google Forms? If you have a lot of items to choose from, can you start typing to either eliminate other choices or search for choices with the ...
user avatar
  • 1
0 votes
1 answer
48 views

Please recommend a form like Google form to add calculations and if else logic when a user submits data [closed]

Say I want two values from the end user X and Y. I want to calculate values like XY and logic like if XY < something then one value otherwise another value.
user avatar
  • 9
5 votes
1 answer
7k views

Fill out google form using an api

I have a private google form I need to fill out every day, so I would like to write a script to authenticate me using my google credentials, and then fill out some of the form programatically, is ...
user avatar
  • 151
-1 votes
1 answer
196 views

Google Forms to Google Sheets [closed]

Can someone help with this? In a Google Form I have a question in the form of a checkboxes choose where multiple answers can be selected. In sheets it putting them all into 1 cell, is there a way to ...
user avatar
1 vote
0 answers
220 views

How do I edit file responses on Google Forms after submission

On a Google form that allowed me to edit my responses after submission, there was a question that asked me to add a file. I did just that and turned it in. Now I want to replace that file. I can edit ...
user avatar
  • 11
0 votes
1 answer
6k views

Google Forms - hybrid ranking/checklist question

I would like to create a ranking question, which only allows one selection per column. On the same row of each object being ranked, I would like the ability to add additional options that don't affect ...
user avatar
2 votes
1 answer
11k views

Dynamic calculation in Google Form

I am creating a "Trader Stall Application" form and want the cost of the Trade Space to be calculated when the user enters the "Frontage Metre" value (eg 10mtrs) multiplied against a static figure (eg ...
user avatar
  • 21
2 votes
1 answer
978 views

How to send Google Form results to a particular sheet ("tab") of a Spreadsheet

Is there a way to create a Form that submits to a particular TAB of a Google Sheet? Use Case: We are using this for meeting pre-check-in. There's standard form. I'd like the results for each ...
user avatar
  • 2,981
1 vote
1 answer
694 views

Linking multiple script created forms to 1 sheet in pre-existing spreadsheet

I work in manufacturing. I have created a Google form for our leadership safety audits which requires unique information (name(s), area being audited, and date) and also includes 25 multiple choice ...
user avatar
-1 votes
1 answer
288 views

getEditResponseUrls - hyperlinks from second linked form not inserting

I am new to scripts, but I was able to find a one that uses getEditResponseUrls to insert the edit link from a form into a Google Sheet. I've now been asked to add a second sheet to my spreadsheet ...
user avatar
1 vote
0 answers
986 views

Adding multiple choice questions to sections of a Google Form via Script

I am working on a survey using Google Forms that I generated via a script. There are over 2000 questions that are all the same format but are broken up into different sections. So, for example, ...
user avatar
1 vote
3 answers
1k views

Remove duplicate items from array?

What would be the best way to remove duplicate items from cells in rows? For instance... Category 1 | Item 1 | Item 2 | Item 2 | Item 3 Category 2 | Item 3 | Item 1 | Item 2 | Item 3 ...
user avatar
1 vote
0 answers
81 views

Auto-update specific cell in a spreadsheet depending on answer from a Google Form Response

My spreadsheet has two tabs Google Form responses Schedule of regular tasks The Google Form gathers data about a specific task and records the date of completion for that task. When a user has made ...
user avatar
0 votes
1 answer
1k views

Google Forms - App script won't iterate through all form fields

I have made a Google Form and onSubmit an app script will run iterating through all form questions and answers however some questions, when the corresponding answer is left empty, are not listed/...
user avatar
  • 479
3 votes
0 answers
59 views

Persistent column formatting in Google Sheets [duplicate]

I have a Google Sheet with an input form. I click the top of a column to highlight the entire column and set format to Currency with two decimal places. This puts the dollar sign in front of all the ...
user avatar
1 vote
0 answers
1k views

How can I change Google Forms style to put multiple textboxes on the same line?

I want to conduct a recognition task for Chinese characters online. People who fill out the task will have to read the Chinese character, and type out the pronunciation of the character in English ...
user avatar
  • 215
0 votes
1 answer
55 views

Can you upload a big email database to use as the sample for your Google Form survey?

I am trying to put together a survey in Google Forms. This is will be emailed to a sample of 3000 people. Is there an easy way to import this email data set as a CSV file and send the emails out to ...
user avatar
  • 1
1 vote
2 answers
12k views

How to validate a date in Google Forms?

Google Forms include the possibility to perform some sort of validation on user input for checkboxes and text; the functionality is available very easily both via the UI and the API. Unfortunately, it ...
user avatar
1 vote
2 answers
72 views

Need questions related to initial questions?

I'm trying to make a google form that my friends and I can use to enter our board game scores into an excel sheet, which then calculates our overall and per game scores... Does anyone know how/if I ...
user avatar
  • 11
1 vote
2 answers
2k views

Date format differs on iPhone

I have created a (google) registration form online. I set the date format to dd/mm/yyyy but when others access the form on their mobile, the format changes to mm/dd/yyyy I would like the format to ...
user avatar
0 votes
1 answer
3k views

Method to get Google Form data into multiple rows

I have a google form to collect - Family Group Name and Family member details. I get the whole data in one row. Is there a way to get the data saved in the format in the image through some add in ...
user avatar
0 votes
1 answer
220 views

Filling Google Form through Google Sheet

I have a database of name, phone number, address. And I have 3 questions in the form: name phone number address If someone filled his name, I want the form to auto-answer his phone number and ...
user avatar
  • 1
0 votes
1 answer
642 views

How to get new Google Form responses to take on non-form functions in Google Sheets

I developed a Google Form that copies responses to a linked output spreadsheet in Google Sheets. In addition to the columns created by the form question/responses themselves, I've added additional ...
user avatar

1
3 4
5
6 7
12