1 00:00:01,010 --> 00:00:02,690 In this video, we will learn about. 2 00:00:03,730 --> 00:00:06,470 Basic social functions in our country. 3 00:00:07,300 --> 00:00:12,350 So for this, we need to cut to the poverty, Ed, by clicking on from data. 4 00:00:14,650 --> 00:00:22,210 And here we need to right click and then we have to click. 5 00:00:25,770 --> 00:00:28,980 Go to their advantage to remove it. 6 00:00:31,020 --> 00:00:35,640 And here you can see function starts that the. 7 00:00:36,960 --> 00:00:41,680 Open bracket and closed bracket, and here we have to write anything. 8 00:00:42,260 --> 00:00:46,990 If I write nothing here, then it will work fine. 9 00:00:47,910 --> 00:00:49,350 So this is the basic structure. 10 00:00:50,490 --> 00:00:53,010 So Zócalo. 11 00:00:55,870 --> 00:00:59,090 Greater than time, Soviet lamda. 12 00:00:59,350 --> 00:01:02,710 So what we have to display had a world, 13 00:01:05,920 --> 00:01:06,430 that's it. 14 00:01:06,910 --> 00:01:09,600 So here you can see this indexers fine, everything's OK. 15 00:01:10,510 --> 00:01:12,190 And if I click done. 16 00:01:14,940 --> 00:01:17,940 And then we have to click here, invoke. 17 00:01:21,770 --> 00:01:24,740 And we got a right. 18 00:01:25,850 --> 00:01:31,230 So this this is the basic syntax of functio, so let's pursue it further. 19 00:01:32,510 --> 00:01:34,880 We just need to delete, involve function, right? 20 00:01:34,880 --> 00:01:36,500 Click here and delete. 21 00:01:40,360 --> 00:01:44,170 And the lost Ed. 22 00:01:45,790 --> 00:01:48,140 So here we have to know, right? 23 00:01:49,450 --> 00:01:56,740 Uh, if I write here, hey, come on, be. 24 00:01:58,780 --> 00:02:11,650 And if I write here, it might be these are the two parameters and here if I write A plus B. 25 00:02:14,890 --> 00:02:17,120 That's it, and only to Clinton. 26 00:02:18,610 --> 00:02:24,410 So these are the two parameters and it is showing options optional, right? 27 00:02:24,700 --> 00:02:33,670 If I click invoke if you show me not because I haven't passed anything, but if I write two plus five 28 00:02:34,150 --> 00:02:39,670 in vogue, then it will give me seven eight. 29 00:02:42,320 --> 00:02:44,540 So let's let to involved function. 30 00:02:48,730 --> 00:02:59,890 Home and Kutty 11 advanced Ed, and if I a little bit enhance this thing for me, if I say a yes no. 31 00:03:02,580 --> 00:03:06,040 And only this one, right? 32 00:03:06,660 --> 00:03:15,270 So if I don't specify anything here, then it means we can have any any type and if I click done. 33 00:03:17,170 --> 00:03:26,200 So here you can see we have no option here, we have only option with a B, so if I click invoke so 34 00:03:26,200 --> 00:03:31,850 he can see I'm getting one warning that this is the required field. 35 00:03:32,680 --> 00:03:40,300 So if I put forth and invoke, then four plus null will be null. 36 00:03:41,350 --> 00:03:47,230 And if I deleted and then I click again. 37 00:03:47,250 --> 00:03:49,330 311 advance ed. 38 00:03:49,810 --> 00:03:54,580 So I have to click of like four plus five. 39 00:03:55,690 --> 00:04:01,630 Invoke, then I will get nine, right, so let mutilated. 40 00:04:04,870 --> 00:04:06,980 2011, it was illegal. 41 00:04:07,630 --> 00:04:15,760 So here you can see if we specify type here, like is a type is a number, then it will be the required 42 00:04:15,760 --> 00:04:16,140 field. 43 00:04:16,630 --> 00:04:23,430 And if I write B, then B, like it is an option. 44 00:04:23,650 --> 00:04:36,220 And if I write here B as no, and then you will see here, they both are non optional. 45 00:04:36,220 --> 00:04:36,510 Right. 46 00:04:36,940 --> 00:04:48,640 And if I again go to the advanced ed, if I write here optional like this one would be the option. 47 00:04:48,660 --> 00:04:51,200 Always capital or option. 48 00:04:51,220 --> 00:04:54,100 OK, and click done. 49 00:04:55,420 --> 00:05:00,660 So here you can see this is a required field and the beta option is right here. 50 00:05:00,700 --> 00:05:03,000 Five and click invoke. 51 00:05:03,520 --> 00:05:10,660 So here you can see it is also working fine because the null plus anything will be null. 52 00:05:11,020 --> 00:05:13,600 Delete and if I. 53 00:05:16,800 --> 00:05:22,110 OK, five past five invoked, so it will be 10. 54 00:05:24,230 --> 00:05:37,610 So we need to further enhance this function delayed and so here we can add one parameter here for if 55 00:05:37,610 --> 00:05:38,210 I say. 56 00:05:43,260 --> 00:05:43,650 Tim. 57 00:05:47,380 --> 00:05:54,650 Tampa as no, and then I'm I need right here. 58 00:05:56,920 --> 00:06:05,440 So this is because we have defined we have declared dysfunction here and and now we have to define here 59 00:06:05,530 --> 00:06:06,040 the left. 60 00:06:08,590 --> 00:06:14,620 So it will be I will say, like the result is equal to this is a variable. 61 00:06:14,620 --> 00:06:20,020 And here I can write one condition here, the if condition. 62 00:06:21,200 --> 00:06:23,240 Like if temperature. 63 00:06:25,170 --> 00:06:28,650 It's less than 20. 64 00:06:30,710 --> 00:06:34,040 Then show called. 65 00:06:39,220 --> 00:06:40,090 As if 66 00:06:43,030 --> 00:06:43,840 temperature. 67 00:06:46,180 --> 00:06:52,290 Is greater than 20 and temperature. 68 00:06:54,160 --> 00:06:55,780 Less than 30. 69 00:06:56,940 --> 00:06:58,010 Then will be 70 00:07:01,020 --> 00:07:01,650 normal. 71 00:07:04,170 --> 00:07:04,710 As. 72 00:07:09,240 --> 00:07:13,110 You have tried everything in small, then it will be hard. 73 00:07:16,670 --> 00:07:27,180 We can write here, for example, and pressure is called like this, so I can copy. 74 00:07:30,120 --> 00:07:31,410 Into our space here. 75 00:07:33,540 --> 00:07:36,480 And then again, I need to put here. 76 00:07:39,460 --> 00:07:41,110 Temperature is normal. 77 00:07:52,450 --> 00:07:56,860 And in this case, it will be again, temperature is. 78 00:07:59,340 --> 00:08:01,270 Through translator And. 79 00:08:05,910 --> 00:08:06,690 Is heart. 80 00:08:10,360 --> 00:08:15,640 They said so in the in the end, we have to right here. 81 00:08:17,550 --> 00:08:18,300 Result. 82 00:08:21,420 --> 00:08:28,550 So this is the here we have defined the function body, right? 83 00:08:29,670 --> 00:08:30,330 So 84 00:08:32,910 --> 00:08:34,410 nobody took it done. 85 00:08:36,570 --> 00:08:37,980 And if I write here. 86 00:08:39,300 --> 00:08:41,220 Thirty four invoke. 87 00:08:43,480 --> 00:08:55,330 So we cannot apply operator and to type number, and so there is some type error here that we need to 88 00:08:55,330 --> 00:09:01,420 go to the we need to delete involve function and we have to go to the advance. 89 00:09:01,420 --> 00:09:04,630 Ed, by clicking on 311, it was editor. 90 00:09:05,980 --> 00:09:11,520 And here we have to, for example, temperature the systematic failure and the severe strain. 91 00:09:12,100 --> 00:09:20,600 So we are getting error that we can't, uh, we can't concatenate numeric with string. 92 00:09:20,620 --> 00:09:24,120 We have to convert them as a numbering text. 93 00:09:25,090 --> 00:09:26,800 So this is a function. 94 00:09:27,490 --> 00:09:32,230 The name is no doubt through text this one. 95 00:09:33,610 --> 00:09:37,030 And it takes the parameter as a as a number. 96 00:09:39,200 --> 00:09:50,420 This one we need to copy and then we can use every that very, very to very have you stamp one right 97 00:09:50,420 --> 00:09:55,820 here then and again here, then copy paste. 98 00:09:56,480 --> 00:09:59,690 So therefore and no need to click done. 99 00:10:00,410 --> 00:10:07,340 And here if I write twenty eight, thirty four in vogue, so I'm getting 34. 100 00:10:07,340 --> 00:10:08,510 Temperature is hot. 101 00:10:08,790 --> 00:10:09,130 Right. 102 00:10:09,710 --> 00:10:23,660 And in the same way if I write here like 12 the 12 year old I know the final part is we will write, 103 00:10:23,850 --> 00:10:30,100 we will create a very simple table and then we will see how we can invoke the dysfunction. 104 00:10:30,320 --> 00:10:30,690 All right. 105 00:10:31,070 --> 00:10:43,130 So for this, we need to delete the latest one and hear the name of the function is like, can the fan 106 00:10:43,550 --> 00:10:44,300 temperature? 107 00:10:46,430 --> 00:10:47,470 Certainly malfunction. 108 00:10:48,100 --> 00:10:52,780 And then we need to right here click, right click and. 109 00:10:55,450 --> 00:10:56,350 It was Ed. 110 00:10:57,990 --> 00:11:01,950 And here we have tried one. 111 00:11:03,540 --> 00:11:05,370 One, David, David. 112 00:11:14,590 --> 00:11:21,610 Timetable temperature is equal to text No. 113 00:11:25,090 --> 00:11:32,270 And here, right, hash, define here list of lists. 114 00:11:34,050 --> 00:11:38,980 So the first list is right here, 19. 115 00:11:52,300 --> 00:11:56,530 And here you can write 22 and. 116 00:12:00,680 --> 00:12:01,340 Thirty one. 117 00:12:05,180 --> 00:12:07,220 And a hero, right coma. 118 00:12:07,730 --> 00:12:09,700 So this is a small table, right? 119 00:12:13,120 --> 00:12:24,650 And they are is temperature and 19 and 20 to 31, and the name of the table is temperature, this one. 120 00:12:25,120 --> 00:12:25,750 That's right. 121 00:12:26,560 --> 00:12:32,720 So here in Norway we have a table and now we need to invoke this function and temperature. 122 00:12:32,980 --> 00:12:35,830 So for this one just to go to the ADD column. 123 00:12:38,430 --> 00:12:40,050 Invoked custom function. 124 00:12:42,700 --> 00:12:47,590 And the name of the column is right, write a message. 125 00:12:49,950 --> 00:12:53,190 And the function curious temperature. 126 00:12:54,570 --> 00:13:04,800 The the column is condemned and we have to click, OK, so here you can see the messages, 19 temperatures, 127 00:13:04,800 --> 00:13:09,540 core temperature is normal and 31 temperature is hot. 128 00:13:10,860 --> 00:13:21,150 And if I if we click here again at Collum custom column and here is the contrives, second by 129 00:13:23,820 --> 00:13:31,380 second base and here we just need to call the function that is Effron temperature. 130 00:13:32,370 --> 00:13:36,510 And here we have to give one parameter. 131 00:13:36,690 --> 00:13:38,430 That is temp. 132 00:13:39,360 --> 00:13:39,830 That's it. 133 00:13:41,870 --> 00:13:51,080 And now if I go to the OK, if I click on OK, and here you can see it is returning the same stuff, 134 00:13:51,800 --> 00:13:52,120 right? 135 00:13:52,790 --> 00:14:00,830 So you can either use invert function or you can use the custom function, because every time when the 136 00:14:00,830 --> 00:14:08,840 function is running for every row, it is taking the parameter from this rule 90 and then the producing 137 00:14:08,840 --> 00:14:13,740 the result, the default function is producing the scalar value. 138 00:14:13,910 --> 00:14:17,720 So that's all about the uses of function in power Kutty.