Thanks for such a well-organized, clear and informative video! You shown me a tool I had honestly forgotten about. Now I'm ready to take my use of forms back to the office. I'm excited to use these tips!
I cannot begin to express how excited I was to find this. I sat through a really sad demonstration today - being kind. I was so frustrated after it. Then I did a quick search and found this! Wow!!!!!!
Hey, This's a definitive guide on Office Forms. But nowhere you've shown how to collect the email address without filling manually! Ideally this should be the most important feature to collect responses from the users.
Amazing video! So excited to use this. I had 3 questions as a noob to all this. 🚴♂️1. If you had a question about distance can you add a drop down box to let the user select units next to their answer (ie mm, inches metres, feet, miles, km etc ?) 👨👩👧👦 2. Can you add data validation to an answer ie between 10 and 60 is allowed and flash up a warning if outside the limits? 🚦3. Can you set a formula based on answers in forms to take the responder to most relevant next question (or end the form) based on where the answer falls in a range of figures. For instance the responder types in their actual age and if its between 10-17 end form, if aged 18-35 goto q4, if aged 36 to 60 goto q5 etc?
Thank you for your informative videos on using Microsoft Forms! I have a specific question regarding Microsoft Forms: I need to create a demographics profile for a group of 15-20 people. Instead of having these individuals fill out the form themselves, I want to enter the information myself for each person. Is it possible to set up a Microsoft Form where I, as the form creator, can input and store the demographic data for multiple people? If so, could you guide me on how to do this effectively? Looking forward to your guidance
Hi Mike, I want to create a simple form/quiz, which has a series of questions weighing certain points with 3 options as answers to the question - Yes, No and Not Applicable. What I specifically want is when Yes is selected as an answer the question earns the points, if Not applicable is selected the question becomes invalid in the total points calculation and if No is selected then the submitter has a provision to comment (describe why it was No) I hope you will be able to help
Love this!!!!!! Super helpful summary for our upcoming MIE training session over the weekend!! Keep up the fantastic work you and your team are doing!!! ❤️❤️❤️
Hi Mike -I have created a question with choice options Strongly agree, agree, disagree and strongly agree - How can I add a feature in that question so that my users can add comments in relation to the question. I could do this with Survey monkey
Thanks so much. Lots of great information here! Quick (or perhaps not so quick question): If I've created a Forms quiz/survey, how can I upload that into a specific Teams meeting in real time when I'm conducting a meeting/lecture/workshop?
This was super informative. I got a ton of tips to use with my classes. Fav tip of all was number 25. Being able to view a video and check on comprehension at the same time is brilliant! :)
Hi Mike, thanks for the great video. Are there any plans to be able to add pre-prepared forms into the chat in Teams? When teaching it would be much easier if we could pre-prepare our polls and quizzes rather than trying to type this as we teach.
Thanks Mike, such a helpful video! Do you know if polls/surveys can be auto scheduled? For example, if I run a weekly group (same time each week) and am looking for weekly feedback post group? Thanks for your help.
@Mike Tholfsen This feature is severely limited in my Office 365 Home Premium subscription desktop version. I cannot create the custom questions you entered into your poll, only binary questions: "approve/reject", "yes/no/maybe", etc. Microsoft is slipping back into their old habits, arbitrarily excluding useful features from normal paying customers. Wow! I thought we they had finally caught up to the 21st century. I was wrong!
Hi Mike, this is awesome video..one of the best on Teams form...thanks a lot, Just need one help I have created a form for new joiner but when he submitted I got some weird columns in excel sheet this is bit strange, how to overcome this issue...please suggest
Great video! Hoping you can answer this question. I created a question with options for the answer (class name). I want to sort them in alphabetical order. I did not see this option but was able to manually reorder the options using the dots on the left. Do you know if there is a way to automatically sort them alphabetically rather than having to move them manually? Thank you!
Excellent film. Widely informative and told concisely. This is must-watch recommendation, as I try to explain the benefits of M365 to a cautious, recently introduced workforce. Thank you Mike.
May 21, 2022 -- FORMS is almost workable for my purpose except for these capabilities... > need option to add a text description below each choice option, to help the user make the right choice. > need to collapse the spacing so it all prints on 1 page > need to print the related Excel file row number on the user's side, somewhere > need to add an organizational logo > need to include a footer with 2 signature & date rows > need to know if 2 users can fill out a form in the isentical time frame > need to restrict visual access to the related Excel workbook to creator/owner of spreadsheet, without locking users out of the form. Question: Any chance MS will add these features? Request for feedback...has anyone else used a free forms builder app that can do the things in my list above? I work for an NFP, so really need to build it myself. Many thanks :)
Thank you so much! It is very helpful. How do I change to multiple answers on the liked the table questions type? I like to get multiple answers on liked questions type. There is only an option for multiple answers just for choice questions.
Hello Mike, thanks a lot for this Video. I have two questions. We would like to use forms before a Job Interview. I would like to know via Email when the Person has finished the Form. Where can i find this application? Further i would like to get the data from each Person sepparetely, no Collection. If a few persons filling the Form i will probably lose the overview. How i can See the data from each Person an what they have answered? Thanks a lot, Nelly
Thank you so much! Got to learn few new things today from you What if I want to get geo location of the person filling out the forms?. How do I do it??
It would be great if Microsoft Forms offered the users the option to create folders in order to classify and organize all our questionnaires. Thanks for the video...!
Is it possible to have the form added to an outlook email so the recipient(s) can fill it out from the email as opposed to including a link they’re required to open in order to respond? Thank you!!
Hello. I'm having an issue with microsoft forms and didn't find and information reggarding it. The issue: I have a forms which people input their responses everyday but sometimes they fill the date camp with the wrong one, example: Today is 01/26/2024 but they type 01/27/2024. The problem is that I have a KPI which i analyze in a daily basis, so this may cause a misinformation with cases that are not accounted to 01/26/2024. I want a way to fixate the date on the forms, cause with this i can eliminate the cases which people may type the wrong date. Is there any way to do this? Thanks in advance.
These are GREAT! BUT... I do have a question. I am creating a form to pre-authorize travel. Question #8 is Estimated Total Cost of Trip [ based on 9, 10, & 11 ]. Is there a way to enter a dollar amount in each #9, 10, and 11 and then have them total to line 8? Thank you.
Hi Mike this was really helpful, really appreciate what I have learned from this video. I can't find it on my online 365 excel integration with forms. when I go to Insert I can't find the Forms option, do you know why that can happen? thanks again
Found Forms yesterday!! I simply cannot figure out how to get the bullet points for section like 'which day of the week'. Using 'Choice' only gives me bars
I’m having an issue with my form data not showing up in Excel. I created a form within Excel web. The first day, I had 3 submissions. The showed up in my Excel sheet. Today I had 6 more submissions. However, my Excel sheet skipped 4 submissions and then listed the last couple. The entry numbers are sequential but there is a gap. I closed Excel and went into the form. I can see all 9 records there. When I say view in Excel, it opens Excel, but the 4 records are still missing. How can I get the missing data out of the form and into Excel?
Great Video. I have always used Google Forms so I am just learning this one. Which do you feel is better or are they essentially the same? Also, why does the excel form download (responses) add extra feedback columns that repeat your questions when there are no feedback questions in the form? I did not find anything in settings or any options for this.
Hi, this was good but didn’t answer my question. I am trying to add a list of options with text boxes beside them. Is this possible? The other option that also does not seem to be available is to have more than one text box under a question. Hoping you can help. Thanks!
This was very helpful, but I've spent hours trying to figure out how to change default text in the forms. I'm sending out a massive invite on behalf of my department, and the email subject line has my name in it instead of the department. Also, it oddly says "You are invited to do this" at the top of my form. It's awkward and doesn't belong. Looks like I'm stuck with it. But I learned some other tricks from this video so thanks.
Thank you! Is MS Forms a separate purchase from Office 365? I don't see it as an option on the plan comparison page. Chat support doesn't seem to be working.
Is there a way to change the footer at the end of Microsoft forms? Mine currently says: "This content is created by the owner of the form. The data you submit will be sent to the form owner. Microsoft is not responsible for the privacy or security practices of its customers, including those of this form owner. Never give out your password. Powered by Microsoft Forms | The owner of this form has not provided a privacy statement as to how they will use your response data. Do not provide personal or sensitive information. | Terms of use" I want to be able to change this to give my forms more credibility. Is this possible and if so, how can it be done?
Thanks for sharing. I have an issue when using the Likert Scale, i.e. I have a long list of statements (>10), so the Statements are not visible when one scrolls down. How does one correct this?
Hi. I need some advice. I have a form with several sections. Each section is to be responded to by different team members. Is that possible? To send each section to different people? Thank U!
Hi Mike, Hope you are doing well!!! How to generate some unique reference id in forms or How can we hide some activity in forms , so i will enter some unique id and hide or disable it ..so that users can change it. thanks in advance
Good afternoon. I was wondering if there is a way that Forms supports mutliple text answers to a single question, basically one question with two free form text answer boxes. I was told that this was possible but everything I have found is that this is not possible to do.
Hi, is there anyway to combine forms? I'm a teacher and trying to make a midterm exam. I would like to combine 3 forms into one. Is there a way? I know you can on Google.
hi Mike, thank you for your videos, please do you know how can I restrict an answer. if i want to offer 3 options but each one has a limited capacity, is it possible? ideally, once one option is full its should disappear. thank you
I added multiple videos for each question for my questionaire. All starts in the same time, and there is a mess. There is a way to block it? Autostart of video off?
Hi Thanks for this video very helpful. I have a situation i want to redirect a user again to first question once he/she submits the response. Scenario is user can submit it multiple times.
Hi Mike, in FORMS we have the questions and sections, I wonder if we can have a comment "page" that we can add to a survey where we can paste a link/upload a document, so we can branch it with any question? for example: If the answer is "NO" this will guide a person to a page where he may find a link, or a document...etc could you please help on this?
LOVED THIS!!! Thank you so much, totally demystified some of my struggles. Thanks so much!
Glad it was helpful!
Thanks for such a well-organized, clear and informative video! You shown me a tool I had honestly forgotten about. Now I'm ready to take my use of forms back to the office. I'm excited to use these tips!
Tip 21 was great! Sometimes I forget to look for cross-app features.
Excellent. Quick, clear, highly informative!
I cannot begin to express how excited I was to find this. I sat through a really sad demonstration today - being kind. I was so frustrated after it. Then I did a quick search and found this! Wow!!!!!!
Thanks. MS needs to add signature option on the forms.
The quiz Math input feature my favourite. Thank u so much for this in-depth educational video.
Great video Mike. Thank you for these great tips! Sincerely appreciated.
Love this chocfull of tips . I just shared this with my colleagues at work, I'm sure they'll be delighted too
Great, thanks for sharing!
My account Annie sebmuged
Hey, This's a definitive guide on Office Forms. But nowhere you've shown how to collect the email address without filling manually! Ideally this should be the most important feature to collect responses from the users.
Thanks for all the advice ❤️
I learned a lot of from this video ☺️❤️
You're amazingly effecient 🏆
Thanks a lot 💚
Thanks for the tips. Very helpful!
Glad it was helpful!
Excellent - thanks for the great work!
Amazing video! So excited to use this. I had 3 questions as a noob to all this.
🚴♂️1. If you had a question about distance can you add a drop down box to let the user select units next to their answer (ie mm, inches metres, feet, miles, km etc ?)
👨👩👧👦 2. Can you add data validation to an answer ie between 10 and 60 is allowed and flash up a warning if outside the limits?
🚦3. Can you set a formula based on answers in forms to take the responder to most relevant next question (or end the form) based on where the answer falls in a range of figures.
For instance the responder types in their actual age and if its between 10-17 end form, if aged 18-35 goto q4, if aged 36 to 60 goto q5 etc?
Great questions. Those are currently not supported but you can go to uservoice to add them or vote: microsoftforms.uservoice.com
Super cool video Mike! Thank you!
Glad you liked it!
Thank you for this video.
Outstanding!
Very informative. Thank you for sharing.
Really enjoyed this! Question for you - can I have the form be the last thing they see, without having to go back to the video? Thanks
Thank you for your informative videos on using Microsoft Forms! I have a specific question regarding Microsoft Forms:
I need to create a demographics profile for a group of 15-20 people. Instead of having these individuals fill out the form themselves, I want to enter the information myself for each person. Is it possible to set up a Microsoft Form where I, as the form creator, can input and store the demographic data for multiple people? If so, could you guide me on how to do this effectively?
Looking forward to your guidance
Such as great video, thank you! Got some great tips for my form.
So glad!
Awesome help thank you..
Hi Mike,
I want to create a simple form/quiz, which has a series of questions weighing certain points with 3 options as answers to the question - Yes, No and Not Applicable. What I specifically want is when Yes is selected as an answer the question earns the points, if Not applicable is selected the question becomes invalid in the total points calculation and if No is selected then the submitter has a provision to comment (describe why it was No)
I hope you will be able to help
Love this!!!!!! Super helpful summary for our upcoming MIE training session over the weekend!! Keep up the fantastic work you and your team are doing!!! ❤️❤️❤️
Gs was helpful. Hope your summit goes well!
thanks for your help mike!
Hi Mike -I have created a question with choice options Strongly agree, agree, disagree and strongly agree - How can I add a feature in that question so that my users can add comments in relation to the question. I could do this with Survey monkey
I came here for this.
Thanks so much.
Lots of great information here!
Quick (or perhaps not so quick question): If I've created a Forms quiz/survey, how can I upload that into a specific Teams meeting in real time when I'm conducting a meeting/lecture/workshop?
Hello! Im learned a lot...and now i have new ideas. Thanks for the video, super cool and informative.
I will see again.
Have a nice day!
Thx
Glad it was useful
1000 thanks
Oh no, I cant believe you covered an entire course for just a couple of minutes!!!! This is marvelous!!! Thank you so much for sharing!!!
This was super informative. I got a ton of tips to use with my classes. Fav tip of all was number 25. Being able to view a video and check on comprehension at the same time is brilliant! :)
Glad it was helpful
great video, didn't answer my question, but gave me some great ideas. Thx a lot.
Hi Mike, thanks for the great video. Are there any plans to be able to add pre-prepared forms into the chat in Teams? When teaching it would be much easier if we could pre-prepare our polls and quizzes rather than trying to type this as we teach.
Setting a pre-made quiz / form as an assignment is a workaround for this.
Great video and love all the tips. As of this day(07/04/23) the file upload option does not appear new question anymore😒
Thank you ! really helpfull !
Thanks Mike, such a helpful video! Do you know if polls/surveys can be auto scheduled? For example, if I run a weekly group (same time each week) and am looking for weekly feedback post group? Thanks for your help.
@Mike Tholfsen This feature is severely limited in my Office 365 Home Premium subscription desktop version. I cannot create the custom questions you entered into your poll, only binary questions: "approve/reject", "yes/no/maybe", etc. Microsoft is slipping back into their old habits, arbitrarily excluding useful features from normal paying customers. Wow! I thought we they had finally caught up to the 21st century. I was wrong!
Hi Mike, this is awesome video..one of the best on Teams form...thanks a lot, Just need one help I have created a form for new joiner but when he submitted I got some weird columns in excel sheet this is bit strange, how to overcome this issue...please suggest
Great video! Hoping you can answer this question. I created a question with options for the answer (class name). I want to sort them in alphabetical order. I did not see this option but was able to manually reorder the options using the dots on the left. Do you know if there is a way to automatically sort them alphabetically rather than having to move them manually? Thank you!
very useful video, is there a chance to merge two forms together?
Not at this time
Great video - particularly appreciate that you took the time to add a table of contents so I could skip to the tips new to me: thanks!
Awesome, thank you!
Thank you for these tips. Can you share how to generate certificates from office form?
Excellent film. Widely informative and told concisely. This is must-watch recommendation, as I try to explain the benefits of M365 to a cautious, recently introduced workforce. Thank you Mike.
May 21, 2022 -- FORMS is almost workable for my purpose except for these capabilities...
> need option to add a text description below each choice option, to help the user make the right choice.
> need to collapse the spacing so it all prints on 1 page
> need to print the related Excel file row number on the user's side, somewhere
> need to add an organizational logo
> need to include a footer with 2 signature & date rows
> need to know if 2 users can fill out a form in the isentical time frame
> need to restrict visual access to the related Excel workbook to creator/owner of spreadsheet, without locking users out of the form.
Question: Any chance MS will add these features?
Request for feedback...has anyone else used a free forms builder app that can do the things in my list above? I work for an NFP, so really need to build it myself. Many thanks :)
Thank you so much! It is very helpful. How do I change to multiple answers on the liked the table questions type? I like to get multiple answers on liked questions type. There is only an option for multiple answers just for choice questions.
Fastastic Skills Mike.. this was worth the time watching. Thank you for making it
This is awesome - going to make keeping all parts of an assignment/school work in the same place
Hello Mike, thanks a lot for this Video.
I have two questions. We would like to use forms before a Job Interview.
I would like to know via Email when the Person has finished the Form. Where can i find this application?
Further i would like to get the data from each Person sepparetely, no Collection. If a few persons filling the Form i will probably lose the overview. How i can See the data from each Person an what they have answered?
Thanks a lot, Nelly
Hello! Can teachers know when the student open Microsoft forms and how long did it take for them to submit their answers?
Thanks...but how to allow people to edit their submitted responses via forms
Thank you so much! Got to learn few new things today from you What if I want to get geo location of the person filling out the forms?. How do I do it??
It’s very informative thank you
It would be great if Microsoft Forms offered the users the option to create folders in order to classify and organize all our questionnaires. Thanks for the video...!
That's a great idea! The team is actively working on adding Forms organization
how can a user of the form take picture of a document and attached to the form before submitting
We don't yet support this scenario but hope to in the near future
Very helpful! Thank you for creating such a great material!
Informative video! FYI: formal name for a "dot, dot, dot" menu is an "ellipsis" menu.
Yeah, I know. It's more fun to say "dot dot dot" and it also translates better to other countries 😄
Is it possible to have the form added to an outlook email so the recipient(s) can fill it out from the email as opposed to including a link they’re required to open in order to respond? Thank you!!
superhelpful video! Thanks a lot 👍
Can you still integrate Forms with the new version of Stream?
Not at this time, but we hope to add this back in the future
Great video thank you for it. Is this on forms premium? I don't have some of your options so I thought maybe it's a premium version. Thank you.
This should be on all versions. Are you using Consumer of Office 365? Also, are you on EDU or Commercial versions?
@@MikeTholfsen Consumer and commercial version
I think you need the 100USD per month version to use some of the features that have been shown. For a small business it's to costly.
@@Malcyt99 thank you very much the help is much appreciated
@@MikeTholfsen ا ربي بل سي ل ربي بس ١لب سي ل
Hello. I'm having an issue with microsoft forms and didn't find and information reggarding it. The issue: I have a forms which people input their responses everyday but sometimes they fill the date camp with the wrong one, example:
Today is 01/26/2024 but they type 01/27/2024. The problem is that I have a KPI which i analyze in a daily basis, so this may cause a misinformation with cases that are not accounted to 01/26/2024.
I want a way to fixate the date on the forms, cause with this i can eliminate the cases which people may type the wrong date. Is there any way to do this? Thanks in advance.
These are GREAT! BUT... I do have a question. I am creating a form to pre-authorize travel. Question #8 is Estimated Total Cost of Trip [ based on 9, 10, & 11 ]. Is there a way to enter a dollar amount in each #9, 10, and 11 and then have them total to line 8? Thank you.
Super Tips on Forms! Thanks a lot Mike, many are going to be very useful to me in my work! 😊👍
Great, glad to hear that!
How can I get an email notification when someone completes a form?
That was beneficial!
Thank you 🙏🏻
Hi Mike,
18th Tip is missing
super video
Thanks!
Hi Mike
this was really helpful, really appreciate what I have learned from this video.
I can't find it on my online 365 excel integration with forms. when I go to Insert I can't find the Forms option, do you know why that can happen?
thanks again
Great. Kudos!
Hi,
I have successfully created MS Form, I am getting duplicated columns in excel sheet. How can I fix it, somebody can help me please.
Wow flipping awesome!😯 I have been using MS Forms now and I learnt A LOT! Thanks!
Glad it helped!
Thanks Mike, very helpful 👍
BTW, to show I was paying attention in class, I doubt you'll get any takers for "Buger" Heaven as a lunch venue! 🤢😄
Found Forms yesterday!! I simply cannot figure out how to get the bullet points for section like 'which day of the week'. Using 'Choice' only gives me bars
I’m having an issue with my form data not showing up in Excel. I created a form within Excel web. The first day, I had 3 submissions. The showed up in my Excel sheet. Today I had 6 more submissions. However, my Excel sheet skipped 4 submissions and then listed the last couple. The entry numbers are sequential but there is a gap. I closed Excel and went into the form. I can see all 9 records there. When I say view in Excel, it opens Excel, but the 4 records are still missing. How can I get the missing data out of the form and into Excel?
Great Video. I have always used Google Forms so I am just learning this one. Which do you feel is better or are they essentially the same? Also, why does the excel form download (responses) add extra feedback columns that repeat your questions when there are no feedback questions in the form? I did not find anything in settings or any options for this.
Hi, this was good but didn’t answer my question. I am trying to add a list of options with text boxes beside them. Is this possible? The other option that also does not seem to be available is to have more than one text box under a question. Hoping you can help. Thanks!
This was very helpful, but I've spent hours trying to figure out how to change default text in the forms. I'm sending out a massive invite on behalf of my department, and the email subject line has my name in it instead of the department. Also, it oddly says "You are invited to do this" at the top of my form. It's awkward and doesn't belong. Looks like I'm stuck with it. But I learned some other tricks from this video so thanks.
Hey Mike, Its only Forms but no Quiz, Right? I can't get the score from a quiz on automate to update a Sharepoint List. Do you know if its possible?
Thank you! Is MS Forms a separate purchase from Office 365? I don't see it as an option on the plan comparison page. Chat support doesn't seem to be working.
The answers for multiple question could also be shuffled, if you want each student to have different set of answers 🙂👍
Wish you could move the columns and stuff once in excel. The endless columns flowing to the right is a killer.
Is there a way to change the footer at the end of Microsoft forms? Mine currently says:
"This content is created by the owner of the form. The data you submit will be sent to the form owner. Microsoft is not responsible for the privacy or security practices of its customers, including those of this form owner. Never give out your password.
Powered by Microsoft Forms | The owner of this form has not provided a privacy statement as to how they will use your response data. Do not provide personal or sensitive information. | Terms of use"
I want to be able to change this to give my forms more credibility. Is this possible and if so, how can it be done?
Thank you for this but are you using premium because I can't find "6:05 Upload a File when answering question" on my own end.
Thanks for sharing. I have an issue when using the Likert Scale, i.e. I have a long list of statements (>10), so the Statements are not visible when one scrolls down. How does one correct this?
Hi. I need some advice. I have a form with several sections. Each section is to be responded to by different team members. Is that possible? To send each section to different people? Thank U!
Hi Mike,
Hope you are doing well!!!
How to generate some unique reference id in forms or
How can we hide some activity in forms , so i will enter some unique id and hide or disable it ..so that users can change it.
thanks in advance
Good afternoon. I was wondering if there is a way that Forms supports mutliple text answers to a single question, basically one question with two free form text answer boxes. I was told that this was possible but everything I have found is that this is not possible to do.
Hi, is there anyway to combine forms? I'm a teacher and trying to make a midterm exam. I would like to combine 3 forms into one. Is there a way? I know you can on Google.
Thankyou so much
Would you know if you change the Header Font Color to Black, still showing white when preview. is that a bug?
Can we customize the 'The form is now closed' message? It is important to communicate why the form is closed to avoid complaints
Not at this time
hi Mike, thank you for your videos, please do you know how can I restrict an answer. if i want to offer 3 options but each one has a limited capacity, is it possible? ideally, once one option is full its should disappear. thank you
How do I create a Ranking based free text question? Eg. Name your top five favorite movies in order of ranking?
1.
2.
3.
4.
5.
I added multiple videos for each question for my questionaire. All starts in the same time, and there is a mess. There is a way to block it? Autostart of video off?
Hi Thanks for this video very helpful.
I have a situation i want to redirect a user again to first question once he/she submits the response. Scenario is user can submit it multiple times.
I just created a Form and have zero idea where the document is even saved. Cant pick another save-to location eather. This app is a confusing mess.
Hi Mike,
in FORMS we have the questions and sections, I wonder if we can have a comment "page" that we can add to a survey where we can paste a link/upload a document, so we can branch it with any question?
for example: If the answer is "NO" this will guide a person to a page where he may find a link, or a document...etc
could you please help on this?
You can put in a request at microsoftforms.uservoice.com
I liked the presentation, bit it went too fast !!!
Great video thank you. Is it possible to create a form that students can complete in 2 stages, I'm thinking of a learning plan. Thank you
I want to use forms for registering customer profiles which export to an excel database. Is this possible? Are there any security concerns