Forum Discussion
COLLECTING DATA VIA FORMS - CONFUSED ABOUT MY OPTIONS
In my opinion, stick with Microsoft Forms.
It's easy for people to use without too much hassle. It's supported by Microsoft Flow so you can set up triggers and actions based on responses. And it's a product that Microsoft are committed to. You can see the coming planned enhancements on the roadmap here: https://products.office.com/en-us/business/office-365-roadmap?filters=%26freeformsearch=forms#abc
And you can suggest new features and view other suggestions here: https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box
I'm not an SQL person - can you take a Forms response file as a .csv and upload the data into SQL, if that's your preference?
I know Forms has some limitations right now, but it will grow. It was scheduled to come out of Preview and into General Availability this January.
-Sonia
Thank you Sonia.
That is good news re Forms full view being active soon (hopefully).
I can probably make good use of that for now, and as you say, build on it as the facilities progress.
I have no problem converting the csv or excel file to the database tables, but would have liked the ability to use my data to fill forms and run queries etc to populate mailing lists etc.
But, it's all a learning curve either way, so will keep going until I find my way.
Again, thanks for your response - much appreciated :)