Thank you so much for doing this! With this whole Covid-19 situation, a lot of people are trying to learn how to create things to make their remote work easier and organized. I was going to do a very bare-bones spreadsheet but wanted to push myself to learn something new. You explained everything clearly and made me feel at ease with the process. Truly, thanks a bunch!! 🤗💐
@ProlificOaktree4 жыл бұрын
No worries. I'm working on a bunch more distance learning related videos now!
@LazarusStr4 жыл бұрын
@@ProlificOaktree Can't wait to check them out! 💖
@vincentdomingo34843 жыл бұрын
What happens if you submit 6 times into the google form? Will your email appear 6 times too?
@pamkrueger4934 жыл бұрын
Thank you for taking the time to explain how to use Google Forms. Very helpful!
@ProlificOaktree4 жыл бұрын
You're welcome. I'm glad you liked it.
@sikimsuseni18014 жыл бұрын
This was so helpful. I run an Influencer Marketing agency and I have been looking for a sign-up form for those that are interested in working with my company. This helped a lot, thank you so much for sharing.
@ProlificOaktree4 жыл бұрын
Thanks, I’m glad you liked it.
@nhnka4 жыл бұрын
Thank you so much! You taught everything I didn't know. Terima kasih ❤
@iwansetiabudi13 жыл бұрын
Sama sama
@laureng75232 жыл бұрын
Thank you! Can one individual fill out more than response? Trying to create a daily checklist that records the answers each time.
@justinebatchelder7283 ай бұрын
Super helpful!
@ProlificOaktreeАй бұрын
Thank you!
@jamiemorse3804 Жыл бұрын
I have a question. I have 7 rows (day of the week) and 3 columns (three different weeks). When opening the data in a spreadsheet it does not differentiate between the data in column 1, 2 and 3. It lumps them all together on one row. How do I get a separate response for each column? Thanks!
@maluborja59392 жыл бұрын
This was really very helpful! Thank you very much for sharing this. For some reason, I could not view the excel spread sheet where the responses go. Please teach where to find it. Thank you.
@keithevanson44484 жыл бұрын
Easily understood, Thank you.
@ProlificOaktree4 жыл бұрын
That's what I was going for. Thanks!
@ravikiran29314 жыл бұрын
Its Very Good Understandable Video. Thank you very much sir
@annavorisek9950 Жыл бұрын
This Video was perfect! Thank you
@ProlificOaktree Жыл бұрын
Glad it was helpful!
@MrViciousway2 жыл бұрын
Thanks! 🙏 Have a potential client that wanted to know if it was possible to add a questionnaire/survey to a website, that exports data to a spread sheet. Straight forward video, Everything you want and more 👍🏼
@elizabethhughart63193 жыл бұрын
OMG!!! What an awesome, clear, succinct tutorial!!!!!!!!!!!!!!!!
@vincentdomingo34843 жыл бұрын
What happens if you submit 6 times into the google form? Will your email appear 6 times too?
@by19073 жыл бұрын
Thank you for this tutorial! Saved me so much time.
@ProlificOaktree3 жыл бұрын
Glad to hear it!
@harshavardhanreddy65585 жыл бұрын
Hey Buddy your video is very helpful Thanks for the video I have one doubt, is there anyway that when user select multiple check boxes for one question, I have to get all the answers in spread sheet into single cell by cama( ' , ' ) separated
@adamsteinfurth93155 жыл бұрын
Yes, that is how the values come into the spreadsheet when the user selects more than one checkbox, for example. One cell per questions, separated by commas if multiple answers.
@BethMHB2 жыл бұрын
Thank you for this. Is there any way to format how the data appears on the Google Sheet? For example, the answers I send through my Form show up on the Sheet as Arial font, size 10. I'd like the font to automatically be larger for staff accessibility. Is that possible?
@ProlificOaktree2 жыл бұрын
I just tested and it doesn't seem to work. It appears the new results come in as size 10 Arial regardless.
@David-fq5un2 жыл бұрын
Why is there no NUMBER field? e.g. to enter wages
@ProlificOaktree2 жыл бұрын
I think any of the fields that allow characters would accept numbers. However, I don't see any that would limit the input to a number if that's what you're looking for. Good luck!
@catherinenamoc81263 жыл бұрын
How to create dashboard by that data? can you make a video?
@sentb5744 Жыл бұрын
Very helpful
@ProlificOaktree Жыл бұрын
Glad you think so!
@JamesBHL74 жыл бұрын
Very useful video. Just a question, can the same respondent fill-in the form multiple times with different data? Will it still be captured in Google Sheet? I'm trying to gather info about hundreds of premises which are managed by dozens of managers. One manager might managed 10-20 premises. So, can one manager key-in the info for multiple premises?
@ProlificOaktree4 жыл бұрын
Yes, there is an option to limit respondents to one response. Leave that unchecked.
@sibastoune3 ай бұрын
Thank you!
@ProlificOaktree2 ай бұрын
You're welcome!
@dianamjeshtri13684 жыл бұрын
I’ve accidentally deleted the section with questions from google form. Is there any method find witch response matches with which question?
@ProlificOaktree4 жыл бұрын
I would try to open it from Forms again and see if they happen to be in the same order. Otherwise, consider using VLOOKUP.
@peaceforpetsdogadventures74175 жыл бұрын
Do you know if I can "Sort" this spread sheet in Reverse Chronicle order? - Meaning that the most recent submission would be listed first?
@ProlificOaktree5 жыл бұрын
You can always sort tables either way, ascending or descending. Just pick the different direction when you choose the sort from the menus.
@Ken-ts6ex4 жыл бұрын
If I just wanted to use the form to collect my own personal data would I need to email it to myself everyday or is there a better way.
@ProlificOaktree4 жыл бұрын
Just let it accumulate in the form and look at it whenever you want. No need to email.
@staninjapan075 жыл бұрын
Thank you. About the form-in-an-email function... If the recipient has email other than Google Mail, does this function work? It is dependent upon recipients being Google account holders?
@ProlificOaktree5 жыл бұрын
No, the surveys can be sent to any email address and the recipient does not have to have a Google account to enter data into Forms unless you chose that users can only submit one response. In order for that to work, users will have to sign in so Forms can know who they are.
@staninjapan075 жыл бұрын
@@ProlificOaktree Thanks
@386rio4 жыл бұрын
after input in google form and showing spreadsheet, can the input combining with vlookup function?
@ProlificOaktree4 жыл бұрын
Yes, you have full control of the resultant spreadsheet.
@franzfms864 жыл бұрын
Does this forms automatically create an excel file for the master list of a survey or registration forms? Or I have to create new form under google account?
@ProlificOaktree4 жыл бұрын
It automatically creates a spreadsheet in Sheets, not Excel.
@franzfms864 жыл бұрын
@@ProlificOaktree thanks for the info.
@sreehari1574 жыл бұрын
Thanks for making this video and it's very helpful
@ProlificOaktree4 жыл бұрын
Glad you liked it.
@seeasif4 жыл бұрын
Easy Peasy. Great. Thanks.
@ProlificOaktree4 жыл бұрын
Lemon squeezy.
@MrMosoani2 жыл бұрын
is there a way it will automatically capture the employee's email? how can we recover the data that were accidentally deleted while retaining the new entries?
@ProlificOaktree2 жыл бұрын
Capturing emails is a setting when you create the form. You could also create a field and ask for it.
@MrMosoani2 жыл бұрын
@@ProlificOaktree thanks. I wonder if it's possible to restore previous version but can also retain the new entries.
@denaehemminger47524 жыл бұрын
I have a question my sheet always has the “request for edit” button and I do not know how to get rid of that off my form
@ProlificOaktree4 жыл бұрын
You've gotta go to File then Make a copy. It's probably not in your Drive yet.
@mjngltn4 жыл бұрын
Great video, thank you. Is there any way to get additional information if the user answers No to a question?
@ProlificOaktree4 жыл бұрын
Yes, it's called Branching. See here kzbin.info/www/bejne/qp7Ve6CKgdysp6c
@maintainapplication44274 жыл бұрын
if you want to evaluate the given answers and be notified if someone answers "No", please have a look at the following Google Sheets Add-On: gsuite.google.com/marketplace/app/maintainapp/842811037884
@palomeke4 жыл бұрын
Hi! Is there any way of gathering data from Google Slides? I want my students to fill in a kid of pdf form and gather the PDFs. Is it possible? Thank you!!!
@ProlificOaktree4 жыл бұрын
Not that I'm aware of. It's not designed for that.
@theharrisenglishlearningpo59533 жыл бұрын
Thank you for the video. Is it possible to import grades from a multiple-choice Google quiz into a spreadsheet? If so, could you make a video on that?
@ProlificOaktree3 жыл бұрын
If you used Google Forms, it has built in functionality to export to Sheets. I think it's in the area where you look at the grades. Not in Classroom but in Forms.
@theharrisenglishlearningpo59533 жыл бұрын
@@ProlificOaktree Thank you for the reply, I appreciate that. I'll check it out.
@theharrisenglishlearningpo59533 жыл бұрын
@@ProlificOaktree Thank you!
@vincentdomingo34843 жыл бұрын
What happens if you submit 6 times into the google form? Will your email appear 6 times too?
@goldysharma733 жыл бұрын
Hello I am from India Can you tell us how we can search or sequenced the name alphabetically ? Please let me know this one
@ProlificOaktree3 жыл бұрын
You can use SORT.
@janellegibson32864 жыл бұрын
How can you transfer data from a google form ( survey) to google sheets, but instead pie data, display numbers. For instance, how many people said yes or no to certain answers.
@ProlificOaktree4 жыл бұрын
You can see the charts before you export. If you want them in Sheets after the export, you would have to insert them from Sheets.
@janellegibson32864 жыл бұрын
@@ProlificOaktree I was asking more about Pivot. I am having trouble doing Pivot. Is it because I have many questions in my survey that are long and not just a yes and a no? If I want to pivot the edit asks for names. I just want to have the questions and a tally of the answers, yes, no maybe.
@ProlificOaktree4 жыл бұрын
@@janellegibson3286 May check out a few basic pivot table videos...
@janellegibson32864 жыл бұрын
I have, but I think there are limitations. It will not allow me to do certain functions. Like only the questions and then just the simple answer. For example, do you like bananas? Yes, no maybe. It will allow only one question, but when I add the next one it moves the first question and messes up the whole format.
@asadmehmood61734 жыл бұрын
Easily understood.
@ProlificOaktree4 жыл бұрын
Thank you!
@nanasuryana78765 жыл бұрын
Thank you for share the video.... Did you have script for "sms to spreadsheet"?. I want to receive sms only on spreadsheet
@ProlificOaktree5 жыл бұрын
I don't know of a way to do that.
@nanasuryana78765 жыл бұрын
@@ProlificOaktree that is ok... Thank you for reply...
@danmalone23304 жыл бұрын
Great video!
@ProlificOaktree4 жыл бұрын
Thanks!
@002sprinkles4 жыл бұрын
Hello, my supervisor shared a google sheet with me a couple of weeks ago with the form linked to it. He asked me to update the responses on the sheet as more people have filled out the form since then. I asked for access but he said I do have access as the google form is linked on the sheet. However when I click on edit form it says on the bottom request edit access and when I click on show summary of responses it's locked and says I need access. Is there a way that I can extract the data from the form (that he created) so I can populate the spreadsheet with the most recently submitted answers?
@ProlificOaktree4 жыл бұрын
No, it sounds like you have a permissions problem.
@002sprinkles4 жыл бұрын
@@ProlificOaktree Thank you for getting back to me so quickly! When he does grant me permission would I just click on form --> show summary of responses and then pull the updated data? I've never done this on a Google form that I didn't create
@ProlificOaktree4 жыл бұрын
@@002sprinkles Yes, assuming the owner of the Form has given you the right permissions.
@002sprinkles4 жыл бұрын
@@ProlificOaktree Thank you so much!!
@jmafanador62484 жыл бұрын
I created the report, but I erased it, and when I try to view it, the system does not allow me to do it. Is there a way to create again the report, after deleting the previous one? Thanks in advance.
@ProlificOaktree4 жыл бұрын
It will create a new Sheet if you fill out the form again. If you want the old spreadsheet back, look in the Trash in Google Drive.
@martinafanador38594 жыл бұрын
@@ProlificOaktree thanks for the answer. The problem is that I also deleted from the trash :( If you know any other options I would really appreciate it. Thanks in advance.
@ProlificOaktree4 жыл бұрын
@@martinafanador3859 If you're in an organization account, contact your admin ASAP. The files will be gone in 20 days. If you're in your own account, the file's probably gone.
@chaymaaelmoutarabbi27574 жыл бұрын
@@martinafanador3859 hello friend I just had the same problem happen to me yesterday hhhhh and spent 3 hours refilling a new questionnaire with the answers I got from people on the first one I only did 50 so far and there are over 100 answers left😢 I'm struggling with it now
@vaishnavis704 жыл бұрын
i have gathered data but i dont how to score it
@ProlificOaktree4 жыл бұрын
Thanks to your questions, I made a new video about how to grade a quiz here: kzbin.info/www/bejne/nWnXhWWNf7eUbK8
@zunairaakram87863 жыл бұрын
Thanks 👍
@ProlificOaktree3 жыл бұрын
Welcome 👍
@gameKing202453 жыл бұрын
dude, IT DIDNT WORK BECAUSE I DONT HAVE THE SCRIPT
@ProlificOaktree3 жыл бұрын
The script for the form? Not sure what you're talking about.
@whkrause4 жыл бұрын
After 8 minutes I still don't know how to link a Sheet to a Form, which was the title of this video. Tons of irrelevant info though.