Yes you could iterate through, say an array of object [{},{},...] containing your dropdown parameters like list items, range location, settings and then call the function with these variables inserting a dropdown for each one.
Great tutorial, i wonder what's that extension at the Repository part. I don't see that with my workspace section. Also i noticed you have got a darker background for the workspace.. how do u have access to it. Can I add the same to my workspace section?
Hi! These are Chrome extensions: Apps Script Color: chromewebstore.google.com/detail/appsscript-color/ciggahcpieccaejjdpkllokejakhkome?pli=1 Google Apps Script GitHub Assistant: chromewebstore.google.com/detail/google-apps-script-github/lfjcgcmkmjjlieihflfhjopckgpelofo
Hi, You could use the onEdit() trigger to read the dropdown selected value and then modify the data validation or even create a dropdown with your selected list beside it. If you want a no-code solution for this, check out: ua-cam.com/video/VW3mhsFfzG0/v-deo.html . I haven't had a chance to create a tutorial on this with Apps Script yet.
![Supercharge Google Sheets with Dependent Dropdowns [Google Apps Script]](http://i.ytimg.com/vi/5Yysv-QouTQ/mqdefault.jpg)
Thanks for this great video! Is there a possibility to create a function to create multiple drop-down lists at once?
Yes you could iterate through, say an array of object [{},{},...] containing your dropdown parameters like list items, range location, settings and then call the function with these variables inserting a dropdown for each one.
Great tutorial, i wonder what's that extension at the Repository part. I don't see that with my workspace section. Also i noticed you have got a darker background for the workspace.. how do u have access to it. Can I add the same to my workspace section?
Hi! These are Chrome extensions:
Apps Script Color: chromewebstore.google.com/detail/appsscript-color/ciggahcpieccaejjdpkllokejakhkome?pli=1
Google Apps Script GitHub Assistant: chromewebstore.google.com/detail/google-apps-script-github/lfjcgcmkmjjlieihflfhjopckgpelofo
what a great turorial video! i would like to get a different dropdown list on A2 everytime i choose different category on A1, how can I do that?
Hi, You could use the onEdit() trigger to read the dropdown selected value and then modify the data validation or even create a dropdown with your selected list beside it. If you want a no-code solution for this, check out: ua-cam.com/video/VW3mhsFfzG0/v-deo.html . I haven't had a chance to create a tutorial on this with Apps Script yet.