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
0
votes
0answers
14 views

#REF!, How to Grab the first response of form and ignore the duplicate in google sheets

I have a google form for attendance and I have a formula to automatically calculate the salary from the attendance. Sometimes people fill out the attendance twice with the same status (work/go home) ...
0
votes
1answer
222 views

Google Apps Script MailApp Not Sending Email To Script Owner

I've set up a script to take information from a Google Form and email that information to multiple people using Google Apps Script. What it does not do, however, is email the owner of the script. I'...
2
votes
2answers
5k views

How to pull last value in a Google Sheets column and populate it across another worksheet column?

This is my first post here- I hope this is the right place for it, apologies in advance if it isn't. Context: I have a password protected presentation that I need to give users access to, but only ...
0
votes
1answer
24 views

Google Sheets Google Forms updates

I have created a Google Form for which collects data from a user. Once the use submits the form I have scripts that copy the data to several other Google sheets and then send an email to the ...
-1
votes
1answer
326 views

How to add 1 question in Google Forms which takes multiple inputs from the user and stores in a single column in Google sheets

I am struggling to create a custom question in Google forms which can ask the user for Multiple inputs or Short texts. For example If I ask a question to a shopkeeper: "Name all the vegetables ...
0
votes
1answer
44 views

RCV Polling Data from Google Forms goes the wrong direction in Google Sheets

I am making an RCV voting system in Google Forms, however, when the results go into Google Sheets, they come out like this: Timestamp 1 2 3 4 239029339 Candidate A Candidate B Candidate D Candidate ...
0
votes
0answers
17 views

Import Data to Google Form

I have a Google Form that is going to ask users a number of questions about a certain service they can choose from a drop down question. Is it possible to import data from a linked Google Sheet into ...
1
vote
1answer
63 views

Hide Respondent's Email Address in Google Form

When someone responds to my Google Form, it displays their email address at the top of the form. I've disabled the option Disable autosave for all respondents in the form settings but the message ...
11
votes
8answers
36k views

How to automatically refresh a filter view in Google Sheets when new data comes in via Google Forms?

I have a filter view in Google Sheets that does not refresh when new data comes in via Google Forms. To refresh the filter view, I can remove the filter and apply it again, or even just click "OK" in ...
0
votes
0answers
12 views

Google Form which uses a pre built sign in

Been reading a lot about Google Forms which need a Gmail account to fill in. I'm having another Gmail account only for sharing pictures with club members. Is there a way to create a form to upload ...
2
votes
1answer
3k views

Lost responses from Google Forms

I have updated my form with some responses recorded. After deleting one question section, the responses for that question disappeared. Can I still get to them?
2
votes
2answers
17k views

I lost my response in Google Form after accidentally deleted the questions

I created a google form this afternoon and there were lots of response that I received. And then I accidentally deleted all of the questions and I thought I can simply edited it back. when I edited it ...
0
votes
1answer
829 views

How to select existing sheet to be populated by a Google form?

I have a team working in pan India with 6 Team leaders. I have created a Google form to collect the everyday status report. Now the question is: How can I assign a particular sheet[already created in ...
1
vote
1answer
29 views

How do I find where the Google Form is saved?

I've started a contract at a small company to update all their google forms. The forms were set up 5 years ago by the last contractor. Unfortunately this means none knows where the forms are saved on ...
0
votes
1answer
88 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 ...
0
votes
1answer
43 views

Copy Google form and linked sheet preserving existing formulas and formatting?

I am required to copy an existing Google Form, however, the linked results sheet has deep formatting and formula. Apparently, the new form requires a new sheet to be linked to form results. How can ...
0
votes
1answer
176 views

Is there a way to add a new sheet tab to a Google Sheet based on the timestamp date?

Students take a weekly survey on Google Forms, and it is transferred to a Google Sheet. I want the Google Sheet to automatically generate a new tab based on the date (timestamp) so that each week has ...
0
votes
1answer
2k views

Add file submitted to specific folder based on answer in google forms

I'm trying to create different subfolders for uploaded files based on the multiple choice question i have in one of my google forms. The form is for certain locations, so based on the location that ...
1
vote
1answer
680 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 ...
0
votes
1answer
26 views

Auto deleting columns when the field is blank

I have created a form that have multiple sections, skipping sections based upon an answer. I have then linked a Google Sheet to this Google Form to collect responses. These responses are auto filtered ...
0
votes
1answer
53 views

How to save question before going back to the same question in Google Forms?

I need to make a questionnaire. The idea of the questionnaire is that it asks the user first two different questions (name and country) and after the two questions it asks that if the user wants to ...
1
vote
1answer
714 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 ...
0
votes
1answer
704 views

How to disable new row when Google Form collects responses for Google Sheet?

When Google Forms collects responses, it creates an entirely new row in the Google Sheet which I don't want to happen because I am using a VLOOKUP for another sheet and it's not grabbing the data I ...
0
votes
1answer
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 ...
0
votes
2answers
206 views

Arrange Google Form Checkbox Responses into a List

I am collecting scholarship recipients in a Google form. The recipients names are in a checkbox format, as some donors give to multiple students. I need to separate out the names into additional rows, ...
0
votes
1answer
55 views

Google Forms - Removing email collection renders invisible required field

I just spent some time creating a form, and while brushing over the final details, I tried activating the email field "Collect email addresses in settings -> general" Then I deactivated it and now ...
0
votes
1answer
55 views

How to add multiple conditions onto a query

so this is completely experimental and not for a class. If anything, I'm doing this because I don't really have class right now. I am self-taught and very inexperienced when it comes to anything code ...
0
votes
2answers
5k views

Google Form File Upload - Change file name to match form value

I have a Google Form for contact information. The form asks for Given Name (col A), Family Name (col B) and a File Upload restricted to images only (col D). I have a formula which displays the Full ...
0
votes
1answer
28 views

Merge multiple columns in Google Sheets from questions in Google Forms if all questions are the same

I have a Google Form where I ask for the specific college someone is studying in (i.e. college of engineering, college of business, etc.) and then send them to a specific question where they select an ...
0
votes
1answer
118 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@...
0
votes
1answer
35 views

Send a Google Forms notification to two differenz email addresses based on

How can I send an automatic email notification to two different email addresses depending on whether a woman or a man has filled in the form? Please can someone help me with a script to check this ...
0
votes
1answer
277 views

Google Forms Quiz Response Sheet

I have added a couple of columns to the Google Sheet Responses for a quiz created using Google Forms. When creating the response sheet (created in the "Responses" tab of the quiz, it automatically ...
0
votes
1answer
613 views

Create triggers on recently programmatically copied Google Forms

I have this main Form that uses its responses to create several other Forms after it's been submitted, but I need that these Forms that were recently created to send emails on their submissions ...
0
votes
1answer
359 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 ...
-1
votes
1answer
436 views

not working form submit Event Object

I have a Google form which I use to populate a Google docs from a certain template whenever a new response is submitted. In order to achieve this, I have written this script, but it is not working and ...
2
votes
3answers
27k views

Why does google forms ask me to sign in even though I am signed in?

I have gmail account signed in and when I open google forms that I received in my inbox, it asks me to sign in to continue. When I click sign in, it again reloads the same page and again asks me sign ...
0
votes
1answer
44 views

Google Sheets formula

I'm using Google Sheets make a spreadsheet with the name in column a, the company in column b and in column f, I need their email. I have 3 companies, and they have slightly different email formats. ...
4
votes
2answers
3k views

Google Forms Answer Validation Based On Another Previous Given Answer

I am working on a form in Google Forms. At some point during my form, I need to validate an answer based in a previous answer. To make it more clear, I give you an example: How many hours do you ...
5
votes
2answers
13k 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 ...
0
votes
2answers
41 views

Get two different type of answers to an answer

How can I get Google Forms to allow me to have two different type of answers to one question? Answers are to be related between them so when working results, I can get the grades of each group member. ...
1
vote
1answer
808 views

How can I merge responses of two Google Form identical to each other but in two different languages

I want to combine the responses of two of my Google Forms that are identical to each other but in two different languages. How can I combine the responses to get the summary of both sets of responses?
0
votes
1answer
325 views

Show student's result when they enter roll number in Google Form

I have a Google Sheet with all students subject marks, roll numbers, names. I'm thinking of following: Students are given URL of a Google Form. Only field there is for roll number. Once they entry ...
0
votes
1answer
8k views

How can I get data from Google Sheets to a Google Forms dropdown list?

I have some data in a Google Sheets file. I want to get a Google Forms dropdown list to be updated automatically from that list. Is it possible?
0
votes
1answer
37 views

How to format a google sheet that's capturing google form data?

I have a google form which I linked to a google sheet via the "create spreadsheet" button on the form. Is there a way to format the resulting google sheet for current and future form ...
0
votes
0answers
13 views

Creating questions based on answers without multiple sections in Google Forms

I'm trying to ask specific questions based on previous answers using Google Forms. I'm aware that this is possible by creating multiple sections and directing users to specific sections according to ...
0
votes
1answer
12 views

Can I edit choices without affecting the already submitted responses?

So I have made a form for a project. I got some responses, but now I want to translate the whole form into English. The problem is that if I try to edit the choices, the responses stay the same, in ...
2
votes
1answer
619 views

Google Sheets - Query Multiple Columns for same Data

We have Employee training data in a Google 'Form Response' spreadsheet which ranges from A1 to JQ1000. This spreadsheet is automatically populated when a Google Form is completed but it is difficult ...
0
votes
0answers
17 views

Auto populate comment

Is there a way to have google sheets auto populate a comment based on specific entries in a cell? I am trying to have google sheets auto populate a google form response if certain content is entered ...
0
votes
1answer
35 views

Google Forms - two required questions - accept with at least one of them

I collect links to historical records describing persons falling into certain categories (e.g. secret Protestant or vampire/witch case). User specifies the Category with a checkbox answer (multiple ...
1
vote
0answers
47 views

How to retrieve Google Form and its 240 responses that have disappeared

Please help me retrieve my Google Form and its 240 responses have disappeared. Those 240 responses have been collected over 2 years as part of my thesis survey. I could access the form and responses ...

1
2 3 4 5
12