Hi and welcome to this video, where we learn how to associate a the program with Balzer.
So you have followed our last videos to reduce and we have shown you how to create music from how to
use two different checkboxes and command buttons and so on, and also how we use the front end to structure
everything and how the information's important using the phone, how they reflected in the content sheet.
We also discussed the formula.
So your main focus is just creation of macro and then application along with things.
So the basic first macro that we need to implement is for the submit button because that is the main
button.
If this is the only prime button with a clear intent to sign but submitted what actually will get the
form submitted, so that will get the key in the database.
So whenever someone is putting in the different values and the variables and everything is filled up
and then he or she is clicking on, suddenly that is the mean button which reflects the information
into the sheet and the frontend database, which there is anything wrong with the statements or maybe
somebody splitting in numeric value in name or character in the traditional mode.
So these things are something that needs to be checked to the macro and process to the macro.
So the separate mechanism in button on which the main macro and the major portion has to be concentrated
on.
So here is a very big program.
I won't be typing it out every step by step because it's a very large program.
I have written it down in a notepad file and I will be copying it and then explain each process because
otherwise it can become very complicated and I will expand it.
Cold, very cold water districts, simplemente macro and this particular button to double click on the
submit button.
And then this automatically comes up private supplement button one.
Click the prompt open arms user from, as we have seen earlier in the module that it's already written
private some command button one click.
So that is what this is private.
So we were using GitHub so far, but here it let private sub public service that accessible publicly
by private sub needs to be private because this is not something that can be used in individual security
level is higher for this.
So let's just copy the code from here.
I have written this code earlier, so let's just copy paste it and then I will explain it step by step.
So is selected from scheduler activity and then just copy it and then and just pasted.
OK, so now everything is in place to enter to.
It has been calculated.
Was coming by default, though let's understand each of these words.
So first, coming to the first code private simple command button.
One Click on the person, click the button.
See three gets activated security.
Remember, she is the place where they have all the columns names her name debera, so this is what
the database gets added.
This is, then the data will get added.
So this is maintained.
So now creating a variable control account and say assigning the dimension is law.
So that is it will be a long, no end user for one, but it works wonderful to see if you remember the
user from the textbook so undervalued.
So this is the name value remains blank.
The message boxes that please enter the first name will then be the exclamation workshop, so it will
be an icon which will in the form of an exclamation mark triangle sign with exclamation mark in between.
That means it's an alert actually shown to the user and then workshop former and so on.
So click OK on that message box.
This form will open up again and it will be right and it will open up, and it will focus on the text
box once it is set focus on the Xbox One.
So that is what is meant by user from one.
Since text box one was empty, the caricature will be on textbooks one so that Israel will focus on
textbooks.
One says text focus.
So this is the same thing for experts to as well as forthcoming one as well, so textbooks to us, both
textbooks to assign meaning someone is not filling up the so please choose a department and then the
phone will open up because I really believe that no.
Then same thing goes for the textbooks three as well as Ford.
And then we come to the next thing because textbooks are all the same textbooks.
Three was did.
So just let's go back to the.
Textbooks a day job training.
And so what we're checking is that some would need the ban on its use when has to be in the form of
a data cannot be some other format.
The data integrity user has to be numeric and not even in new numeric has to be for.
If not is data.
That means if the format is not it, it's not a data, then the networks must contain the data.
So it's a message to the user that it has to be a date format.
Similarly, if we use the textbooks for it was a numeric registration amount, so it has to be a numeric
value.
If instead of numeric, someone puts in a character and if it's not numeric and secondly, if not is
numeric, the amount of books must contain a number of information x and instead focus on text books
for the similarly to just focus on the textbook.
That is not correct.
So we just better address the fact that this was error.
So we have addressed two issues of remaining the blank and if if it's the correct format that it is
written, is will now say he or she has filled up all the information correctly.
So if all the information is filled up correctly, we're going to count it remembering that.
I mean, no, no.
The main function of looking is coming here looking to go to Worksheet 21.
So starting from the person that is the absolute top left on a sell it to start to stumble across.
This is the most important task of the variable count to count the number of rules.
So when you're the first person enters the information, including the first cell after that, when
the second individual is information, then it should come in the second one and then it should come
in the third one, this one.
So it needs to be seen how many rules have already been updated so that the new data always comes in
after that.
So the new new information has to be brought in after the number of throws already present.
So that is very important.
So it starts from anyone with sheets in order to do a lot of sick of searches of function.
I will show you how using the Excel sheet now, let's try to understand what it is of several count
common zero.
So this part is the rule and this what is the column?
So when I'm saying I'll set a local common 0.12 going to the from one our textbooks under 12.
So this so this part is easy to understand.
I mean, the value that someone is putting in in the textbooks, one that is the name that is the value
and the name needs to go into the column name.
So this is even great.
So if someone puts in the name you're trying to be dead on should be an A2.
So I said, does that function of shifting from one side to another, which does the job of shifting
the location?
So I've said from A1 to A2 means it's moving down so that it was moving one rule and zero columns.
So if you notice it was zero zero six will not shift any columns that will sustain the same column and
it will shift and they need to say and how many rules it will shift one drone over the next one in three
local comma one.
So it will be from A1, it will shift to one, and then again, it will shift to one column to the right.
So it will go to the sending this since textbooks to have something that will be the surname, then
this surname bin seaport department is local.
Comma to sokomba works for one row and then two columns, which will come under department.
Then we have a local 3.0 value, which will go into the data value that textbooks will has to be in
the final four days.
Then it will go English of three columns from A to B, and the text box for Android will shift to amount.
It's just an amount.
And then last is the checkbox that is not a single value that is a sort of true or false.
Well, the new the phone one ridiculous numbered value is equal to true then of five equal, yes.
So if chequebooks one is checked, yes, that is the yes witness claim, then the permanent issue?
Yes, another residential.
So if it's else, then it's not.
It's all set.
So at the end, we have assigned one here which is not there and a problem.
This is basically a system generated date and time column that runs the bus, and it's in the information.
It gives the information to the user from the time and the date of that information given will be updated.
I think the time of restriction, which in the computer system you find anything to be whenever you
are filling up the form, it will not be anything predefined.
So upset messages are telling your phone.
Now that is the present time, that is when you are entering, whatever the time and date is for the
current time, whether the system time date is for the time, you are filling up the form given by the
statement year our month, sorry, every minute seconds and then we go to end of it so that we started
here.
After you count, then you are unloading their phones.
After doing everything, we need the user for them to come down.
The data gets updated in three three and then the three student activated and will show you.
The a2zero fee to get the columnist, the judge said a lot of information to scholars and show you scholars
say it was your opinion.
So that is all we have for the filling up of the submit button.
So this is the most important and crucial part of the court where we see how the data is actually printed
up in interviews.
So in the next video will be coming in to the more that the two common buttons.
And how did you?