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.
@@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.
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!
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?
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!!
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!
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
Hello, I got the following error "TypeError: Cannot read properties of null (reading 'getSheetByName') updateQuestion @ Code.gs:15", Can you help, Thanks
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?
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)
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,
I was searching the entirety of youtube for this but atlas, I have found it. Salute to you sire!!
Excellent!
Glad it was useful!
Excellent video
You are a great teacher
Thank you for the kind words!
GREAT VIDEO! Thank you very much!
Thank you for commenting!
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
thank you for the excellent lesson
Thank you for commenting!
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.
Thank you very much for this video. It is invaluable and has helped me with a very specific problem 👌
Thanks for the words!
Thank you.
Thank you for commenting!
@@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.
@@antcannon Excellent solution! Thanks for sharing!
Even simpler could be to use the "debug" function to check what information there is available in the code.
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!
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?
You should add these line after creating the array
responseArray=responseArray.filter(row=>row[0])
Let me know if it works
Regards!
Супер!!!! Дякую!!!
Спасибо!
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!!
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!
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)
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
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
nice one! :) thanks for this. haven't thought yet its use though, but i'm sure this will come handy someday ^_^
Thank you for commenting!
Please provide further guidance on how to redirect questions based on answers.
Complicated subject
I'll leave this nice video for you to see
ua-cam.com/video/dYF7c3yws9A/v-deo.html
Kind Regards
Can I use the same for dropdown type of question?
Hello!
Yes, it is very similar
You just have to change the type of question in the code
.asListItem
Regards!
Hello, I got the following error "TypeError: Cannot read properties of null (reading 'getSheetByName')
updateQuestion @ Code.gs:15",
Can you help, Thanks
Hi!
Could you paste your code?
Kind Regards
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?
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)
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,
bro i love u lol
Love u 2 ;)
Thx for commenting!
Limit of list is 1000, sucks maaan
Is true!
I invite you to check my videos on webapps. Less limitations
Kind Regards
WAY too advanced. Thanks anyway
Jaja, sorry.
I don´t know an easier a way but if I find it, I´ll post it
Thx for the comment!