Categorize Google FORMS responses in different sheets in Google SHEETS
ฝัง
- เผยแพร่เมื่อ 29 ส.ค. 2024
- In this tip, we will learn how to send your Google Form responses to different sheets depending on the answer
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below
Thanks for sharing
Thanks for commenting!
Hi, how to create a google form which automatically separate the responses into a different spreadsheet (different google sheet files) by work unit category (from the multiple choice google form question) when respondents answer the questions / enter the data in the google form.
This was so helpful!
Thank you!
I appreciate your video! I am wondering what would change in the Apps Script if my Google form has 5 questions and the 4th question is the multiple choice? Thank you!
Hello!
This is the important line
let city = responseSheet.getRange(rowToCopy, 4).getValue()
make sure that "4" matches to the column where the response of your dropdown arrives
Kind Regards
@@practicalsheets Thank you, have a great day!
This is aweome. Thank you!
Is there a way to only have the categorized sheets and not the master responses sheet or is the only option to hide it?
You could do everything with Google Apps Script
Kind Regards
Super useful!
If I want this to work alongside with the ID Ref script what should I do?
Tried copying ID REF code to be before Categorize Code, but could make it work; I changed column values to be +1 and to try to copy the last column but couldn't make it.
Even if it's not possible this still works a lot!
It depends. Would you like to have the consecutive independent for each category? This will be a bit trickire, but both ways could be done
Kind Regards
@@practicalsheets No, just copy the Master Consecutive ID. I copied the consecutive code and paste it before the categorize responses, then added a +1 to columns= rangeToCopy.getNumColumns()+1, but I think I may be doing this wrong or understanding it wrong.
Thanks for all your help! will keep watching your videos to keep learning
I did some more testing: tried working with two different functions on same code but couldn't get it to work.
So what I did was create just one "new" function which has both codes, and at the end of my "new" function, paste the value stored in "consecutive" (from the other video).
@@krpdi3m Excellent!
hi! i followed accordingly however my google sheet does not have the function =query
Hello!
Are you sure you are not working with an excel file?
Kind Regards
I get all the data from the first column in the first cell. I.e A1:A500 in now all inside A1. Where am i going wrong here
Could you show me your code pls?
Kind Regards
It also doesn't work for me
not working for me , can u please help ?
Hello can I get a copy of this script?
Yes of course. You may go to the Patreon page where you can downoload the whole file with the script
Anything you may need please let me know
Kind Regards
Mine seems to be formatted just like yours but it gives an error.
=QUERY('Form Responses 1'!B:L, "SELECT B:L WHERE L='8th Grade'")
Any clue why the error?
Hey try to write all column names, and separate them with commas and then see? For instance "SELECT B,C,D,E,F,G,H,I,J,K,L WHERE L='8th Grade'"
See if that resolves the issue.
Instead of SELECT B:L use SELECT *
The * tells it to select all.
=QUERY('Form Responses 1'!B:L, "SELECT * WHERE L='8th Grade'")
@@thedude2000zify thank you
@@CutTiesWithYourCaptor thank you
Couldn´t have answered it better. Thank you!
This was so helpful!
Thanks so much!