 Hello. Hi, everyone. Welcome to the Salesforce Learning Bootcamp. And today is day number three. And you can see on the slides, topics are listed. So we'll wait for a few minutes so that everybody join and then we'll be starting. Just wanted to confirm, are you able to listen me properly? And my screen is visible. So can anyone confirm? Am I audible properly and the screen is visible? Yes. Okay. Thank you for confirmation. Okay. So till we are waiting, so like as usual in my session, like initially I just explain concept and then I just give you demonstration. And after that, you ask lots of questions and I try to answer. So I just thought like how to answer as many questions as I can. So what I did, I just went through the yesterday's recording and just I just collected all the questions that you asked. And I just created a document for FAQs, Frequently Asked Questions. So that document I have created and that the document is available with the Excel sheet. So I will be talking about that. So before that, like we are on time now. So I'm just moving to the next slide. So let's complete initial slides and then I will take you there. So this is me. So every day I'm showing this slide so that, you know, like with whom you are learning Salesforce. So I have done lots of research. So a basis on that I'm trying to give you an overview of Salesforce admin and development. So next are virtual learning best practices that you need to know. So as you can see, like every day you need to focus on the live session. So I'm assuming everybody is focusing on live session properly. You can take proper notes for future reference. You are writing down doubts and you are asking in questions and answer part of the session. So that is very good approach. As I suggested, don't miss any session as most of the topics are connected. Still, if you like miss any sessions or recordings are always available on my YouTube channel, so you can just go through. You need to practice each session. So for that I just created a separate practice sheet. So through that you can practice each and every topic. And while practicing the topics, if you face any doubts, so like very few people are asking doubts in the comment section after the session. So post session, if you have any doubts, still you can ask questions. And today I will show you like why it is important because I am now started documenting all the questions along with the answers. Right. So whenever you practice and if you see any doubt, any kind of doubt, just ask that in the comment section of that particular days recording. So I will pick that question and I will try to answer that with the help of document. Keep doing above every day to build strong foundation for a successful career in Salesforce ecosystem. So always remember these best practices. So if you follow all the steps, you will be creating a strong foundation. And session will be divided into two parts like initially topic explanation and demo and then I will be covering question and answers. So this is a gentle request like please remember me in your prayers so that I can run this bootcamp for almost six months. Then follow me everywhere. And at the bottom you can see I just mentioned some prerequisites. So on my channel you will find C, Java, HTML and CSS videos. Those playlists are available. So if you follow those playlists, so that will give you a prerequisite for Salesforce, Apex and LWC development. So many people asked me like we don't know coding so it will be easy for us to learn Apex and LWC. So I just tried to give you an insight like if you go with C and Java videos. So you will be able to understand Apex well because Apex is similar to Java and HTML and CSS are required for LWC. So basically if you go with that, if you have time, so you can just watch those videos from my channel. Okay, so jumping on the topic. So before jumping on the topic, here you can see I have just created one more sheet which is FAQ sheet. And this link is available here. If you click on this link, so you will be able to open the sheet, right? So you can open the sheet and you will find all the FAQs that you're asking in the chat. So I just tried to document all the questions that you're asking. So this link is available with you. Just open the Excel sheet and you can go through with all the questions and their answers, right? Still, if you will be having any questions, so I will be trying to answer, right? So I hope this will help you. Okay, and while you are reviewing these questions and answers, so what I'm going to do, I'm going to create some text fields as per the requirement. So till the time I'm creating those fields, you can just go through with this document and then you can just try to understand the answers, right? So I'm just logging in my org, so I'm already logged in. So what I'm going to do from this data model, I'm going to create all these fields. So yesterday I created name field. So now I'm going to create father name, mother name. So these fields I'm going to create on student object. So I hope you already created these fields as part of practice. So if you have not created, so you can create along with me. Also, like the document which I have shared with you, FAQ document. So you can just go through till the time I'm creating these fields. So first of all, I'm creating text field, which will be for father name. So it will take some time. So be with me. So I'm just trying to create all the fields so that I can show you like how we can arrange those fields on the page layout. And we will be creating some records as well. So I'm just clicking on next. So the field creation step I already demonstrated you. So now I'm just clicking on save and new. So I just created father name. Now I'm creating mother name of type text clicking on next. So first of all, I will be creating all the text type fields. So right now I'm creating text type field. Then I will pick text area, then text text area long and text area rich. Right. So I just created father name and mother name. Right. So I am just highlighting which fields are created. So I'm highlighting them with green. And here I'm changing the color because we'll be changing this color in future. So email. I think I created yesterday. No email and phone I have to create. So I'm just clicking on new. And now I'm going to create phone field. So I'm selecting phone clicking on next. So here I'm creating phone field. Clicking on next, then visible to all the profiles. Then again, I'm clicking on next and save and new. Then I'm creating email field of type email. So those who joined late, like I just created FAQ document which is available here. So you can just open this and go through with all the question and answers that I just collected from yesterday's session. Till the time I'm just creating all the fields. So I just created a father name, mother name. Now I'm creating phone and email. So these are also created. So phone, you can create for type phone or number. So you can pick any. Now I'm just highlighting it as green. Then we need to create age and address. So age will be of type number. So I am selecting number from here, clicking on next. So age. So here you need to focus. Length is available. And if you want to provide some decimal point, like if you want to store value like this 12345678.90. So what you need to do, you need to provide decimal point here. Right. So if you go to the exercise, so here I mentioned this for some of the field. Like if you are creating entrance code, so five comma two. So five, you need to put here as length and two will be putting you will be putting here. But right now, like as we know is doesn't have decimal point. So we will be picking whole number. So here length is 18. So I can reduce it to three. Then I'm just clicking on next. So this field will also be created. Yes. So clash legend, we can create phone field with text as well. No problem. So I just created age. Now I'm going to create next field, which is address and address. I will be creating off type text. And if you have gone through with the FAQ document, so you can just give your feedback. If you have already created all these fields. So this will be motivating me because I am doing all these hard work. And apart from one and a half hour, like one hour 30 minute session, I am daily spending at least two hours to prepare all these documents and exercises, everything for you. So please give me feedback so that I can feel like I am giving you quality knowledge. Then I'm going to create entrance score. So there is one question. Can you please let us know each data type field character length maximum? Okay. So for text, like maximum, whenever you create any field, so it is mentioned here. So for text, here you can see it is not mentioning. So you can put any number. Then for text area, it is 255. Then here it is 131072. And here as well, right? For number, it is 18. Okay. So I was about to create entrance score. So it is off type number. Clicking on next. So I think for entrance score, I just provided 5, 2. So what we need to do here, we need to write entrance score. Then here I am writing 5. And after decimal place, we need to write 2. Then next. So this field will be created. It will be visible. And I am again clicking on next and save and new. So this way, one more field is created. Now I need to create stream, right? So as you can see, I just created text and text area. So before creation of pick list, let's create this text area, text area long as well. So next is career objective. So I am going to create. So I think these fields are not part of this day 2 exercise. It is part of day 3. So right now I am creating this field. So if you are joined through laptop and if you can create these fields with me. So you can just create because I am just creating these fields. So it is very simple. So if you want to create with me, you can go ahead. So next I am creating career objective. So this entrance score I am create, I have created. Now I am going to create career objective. So it will be of type text area. So I am just clicking on next and here I am writing career objective. Then I am clicking on next. Visible. Next. Save and new. So career objective is also created. Then brief bio is of type text area long. So now we will be creating this text area long. So it will allow you to store these number of characters on separate lines. Right. And the difference between text and text area is in text, you can write letters and numbers in same line, but in text area you can enter data in separate lines. And I think text is also having limit is 255. So now I am going to create text area long. So I am just clicking on next and its name will be brief bio. And here you can see maximum length is also available. Then number of visible lines. So this is for UI, like on UI, how many lines you want to, like you want to be visible. So you can increase this as per your requirement. Then I am clicking on next. Visible to all the profiles again next and save and new. So one more field is created, which is of type text area long. Now next I am creating resume. So it is text area rich. So it is important to understand. Text area rich basically allows user to enter formatted text. You can add images and links and up to 131072 characters on separate lines. That's why it is text area rich. So I am just clicking next. So here I am writing resume. So someone is asking we can create 500 fields. So I just provided a document here, like how many custom fields per object we can create. So you can go with this link and you can just explore it. So I am just creating resume and here you can see number of visible lines are 25. So if you want to modify, you can. Then clicking on next. Visible to all the profiles. Then again clicking on next and save and new. So this way this text area rich is also created. So those fields which are highlighted as green, they are created. Then I'm going to create this checkbox which is pass out. So from here I'm going to select checkbox. Clicking on next. And here I'm typing pass out and question mark. So here you can see we have default value. It can be checked or unchecked. So by default I want unchecked. So I am selecting this and I'm clicking on next. Visible to all the profiles and again I'm clicking on next. Save and new. So this way this field is also created. Then we have one more checkbox which is enrolled full time. So this field basically we will be creating so that we can track whether student is full time or part time. So full time means student will study on weekdays and part time means student will study on weekends. So this is a checkbox visible to all profile next and save. So this time I just clicked on save so that I can see the list of fields. So here you can see lots of fields we created and they are available along with their label and field name. So this field name is basically API name. The fields which are created as custom, they are having underscore underscore C. The fields which are standard, they are not having underscore underscore C. So this is backend. Now let's jump to front end. So yesterday we created one application named as Sanjay Gupta Tech School. So I'm going to open this application and here you will find students tab. So if you try to create new student record, so whatever fields we have created, you will see them here. So many are text type. Then we have text area. These are text area, text area long. Then this is text area rich resume, which is having formatting options as well. Then pass out and enroll full time. These are check boxes. So you can just check and uncheck these fields. And you can fill the information and you can store the records. And if you go to existing record, so there also these fields will be available. So always remember whenever you create new fields, so those fields will be available for new records as well as for existing records. So we need to create some more fields. Then I will be showing you how we can manage the page layout so that these fields can be arranged properly because right now all the fields are coming in single column. So we can arrange them in two columns so that they will be more readable. So from here, we created this field as well. Now pick list fields are remaining. So let's create these fields as well. So first of all, I'm going to create stream. So stream values I have already mentioned here. So now I'm going to create pick list field. So after creation of text, text area, text area long, text area rich, I'm going to show you how we can create pick list fields. So we have two types of pick list. One is pick list and one is multi-select pick list. So in pick list, we can select one option from many choices. And in multi-select pick list, we can select many options from all available choices. So first of all, I'm going to create stream and it will be of type pick list. So I am just clicking on new. And from here, I am selecting pick list. So I'm just clicking on next. So punkers, all these fields are available in the Excel sheet. So you can just create them from there. And Excel sheet link is available in the description. And if you can access the Excel sheet, so someone is asking FAQ link. So FAQ link is available in this Excel sheet here. So if you click, so the document will be opened. Now here you can see we have two options while creating this pick list field. So we have use global pick list value set and we have enter values with each value separated by a new line. So if I select second option. So first time skipping. So after explaining pick list and multi-select pick list, I will be explaining global pick list value set. But first we need to understand like how we can manually enter the values. So what you can do if values are available with you already. So you can just copy them. And you can paste them here. Right. Then we have two options display values alphabetically or second is use first value as default value. If you want to use these, you can check them. And then we have option restrict pick list to the values defined in the value set. So for example, if you are loading data from Excel Excel sheet to your Salesforce org. So whenever you are importing data, so you need to make sure for this pick list field in Excel sheet only these values are available if you provide any other value. So that won't be accepted. That's why this checkbox is available here. And you can go through this help text. So enforce data integrative with restricted pick list. The setting limits the field to accept only values from the pick list. Even if the field is updated through the API. Right. And if you uncheck then this pick list field can be like accepting any value. So best practice says you just need to check this checkbox. And then I'm clicking on next. Visible to all the profiles again. I'm clicking on next and save. So this way I created one more field that is stream pick list. So I'm highlighting it as green. Then I need to create Salesforce role. Right. So we have different roles in Salesforce. So for that I'm going to create one more pick list. And again, this will be single selection pick list. So I'm selecting Salesforce. So I'm here typing Salesforce role. Then again, I'm selecting second option. Enter values with each value separated by a new line. Right. So what I need to do, I'm just copying these values from here. Copying them and I'm pasting them here. Right. So this way I just entered value separated by a new line. And someone asked, can we restrict pick list values based on user? So no, we cannot restrict pick list values based on user. Pankaj, we cannot have radio button option in Salesforce. For that you can create pick list. Okay. So people are saying my screen is not visible. So I think for me it is visible like in other system I have opened this. So you can just refresh or check your connection. So now what I need to do, I'm just clicking on next so that this pick list can be created. So it is visible and I'm just clicking on save and new. Right. So I just created this as well. Salesforce role pick list. Now I need to create Salesforce skill set multi pick list. Right. And these are skill sets. So I'm going to select this option. So you can see here we have pick list multi select and you can read the description allows user to select multiple values from a list you define. Okay. So I'm selecting this option. Then I'm clicking on next. So field label is Salesforce skill set. Right. So I'm just writing it here. Salesforce skill set. And again, we need to provide values here. So I'm just going to copy. So you already have the sheet. So you can just copy and paste the values here. So this way it will be created. Then number of visible lines you can set accordingly. And other features are same as single selection pick list. Then click on next. Visible to all the profiles. Then next and save. So this way I created all the fields other than look up. So I just didn't create look up because this will be covered in the next session. And this weekdays pick list through global value set I will be demoing after this topic. Right. So I think most of the fields we have created. Now let's jump to the UI. And I'm going to refresh the page. So here you can see all the fields are available if I go and edit. So this is our resume field. So someone asked me to revise. So this is text area rich field. So in this, like you can do some formatting. So let's say I'm typing name Sanjay Gupta. And if you want to apply some formatting, like you want to increase the text size, you want to apply different font, bold, italic underline. So these options you can apply if you want to put it in center. Then if you want to put a link image. So all these options are available. Right. This is checkbox. Then this is pick list. You can select one option. Then Salesforce role. You can select one option. Then Salesforce skill set. So from here you can select multiple options. Right. Whatever your skill set is. So this is multi select pick list. And you might be surprised. Like I, I hope many of you are related to engineering background. But to be honest, I just graduated with arts and somehow I managed to do M tech later on. So this is strange, but I managed to do it with arts degree and a few diploma courses. So I'm lucky enough. Like I by mistake chose arts in 1112 and did graduation in arts. But due to my interest in programming, I somehow managed to do masters in technology. And now I'm like teaching many engineering graduates and corporate employees as well. Right. So this way I just provided this information. Now I'm just clicking on save. So here you can see this information is saved. Right. If you see the pick list. So here we have one option. And for multi select pick list values are available as a semicolon separated. Right. So if you want to create new record, so that is also possible. So you can just click on new. Yeah. Global pick list value I will be explaining. So just have faith, wait for some time. So here I need to provide names. So let's say I'm providing name as John, then Davis. So I just provided name. And here you can see how text is available. Then I provided father name. Right. Then I just need to provide mother name. So I'm filling all these information. So test at the rate test.com. Then you can provide age, then address, entrance score, let's say 100 career objectives. So these information you can fill. So this way at the time of record creation, you can provide the data. And if you save this, so your record will be created and you can see all the information is available. And if you click here, so you will find three records. Right. Now I'm going to discount. Someone is saying discount field left. So discount is basically on this instructor. So right now I'm focusing on the student object instructor. We will be seeing later on. So this may be your assignment because if you see on the exercise sheet, so I just mentioned it. Create all text pick list, multi-select pick list, checkbox, number, field on student and instructor object. So student, I have created instructor. You can do later on as part of day three exercise. Right. Now one more thing I'm going to show you. This is quite interesting and see it carefully because it will give you more insight of records. So we can add some fields on list views. So here you can see this recently view is a list view, right? Here we have this one field, but if you want to have more fields here, so you can just do. So for recently view, this option is not available. Select fields to display. But from here, if you click on this dropdown and select this all, so you can see these are list views. So if you click on all and go here on this gear icon, right? If you click on this gear icon, so you can select this option. I'm showing it again. You can select this option, select fields to display. So what I'm going to do, I'm selecting email. I'm selecting name of the student. I am selecting father's name and trend score and pass out. Then I'm selecting enrolled full time. So you can select 10 fields here that you can display on the list view. So you can see now this UI is looking much more attractive. So you have lots of information here, right? So this is similar to Excel. Like here you have heading and these are basically fields and below you can see you have rows. So in some of the fields, there is no data so you can easily identify. If you want to fill data from here, you can type, right? So here, like if you fill the data. So if you press enter, so you will see save button at the bottom. You can just click on save, right? So it will be saved and it will be saved on the record detail page as well. Okay, then for each field, you can see this arrow icon is available. Email, then name. This is for sorting purpose. So here you can see we have Vikas, Anna and John. So if I click here, so all three records will be sorted basis on name. So I just clicked, you can see records are sorted basis on name. So this is the additional feature that is available here. So I'm just explaining little bit about list view because we have a separate session on list view if you go here. So we have a separate session on list view that will be on day six. So I will be explaining list view in detail with proper examples, right? So I think this will help you to manage your list view and you can do it for all list view, not for recently viewed. So Subha Reddy is asking how many fields we can add in list view. So I already told you we can add 10 fields. Subham dependent pick list I will be explaining. Global pick list also I will be explaining, right? So I think till here you understood everything. I just created lots of fields which are highlighted as green. These many fields I created and I showed you how we can manage those fields on this list view. Now, if I open any of the records so you can see all the fields are listed in single column. So I'm just going to show you how we can manage them in page layout on like right-hand side as well. So again, I will be giving you brief intro about page layout. In detail we will be understanding about page layout in next like day five session, okay? So we have separate page layout session so there we will be discussing. So right now I'm going to give you brief overview. So you just need to click on this page layout option which is available under student object in object manager. So I am just opening it then I'm going to click on the student layout so it will be opening. Right and if you scroll down so here you can see all the fields are available. So what you can do simply select like you need to click and drag and drop it to right-hand side. Click drag and drop. So your field will be shifted to right-hand side. So now you can see in two column fields are arranged and you can just click on save. Now if you go to UI and refresh so sometimes if you modify the page layout so changes might not reflect immediately. In my case it got reflected immediately but maybe in your case if it doesn't reflect immediately so you can refresh multiple times. So here you can see fields are arranged in two columns and now UI is looking much more better. So there is one question how we can check August sales cloud service cloud. Okay so right now we are using developer edition which provides you for cloud sales service marketing and experience. But if you purchase any cloud application right if you purchase any addition related to particular cloud. So in my first session I showed you you need to purchase a license for that particular product. Okay so I can again show you if you go to salesforce.com so here at top left corner you have products. So if you want to purchase sales cloud so you need to click here and here you can see licensing rates are available. So you can just click on pricing and basis on this pricing you will be able to purchase right. So right now we are using developer edition org which is available free of course which provides you three four clouds. But if you if you want particular cloud org so you just need to purchase that accordingly. Okay so I think till here you understood everything. Now I am moving to next topic which is global pick list value set. So basically we need to understand what global value set is. So if you want to use a pick list in many objects. So for example if you if you want to create a pick list for week days if you want to create a pick list for week days for more than one objects. So instead of creating it for more than one object you can create it as a separate pick list and then you can use that pick list into other objects field. Right so let's understand it with a scenario. So here you can see under student object I need a pick list that is a week days. Right and under instructor also I need this pick list week days. So I am highlighting it with green because I will be creating it. So here I need week days pick list and under student object I also need week day pick list. Both will be having same week days because week days are common. So what we can do we can create a global pick list value set as week day and that we can use in these two pick list under two different objects. So now I am going to show you how we can create global value set. So you just need to go to home just click on home and here you can search for pick list value set. So what you need to search you need to search pick list value set and click on this option pick list value set. So you can just read the description here global pick list value sets. Let you share the value across objects base custom pick list field on a global value set to inherit its value. The value set is restricted so users cannot add unapproved values from the through the API. So here I will be creating a global value set for week day. So label will be week day. Then this is unique name then description if you want then here you can write Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday. So this way I just provided the values and here you can see if you want to arrange them alphabetically you can. If you want to use first value as default value you can if you select these check check boxes. So while creating a pick list on particular object and if you reference this global value set. So through that objects field you won't be control you won't be able to control these two options. Right. So whatever option you select here as global pick list value set. It will be intact for other fields other pick list fields that you will be creating under particular object. Right. So I'm just clicking on save. So here you can see global value set is created. Now one more thing I just want to show you like it is common for global value set as well as other pick list and multi select pick list. If you have created a pick list or multi select pick list either global or local. So after adding some values later on if you want to add some more values. So what you can do just click on you and you can have some value here. Let's say test and if you click on save. So it will be added to your values. Right. And if you don't want to use that value and you don't want to delete as well. So what you can do you can just deactivate. So what is the benefit of deactivate? So for example if in some of the record you have selected this value test. And if you delete so you won't be able to delete because it is already used by some records. So instead of deleting what you can do you can just deactivate. So for existing records it will be available and for new records it won't be available. And this is true for other objects as well. So if we go to student. So under student we created some pick list. So I'm going to open this one Salesforce role. So let's say if you want to open one more role we have six roles. Now if you want to add one more role. So what you can do you can click on new and you can type let's say associate. Then just save it. So this pick list value will be available here at the bottom. If you want to reorder you can if you want to replace you can. Printable view will be available chart color. So you can just explore these values as well. Right now under student I just need to create one new field pick list field as week days. And just see carefully while creating this pick list. I won't be typing any pick list values manually. So here name will be week days. And this time I will be selecting this option global value set. So here you can see options are available. So I'm selecting week days. I didn't select the second option. And here you can see these check boxes are not visible. These are disabled because these are controlled through global pick list value set. Right. And if I click on next so I can select visible to all the profiles. And then again I'm clicking on next and save. Now if I go here and refresh the page. So you will see a week days pick list. And there you will find values as well. So here you can see if I edit. So I will be able to select values. These are coming from global value set. Now if you want to create this pick list for other object. So we have one more object that is instructor. So you can go here. Click on new. Then here I am again selecting pick list. And so this global value set you can use for pick list as well as pick list multi select. So week days then use global value set week days. And rest of the steps will be same clicking on next and save. Okay. So here you can see week days pick list is created. So if I go here and try to create instructor record. So here you will see that week days pick list. So values are available automatically. So we don't need to provide values manually. They are coming from global value set. Right. So this way I hope you understood the use of global value set. Okay. So I'm just checking some comments. What is the use of restrict. I think I already answered. So if you check the restricted check box and you are importing data outside Salesforce. So if your field is having that particular pick list value then only it will be imported. Otherwise not. So Bhanu Pratap. I think I already answered this. Can we add new pick list value by using data loader sir. If you uncheck that restricted, then you can otherwise not. When do we have class daily. So Avula. I think you have this Excel sheet. And in this Excel sheet, you can find dates when session is available. And whenever I schedule, I just provide the link here so that you can join. And I think it is the easiest way. I cannot go beyond this and link of this sheet is available in the description for second object. Can I name different field name? Yes. I said we can name different like we can have different name for second because that is available. So it depends on you. So so Bhanu Pratap. First of all, you need to go to company information so that you can check the license. So from here, you can go to company information so that you can check the license of your edition. Right. And then if you go here and click on view all. So here you will find that particular app. If you purchase sales cloud, so you will find sales application. If you purchase service cloud, you will find service application. This way you can verify. Right. So now I am moving to next part. And today I am seeing less questions. So I think you are understanding whatever I am demonstrating. Then we have field dependency. Yeah. Shubham, we can change the data type of field later. So if you want to change the data type. So what you need to do just to go to particular object and under fields and relationship, let's say I'm opening number type field. So you will find a button. Add it. And here you will find this option change field type. So if you click on this button, so you will be able to change the data type. So I just clicked on that button and here you can see you can select particular data type in which you want to change. So you can just try this like changing a particular field to other data type. And if you face any difficulty, so like after the session whenever you try, so you can post in the comments so that I can answer. So next I am going to explain you about field dependency. So we can just create dependency between two pick list. So let's first understand like what dependency is. So how you can understand. So if you see here under fields and relationships. So just beside new. So one more thing we have available deleted fields. So if you delete any fields, so all the deleted fields will be available under this button. Right. And if you click on field dependency, so you can just set dependency between two fields and this set history tracking, I will be covering in upcoming sessions. So right now let's focus on this field dependency. So right now there is no dependency. So if you click on new, so you will be able to create the dependency. But before creation of dependency, you can just go through with this description. So we can create a dependent relationship that causes the value in a pick list or multi-select pick list to be dynamically filtered based on the value selected by the user in another field. Right. So we will be having two fields. One will be controlling and one will be dependent. The field that drives filtering is called the controlling field standard and custom checkboxes and pick list with at least one and less than 300 values can be controlling fields. So this is the criteria. Right. So this is the criteria that you need to remember. So on controlling side, we can have custom as well as standard checkboxes and pick list only. And on the dependent side, we can have custom pick list and multi-select pick list only custom. We cannot have standard. Right. So here I'm going to select Salesforce role as a controlling field. And as a dependent, I am selecting Salesforce skill set. Right. So I think I mentioned this here as well. So you need to create field dependency between Salesforce role and Salesforce skill set fields. Right. So I'm going to create it. So controlling field is Salesforce role and dependent field is field is Salesforce skill set. Now I'm just clicking on continue. Yes, we can recover any deleted field as well. Okay. So now just focus on the screen carefully. Just focus on the screen carefully. We have controlling field as Salesforce role and we have dependent field as Salesforce skill set. So now I'm going to match it. So admin admin is the role. And from skill set, we need to select like whenever from Salesforce role pick list if I select admin. So what skill set you want to show in this skill set pick list. Right. So you can just click. So just click and include value. So it will turn into yellow color then data security include if you want to include multiple. So just click and drag and select then include values. Anytime if you selected wrong value, like if you selected test class, which is not part of admin role. So you can just exclude it as well. Right. So just click and exclude values. So here I am selecting smart sheet. Then you sit chart and G suit. Right. These values are selected for admin for developer. I am selecting all these values till here. Then for QA, I am selecting admin things. I am not selecting flow. And I am selecting these two and these two. Right. So it is purely customizable. It will depend on the requirement like which field you will be selecting. Then for business analyst, you can select these and these two. Okay. I just need to click here. So here I'm not selecting Lucid chart and G suit for architect. I am selecting all these things, everything. And we, we right now here we are viewing one of five. We have two more. So you just need to click on next. So you can see two more project manager. So for project manager, I just want this two and this two. And for associate, I just want these four. And let's say G suit as well. Right. Everything is available here. Now you can just click on preview. So we have preview button. If you click on preview button, so you can just test it. Otherwise you can simply click on save. So this way I created field dependency between those two picklists. Right. Now if you click again on field dependencies. So here you will see this. Controlling is Salesforce role and dependent is Salesforce skill set. Right. Now what I need to do, I just need to go to the UI going to students. And here I'm going to do refresh. So whenever you apply some new feature, you just need to do refresh. And I'm just clicking on new and trying to search. So here you can see we have this option available view all dependency. Right. So if you click here. So right now you can see in Salesforce skill set, nothing is available. If I select admin, so whatever we selected for admin, those are available only. So apex trigger, those are not coming. If I select developer, so you can see apex trigger. Everything is coming here. If we select associate, so only four, five options are available. Right. Now you might be thinking why this view all dependencies is available here. So it may possible like your controlling and dependent fields are available at different places on the page layout. And you may be having more than one dependencies. So how you can identify which is controlling for which dependent. So you can just click here and you will see all the dependencies here. Right. So if you are clicking here under this. So like if it is controlling or it is dependent. So it's controlling and dependent pair will be available here so that you can test it out. Like Salesforce role is controlling and Salesforce skill set is dependent. Right. So this way you can apply this you can choose and you can save the record. Right. So this way we can create field dependency. So I just created field dependency between these two fields. I created between Salesforce role and Salesforce skill set. Now I'm going to show you how we can do it for checkboxes. So we have enrolled full time checkbox and week days pick list. Right. So controlling will be checkbox and enrolled full time and dependent will be week days. Right. So this I'm going to show you how we can do that. Right. So again I just need to click here field dependencies clicking on new then from here I am selecting enrolled full time and dependent I am selecting week days. So what is the idea behind this requirement? So if enrolled full time checkbox is checked it means student is full time. So student will be available on week days Monday Tuesday Wednesday Thursday Friday. If it is unchecked then your dependent field week days will be having only Saturday Sunday. Right. If it is unchecked so I'm just clicking on continue. Now if it is unchecked so I want these two values to be included and if it is checked I want these five values to be included. Right. And I'm just clicking on save. So it is saved now if you go to field dependencies so you have two dependencies now. And if you go to the UI and so let's let's create a new record. So here you can see now we have four. So under this checkbox we have dependencies under this under this under this. So if I click here so it's controlling and dependent will be available. So it is unchecked so you can see Saturday Sunday is available. If it is checked you can see Monday to Friday is available. So this way it is happening. If you if you click here so it's controlling and dependent will be displayed. So this way you can find the pair. So right now we have four dependencies so it is very difficult to identify so you can just click and you can find the pair matching pair. And like right now this checkbox is unchecked. So here you can see two values. If you check it so you will be finding all five values. Okay. So this way you can test it out. Okay. So I think this field dependency is also clear to you. So Abhi is asking can we recover deleted fields by just going on the object click field and relationship on top. There is a button deleted field from there we can recover. Yes. So answer to your question is yes. So I am just taking more questions. So Radha Krishna asking can we attach document as well in rich text. So answer will be yes. Yeah. So Salesforce tutorial asking can can also explain how to access field on account to opportunity by formula. Yeah. So cross object formula I will be explaining so that I will be explaining with the help of project. Can you change any pick list value on standard object. Yes. We can add pick list values on standard object Mary. Can you provide which field is possible to change up to which field sir. No. I don't have any document for that. So you just need to try like if you click on change field type then you will be able to identify. Can we recover any deleted field years. Abdul is asking sir provide handwriting notes. So I think I am already doing everything for you. So I cannot write handwriting notes. So if I do that I think I will probably die. So like I'm creating these slides it will take some lots of time. So I cannot go for handwriting notes. You can do that. So always deployed for dev.com. Just please ask relevant questions. We are expecting in depth of apex and LWC or aura please do in a same way. So this month I already told in the day 0 like everything will be explained in detail and with this Excel sheet I can I think you can identify like everything will be explained detail and this is third session and you can see I'm explaining in the same pace and if I will be explaining on day 100 same pace will be there. I will be that much motivated. So I just want your support. So please stay with me and have trust on me. When you create pick list. When you create pick list you can add values. Yes. So field dependency completely understood which field is possible to controlling. So so for this I just showed you so whenever you create new. So just just read this article which is available here. It will answer your question. So just read all all these things. I think you are not reading all these articles. These are important. If you read these articles you will be able to understand everything. Yes. So Neil I will try to explain integration as well. And I think clash legend and Vishal they are smiling on my joke like on handwriting. I think so. So I think we completed one session. So I am just going to explain one more thing that is schema builder. Right. And I just planned formula field and validation rule as well. So I will be taking those topics to next session because like in today's session I don't think it will be able to complete. So let's understand schema builder. So yesterday there was lots of questions regarding schema builder. So now I'm going to show you. So basically schema builder is used for few purposes. If you want to see your object on the UI like how graphically they will be available. So you can just have a pictorial representation. And if you have relationship between your objects then also you can use schema builder. So right now you can see most of the objects are selected. So what you can do from here you can select clear all. So all the objects will be cleared from this canvas. Then here we have options like all selected standard custom and system. So I'm going to select custom objects. So we have to I am selecting them. And if I click here so you can see these two objects are available here. So this way like if you want to demo your schema like whatever objects you have created what all fields are available there what what are data types which are required. So here you can see red lines are required. So we have legend here. So this way you can understand. So you can take a screenshot of this and if you are interacting with clients. So your Salesforce object data model your Salesforce data model you can easily explain with the help of this right. So this is the first purpose then second purpose like in next session next Monday. So next session will be on Monday like tomorrow is holiday national holiday in India. So I won't be taking session because of long weekend. So if you see this legend so here we have two relationships look up and master detail. So on Monday we will be understanding these relationships. So if you have relationship between your objects so those you will be able to see in this schema builder then if you want to create fields so that is also possible. So I think from here you can create object as well as field. So let's create one field. So I'm going to create. Let me check what all fields are available. So here on instructor we don't have name field. So I'm going to create this name field on instructor. So what I need to do I just need to drag and drop this text here and I can select this information field label field name then I can enter length and other information and then click on save. Right. So if I refresh so this way here you can see name field is created. Right. So this is the first use of schema builder like if you want to create any field that you can create from here and if you want to create objects so that is also possible. So you can fill this form and if you click on save your object will be created and you can auto layout then view options so you can display element names. So here you can see student underscore underscore C instructor underscore underscore C if you toggle so it will be showing label. Okay. So right now it is showing label. Then if you want to hide relationship then you can if you want to hide legend so legend is available on right hand side so if you want to hide this legend you can. Okay. So and if you want to close it then object selection I already told you you can search as well you can select all clear all so these options are available with schema builder. Right. So I think now you can understood the difference between schema builder and object manager so I think object manager is more useful because through object manager we can do many things beyond the schema builder but for graphical representation of objects their relationships so after creation of relationship we can again go with schema builder and we can just check like how objects are related so for that purpose you can use schema builder right and okay one more thing we need to do like we need to create standard and console navigation apps so yesterday what I did I just created standard application so here you can see we have the standard application so someone asked me like for custom objects can we create it can we create console navigation as well so answer will be yes so what you can do you can just go to home and here you can search for app manager and from here you can select new lightning app so I'm just typing abbreviation of Sanjay Gupta Tech School and typing console s gts console and quickly I'm going to create it so I'm just clicking on next and from here I'm selecting console navigation someone asked like what is setup and personalized so basically we have two type of setup if you want full setup while opening the app so you can select first option if you want just service setup you can select second option so always go with full setup then next and yesterday I use this utility item but I was I just forgot to show you so if you go here so at the bottom left corner you can see we have this chatter feed so this is basically your utility item so if you want some items to be available here so that you can access them quickly so these are basically your utility items which are available bottom left corner so right now in this application I'm not placing any utility item it is optional then clicking on next so I'm just adding student and I'm going to add instructors and then I'm clicking on next so navigation with a why it is showing this there is some issue it is not allowing me to go next okay we need to select one more option we didn't select navigation so I don't see any option here so it is saying navigation rules determine whether to open a related record and additional to the primary record you haven't selected any navigation item for this app so friends like I just need to review this so maybe next session I will get back to this problem because I don't see I just need to research it right so I will be explaining you later I don't see any option here that I can select let me see if it is available here no okay so this this this slide I'm just skipping as of now so this will this we will be covering in the next session so today I thought like I will be covering formula field and validation mood so this I will be covering in the next session right so this is all for today now I'm just taking few more questions so Mary you said like you don't feel confident about schema builder so you can just go through and maybe the questions you can just paste in the comment section of the video and then I will try to answer those so those those who just understood everything they can leave like today's session completed and next session will be on Monday right Monday same time so I'm just going to pick more question how can we know if that if what case we need to choose so umka hope this this will be decided by the architect of your project and which which pick list you need to use global or local yeah so Avula I will be explaining formula field and validation rule in detail yeah and the next session will be on 30th January we need to put page layout to see in detail page yes so nasir page layout is already placed if you want to modify you can do but it is already available is it possible to control pick list values particular profile or user no so Neil if you want to do donation so on each video like you will see super option so through that you can do if you if you want to like buy me a coffee so you can just pay through that but it is optional so I won't promote it if we created anything on schema builder as it is it reflected on you I yes whatever we will be creating like field or object from schema builder so it will be reflecting on you I but you need to make sure whether it is added to the page layout or not so what you can do just create a field from schema builder then check you I if it is not available then to the page layout and then it will be available so let me just show you that thing so if I go to the instructor so I just created name field so let me see whether it is available or not yes so it is not available I am just refreshing the page so that we can see yeah it is not available so what you can do just go to object manager and then search for instructor and here you need to go to page layout and under page layout you need to check whether name field is added or not no so here you can see this name field is highlighted so if you create field from schema builder they are not added to page layout directly so what you can do just click and drag and drop it to the page layout then it will be added and save it right thank you with the for trusting me so clash legend we don't use schema builder much it is for just having a graphical representation of your objects pick list value for STD and custom object but global pick list only for custom object only am I right yeah you can use global pick list on standard objects as well Karthik Swati hello so Abdul no worries but it will be difficult for me to write notes so you can just watch the recordings and you can just create notes yourself so Suman we will be using data loader then I will be explaining you okay so we have lots of questions so what I will do I just showed you like I have created this FAQ document so I will just go through this recording and I will try to pick the questions because I just want to have have question and answers both collected so I will be picking all the questions and I will try to collect questions along with answers and link of this document is available here in the sheet and from now onwards I will try to put this FAQ sheet link in each video description as well so that it will be easy for you to have that okay so I am giving you two three minutes if you have more questions so you can just paste in the chat so that it will be recorded otherwise whenever you watch this recording for practice so in the comment section you can pose the questions and in this exercise sheet you can see day 3 task is available so just go and explore everything right now I have not explained these things so I am just removing this from here so it will be day 4 right so you can just ignore this okay so this much you need to complete and this console application like I will be explaining at day 4 right so no need to worry whatever like we have completed till schema builder so I will be starting with this console navigation app then we'll try to cover formula and validation rule and topics and accordingly I will be updating this sheet as well so I will be shifting formula and validation rules from here and I am going to paste them in the next day topics right so this is updated so that you can keep track so I think you have everything so just like follow me whatever I am explaining so if you have more doubts whenever you will be watching the recording you can just post and if you want to learn development so development will be starting I think in March so you have almost one month so you can just learn Java C HTML and CSS basics from videos those are available on my channel so that you can have a base for learning apex and LWC I will be explaining them in detail from the beginning but if you have some basic knowledge so it will be good for you so all those recorded videos are also in depth explained like I am taking this live bootcamp so you can go and just create a base for you so thank you everyone just enjoy long weekend thank you for believing in me and joining these sessions on daily basis and please spread the word so that many people can attend these sessions and they will also be benefited thank you everyone