Google_Sheets depending cascading drop down with auto complete
Budget: $50 – $100 USD
Dependent cascading drop down function
We found a template google sheet which solves exactly our purpose. However, the app script code is way overloaded with other functions in that sheet so we can’t reverse engineer the code. We would love to have all overhead code removed, so only have the functions necessary for our needs, so if we enhance the code in the future we can work with it. Functioning code is given below…
Desired Function:
Worksheet Definitions
This Table gives the reference for the dependent drop down and can be added in rows and columns as we go forward
A sample Table is given to check the programm
HW configurator
This configurator functions with basid dependent dropt downs. Key function
Column A (drop down selection)
Column B drop down is dependent on the drop downs of column A
Column C drop down is dependent of selection in column A and B
Column D drop down is dependen of selection in column A,B and C
Etc
Asap there is only one choice, the next columns should be auto populated. If a selection is deleted in a lefter column, then all values to the right should be deleted as well.
So if a row is populated with values and column a selection is deleted, all values in B,C,D, … should be deleted.
I found a functioning app script code but failed to reverse engineer it to delete out all the overhead from other worksheets that are not needed. Asap I start to delete the sheet doesn’t work anymore.
Ask:
Delete all other worksheets apart from Dropdowns+ and Dictionary.
Rename worksheet “Dropdowns+” –2→ “HWconf” and “Dictionary” –2→ “Definition”.
Remove all overhead code for the other worksheets and have as small as possible App Script code base.
Or:
Develop a new google sheet with App Script that deliver this functions as in this sheet.
Whatever is easier and faster!
We found a template google sheet which solves exactly our purpose. However, the app script code is way overloaded with other functions in that sheet so we can’t reverse engineer the code. We would love to have all overhead code removed, so only have the functions necessary for our needs, so if we enhance the code in the future we can work with it. Functioning code is given below…
Desired Function:
Worksheet Definitions
This Table gives the reference for the dependent drop down and can be added in rows and columns as we go forward
A sample Table is given to check the programm
HW configurator
This configurator functions with basid dependent dropt downs. Key function
Column A (drop down selection)
Column B drop down is dependent on the drop downs of column A
Column C drop down is dependent of selection in column A and B
Column D drop down is dependen of selection in column A,B and C
Etc
Asap there is only one choice, the next columns should be auto populated. If a selection is deleted in a lefter column, then all values to the right should be deleted as well.
So if a row is populated with values and column a selection is deleted, all values in B,C,D, … should be deleted.
I found a functioning app script code but failed to reverse engineer it to delete out all the overhead from other worksheets that are not needed. Asap I start to delete the sheet doesn’t work anymore.
Ask:
Delete all other worksheets apart from Dropdowns+ and Dictionary.
Rename worksheet “Dropdowns+” –2→ “HWconf” and “Dictionary” –2→ “Definition”.
Remove all overhead code for the other worksheets and have as small as possible App Script code base.
Or:
Develop a new google sheet with App Script that deliver this functions as in this sheet.
Whatever is easier and faster!