How to update a Google Forms MULTIPLE CHOICE question from Google Sheets

In this project you´ll learn how to automatically update the options of your Questions in Google Forms from a Google Sheets Table
➤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

[@DSK23-n2x]

I was searching the entirety of youtube for this but atlas, I have found it. Salute to you sire!!

[@practicalsheets]

Excellent! Glad it was useful!

[@stinkyballsmeller]

I wasn't expecting to find a solution to the very niche problem I was dealing with, but somehow against all odds this video exists. You, Sir, are a legend.

[@practicalsheets]

So glad to be useful! Thanks for your kind words!

[@livingmatt3729]

This was extremely helpful and I appreciate your pace of instruction. Your explanations are spot on. Is there a way to have have an associated image located in a second sheet column show in the form when an option is selected for a dropdown. I have an image next to each of my options in the connected sheet.

[@mohamadhadiyudin4871]

Thank you so much for making this video. This is what I looking for and you gave me the best solution thank you so much

[@SFJourney52]

Excellent video You are a great teacher

[@ricomunnik]

GREAT VIDEO! Thank you very much!

[@practicalsheets]

Thank you for commenting!

[@Tadae323]

Thank you very much for this video. It is invaluable and has helped me with a very specific problem 👌

[@practicalsheets]

Thanks for the words!

[@user-gj3fk8pf5f]

Thanks this is a useful video - is there anyway to set the correct answers? (I am using a multi-choice grid question, but can change this if need be)

[@rjm842]

thank you for the excellent lesson

[@practicalsheets]

Thank you for commenting!

[@perrysantos]

nice one! :) thanks for this. haven't thought yet its use though, but i'm sure this will come handy someday ^_^

[@practicalsheets]

Thank you for commenting!

[@yuriit.8192]

Супер!!!! Дякую!!!

[@practicalsheets]

Спасибо!

[@the_bread_code]

Even simpler could be to use the "debug" function to check what information there is available in the code.

[@practicalsheets]

Yes you are absolutely right I prefer the logs for beginners, but the debug feature can be really useful, especially when you have a lot of variables Thx for the comment Regards!

[@mfox1]

Very helpful, thanks! One problem: when I tried this code to change rows in a checkbox grid or multi choice grid, it creates duplicate columns in the response table. Thoughts on how to correct this?

[@practicalsheets]

You should add these line after creating the array responseArray=responseArray.filter(row=>row[0]) Let me know if it works Regards!

[@inneuse]

hello, first of all, great video! i wanna pre populate a form with certain values that corresponds with some data from our google sheet. in my case i wanna start a survey to our customers related to their projects. so all i want to do is to show the list of all the existing projects by pro populate as a checkbox list from comma separated values from my google spreadsheet. maybe you can help me with that. thx

[@practicalsheets]

Hello! Is it not very similar to what I propose in the video? Please let me know if I'm not understanding correctly Kind Regards

[@Anhttse02596]

Please provide further guidance on how to redirect questions based on answers.

[@practicalsheets]

Complicated subject I'll leave this nice video for you to see kzbin.info/www/bejne/moqpaJZprtymb6M Kind Regards

[@meem-7a]

i was working on developing my forms but i was facing issues with sheets but somehow your magical work hepped a lot.. thanks to the moon and back and much more.. but i need more more explain about the checkbox questions☑ can use your cods the same way exactly or we delete from it what you deleted in the end of the video? this is the only thing that is confusing me!!

[@practicalsheets]

Hello Thanks for the kind words! Almost exactly You just need to change this part... asMultipleChoiceItem() ...for the appropiate. Here is the list Multiple Choice - asMultipleChoiceItem() Dropdown - asListItem() Checkboxes - asCheckboxItem() Regards!

[@nishanmostafa]

how do i set the answer key of the MCQs from google sheet? Like i have 100 mcq and all the ans are stored in google sheet ,so how can i automatically set the answers in google form?

[@antcannon]

Thank you.

[@practicalsheets]

Thank you for commenting!

[@antcannon]

@@practicalsheets I used this on a staff sign in form where peoples names are the answer choices. I added a sort method so that it when names are added to the sheet the script sorts it automatically. Then I learned how to use the textFinder process combined with the getRow to make the script find the Staff name header and then start the range at the row after. So that I can put instructions at the top off the sheet. And that it would work no mater what row the header started at.

[@practicalsheets]

@@antcannon Excellent solution! Thanks for sharing!

[@bartpas12]

Can I use the same for dropdown type of question?

[@practicalsheets]

Hello! Yes, it is very similar You just have to change the type of question in the code .asListItem Regards!

[@alaabandar6043]

Hello, I got the following error "TypeError: Cannot read properties of null (reading 'getSheetByName') updateQuestion @ Code.gs:15", Can you help, Thanks

[@practicalsheets]

Hi! Could you paste your code? Kind Regards

[@faisalsabir3316]

Good tutorials but you don't need to store a map() array into another variable. The map() function changes the items of the array itself so no need to create another variable. Secondly for the options you can use getLastRow() with range so you get exactly what is needed. Another method of converting 2d array to 1d array is -> var newArray = [].concat(...array)

[@practicalsheets]

Hello! Thank you for your comments Are you sure? I think map does create another array and you have to save it. What you can do is store it in the same variable of the original array Look what I found "The map() method creates a new array populated with the results of calling a provided function on every element in the calling array." The problem with getLastRow, is that it wont work if you have multiple columns with different length, then you would have to do a custom function for finding the lastrow of a given column Finally. I have yet to understand the []... But you are right, I´ll study it in the future Thank you again! Regards,

[@adilsalim1337]

bro i love u lol

[@practicalsheets]

Love u 2 ;) Thx for commenting!

[@adminanar]

Limit of list is 1000, sucks maaan

[@practicalsheets]

Is true! I invite you to check my videos on webapps. Less limitations Kind Regards

[@timroche1947]

WAY too advanced. Thanks anyway

[@practicalsheets]

Jaja, sorry. I don´t know an easier a way but if I find it, I´ll post it Thx for the comment!