1. Register 10 test data in Google Form
2. Delete all reflected spreadsheet data
3. Register production data from the same Google form
→→→ Production data is registered from the 12th line without changing the line deleted in 1.
[What you know by investigating]
・ Google Form holds data entered in the past.
・ The data on the Google spreadsheet linked to the Google form is just a copy of the data in the form
I want to delete all data stored in Google Forms
Answer # 1
After investigating various things, I solved myself. Follow the steps below.
【1】 First, on the Google Form edit screen,
1. Switch from question tab to answer tab
2. Press three vertical marks → Select "Delete all answers"
3.Turn on/off "Reply accepting answers"
【2】 In the next Google Sheet,
"Delete line" from the 4.2th line to the last line where data was entered
* Please delete the row itself, not the cell data
The garbage data entered for testing is now erased, and the production data is entered cleanly from the second line.
- send error for batch email sending of google apps script
- google apps script - i want to add word art to the plain page of gas google slides (win10, chrome)
- google apps script - find the character string (a) in the a column of the spreadsheet with gas and enter the character string (b
- google apps script - gas replacetext's searchpattern will not be replaced if a regular expression is used
- google apps script - how to open the specified url when pressing a specific part in gas
- google apps script - i want to replace the text in the original gas format
- google apps script - i can't automatically send an email to a list on google sheets
- google apps script - i think that it is blocked by the handling of url, which makes an english-english dictionary using import x
- google apps script - i do not know how to avoid the error of for loop in gas
- google apps script - google appscript spreadsheet check box automatic creation
- google apps script - spreadsheet vertical writing if you truncate it, a line break will occur
- google apps script - the slack outgoing webhook is deprecated, is there any other that can fire an event depending on the trigge
- google apps script - [gas] i want to output to a spreadsheet even when there are no events (plans) in google calendar
- google apps script - if there is more than one post per hour, i want to be notified only once
- google apps script - post from gas to the home of line works
- google apps script - i want to be able to auto-fill a range of strings in a sheet repeatedly
- google apps script - faster gas protect execution time
- google apps script - i want to be able to perform form tests automatically by filling in a spreadsheet
- [google apps script] could not send email from spreadsheet: no recipients specified
- how to change google calendar event title with google apps script
- google apps script - about manipulating files duplicated with gas
- google apps script - [gas] i want to import multiple members' google calendars into a spreadsheet using gas, but i get an error
- google apps script - [gas] specify the number of lines in the range must be 1 or more
- google apps script - about calendar linkage from gas spreadsheet (gethours can not be used)
- google apps script - a question about gas errors
- google apps script - i want to convert a spreadsheet to pdf with gas, but an html file (?) is generated
- google apps script - about the repetition process when creating an email from a spreadsheet
- google apps script - gas and gss password verification always match