I have three multilevel dropdown lists in my sheet, First on chooses Team (8 different), next one chooses system (8 different) And the last one chooses subsystem (Between 9-34 depending on what system was choosen). With the click of a button I want to run a script that creates a partId. The format for the partnumber should look like below where team,system and subsystem are numbers and xx is a raising number each time one combination of the others are selected.
ER23 - [team][system][subsystem] - Pxx
Could look like:
ER23-3208-P01
ER23-3208-P02
ER23-3208-P03
ER23-3208-P04
ER23-5324-P01
ER23-5324-P02
Each time someone presses the button the number gets placed in an ordered list.
I can´t figure out a good way to go about this in the scritps app. Any suggestions?