Fax Mark Dropdown with airSlate SignNow

Fax mark dropdown

[Music] in this video I'm going to walk you through using the script on my blog for creating cascading dropdowns in SharePoint 2013 2016 and office 365 for the classic forms the first thing you'll need to do is go to the github repository linked in my blog and in the description of the video below where you can download the JavaScript files locally and then upload them to SharePoint you'll see here the two main files are hillbilly cascade gif and hillbilly Cascades see ewp so download these files here I have them already downloaded and I'm going to upload these to the site assets directory of my SharePoint site so over here in office 365 and my site assets directory I am going to just simply drag and drop these files to upload them ok so we now have those files in our site assets the next thing we have is the lists that are going to be used for the Cascade drop down I'm keeping this very simple for this example we have a list called states where the title field is just some different states right now we just have Arkansas Alabama Texas and Ohio I then have a list called counties and within this list we have the name of the county and then a lookup field to the state for that county so we have all of the so when you specify a county you specify which state is that counting from finally we have a list called cities and in the cities list we have a list of the city and then the county for which that City belongs to so on our form a user would select a state and then it would show all the counties for that state then we'd select a county and it would show all the cities for that county so you could set this structure up any way you wanted I wanted something that hopefully most people could grasp that what we're trying to get there I then have a list called cascade and if we look at the list settings for this list you can see that we have a state field which is lookup field to the state list a County field which should look up to the counties list and a city field which is a look up to the cities list okay so get that set up in your system if you want to follow along with exactly how has the script implemented and then what we need to do is put our script onto our forms and SharePoint and then modify the script as needed for the field names so let's go to the new item form for our list called cascade so we're going to cascade we're going to go to the list tab up here again this is in classic mode so you want to switch in the classic mode to use these forms anyway since we modifying the classic forms go into our form webparts and we're going to choose default new form this opens up our default new form and you can see here it lists all of the states all of the counties regardless of the state and then all of the cities in our list so when you choose something you know it's it's not going to have that relationship that we want so what I'm going to do is I'm going to edit this page I'm going to add a webpart to this page and I'm going to add a media and content content editor web part I'm going to edit this web part and I'm going to point it to that file that we uploaded to our site assets library so that was in site assets and we want to point it to the C ewp file so that was called hillbilly cascade cew t.j.s and now we will apply that and we will stop editing so now when we go to create a new item on this list will see that the state show all the states but you know that no counties lists are listed and no cities are listed and it also shows us the text select the County and select a city so now when I select a state it reloads the County fields with just the counties for Arkansas the city fields are still blank and I select a city so I'll select Washington County and now it shows the cities for Washington County so now we're in Korea we're forcing that relationship for those cats getting dropdowns plus if I now change this to a different state Ohio it clears both fields not just the counting field because if you change the state you would also want to clear the city of anything that was selected before so you can choose Hamilton Ohio Cincinnati is the city and then we can go ahead and save this and if we go and look at this in the Edit form you can see that it shows in the Edit form but again it's showing all of the options for the drop-down and we don't want to do that we want to enforce the Cascade on the Edit form as well so we can do the same thing we can edit this page add a webpart to this page and we can add a media and content content editor web part edit this web part and point it to the file in our side assets library and apply that so now when we edit an item we will see that same cast English relationship so it's only showing us the counties for Ohio and it's only showing us the cities that we have in our list for the county of Ohio so now you get the same functionality on that edit form and it maintains those values so if I change the state to Arkansas you're going to see it clears those other two fields select Boone select Harrison so you can see it works on the Edit form as well all right so that's how you implement the script so let's take a quick look at the script itself so you can see how I made it work so I'm going to go into site assets library and I'm going to open up that hillbilly cascades CEW pjs file by looking at this file we can see where we're referencing jQuery zalo J's jQuery we're also referencing that hillbilly cascade JSP file and that's kind of the main file that does all of the lookups and sets the fields for us so you unless you need to change that functionality for anything you don't have to worry about the code or look at it just reference that file the important thing you need to do is you need to set up a new object for every field that needs to be a cascade field so you can see in this code we have two entries in this cascade array right we've got one that has the fields needed to create the Cascade for the County where we specify what is my parent field what's the list of the counties come from which field in that counties list has the name of the county what is the name of the field on the form for County and then what is the name of the field in the counties list that has the name of the state and then there's also this new feature in this latest script where you specify what do you want the text to be in the drop-down box for when nothing selected so we create that for the county and we put that in the array and since we want to do multiple Cascades I create another entry for the cities so it tells this is the configuration say how do I know which cities to load and we're telling it to go based on two cities list look at the county field in the cities list and that is how we will do the lookup for the city's field once you build all of these objects and put them into the array you execute this hillbilly cascade function where you pass in your array of objects so if you only want one cascade you could delete just this one and just modify this one object if you needed to have an additional level you could easily just go ahead and copy and paste this and update it for whatever that other cascade should be update the following site assets refresh your page and it will work it is very important when using this script that you make sure you use internal field names where appropriate the display names are appropriate and the correct list names or the script won't execute properly all right so that's all there is to it take a look and good luck thanks [Music]