Categorize Google FORMS responses in different sheets in Google SHEETS

[@AzharIbrahimOmar]

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.

[@SamsonTennela]

This is aweome. Thank you!

[@AntsPlayChess]

Scripting was so confusing for me, though you explained it very well. Thank you for posting this!

[@practicalsheets]

Thank you for the nice words! Kind Regards

[@TaiKneeDancer]

This was so helpful!

[@practicalsheets]

Thanks so much!

[@AimeeBottorffBelovedPearl]

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!

[@practicalsheets]

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

[@AimeeBottorffBelovedPearl]

@@practicalsheets Thank you, have a great day!

[@tanakornpromthep9025]

Thanks for sharing

[@practicalsheets]

Thanks for commenting!

[@JosephVona-v1t]

Will something like this work if the next section of questions depends on the previous section's answers?

[@mayordefi7908]

Yes, it would

[@practicalsheets]

Yes it would...the sections are only another item of the form...for form, all questions regardless of the section are part of the form Kind Regards

[@NicolasTamayo-k8m]

Is there a way to only have the categorized sheets and not the master responses sheet or is the only option to hide it?

[@practicalsheets]

You could do everything with Google Apps Script Kind Regards

[@vonswelllathan2154]

Hello can I get a copy of this script?

[@practicalsheets]

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

[@safwanahothman6636]

hi! i followed accordingly however my google sheet does not have the function =query

[@practicalsheets]

Hello! Are you sure you are not working with an excel file? Kind Regards

[@krpdi3m]

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!

[@practicalsheets]

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

[@krpdi3m]

@@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

[@krpdi3m]

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).

[@practicalsheets]

@@krpdi3m Excellent!

[@Tboy-y6q]

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

[@practicalsheets]

Could you show me your code pls? Kind Regards

[@michellebeatty8079]

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?

[@thedude2000zify]

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.

[@CutTiesWithYourCaptor]

Instead of SELECT B:L use SELECT * The * tells it to select all. =QUERY('Form Responses 1'!B:L, "SELECT * WHERE L='8th Grade'")

[@michellebeatty8079]

@@thedude2000zify thank you

[@michellebeatty8079]

@@CutTiesWithYourCaptor thank you

[@practicalsheets]

Couldn´t have answered it better. Thank you!

[@diegopatt]

It also doesn't work for me

[@bestdealjor2211]

not working for me , can u please help ?

[@riddhidoshi9110]

This was so helpful!

[@practicalsheets]

Thank you!