Google Scripts Code for Dynamic Dropdown

I have a Google Sheet with a lookup table that includes product groups (repeated a number of times) and multiple products within these groups.

I need a script that will create a dynamic dropdown in another sheet.

The first dropdown will select the group (a normal validation dropdown)

The second dropdown will use the first dropdown as a search key. It will then look at another sheet, find all instances of that search key (product group_, and return (as a dropdown) the relevant products within that group.

I have seen a way of doing this with a script, but only when the product group is given once, not multiple times. An example of the raw data is below:

Product Group Product

Group 1 Product A

Group 1 Product B

Group 2 Product C

Group 2 Product D

Group 2 Product E

The orginal Google Sheet will be shared with the selected bidder.

This should be a fairly short exercise for someone who knows what they are doing

Skills: Javascript, Script Install

See more: google search aspnet dynamic website, place google tracking code, google map api dynamic list, google conversion code php, google tracking code, zen cart google conversion code, crm javascript dynamic dropdown, google conversion code, sample google checkout code, dynamic dropdown menu, google maps code generator, google conversion code dreamweaver, google zip code distance, google zip code radius, install google adsense code, ajax dynamic dropdown box search state, dynamic dropdown jsp dynamic data, zip code road miles using google scripts, code dynamic google maps, javascript code dynamic countrystatecity dropdown

About the Employer:
( 5 reviews ) Ashby de la Zouch, United Kingdom

Project ID: #17875551

Awarded to:


I have quite a bit of experience in automating Google sheets and It should be fairly simple task. I would be pleased to work on this.

£10 GBP / hour
(1 Review)

10 freelancers are bidding on average £12/hour for this job


Hi, Greetings! To quickly apprise you about our model, our engineers would be working full time on your project only and would be completely integrated into your team. By complete integration, I mean, they would More

£11 GBP / hour
(13 Reviews)

I am expert in PHP, CI and Laravel.I have created ecommerce and job portal website in these [login to view URL] check previous work Laravel [login to view URL] [login to view URL] [login to view URL] CI More

£17 GBP / hour
(8 Reviews)

Hi, I am Full stack developer having 6 years experience in technologies like Html 5, Css3, Bootstrap, JavasScript, jQuery, Angular.js, React.js, Node.js, [login to view URL], Vue.js, Php, WordPress. Lets see how can i help yo More

£10 GBP / hour
(2 Reviews)

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si More

£13 GBP / hour
(0 Reviews)
£11 GBP / hour
(0 Reviews)

Hi, As far as your description goes, you need an application where you will upload the spreadsheet and from that a dropdown will be created of groups. based on the group selection products will be sorted etc. Basically More

£14 GBP / hour
(0 Reviews)

Hi I am "VBA Developer". Expertised in Web Scraping & VBA Macros.. i can do any excel automation tasks, bulk email handling using outlook,File Conversion i can "SCRAPE" any website either static or dynamic also.. More

£10 GBP / hour
(0 Reviews)

Hi Sir/Mam, Thank you for posting the project! I hope you are doing well. I am a web developer with expertise in developing HTML, PHP, CSS, MySQL, Graphic Design, javascript, eCommerce, WooCommerce, and WordPre More

£16 GBP / hour
(0 Reviews)

Here's a Google sheet with the functionality you asked for - [login to view URL] As I'm new to freelancing, I built this prototype solu More

£11 GBP / hour
(0 Reviews)