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.
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
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).
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.
Scripting was so confusing for me, though you explained it very well. Thank you for posting this!
Thank you for the nice words!
Kind Regards
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!
Thanks so much!
This is aweome. 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!
Will something like this work if the next section of questions depends on the previous section's answers?
Yes, it would
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
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!
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
Thanks for sharing
Thanks for commenting!
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
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
not working for me , can u please help ?
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
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!
Thank you!