In this video, we will learn about.
Basic social functions in our country.
So for this, we need to cut to the poverty, Ed, by clicking on from data.
And here we need to right click and then we have to click.
Go to their advantage to remove it.
And here you can see function starts that the.
Open bracket and closed bracket, and here we have to write anything.
If I write nothing here, then it will work fine.
So this is the basic structure.
So Zócalo.
Greater than time, Soviet lamda.
So what we have to display had a world,
that's it.
So here you can see this indexers fine, everything's OK.
And if I click done.
And then we have to click here, invoke.
And we got a right.
So this this is the basic syntax of functio, so let's pursue it further.
We just need to delete, involve function, right?
Click here and delete.
And the lost Ed.
So here we have to know, right?
Uh, if I write here, hey, come on, be.
And if I write here, it might be these are the two parameters and here if I write A plus B.
That's it, and only to Clinton.
So these are the two parameters and it is showing options optional, right?
If I click invoke if you show me not because I haven't passed anything, but if I write two plus five
in vogue, then it will give me seven eight.
So let's let to involved function.
Home and Kutty 11 advanced Ed, and if I a little bit enhance this thing for me, if I say a yes no.
And only this one, right?
So if I don't specify anything here, then it means we can have any any type and if I click done.
So here you can see we have no option here, we have only option with a B, so if I click invoke so
he can see I'm getting one warning that this is the required field.
So if I put forth and invoke, then four plus null will be null.
And if I deleted and then I click again.
311 advance ed.
So I have to click of like four plus five.
Invoke, then I will get nine, right, so let mutilated.
2011, it was illegal.
So here you can see if we specify type here, like is a type is a number, then it will be the required
field.
And if I write B, then B, like it is an option.
And if I write here B as no, and then you will see here, they both are non optional.
Right.
And if I again go to the advanced ed, if I write here optional like this one would be the option.
Always capital or option.
OK, and click done.
So here you can see this is a required field and the beta option is right here.
Five and click invoke.
So here you can see it is also working fine because the null plus anything will be null.
Delete and if I.
OK, five past five invoked, so it will be 10.
So we need to further enhance this function delayed and so here we can add one parameter here for if
I say.
Tim.
Tampa as no, and then I'm I need right here.
So this is because we have defined we have declared dysfunction here and and now we have to define here
the left.
So it will be I will say, like the result is equal to this is a variable.
And here I can write one condition here, the if condition.
Like if temperature.
It's less than 20.
Then show called.
As if
temperature.
Is greater than 20 and temperature.
Less than 30.
Then will be
normal.
As.
You have tried everything in small, then it will be hard.
We can write here, for example, and pressure is called like this, so I can copy.
Into our space here.
And then again, I need to put here.
Temperature is normal.
And in this case, it will be again, temperature is.
Through translator And.
Is heart.
They said so in the in the end, we have to right here.
Result.
So this is the here we have defined the function body, right?
So
nobody took it done.
And if I write here.
Thirty four invoke.
So we cannot apply operator and to type number, and so there is some type error here that we need to
go to the we need to delete involve function and we have to go to the advance.
Ed, by clicking on 311, it was editor.
And here we have to, for example, temperature the systematic failure and the severe strain.
So we are getting error that we can't, uh, we can't concatenate numeric with string.
We have to convert them as a numbering text.
So this is a function.
The name is no doubt through text this one.
And it takes the parameter as a as a number.
This one we need to copy and then we can use every that very, very to very have you stamp one right
here then and again here, then copy paste.
So therefore and no need to click done.
And here if I write twenty eight, thirty four in vogue, so I'm getting 34.
Temperature is hot.
Right.
And in the same way if I write here like 12 the 12 year old I know the final part is we will write,
we will create a very simple table and then we will see how we can invoke the dysfunction.
All right.
So for this, we need to delete the latest one and hear the name of the function is like, can the fan
temperature?
Certainly malfunction.
And then we need to right here click, right click and.
It was Ed.
And here we have tried one.
One, David, David.
Timetable temperature is equal to text No.
And here, right, hash, define here list of lists.
So the first list is right here, 19.
And here you can write 22 and.
Thirty one.
And a hero, right coma.
So this is a small table, right?
And they are is temperature and 19 and 20 to 31, and the name of the table is temperature, this one.
That's right.
So here in Norway we have a table and now we need to invoke this function and temperature.
So for this one just to go to the ADD column.
Invoked custom function.
And the name of the column is right, write a message.
And the function curious temperature.
The the column is condemned and we have to click, OK, so here you can see the messages, 19 temperatures,
core temperature is normal and 31 temperature is hot.
And if I if we click here again at Collum custom column and here is the contrives, second by
second base and here we just need to call the function that is Effron temperature.
And here we have to give one parameter.
That is temp.
That's it.
And now if I go to the OK, if I click on OK, and here you can see it is returning the same stuff,
right?
So you can either use invert function or you can use the custom function, because every time when the
function is running for every row, it is taking the parameter from this rule 90 and then the producing
the result, the default function is producing the scalar value.
So that's all about the uses of function in power Kutty.