Forum Discussion
See who did not take the survey in Microsoft Form
I send you a message. If you have time.
I like your solution and think it can work for me. But need more help
The responses can be output in an excel format. How hard would it be to initially enter all the recipients into the form, so that it's easy to see who has already answered and who hasn't. I need to verify that everyone has responded, and that workaround is crazy.
- Hugo_RoyenFeb 21, 2024Copper ContributorUnder settings, you can use the option to register the names of all respondents. If you do, their name and e-mail will appear in the results table that you can export to Excel. That could make it easier to compare it with you list of invitees.
- StephanieSolargikFeb 21, 2024Copper Contributor
Hugo_Royen of course I did that. However my form was addressed to a mailing list (e.g. a department or the whole company) and that doesn't generate a list of invitees to compare to. 😞
Anyway, the form worked pretty well for me.
- chris-thompsonFeb 21, 2024Copper Contributor
Hugo_Royen Yeah but that requires additional steps which could take some considerable time with a large list of people. It would seem pretty intuitive if you have the option to collect email addresses of those responding already, that it should be able to also very quickly generate a list of who has not yet responded. Simply put, why would anyone who is collecting email addresses in a form NOT be interested in who has not yet responded? This is a pretty big oversight (and I would imagine a very low hanging fruit for a developer) for something that would benefit nearly everyone who uses forms.