 Hello friends. I am Sanjay Gupta. I welcome you on Sanjay Gupta Tech School. In this video I am going to cover these three points. So I will demonstrate you how we can create pick list as both controlling and dependent field. Second point is pick list as controlling and multi select pick list as dependent. Then third will be checkbox as controlling field and pick list as dependent. So before starting, let me share you how you can watch Salesforce related video series. You can search my name on YouTube. So you can watch that sees on my YouTube channel. Now, first I'm going to open the app that is my university in new tab. And here you can see a book tab is available. If we click on new, so we will see some pick list and multi select pick list are available. So we have category pick list, then we have available in the authors country and then available in which country. So first I'm going to demonstrate you this point pick list as both controlling and dependent. So controlling will be pick list and dependent field will also be pick list. So I'm going to make this category as controlling and authors country as dependent. So right now you can see for all these categories, all these countries are visible. So now I want to show limited country names for particular category so that we can create controlling and dependent thing. So now I'm going to search for book object here I'm searching for category. So here you can see the option field dependencies. So you can click on you. You will see these two options controlling and dependent before the this. Let me share this detail with you. So here you can see some text is written, which is saying create a dependent relationship that causes the value in a pick list or multi select pick list to be dynamically filtered based on value selected by the user in another field. So now it says the field that drives filtering is called the controlling field that we need to select from here. Then further it says standard and custom checkboxes and pick list with at least one and less than 300 values can be controlling field. So standard and custom checkboxes and standard and custom pick list can become controlling fields. So you can see multi select pick list cannot become controlling field. Then next point says the field that has its values filtered is called the dependent field. So that we can select from here. Then custom pick list and multi select pick list can be dependent fields only. So only custom pick list and multi select pick list will become the dependent fields. So standard pick list and checkboxes will not be dependent fields. Then it is saying under steps. Select a controlling field and a dependent field click continue when finished. On the following page, either the filter rules that control the values that appear in the dependent field for each value in the controlling field. So now I'm selecting category as controlling and authors country as dependent. So here we have four values in category, computer, English, IT and maths. So computer idea technical and English maths are non-technical. So for computer, I'm selecting these four values, Australia, China, India and Spain. So if you click on this computer, so it will select all the values. So here you can see after selecting, you can click on include values. So you can see this legend biker is showing excluded values and yellow is saying included values. So these four countries are included for computer. Same I'm doing for IT. So this time by pressing control, I'm clicking on the countries and then I'm clicking on include values. So these four are included for IT as well. So for computer and IT, these four values will be available. Then for English, I'm choosing these and formats also. So for computer IT, Australia, China, India and Spain will be displayed. For English, Sri Lanka, UK, USA and Japan will be displayed. I'm clicking on save. So again, if I search for category, open this. So this time you will see field dependencies. So this is dependent on this field. And if we see authors country, so here you can see it is showing controlling field. So authors controlling, sorry, authors countries controlled by category. Now I'm doing a refresh clicking on you. So here you can see right now you cannot select author, you cannot select authors country until you select category. So if I select computer, now it is visible and we can select only four countries that we selected by creating dependencies. So Australia, China, India and Spain for country. So sorry for category computer. If I select IT, same values are displayed. If I select English, now you can see different set of values. If I select maps, you can see different set of values. So this way this category is controlling pick list and this is dependent pick list. Right. If you click on this view all dependencies. So here it is showing. So it will show only dependencies here. So you can see and check these. Right. So now further, I'm going to control. Available. Sorry, I'm going to control this one available in with this category. You can see available in an available in which country both are multi select pick list. So now we are going to fulfill this criteria. Pick list as controlling and multi select pick list as dependent. So again, I'm searching for category. This is a pick list. It will be now controlling multi select pick list. So again, I'm clicking on new. So from here I'm selecting controlling as country. And dependent as available in. So again, for this computer, I'm selecting online stores and details. Clicking on include values. Then let's say for it selected all now. I want to only exclude this library. So I'm pressing control and clicking on this. So it is excluded and I'm including this. Now for English. I'm just including library. For Max also I'm including library. Now I'm clicking on save. So English will show this option and computer will show these two options. And if you want to increase options. So let's say I'm including this also. I'm including this library and retail store for Max library and online store. So this way I'm choosing these values. Right. Now, if you want to exclude any selected value, you can click on that. And you can click on exclude values as well. So this will be excluded. Right. And here descriptions are also written. So you can read this to control these things. So now I'm clicking on save. Right. And again, I'm opening this for reference so that we can compare. So this we have selected. Now I'm doing a refresh clicking on new. So now you can see you cannot select available in as well as authors country because both are dependent upon category. As I select a category, both will be available for selection. So for computer only two options are available online store and retail stores. So let's see what we selected for computer. We selected online stores and retail stores. So both options are available here. So you can choose one or more than one. And here this authors country is available if I select Max. So it is showing library and online stores. So for Max, we selected both the values. So it is working fine. Now, if I click on this view all dependency. So this way it is showing. You can select computer. So it shows this and this. So both authors contain available in us are dependent on this. So this way it is showing dependencies. Right. So I hope you understood both the points how we can. Control a pick list and how we can control and make multi select as dependent. Now we need to do this checkbox as controlling and pick list as dependent. So for this, I have to create. One checkbox field. So I'm going to create a checkbox field. That will control. Pick list. So its name is. Our label is technical category. So right now it is unchecked. Clicking on next. It will be visible for all the profiles. It will be available on the layout and I'm clicking on say. So now if I refresh it. So this checkbox will be available on the layout. So here you can see it. So now I'm going to modify the layout so that I can place it near the. Pick list that we are going to control. So, so we are going to control category pick list with this technical category checkbox. So now if I click on new. So you can see a checkbox named as technical categories available just before category. So now if you check this checkbox, I want only computer and it should be available here. If I uncheck this checkbox, then I want English and math should be available here. So now I'm opening this checkbox field. Here also you can see field dependencies. So I'm clicking on you selecting technical category checkbox as controlling field and category is dependent. So through checkbox, we can only control pick list, not multi pick list. So it will not show multi pick list or field as dependent. So for unchecked, I want English and maths. So I'm including them for chat. I want computer and IT. So I'm including them and clicking on save. So now you will see if checkbox is unchecked. Then only English and maths will be displayed. And if it is checked, then computer and IT will be displayed. So here you can see by default it is unchecked. So only two options are available. If it is checked, then these two options are available. And if we click on this, so it will show the dependencies. So if I here, you can see technical category. If it is checked, then computer. If I select computer, then I can choose these two. So this way it is working. So you can see all the dependencies here and you can choose options and find out which field is dependent on what. Then after selecting values, you can apply. So they will be available here. And you can click on save. So I hope you understood all these three points, how we can make a particular field as controlling another as dependent. So I hope you understood whatever I demonstrated in this video about field dependencies. If you want to watch more Salesforce related videos and video sees, you can search my name on YouTube. So thank you for watching this video.