Did you like how we did? Rate your experience!

Rated 4.5 out of 5 stars by our customers 561

Award-winning PDF software

review-platform review-platform review-platform review-platform review-platform

Video instructions and help with filling out and completing Can Form 8815 Dependent

Instructions and Help about Can Form 8815 Dependent

Okay, so this is going to be my next, and hopefully the last, video about dynamic dependent drop-down lists. If you watched the other drop-down list videos, you've probably seen how I made this project where I have a drop-down. You select one of these brands and then you have the models that show up just for that particular brand. So, if I go to this tab, this is basically how it's laid out: we have the brands in column C and on the right, we have the models. Depending on which brand we select, the models for that brand will show up. If we go with Ferrari, we should only get models for Ferrari. If I select it, you'll see that the drop-down only has those models from Ferrari. Now, the challenge with this way of doing it is that it only works if you have two columns side-by-side that you're trying to use it for. If you want the whole column to work the same way, where you select a brand and then have the models for that brand next to it, this won't work. To make something like this work, we will have to use app scripts. This is going to be a pretty fun video for me because I haven't done this before, but it shouldn't be a problem using app scripts to get this done. It will probably be a long video, but if you know this channel, you know that's not new. It happens all the time. Anyway, let's go ahead and get started. The first thing I'm going to do is restructure this. I'm going to clean this up and delete the first two columns because we won't need them anymore. I'm also going to restructure the data the other way, so it's nicer for the...