[Music]
okay guys what we're gonna show you
today is how to gather data from
multiple users and bring it into your
Google sheet these users won't even have
to see your sheet they won't have to
interact with it they're going to get a
Google Form sent to them and you can
style this however you want and make it
nice and easy for them so the point is
to get these fields from people and
we're going to distribute it in
different ways so before you create the
spreadsheet you're going to start in
Google Drive
you're going to right-click on any empty
space in the desktop or you could start
from the new button you go down to more
is this not one of these three main
programs so go to more click left click
on Google Forms that's how I created
this file that you see right here I call
the data gathering so let's go to that I
already have it open in this tab and
this is where you start to build your
form so the first thing you want to do
is you can want to give it a title I
gave mine a terribly generic title but
it works and decide what information you
want to gather I thought it was a good
example to just leave it as names and
email addresses and then act like I was
doing a survey where I wanted to get in
touch with people and we'll go through
that but let's focus on this first field
so I want a first name forms needs to
know how to treat that response is it
going to be a short answer where they
just type in some characters into a
field or should it be giving them
multiple choice etc we'll go over some
of the main ones of these but for now as
a short answer all right they're just
going to type their name and you'll
notice I made this required what that
means is they can't submit this form
with this field blank and they'll have a
little red asterisked when they look at
the form that's going to show them
that's required last name is going to be
the same as is email address this is
just set up to accept a short answer but
when we come down to what they should we
contact you this question is given the
type update so you come down to the
bottom it's the second one up from the
bottom
if you left-click on that what that does
is it makes this field smart enough to
know that it should only accept the
valid date value this type of question
was actually pre-populated once I typed
what day should we Kansai to you it knew
that I probably wanted a date field you
can change it but it did pre select this
and let's flip over to the actual survey
itself for one second and then we'll go
back so I want to show you what happens
for this date field first of all it
pre-populates month/day/year if you're
in a country where these are in a
different order it's going to populate
that differently it just knows them in
the United States and you can enter the
date just using your number keys so
that's November or you can use this
drop-down you'll get a little calendar
picker and let's just let's just select
today and this ensures that this value
is going to come into your Google sheet
as a date so it can be sorted and worked
with as a valid date dates are hard to
get from users because oftentimes
they're just typed in in a format that
your spreadsheet doesn't recognize so
this will work around that problem let's
go back to our form this next question
is to show multiple choice so so what
time should we contact you
you know 8:00 to 5:00 or after 5:00 and
the user will be able to check one of
these two values and the point of doing
this instead of happiness as a short
answer is you'll be able to sort by the
users that you can call during the day
and the users that you call in the
afternoon if you just had them type this
in they would do it lots of different
ways you wouldn't be able to sort it at
all so if you have thousands of answers
you want to try to do multiple choice if
possible this is another multiple choice
question but the last one do you own a
car
this is just another form of multiple
choice but it's going to give your user
different interface so instead of radio
buttons it's going to give them
checkboxes that will also allow them to
check more than one yeah yeah sort of
they'll be able to do that
really after looking at this question
you probably want radio boxes here
because it's either yes no or yes sort
of right so let's change
but if you have a question that you
could answer more than one way but
there's still only limited ways that you
can answer it I would use those
checkboxes so now let's send this survey
out and this send feature is going to
completely differentiate it from just
trying to get people to fill out a
spreadsheet when you go up to the send
button and you left-click on it you're
going to see several different options
here and because I'm using Google Forms
from inside of a page esuite account I
have this first option which is to
automatically collect the email
addresses from other people in my
organization and you can also share it
out to people in your organization
easily if that would be helpful to you I
have a link down in the description and
a code that you can use for 20% off and
here's your different options on how to
send us so if you email it I already
emailed it to myself we're going to look
at that in a second but you can check or
not check this box and this is important
so if you want to include the form and
the email that gives your users just one
less thing to go through so it's
probably going to give you a better
response rate so I did that I said
include the form the email and if we
come over to my gmail this is the email
that I got so it says Google Forms on
the table
this is the title of your form and if
you click on that that'll bring you to
the web interface of the form but you
can fill it all out right here and click
Submit it makes it really easy for your
users another way to send this out would
be just the link so you could email it
or you could text it to someone and
they'll click on this and then we'll
bring them right to the interface even
if they're using a mobile device it's a
responsive website so it will work
really well in the mobile device or you
can embed it so I wanted to show you
this option it will give you code to
paste on the back side of your website I
did that I left the width and the height
as what they were and when I come over
to my website I just made a little test
page here just show you scroll up here's
the form so you would direct people to
the web page address that you put this
on
they can fill out the form while they're
still on your website they don't have to
leave and when they get to the end of it
they could submit it from here
so that's several different ways to
gather information from your users
without them ever touching the
spreadsheet and then when you're done
you left-click the responses and from
here you can grab the data click on this
icon and it will bring you to the sheet
and you'll notice it's the name of the
form just with the word responses in
parentheses and this is all of the data
that came in from the users that were
submitting it these are the required
fields so you notice every single one of
them has a value if you want to require
all of your fields you can but just keep
in mind that you're going to get better
response rate if you don't require
everything because maybe your user
doesn't know or they are just tired of
the form they want to click Submit but
now that you have it in here you can
sort by these fields so these date
fields you can sort by those because you
know that they're valid dates in one of
the great applications of pulling in
dates and probably times as well is that
you can use this to gather times and
then put it into a formula to pay your
employees to figure out the number of
hours that they've worked so that's it
that's how you get data from multiple
users into a spreadsheet so that you can
report on it from there I hope that was
helpful you can check out this next
video that I talked about briefly is how
to make a timesheet so if you're
collecting time from employees you would
just flow it into this template and if
you liked this video and you want to see
others like it please hit subscribe
thanks
[Music]