Help with Google Apps Script - need to build a dynamic dependent drop down list with minimum 5 dependencies.
Budget: $30 – $250 AUD
I need to build a dependent drop down list using Googlesheets and Google Script Editor. I have found a tutorial that is almost ideal but it only has 2 dependent drop downs and data validation exceeds the maximum 500 rows so I need to use the list from a range criteria instead. This eventually needs to be embedded into our company intranet.
Primary dropdown: Region
First dependent Dropdown: Sub Region
Third Dependent Dropdown: Product Category
Fourth Dependent Dropdown: Product Type
Filtered Result: Supplier
We used to use Awesome Table but the cost is now prohibitive since they introduced pricing based on use.
I can provide this sheet and the script I have started to try to mimic the Awesome Table filtering.
If anyone thinks they can help with this, please let me know how long you think the job will be and your price
I will also need comments in the script to identify what is being done step by step so I can fix/adjust in the future.
I have attached a mock up of what I am trying to achieve if the rows for subregion (column B) were less than 500 (Unfortunately they are close to 40,000) and the script so far.
Thank you
Sandra
Primary dropdown: Region
First dependent Dropdown: Sub Region
Third Dependent Dropdown: Product Category
Fourth Dependent Dropdown: Product Type
Filtered Result: Supplier
We used to use Awesome Table but the cost is now prohibitive since they introduced pricing based on use.
I can provide this sheet and the script I have started to try to mimic the Awesome Table filtering.
If anyone thinks they can help with this, please let me know how long you think the job will be and your price
I will also need comments in the script to identify what is being done step by step so I can fix/adjust in the future.
I have attached a mock up of what I am trying to achieve if the rows for subregion (column B) were less than 500 (Unfortunately they are close to 40,000) and the script so far.
Thank you
Sandra