Categorize Google FORMS responses in different sheets in Google SHEETS
HTML-код
- Опубликовано: 18 окт 2023
- 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
practicalsheets.com/patreon
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: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
This is aweome. Thank you!
This was so helpful!
Thanks so much!
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.
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!
It also doesn't work for me
not working for me , can u please help ?
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