 Hello, hi everyone. I am Sanjay Gupta. Welcome you on Sanjay Gupta Tech School. So you can see today we are going to start admin project. So till now I have delivered total 15 sessions to you. And this week we will be summarizing everything, whatever we have done so far, right? With the help of a project. So this will be end-to-end project and we will be creating lots of stuff together. So I'm just waiting for more folks to join and then I will be starting today's session. So if you want, like your friends, colleague wants to join and if you want to remind someone, so please do so that they can also try and implement a project from the beginning, right? So I have prepared a document for you and after three, four slides, I will be sharing that link with you all so that along with me you will also be able to implement, right? So once again, hi and welcome to everyone. Okay, so moving to next slide. So this is me. I hope now most of you very well know me. Like who am I? What is my experience? So maybe few folks are new because in this week we are going to discuss about a project. So if you don't know about me, so you can just go through this slide and I'm running Sanjay Gupta Tech School and like right now I'm running Salesforce Bootcamp, which is for admin and development. It will be for six months started in January. It will go till June 2023. And while I'm delivering this bootcamp, so I'm planning to do sessions related to other stuff as well. So maybe I will be soon sharing with you information related to other bootcamps that I am going to launch on my channel and few will be delivered by me and few will be delivered by other folks as well. So I'm going to build a community of content creator and like content deliverable so that who wants to teach beginners. So they will be joining me and they will be delivering whatever knowledge they have, right? So moving forward, so like you can see as I promised you in January, I think I took day zero session on 17th of January and I promised you like week by week, day by day we will be going to cover things. And as per my promise, you can see we completed week one with admin concepts week two again with admin concepts. Then in week three, we completed reports and dashboard. In week four, we completed data security and data loader data import wizard. In week five, we discussed about few more admin concepts like approval process and other. And right now we are in week six where we will be going to understand how we can collectively implement all these things we have learned so far, right? So that in interviews, you can say like you have implemented a small project. It is not a big project. It is not related to any organization. It is not related to any client. It is a generic project. And after implementing this, you will get to know lots of things, right? So moving forward, again, I'm sharing this slide with you so that like if you want to share information with other people. So please do and ask them to follow Sanjay Gupta Tech School on different social media platforms. And if you want to ask questions, you need to subscribe the channel, right? So these are the information that you can share with others. Okay, so now I can see like more than 100 folks have joined. So this is good. And I just want to share with you like in each of the session, more than 100 concurrent viewers were there, learners were there. So I every day, like whenever I deliver a session, so I feel very happy, like due to my efforts, I'm able to build a community where beginners are learning Salesforce. And I can see on Telegram channel, people are discussing doubts. So please help each other so that you can learn and grow and get a job. And I'm always with you with my knowledge so that I can support you, right? So moving forward, now I'm going to show you a project. So first I will brief you and then I will be sharing the link with you so that if you are on laptop, so you can also implement steps with me. Because in today's session or like in this week's session, I won't be discussing any concept, everything you already know. So I will be implementing each and everything step by step, right? So you might see like things are like taking time. So if you know things already and you want to implement those things with me. So I will be sharing this doc link with you and you can also implement this with me. And if you just want to view and you want to implement it later on, so that is also possible, right? So as I told you, like our project will be based on recruitment app. So first I'm going to discuss about the recruitment app with you. So here you can see end-to-end diagram is available where we will be implementing all these objects. So first of all, you can see there is one object which is known as user. So in Salesforce, user is standard object. Here STD means standard object. Then we need to create position object, then job application object, candidate object. Then these objects will be having few related lists. Those are available here. Then we have job posting, review, employment, website object. So total six objects we will be creating along with lots of fields, records, and we'll see everything that we have learned so far, right? So here you can see, first of all, we need to create an app that is named as recruitment. And before implementing, then going to share this link in this exercise sheet so that it will be available with everybody. So in my opinion, it will go from day 16 to 18, right? So day 16, 17, and 18, we will be doing admin project. So link is available with you. So you can open this document and you will be on this document, right? So please open it with me so that we can implement it together. So what I'm going to do and like what I'm going to do, I will be implementing these steps one by one and I will keep an eye on this YouTube chat. So if you have any question, you can ask, otherwise you can just log into Salesforce org and you can start implementing this project with me, okay? So now I'm going to create application and like if you have any doubt, you can just ask, otherwise I'm implementing and we'll be keeping an eye on the YouTube chat. So first of all, I'm going to implement the application because if we have app created, then only we can place certain objects. Those are created in form of tab in that application. So moving to Salesforce org. So here we need to go to setup and I'm clicking on home. So here I'm going to search for app manager because if you want to create an app, so we need to click on app manager. And again, remember like this is a complete revision of 15 days stuff that we have learned so far, right? So if you missed any sessions, so this week will be very important for you. So I'm clicking on new lightning app so that I can create new application. So here I'm just zooming out, cancel. Here I'm writing app name as recruitment, development, developer name will be recruitment. If you want to write any description you can do. And here if you want to upload any image for branding purpose, you can you can change the color theme. Okay. So in my org, it will look like this. Then I'm clicking on next. So here you can see initially we discussed like we have two navigation styles. One is standard navigation, one is console navigation. So both are available here. And if you want to select supported form factors, so all the options are available. So I'm going to do standard navigation, right? So Raghu document is available in the exercise sheet. If you go here, so here you will find this link. So just click on this and you will be able to open this page. Right? So I was creating this. Now I need to click on next. Then right now I don't need to put any utility items. So I'm just clicking on next. And here I am just adding home page, right? Because other objects and tabs I have not created. So right now I'm just adding home page here and I'm clicking on next. So make sure to add system administrator profile here. If you add your system admin profile, then only you will be able to access this application. Then click on save and finish. So we completed first step so that our app is created. Now if I go to front end and in the app launcher, if I want to open my application, so it will be available. So I'm going to search for recruitment app and you can see it is available. And right now in this application, you can see only one tab is available. That is home. So now after creation of this application, we will be creating object. Then we'll be creating a tab for that object and then few fields. So the link of the document is available in the exercise sheet. So let me just copy and paste this link in the chat so that you can have it. So I just pasted the link in the chat so you can have it from there. Now I'm on step number two. So okay, Nikhil, I'm going slow and please let me know like if you are doing with me or not. So if you are doing with me, so please type yes so that I can go slow. So I just completed step number one and right now I am on step number two. Okay. So Ram is asking something. I don't know about this. So if somebody knows, please help Ram. So now I'm going to create this object. So here you can see object name is position, right? The object which I need to create this object name is position. So I'm going to create it. So moving to object manager. So yeah, I can see many of you are saying yes. So I'm happy like you are implementing it with me. So under the object manager at top right corner, you can see this create option is available. And I'm just going to click on custom objects so that I can create custom object. And from here, I'm going to paste the label. So I just pasted label as position plural label will be positions. So I'm pasting it again and adding s. Then unique name is position. If you want to put any description, you can otherwise it is optional. Now here you can see whenever we create any object. So we need to create a field and feel field name. We need to provide and along with its data type. So if you go to the project document, so here you can see name field data type is text. Right. So here it is by default text and record name is by default position name. So you can leave it as is. Don't do any changes here. Leave it as is. Then if you want to allow reports activities track field history. So I hope if you have attended all previous sessions, so you can relate what is report, what is activity and what is field history. So I am enabling all these check boxes because in future on this object, I will be creating reports. I will be enabling activities. I will be enabling field history. Right. So these three options I am enabling rest time leaving as is. And at the bottom, you can see there is a checkbox which is to launch new custom tab wizard after saving this custom object. So in initial days, I told you two different ways to create tab. So one is this, like if you enable this checkbox. So automatically after object creation or tab will be created. And another option is like in setup. You can search for tabs and from there also you can create a tab. So I'm just clicking on save. And from here you can see position object is already available and I need to select the tab style. So I'm just clicking on this button. And from here I'm selecting trophy as tab style and clicking on next. Now here we have three options default on default off and tab it in. So I'm selecting default on and for all the profiles. So remember in this project, we will be creating different profiles and permission sets as well. And at that time, we will learn like how we can control these things. Right. So for now I'm applying one tab visibility to all the profiles. Right. That is default on because I want to place this tab on navigation bar. So if you want to place your tab on navigation bar, you need to select default on. So I'm just moving to next. Now this is important. So here what you can see it is showing list of available apps and asking to choose the custom apps for which the new custom tab will be available. You may also examine or alter the visibility of tabs from the details and added pages of custom apps. So right now what we need to do we need to select recruitment app where we need to place the app. So right now all the check boxes are checked. So I'm unchecking them and I'm going to search for recruitment app and in my system it is available at the bottom. So I'm going to select this checkbox which is for recruitment app. So you can see I just selected for recruitment app. So it means position tab will be placed on the recruitment app. Right. So I'm just clicking on save. So this way my tab is also created. So till now what I did I just created recruitment app. I created position object and I created its tab. Okay. So few folks are saying like it is too fast. So yeah. So I'm assuming like you all know these basic things. So that's why I just created it fastly. So now I'm giving you enough time just implemented and here I'm going to just show you like what fields are created and I'm going to refresh my app so that I can see positions tab. So here you can see under recruitment app to tabs are available home and positions. Right. So I just completed step number two and step number three. I created position object and here you can see I created positions tab as well and it is added to recruitment app. Okay. So Pooja is asking when I will be starting development. So this week admin project is going on next two weeks I will be focusing on flow. So flow is also included in development part. So you can consider like from next week I will be starting the development. So someone is saying like I'm not audible audible. So is it true? So there are some questions. So a per night saying in real time project who gives all details in clearly so basically architect and tech lead gives all the information related to project that you need to implement. Yes. We will be completing all the topics that we have covered so far. Okay. Thank you. Thank you. Okay. Let me check if I can increase. Okay. So I think while creating recruitment app. So let me just show you this again. So what you can do just go to app manager search for app manager and you can add it your application. So I'm just searching for recruitment app. So what you can do you can just add it your application and there you can verify whether you have added correct home tab or not. So here you just need to click on navigation items and just verify whether you added home tab having this icon. If yes, then it will be available. Otherwise not a cool is asking like user stories. So user stories will be provided by a business analyst or maybe architect. Yes. Ashwini the this admin project which we are implementing right now it is a complete project. So we just started. So have some patience and implemented with me and once few points or steps we will be completing then you will get to know. Okay. So I already shared the link with you and like virtually I'm implementing. So maybe few folks are ahead few are behind. So I'm going to implement each and everything step by step so that you can understand right now we need to implement fields on position object and I think field creation is the easiest task. So you can just copy this label and just see the data type and quickly create all these fields. Right. So Manisha I think there is some issue at your own at your end because most of the folks are able to listen properly. So now I'm going to create fields. So moving to recruitment. Sorry. Moving to object manager and I will be opening the position object. So under fields and relationship I'm just going to click on new. Okay. So we just need to select text area long. So here text area long for first four fields we need to select text area long. So I'm going to select it and clicking on next. So I think everybody is comfortable with field creation. So I'm creating in my org. So you are you are working in your org so you can just create and length visible lines. These you can just decide as per your own requirement. So I'm just clicking on next. Then I'm selecting visible to all the profiles for all the fields I will be selecting later on when we'll be configuring profiles and permission sets. So we will be doing some changes. So I'm just clicking on next. So now if you want to create back to back fields. So what you need to do just click on save and new and then select next responsibility. So this will be quick implementation now. So again select text area long then click on next. Then type the field label as responsibilities then leave everything as is then again click on next. Then click on visible to all the profiles then click on next and again click on save and new. Right. So now I just created two fields. So you just quickly implement all the fields. Till then I am just taking few questions which are available in the chat. So Ananya flow will take around two weeks or maybe more because I am covering everything in detail. So I just planned two weeks as of now if it will be taking three weeks so I will go three weeks as well. Akshay no this type of document won't be available. They will be providing you the stories and built tasks through a software which can be Zira or any other software. So this I created for beginner purpose so that everything will be written clearly and easily so that if you are implementing something so you should know but in real time projects it will be in different way. Yes Vishal I will be doing it fast because it is just starting so I just want everybody like have insight so that everybody can start. Varun actually OWD information is available at the end of this document. So right now what you can do while creating fields you can just select for all the profiles. Pooja coding is not available in admin part. So Ashish right like if you are implementing if you are developing something so you can say like you build tasks if you are testing already build tasks you can say like you are testing if you interact with clients to gather the requirements so you can say you are working as a business analyst. So it depends on what type of task you are doing. Okay Tripti I'm happy that your home tab is visible. Ashvini is asking so in the project we will be implementing admin development and WC in the same project I will try to do so. So in this admin project I will try to plug flow and apex and we'll try to have some LWC stuff as well. So I'm here I would suggest like in your personal org if you do practice so that will be better. Vishal we cannot clone the fields marry yes many things to do because that's why it is a project. No need to worry because I am with you in every step. So I just stopped to implementing so I'm just answering questions then I will be quickly implementing all the fields. Yeah so Asit whenever we create fields so at the time of field creation what type of permission you want to give to your profile so it is asked so you can just select all visible to all the profiles. Thank you Ashvini Vamshi I will try to have admin sorry development related stuff in this project. So right now don't focus on development. I will be covering each and everything in detail. No no need to worry. Everybody is asking so I will try to plug some development stuff in the same project so don't worry. Okay Manisha happy that you are able to hear. Okay so Simi is asking how to create C sharp checkbox so this is basically C hash so what you can do you can write like label you can write as C hash and API name you can write as C underscore sharp. So I just typed it in the chat so you can write API name as C underscore sharp. Okay now I'm also going to implement this quickly so now I'm going to create this third field that is still required so here I just I'm just going to select long text area long then I'm going to paste it so it will be created next then I'm going to select visible to all the profiles again next then save and new then I'm going to copy next field so I'm going to create text area long then again clicking on next so here I'm going to paste it educational requirement clicking on next visible to all the profiles again clicking on next and save and new right so four fields I created which are related to text area then we have two currency so I'm creating min pay and here here seven comma two is written so just see like how I will be creating them so I am going to select currency from here I'm going to create currency field and clicking on next pasting min pay so here you can see length is seven 18 so I am writing seven in length and decimal place will be two so this is the meaning of seven comma two then I'm clicking on next visible to all the profiles clicking on next then save and new next field is max pay right so I'm going to create this field so it is also of type currency okay so max pay again here I'm writing seven and decimal point will be two next visible to all the profiles again next save and new right so this way I just created six fields now I need to create these checkboxes which are very easy so travel required so you just need to select checkbox from the data type click on next so here you can see we have two default values checked and unchecked so by default it should be unchecked right so travel required then click on next visible to all the profiles again click on next save and new right so we need to create one more checkbox that is for Java so I'm just creating it now so meanwhile I'm creating this if you see any comment in the chat and if you know the answer so please help because if I do both it will take lots of time so please help me so I'm just selecting visible to all the profiles clicking on next and again I'm clicking on save and new and those who are showing gratitude by super chat thank you for that thank you to them I will surely buy coffee this weekend so next is JavaScript so again I'm going to create a checkbox clicking on next so again you can see default value I'm leaving as unchecked clicking on next visible to all the profiles again clicking on next save and new so next is C hash so basically it is C sharp right so see how I will be creating this checkbox so I just selected now here I'm typing label as this and field name you can see it is showing as C so you can write it like this C underscore sharp because in field name in API name in unique name you cannot use any symbol other than underscore so this way you can modify it right so now I'm going to click on next visible to all the profiles again I'm clicking on next save and new the next is apex so lots of checkbox fields because for recruitment if you have any open position so you will be like tracking the skill so these checkboxes we are creating to track the skill for particular position so this way I created this field now I'm going to create one more that is for Excel so all these are of type checkbox so visible to all the profiles again I'm clicking on next save and new next I'm creating for PowerPoint and if you like after this session if you still have problem you can ask question so again I clicked on next then this time I'm creating word visible to all the profiles clicking on next save and new and last I have team building so I'm just copying it so this is again a checkbox so I just selected checkbox creating a field labeled as team building right then I'm going to click on next visible to all the profiles again I'm clicking on next and save so this time I'm just clicking on save so that I can lend up on this page fields and relationship so you can also stop just click on save and see how many fields you have created right and how quickly we are able to do that so if you if you have enough knowledge so things you will be able to implement quickly right so in my org all these fields are created so you can just verify whether all these fields you also have created or not in your org right so all the fields should be available like this and now if I scroll down so you can see next segment is for date right so now I'm going to create open date so I'm just going to create a date field clicking on next right next then visible to all the profiles again click on next save and new then higher by so it is again date field so I'm selecting date as a data type clicking on next so I think now these steps are very easy so you will be able to implement this so I'm also implementing this with you so that everything will be available in my org as well because everything is dependent if you miss any of the step so you will not be able to complete the task properly so this will be of type date again so I'm just clicking on next close date again clicking on next next save and new so this way three date fields are also created now next you can see we have pick list and while creating pick list there is one option is available like use first value as default so pick list name is location so first I'm going to copy that and I'm going to select pick list from here and I'm going to create it so create it carefully so field label will be location then from here you need to choose the second option enter values with each value separated by a new line so now what you can do just copy the list and paste it here so all the values will be available in different lines right now here it is mentioned use first value as default so you can check this checkbox okay and you can just click on next and rest of the options will be same as we did for other fields visible to all the profile then next and save and new then we have another field that is pick list it's label is status and here I'm going to create one more pick list so here you can see label is status then enter values so I'm just going to copy and pasting it so I hope everybody know what is pick list so we provided pick list values now I'm just clicking on next visible to all the profiles again I'm clicking on next save and new right so we need to create more pick list so this pick list label will be type so I'm going to create this so here we need to provide the values okay so all these values I just pasted now you can also click on next visible to all the profiles click on next save and new so now again we need to create one more pick list that is functional area and here you can see it is mentioned pick list sort alphabetically so I'm going to create one more pick list so this pick list label is functional area and values I need to copy from there so we have total six values so I'm just copying and pasting them right and here what is mentioned sort alphabetically so here is the option display values alphabetically not in the order entered right so I'm just clicking on next visible to all the profiles again clicking on next and save and new right so this way this field is also created now we have one more field that is job level so I'm going to create that as well it is again a pick list and here also we need to provide the values so I'm just going to copy this and pasting them here right and enabling this checkbox because we want to sort them alphabetically then clicking on next visible to all the profiles next now before clicking on save and new so here you can see we have working days and it is pick list multi select right so we need to create one more field okay so I'm just copying working days and working days are available here so I'm going to so here I selected pick list multi select then I'm just clicking on next so here I'm just pasting okay so now I'm going to paste all these values right so okay I'm just removing this checkbox don't select this checkbox because these days should be in the order which we entered this is multi select pick list now I'm clicking on next visible to all the profiles again clicking on next and clicking on save and new so Bachel is asking like what is the what we want to achieve through this project so Bachel let implement it for two days today and tomorrow then you will be having brief idea like what we are implementing and maybe on third or fourth day I will be relating each and everything end to end right because if I explain it theoretically in the big links so it will be very difficult to understand so let's implement and then we'll be doing end to end testing whatever we have built and a set if you are not able to see fields so just refresh sometimes when we create fields so it takes time to reflect on the UI and see like we need to create this last field that is certification and it is of type text area rich so I'm going to create this one clicking on next and here I'm pasting this label clicking on next visible to all the profiles again clicking on next and save so this time I'm just clicking on save because successfully we created all the fields and they are listed here right now what is the next step so this is important everybody read this now create at least five records with proper data for position object so right now what I'm going to do I will be creating five records under position object right so I'm moving here you can see I'm on recruitment app and here positions tab is available so I'm just refreshing the page so I'm just clicking on positions tab so here right now there is no record if I click on this list view and select all nothing is available right so in the requirement it is mentioned we need to create at least five records with proper data so now I'm going to create those so if I click on new a form will appear and it will be having all the fields so you can see all the fields that we created are listed over here so in my in my org those are available if in your org those are not available just refresh your front end so that whatever you have implemented from back end will be visible so position name for example I am creating salesforce admin then here I can write description responsibility so these I am not writing and here I'm filling minpay let's say ten thousand dollar twenty thousand dollar then you can just write the skills like excel or travel required or not team building right so this way you can write you can just check the skills and open date higher by close date these also you can fill location so location is a pick list here locations are available you can select anyone then status like it is new position or any other value just go through with values as well so that you can understand what you actually are trying to build right not just build just try to focus in detail whatever you have implemented so far then we have type like full-time part-time internship or contractor so you can select particular value then we have functional area these are functional areas then you can select any value from here as well then working days you can choose more than one let's say this employee works four days in a week and then certification details like certification pictures you can insert in this field and then you can click on save right and always remember whatever we are implementing everything is that test data whatever I am creating it is test data I'm just picking random values which is not related to anyone right so one record is created if I again click on positions tab so you can see one record is available here as Salesforce admin ok so now I am going to click on new then I am creating one more position let's say Salesforce developer now here I am like checking checkbox travel required team building then let's say open date I am selecting for today close date I am selecting Friday date right then if you want to select any value from here you can and just click on save so this way one more record is created so we need to create total five records so quickly create and don't fill all the fields so business analyst so right now I am filling this position name only and I am clicking on save and one more I am going to create so next is Salesforce architect so these all are positions that I am creating right again I am creating one more quality analyst right so these five positions I have created and all these five positions are related to Salesforce ecosystem right so I am just creating relevant data so that you can relate the things ok so this way I hope you all are with me and if you are behind no problem project document is with you this recording will be available anytime you can watch it and you can just follow otherwise you can ask questions through comments in the video section or you can just use telegram channel as well so I would request everybody to join different groups so that you can discuss things because I am trying to create a community and in longer run this community will help you right so if you interact with people you ask question you answer questions so it will help you and improve your knowledge as well I also learn this way only and doing this stuff for you so that it will enhance my skills as well right so by giving your knowledge to someone you will be enhancing your skills only ok so I think everybody completed till here if not so in free time you will be able to follow me now here you can see we have other requirements which are not related to object creation type creation and field creation so right now what we did like if you remember our day two session in day two I just guided you how to create app how to create object tab fields and records so that is completed now we need to create dependent pick list right so here requirement is on position object we need to create dependent pick list and our controlling pick list will be functional area and our dependent pick list will be job job level so there is a note like for finance department finance dependent will be those starting with FN for human resource starting with HR and so on it should be department ok so now I'm going to give you a brief demo like if I open any of the record and if I added if I added the record so you will realize it so here we have functional area which is having finance human resource IT another if I select finance I see all the data so you can see it is abbreviated FN is for finance HR is for human resource IT is for information technology we can see all but if I selected finance so I should see FN 100 200 300 and 400 right now if I select human resource so it should be like HR 100 HR 200 HR 300 and HR 400 so we just need to create dependency between these two fields ok so now I'm going to do this for you so that you can understand so here we need to create field dependency so here you can see this option is available field dependencies so I'm clicking on it ok so I'm just clicking on new and here you can see controlling and dependent fields are available so controlling I am selecting functional area and dependent I am selecting job level and clicking on continue right so here you can see we have all the things listed right so under finance I'm selecting FN related and clicking on include values then for human resource I am selecting these four clicking on include values for IT I am selecting these four and include values then miscellaneous I am selecting these four and I'm clicking on include values then retail operations I'm selecting these four and clicking on include values right then clicking on next from here so we have warehouse as well so I am selecting this include values I think R O I ok this also I selected so all six I selected right now I'm just clicking on save so this way I was able to create dependent pick list ok now if I go to UI so always remember whenever you implement anything just after implementation just test it as well whether it is working as expected or not so I am on this record and I'm going to add it it so here you can see field view all dependencies option is available it means it is applied and I'm not able to select job job level so first I need to select functional area so from here I'm selecting finance and you can see only four options are visible if I select human resource so only four options are available so this way you can apply field dependencies right so we already discussed in one of the session so I hope this gave you a revision now next we have formula field so let's create this formula field so we have two formula field that we need to create so I'm going to create first one days open right data type will be numbered so what is the requirement if close date is blank then we need to populate today minus open date so for example we or HR created a position in an organization a position is created and we need to check like from how many days that position is open so for example if I created a position on first fab so today's 27th fab so like total duration will be 27 days so under days open formula field that value should be populated so if close date is blank like close date is not specified so days open difference will be calculated through today minus open date otherwise it will be calculated through close date minus open date so we are considering open date will be available and close date will be optional if it is not available then instead of close date we will be using today so this way we need to implement this formula field and formula field label will be days open so I am going to use it now so under position I am going to create new field clicking on new so this will be a formula field and guys if you are not able to follow me because you need to see on the demo which I am demoing and you need to implement together on your org as well so if you are not able to be in sync so no need to worry just focus on the screen where I am demoing so that you understand and later on you can just try to implement these things at your own and if you get stuck then you can just like watch the recording and then get help and try to solve it so here field label will be days open so you can see the unique name will be populated automatically now from here I am selecting number as data type decimal places are not required so I am making them zero clicking on next now here I need to build the formula right so here we need to apply conditions as well like if your close date is blank so we have two alternates so what we need to do go here and search for if so click anywhere and just type I so you will automatically land up to the functions which are starting with I so I am selecting if clicking on insert selected function so it is available here so we need to implement logical test then true and then false and the requirement says if closed it is blank so we need to check whether closed it is blank or not so in place of this logical test I need to have another function that is blank so I am inserting that so what I did I just selected that value logical expression and I just inserted this is blank function now in place of this expression I am just deleting it I need close date field so what I am doing I am clicking on insert field from here I am going to select close date and insert so I selected close date I am clicking on insert so here you can see if is blank close date so if closed date is blank if it is true then this true part will be evaluated if it is false then this false part will be evaluated right so true part says today minus open date so what you can do here just erase it from right hand side you can insert one more function that is today then put minus and then insert open date field so open date is available here we just created so selected and click on insert so this way you can see this is the true part today minus open date right so one part is completed if closed it is blank so this will happen now if closed it is not blank so what we need to do closed date minus open date so here value underscore if underscore false you just need to remove it so just click on insert field and you can write closed date insert then put a minus sign okay sorry we need to go inside then put a minus sign then insert and then open date then again insert so this way our formula is created if is blank closed date if closed date is blank than today minus open date otherwise closed date minus open date right after implementation of this you can just check the syntax so if it is correct so it is implemented and you can just click on next now I'm clicking on visible to all the profile and you can see it is by default read only so again I'm clicking on next right and moving to save right so this way formula is created now I'm going to UI and the refreshing so now I'm going to test it so I just opened the record and I'm not able to see that field which I created so I'm refreshing it again sometimes it happens when you create the field so refreshing it again okay it is not available so let me just go to the page layout and I'm going to confirm whether it is placed on the layout or not so here I'm going to select that days open okay so it is available here so I'm just clicking on save once moving here and refreshing the page still not available again I'm refreshing the page okay now what I'm going to do I'm going to create new record so maybe okay here also it is not available so it is taking some time so let me just refresh the existing ones okay so it is taking time so let me just populate these values so open date I'm filling as first of fab and my close date is blank so I'm just clicking on save so if you are able to see that field so whenever you populate open date so you can see days open value right in my case it is still not visible on layout but it will be available in some time so if I populate open days as first fab so close date is blank so days open will be 27 and if close date is populated so the difference will be accordingly so both close date and open date will be subtracted and the difference will be available right so this way I hope you understood like how we can create the formula so I'm just going to open that and I'm going to explain it again one more time so this is the formula which I created so this is the condition which I implemented with if like if close date is blank so this is the true part so if close date is blank then from today open date will be subtracted and this today is a formula which will give you the today's date automatically and here you can see close date minus open date so these are two fields so Swapnil is saying it is showing 26 days open field so maybe it is not including current date today's date that's why it is showing 26 yeah so Swati you are like if we don't create field then also it appears you can just try and create new fields so I think after some time it will be available so let me just do one more refresh no on my org it is still not available no problem so I hope you understood how it is implemented so in your org you can practice this thing okay so I am just stopping today here like I'm not explaining 6b because I just want those who are behind they complete till here and like if you get enough time so you can go ahead and you can implement things those are available in later sections so tomorrow I will try to implement more things so that you will be able to understand like how things will be implemented so this is a 24 page document where lots of things are available okay so you can just go through whatever you understand and I will try to implement each and everything in these sessions so I just planned three sessions this week if like we need more sessions so I will try to stretch and maybe we will be having four or five sessions on this complete project but I will be implementing each and everything by myself so that those who won't be understanding they will see and they will be able to understand the things right so till today I am able to complete till 6a tomorrow I will be starting from 6b and will be following the steps which are written over here okay so if you have any doubt so you can just join the session and you can just go through right and if you have enough knowledge you can just practice and I just provided this my like everything I just collected and like designed it so that you can implement and practice things and if you scroll down so you will see lots of things are available here like I told you we will be discussing about cross-object formula field in the sessions so here you will see like how we can create hyperlinks as well then you will get to know roll-up summary different roll-up summaries validation rules then you will be creating different related list you will be configuring them right then if you go down you will have duplicate rule matching rule you will configure home page then you will be implementing related list single feed tracking field history tracking list views global action object specific action so all these things we did then we have reports so you need to build lots of reports dashboard then how to export data share report profile permission sets right so all these things are listed here so it will be a quick revision whatever we have done so far so I hope you will enjoy this then data import bizarre data loader so I just kept it for self practice so that you can experience these things then we have approval process as well that we will be implementing for position object then we have flow exercises right so like this document will be fruitful for the beginners those who want to get familiar all the with all the concepts those are available under Salesforce admin and once this is completed so from next week onwards we will be starting flow builder which is kind of low code development so like if you are able to implement that so like you you will be having enough knowledge related to development and after flow sessions I will be starting apex programming right so this is all about today's session and now if you have any question you can ask otherwise I will ask just implement then ask questions in the comment section of this video or like you can ask questions in the telegram group as well okay so I hope this effort will help you out those who are totally beginner for them this project will be more helpful okay okay so please share this thing with others as well so that they also get to know and they can also begin the Salesforce journey and for each and every role Salesforce admin knowledge is very important and like this week admin stuff will be completed then soon we will be completing development part and I am also planning to have cloud specific boot camps like sales cloud service cloud omni studio so like I'm just preparing content for those so like after development sessions I will try to give knowledge on those clouds as well okay yeah so like people are asking can we try remaining topics in that X yeah you can go ahead and you can implement like I will be implementing few things tomorrow and few day after tomorrow so if you want to go ahead that is not a problem and if you want to go with me so you can just wait till tomorrow and drama is asking like effort so it took lots of time so data model I took help and I just refined and added lots of features so that it will be a little bit complicated document to be implemented so thank you everybody so we'll connect tomorrow again and I will try to complete this project this week you have enough time I have limited time so I will be implementing tomorrow in the session only so I will try to build things so in front of you but few fields objects maybe if we will be running short of time so I will be implementing those offline and like I will show you how I implemented those so that we can quickly complete the things okay thank you everybody have a great day ahead good good morning good afternoon good evening because people are joining from different time zones thank you everybody