Categorize Google FORMS responses in different sheets in Google SHEETS

Подписаться 12 тыс.

Просмотров 19 тыс.

50% 1

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

Опубликовано:

27 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 35

@AntKeeperJasper 7 дней назад

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

@AzharIbrahimOmar 8 месяцев назад

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.

@riddhidoshi9110 Месяц назад

This was so helpful!

@practicalsheets Месяц назад

Thank you!

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

@NicolasTamayo-k8m 2 месяца назад

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 2 месяца назад

You could do everything with Google Apps Script Kind Regards

@JosephVona-v1t 15 дней назад

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

@mayordefi7908 14 дней назад

Yes, it would

@bestdealjor2211 9 месяцев назад

not working for me , can u please help ?

@krpdi3m 3 месяца назад

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 3 месяца назад

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 3 месяца назад

@@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 3 месяца назад

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 3 месяца назад

@@krpdi3m Excellent!

@diegopatt 9 месяцев назад

It also doesn't work for me

@vonswelllathan2154 2 месяца назад

Hello can I get a copy of this script?

@practicalsheets 2 месяца назад

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

@tanakornpromthep9025 Месяц назад

Thanks for sharing

@practicalsheets Месяц назад

Thanks for commenting!

@Tboy-y6q 4 месяца назад

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 4 месяца назад

Could you show me your code pls? Kind Regards

@TaiKneeDancer 5 месяцев назад

This was so helpful!

@practicalsheets 5 месяцев назад

Thanks so much!

@safwanahothman6636 3 месяца назад

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

@practicalsheets 3 месяца назад

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

@SamsonTennela 8 месяцев назад

This is aweome. Thank you!

@michellebeatty8079 2 месяца назад

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.