Google Scripts Code for Dynamic Dropdown

Përfunduar Postuar 5 vite mё parё Paguhet në dorëzim
Përfunduar

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

JavaScript Instalim Skripti

ID Projekti: #17875551

Rreth projektit

7 propozimet Projekti në distancë Aktiv 5 vite mё parё

Është zgjedhur fitues:

makhil2009

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 / orë
(2 Përshtypje)
2.3

7 profesionistë freelancer dërguan një ofertë mesatare prej £12/orë për këtë punë

Mokshith30

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.. Më shumë

£10 GBP / orë
(3 Përshtypje)
2.3
subhodeep89

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 Më shumë

£14 GBP / orë
(1 përshtypje)
1.5