Send Lots Dropdown with airSlate SignNow

Generate dropdown transcript

all right so since I had my last video about dependent drop downs I've had a lot of requests to create a dependent drop-down that will go for another level so basically what we're trying to do we're trying to create little drop-down validations lists so basically if I pick one thing in the first column I will only have some options in the second column and then if I pick some option in the second column I will have only certain options in the third column that's what I'm gonna try to do in this one so let me explain you what the logic is gonna be so for me I have this options tab and here I have all the options listed so the idea here is that the first column will be different regions so if we select for example Midwestern here in the first column we should only get states that are in Midwestern so if we look here we should get only Illinois here is one of them and Indiana is another one right now if we select Saturn then we're gonna get like this one and this one right here so then if we do Midwestern and Illinois in the second column right here then we want to just get representatives from those so the logic that I'm gonna use here is that if I structure my data like this in the options tab if I could just take this list and filter it and just filter it to whatever is selected in that first drop-down right here so if its Midwestern we'll filter it to Midwestern that way you get a list of states we should be selecting and then if we also select let's say Illinois here and we'll filter this column to say Illinois then we're gonna have just a list of sales reps that we need to have as a drop-down in the third column so that's the logic I'm gonna go with to structure this data basically just make it happen now we could have used filter function to do this if we were just trying to do this for one bro but I want this to work for the whole column so we're gonna have to use app scripts to make this happen so let's get started with a basic thing so let's make sure we just get a drop down here that will select the region from this column from our options tab so that's gonna be actually a very easy thing we don't need to do any app scripts for this all we have to do just select the area where we need to apply that validation I'm just gonna highlight some area here go on their data go data validation and then I'm gonna do lists from a range and click here in this box I want to reject any input beds anything different than what's selected I'm gonna click here go to my options...