 So here we are in Google Drive, and I presume you've locked into your Google Drive and I've made some folders and I've navigated to the folder where I want to create my Google form And it's very simple. We're just going to click on new and under more you'll see Google Forms That is our Google form and It is going to open a new form for you. See if I've already done one there So that's what it's going to look like if it exists there and if data has already been collected You'll see the little spreadsheet on the right-hand side there, but let's go ahead. We're going to make a new More a Google form and it opens up for us there And this is what it looks like at the top just our form settings. Let's increase the size there So we can see what's happening. It says require log in to view this form Of course, you want to be able to log into this again It's always I reiterate make sure that you have permission to do data collection using a tool such as this You can ask for a progress bar at the bottom of the page as the page has been filled in Only allow one response per person requires a login while we want to log in many patients so we won't do that and We don't want the shuffle order to the questions We can quickly give it a name. This is going to be our Julia case control series There we go. Give it a little description. This is our data collection tool And We just going to do our first question now remember our first question was patient ID I'm going to try not to use any kind of spaces because that's the way the data frames package in Julia with a data frame refers to the column headers and It will it will I think put underscores I think if there are spaces but try it for us not to use spaces yet all we don't want to put any helper text there Remember we want to keep things anonymized. I'm not going to say this refers to the specific patient look them up by the ID Nothing like this. It's not a multiple choice It is just going to be text and I want it to be required So just simple text. I wanted to be required I don't want any blank or missing values in the data collection tool That's a very important specifically when it comes to data frames Difficult in Julia to handle missing values and you have to do a bit of extra work to deal with that So we're going to say required question always and Now we want to add a new item So I can just say add item or this little drop-down box And the next one remember was going to be cat one But we only want people to be able to select either a or B. So let's say choose from a list and Remember so for us this was going to be just cat one. I don't want to do any helper text I don't want to tell anyone what this is and I only want people to be able to select either be or A or B. That's it and it is required. It must be filled in That's all I want next one was going to be cat to also be able to choose from a list So it's going to be cat to No helper text and remember we said we had a C an X or an R or we had an F, an L and a B. This just makes data entry a bit quicker and it also allows for Minimizing the mistakes that someone can make because easy to type on a keyboard the D key if you wanted to hit the F key or something like that but it does it could provide a little bit of Guesswork on a part of someone who gets hold of this data to see where we were going with that So it's a bit of a given take here, but for our accuracy's sake always constrain what someone is able to enter the data on that minimizes the Mistakes that can be made again It must be required next one remember that was just going to be text that we want because that was Va one Which was just the age and we have told each other everyone involved in the study If you do do the data collection mentally add Five to the patient's age if they were 32 or 33 I think was the example is make them 38 and that is what's going to be entered again It has it is required next one was also text remember that was this Va 2 It was required and that was going to be the patient's a b a 1 c and then lastly also just text It was going to be CRP, which we called Va 3 and it's also required and done. That's it It's all done Form is ready. We can see what the live form would look like and this is what it would look like if someone folded in These were what they were able to see there. We have nicely And it says this is required. I can't can't carry on before that was done end of story Now we can change the theme. You saw that I had a little Made it look look nice. These are some themes you can choose from they're not terribly inspiring and really Sometimes a bit overdone we we don't want any of that we're going to stick to that You can customize it by choosing a different header. You can choose your own image You can choose change the title there around when you say choose image there I think you can either drag it from from some Examples that are given here That perhaps is not the worst one. Let's select that or you can use your own pictures And if you now view the live form you see it's going to be or should at least be updated your form looks looks a little better Okay Now what we want to do though we finished with changing the form. We're just back to editing the questions now We can send the form electronically to our collaborators. So send forms in other words we can put Someone who's going to do the data collection first email address in there that it will appear on in the email inbox And when they open that email they can hit on for the forms inside of a browser Which is usually the safest thing to do when they do that they are going to see this live form and They just fill it in every time when they hit submit it is going to now create in our folder here something like this a Spreadsheet and there's our category our column head is there simple as that and we're going to say file download as and Remember comma separated values that that is what Julia likes to work with what the data frames package likes to work with comma separated values We're going to download it as a comma separated values all the patient details filled in they know missing values And it's that comrades comma separated value file that we're going to import into Julia box And we're going to use in our data analysis using Julia