hello hi everyone so the first thing that we should know when it comes to developing an application in service now is to determine how many tables that we need for our application and what type of tables that we need for our application so whether we are going to extend our table or are we going to make it extensible or not so these are the questions that we should ask in the beginning so we need to have a clear idea about what is the application design that I have for my application okay so in our case here for lingual we are not going to have more than three tables for now and I'm not going to extend any tables so in this video I'm going to show you how we can create a table how to add fields in our using form design and also how to create form views so whether is a student logged in as a user is going to have a particular view or is a teacher as a logged in as a user is going to have another view so we are going to create form layouts and then also creating roles in order to give access to certain people to this application so let's get started so we're gonna start to create our application now let's click on create application in studio and then give a name for our application so I'm gonna give a name here linguas I can put whatever the name that you want now as well I'm gonna write a description here on line terrain school management application for example you can put whatever the text that you would like to have and then I'm going to create two different roles so first role is going to be student role the second role is going to be a teacher as I as I'm going to have two different personas so I would like to have two different roles for my application okay let's select here what type of format that I would like to use classes that's classic that's the one that I want to use and here click on in studio advanced okay once you have your application created click on the application and then we're gonna start to create our custom table okay we're gonna have a student request custom table basically the table is used to allow any prospect or any potential client in order to submit their the first request to get the 20 minutes introduction for free so I'm gonna give a label name here student request for now and then also I'm gonna uncheck the box for create mobile modules so I don't want it anymore I'm going to make sure as well that I have Auto number check so I can have some root cause with reference number and the default user role I'm gonna delete it and then set it I'm gonna select here the link without student role that I have created just before okay click on submit and see what's going to happen and here we're gonna have we have our table is created and we have some access control but we do not have the application video so we're gonna create an application menu here and I'm gonna call it lingua okay so under linguae application I'm gonna make sure they select the appropriate role I'm gonna have here the student role for now okay so now make sure as well for the module spoon request that I have the right application when you as you can see here have some other so I'm going to delete that one and then select here link or the one that I have created okay and set also the order 200 so now we have created a our table access control rules and so on let's now design our form okay let's create all the fields that we need so I'm gonna create as a first field it's going to be a choice field okay it's going to be a language choice field and we're gonna ask to the student what language you would like to learn so I'm gonna say here Spanish and then Korean so these are the choices that I'm giving here you can put whatever the language that you want as well and here another choice field which is going to be applications so application for lessons so what type of application they would like to use or their introduction or lessons so it's going to be zoom or Skype or it can be anything else okay and then we're gonna I'm gonna have two different day field start day time and end date time so these are used to ask the user in order to submit their basically the introduction time when they would like to have their introduction and further I'm gonna have to reference field the first reference field is going to be requested for to whom they are going to assign the request so it's going to be a user is going to refer to user table and then the second one is going to be assigned to pretty much similar it's going to refer to user table and it to whom you're gonna assign the request and we're gonna create another one which is a request status we're gonna have different status for our request so it's going to be scheduled fulfilled sorry question schedule fulfilled and then abundant so these are the different stages and the last one we're gonna have conflict status for now I'm not going to explain you why we have this feel but we do need this video so we're gonna have three different values you can schedule internal schedule and not so this is a choice feel okay so from now on we're gonna work on creating views for our student and also teacher so the first view is going to be a student view so I'm gonna create that view and make sure that I don't have conflict status and requested for field for students so I'm gonna delete that part and save it okay so make sure that you don't have complete status and request it for and then save it and then I'm gonna create one more field basically I forgot to create one field in the default view which is the contact ID so basically when the person is going to select the application for lessons we do want to know who is a contact 8050 if it is Skype I want to know what it's a Skype ID or if they zoom I want to know the email so I'm gonna create that one and I'm gonna change the student at that field as well and I'm gonna create now the tutor view okay so I'm gonna click on default new and then type teacher okay and then save it we're gonna keep all fields as it is for as we as it is for a default view so we're gonna keep everything teacher okay we have done with our views and pretty much we're gonna work on view rules access control and some other things in the next video thanks for watching hope you liked it bye