All Questions
15 questions
0
votes
1
answer
614
views
i want to auto fill google form by data in google spreadsheets
i have this form
https://docs.google.com/forms/d/e/1FAIpQLSc4OjEgxlYpcAO7zkd9-jLNvkB3nZRsrkMv-IqVII6EnL0DnQ/viewform
and i want to submit 100 response into it,
every response will be 4 answers only.
...
0
votes
1
answer
939
views
How do I populate checkbox google form responses from another google form?
I am having trouble with populating checkbox responses into another google form from the google sheet.
Here is my workflow. Someone fills out the original google form. The responses are filled out ...
-6
votes
1
answer
145
views
How to extract a cell in google sheets if multiple other cells on same row meets criteria
I have collected a lot of data into a google sheet through google forms. I would like to extract specific parts of this data on to a presentable page of the sheet. For example, I would like to extract ...
0
votes
1
answer
357
views
Set value on form submission based on previous row
I have a script that triggers on form submission, checks the row before last row and should write a TRUE value to the 9th column of the checked row IF all three cells on its left have a TRUE value.
My ...
- 15
0
votes
1
answer
1k
views
How to set up a Google Sheet to automatically create new tabs/sheets for Google Form responses based on the date?
Our company is trying to find a way to set up a Google spreadsheet to automatically create new tabs/sheets for Google Form responses that come in based on the date. Theoretically, with submissions ...
- 1
0
votes
1
answer
88
views
setFormula() in a FormResponse Sheet
I am using GAS to generate a Google Form via Google Sheets. After the Form is generated and the "Responses" tab is added to the Sheet, the script adds a formula to cell E1 that is just ...
- 327
0
votes
1
answer
193
views
Google Apps Script to automatically duplicate a row the number of times a comma appears in a column keeping basic info?
Can you write a Google Apps Script that can duplicate a row the number of times a comma appears in a column? I have a Google Form that's for scheduling appointments for blower door testing and ...
0
votes
1
answer
2k
views
Google Apps Script Error Exception: Questions cannot have duplicate choice values. GSheet > GForms updater
I'm working on making a Google Sheet update relevant Google Form questions from a list of cells if the header matches a question. The code runs fine, but for some reason, I continue to run into an ...
- 3
0
votes
1
answer
581
views
How do I add all headers with named values
I am converting Google form submissions into pdf files and the code seems to work for the values that are questions listed in the form. however I also have multiple columns that calculate data based ...
- 53
0
votes
1
answer
639
views
Google Forms link to Google Sheets in a specific sheet
Here is the situation:
I have a tab 'Page1' that receives data from an application. I need to join these data with data coming from a Google Forms, still in the 'Page1' tab (it needs to be in this tab)...
2
votes
1
answer
1k
views
How to set value in another column of Google Sheets based on certain value of column in the same sheets
I have this sheets that has a lists of email address. I want to auto populate the Column D base on the value of email in column B.
What I want to auto populate in column D is the first name of the ...
- 179
0
votes
1
answer
194
views
How do I pull over info from google sheets into a dropdown menu in forms that will update itself every minute
I am setting up a trivia game through google sheets/forms.
I have a google form that makes a team enter in their team name and submit.
This then goes back to a google sheet with time stamps.
I want ...
- 1
0
votes
1
answer
71
views
How can I use OnSubmit trigger to run function on a google spreadsheet?
I will try to explain the situation so you can better understand my problem. I have a spreadsheet that contains 3 sheets: the first one contains the answers from a form, the second one contains the ...
0
votes
1
answer
307
views
Sending email based on a vlookup cell generated by a form
I'm looking for a script that would send an automatic email to a seller (column J) when a change is made to one of his customers. The change is made through a google form. So the form is linked to a ...
9
votes
6
answers
29k
views
IMPORTRANGE function not refreshing new entries in linked Google sheet
My IMPORTRANGE function is not refreshing with new data once the linked spreadsheet is added to. Instead, I am having to cut and paste all of the formulae again whenever I want to view the new ...
- 317