Đã hoàn thành

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

Kĩ năng: Javascript, Thiết lập Bản thảo

Xem nhiều hơn: 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

Về Bên Thuê:
( 5 nhận xét ) Ashby de la Zouch, United Kingdom

ID dự án: #17875551

Được trao cho:


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 / giờ
(1 Nhận xét)

10 freelancer đang chào giá trung bình £12/giờ cho công việc này


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 Thêm

£11 GBP / giờ
(13 Nhận xét)

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 Thêm

£17 GBP / giờ
(8 Nhận xét)

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 Thêm

£10 GBP / giờ
(2 Nhận xét)

"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 Thêm

£13 GBP / giờ
(0 Nhận xét)
£11 GBP / giờ
(0 Nhận xét)

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 Thêm

£14 GBP / giờ
(0 Nhận xét)

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.. Thêm

£10 GBP / giờ
(0 Nhận xét)

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 Thêm

£16 GBP / giờ
(0 Nhận xét)

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 Thêm

£11 GBP / giờ
(0 Nhận xét)