1
00:00:00,630 --> 00:00:08,010
So once we have our sheet data as needed and it's putting the questions away, we're ready to move that

2
00:00:08,010 --> 00:00:11,000
and migrate that into our Web application.

3
00:00:11,370 --> 00:00:14,190
So just make sure that it is outputting property.

4
00:00:14,370 --> 00:00:17,130
And I'm removing some of the console messages.

5
00:00:18,030 --> 00:00:23,100
And we do have the same function that's loading the questions, the question content.

6
00:00:24,990 --> 00:00:31,830
So it should be fairly easy to copy and paste some of the code and easily bring it in to our application.

7
00:00:32,250 --> 00:00:39,360
And instead of contacting the JSON file, we're going to be getting the content and coming out of what

8
00:00:39,360 --> 00:00:42,590
we've got within the JavaScript object.

9
00:00:42,600 --> 00:00:44,330
So we're outputting the questions.

10
00:00:44,760 --> 00:00:51,570
So let me just move this down to the bottom and we can also output the questions on the page

11
00:00:54,330 --> 00:00:58,400
to make sure that we've got the same structure as we did from the JSON file.

12
00:00:58,980 --> 00:01:01,620
So let's put it into the validator.

13
00:01:03,810 --> 00:01:10,470
And everything looks very similar to what we have or what we had whenever we're outputting with APS

14
00:01:10,470 --> 00:01:13,700
five, whenever we've reconstructed our JavaScript object.

15
00:01:15,540 --> 00:01:19,620
So now we can copy the rest of this information out.

16
00:01:19,950 --> 00:01:26,250
So what I'm going to do is I got to make a copy of APS five and then we'll update the code from the

17
00:01:26,250 --> 00:01:32,440
APS six into the APS seven and just update the way that we're getting the data.

18
00:01:33,210 --> 00:01:42,870
So let's pull in content from APS seven and that's again loading the content and just again, make sure

19
00:01:42,870 --> 00:01:44,330
that it does look the same.

20
00:01:44,340 --> 00:01:46,580
So we've got a correct option and questions.

21
00:01:46,920 --> 00:01:51,650
So everything looks pretty good and let's make an update.

22
00:01:51,690 --> 00:02:00,270
So adding in the ID and that you are all so going up to where we've got the euro, so ID and you URL

23
00:02:01,350 --> 00:02:08,700
and then let's load the we've got the questions array and then the only function that's really different

24
00:02:08,700 --> 00:02:10,490
is the load questions function.

25
00:02:10,860 --> 00:02:13,980
So let's go into there and update the load.

26
00:02:13,980 --> 00:02:19,830
Questions function with our newly constructed function that we did from the last lesson.

27
00:02:20,160 --> 00:02:22,110
So we're ready to start the quiz.

28
00:02:23,160 --> 00:02:27,270
Let's add in a new question.

29
00:02:30,890 --> 00:02:39,120
And what is the ocean so this can be blue, purple, red, yellow.

30
00:02:40,400 --> 00:02:42,050
So let's see what happens.

31
00:02:42,110 --> 00:02:43,780
So it looks like it loaded properly.

32
00:02:43,790 --> 00:02:44,610
Start the quiz.

33
00:02:44,900 --> 00:02:46,150
What color is the ocean?

34
00:02:46,820 --> 00:02:47,730
So we got it wrong.

35
00:02:48,500 --> 00:02:49,580
What color is the sky?

36
00:02:49,730 --> 00:02:50,510
We got it right.

37
00:02:51,170 --> 00:02:52,430
What color is the grass?

38
00:02:52,580 --> 00:02:53,390
Got that right.

39
00:02:53,720 --> 00:02:55,370
And also this one.

40
00:02:55,850 --> 00:03:04,310
So right now we scored two so far four questions, completed a score of two and generated our response

41
00:03:04,310 --> 00:03:05,020
to the quiz.

42
00:03:05,600 --> 00:03:13,760
So we're able to successfully link our quiz application getting more complex, Jason, data that's coming

43
00:03:13,760 --> 00:03:14,690
from the spreadsheet.

44
00:03:14,990 --> 00:03:22,610
And then now this is just running regular front end code, connecting to the sheet data so you can load

45
00:03:22,610 --> 00:03:29,750
this onto your website and have the quiz content driven from a Google spreadsheet.

46
00:03:34,080 --> 00:03:39,630
And you could try it out, build your own version, and then, of course, as you customize the quiz

47
00:03:39,900 --> 00:03:47,310
and the presentation of the quiz content, you can also update that, how it looks and the how it goes

48
00:03:47,310 --> 00:03:50,430
through and even how the results are being presented to the user.

49
00:03:52,290 --> 00:03:59,730
In the main objective of the earlier lessons was to be able to take JSON data, very complex JSON data,

50
00:04:00,000 --> 00:04:03,180
and make use of it within your Web application.

51
00:04:04,170 --> 00:04:10,320
Now you're ready to finalize your application, whether you're getting Cui's from adjacent file or whether

52
00:04:10,320 --> 00:04:15,990
you're getting it from sheets, you can go through the application and do some debugging, make some

53
00:04:15,990 --> 00:04:17,680
updates to the staling as needed.

54
00:04:17,910 --> 00:04:23,250
So in this case, go ahead and try to update some of the content within the sheet, refresh the Web

55
00:04:23,250 --> 00:04:28,920
application and try it out and just make sure that it is working as expected.

56
00:04:30,090 --> 00:04:33,060
If you have any questions or comments, I'm always happy to hear from you.

57
00:04:33,270 --> 00:04:35,070
Thanks again for taking this section.