How to create a questionnaire in SharePoint Online

now do marketing activities often need to collect user information, to all users to print a questionnaire survey, questionnaires collected back after the need to do input Excel Action, need to count the data of each problem, and then by the statistics of the personnel to send relevant information to the relevant departments, in fact, the middle of a lot of time, but also waste a lot of manpower. If the customer feedback questionnaire for the product, once the customer is interested to understand, and the entire data feedback if more than 3 days, then the sales staff in the timely follow-up is influential.

and several advertising industry friends learned that at present, our industry's party B, in helping customers to do channel conferences, customer meetings, still use the traditional paper print questionnaire, and customers are still staying in this way. If you tell the customer, after the meeting can be a short period of time will be able to collect data and feedback to the customer, I believe that customer satisfaction will also improve a lot. Customers can use the time they originally needed to spend on the statistics table to analyze the data and write the closing report.

in both of these scenarios, we can Excel Questionnaire is located in the chain to deliver into a QR code, this is more easily than shaking a way to achieve, because each user holds the device is not uniform, and some because of Bluetooth reasons, some because of the system reasons. Sweep function, almost all smartphones can be achieved, in the implementation of the operation is more easily presented.

Some people ask, where will all this data be kept? Will there be irrelevant people who see the data I've collected? No. Because we can create a site that belongs to this team in a Sharepoint site and limit the sharing of Excel, only authorized users will be able to access the document.

Then, I will show the whole process of creation, and everyone will find the ash is always simple. Ha

Use your own o365 account number and password login: https://login.partner.microsoftonline.cn

Select the nine Gongge in the upper left corner to select a website.

650) this.width=650; "title=" tune. png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M00/80/E9/ Wkiol1dea-jwo2bpaadq2whncdi657.png "alt=" Wkiol1dea-jwo2bpaadq2whncdi657.png "/>

Select a good site, or create a new site, click "New", select " Excel Survey.

650) this.width=650; "title=" Tune 2.png "style=" Float:none; src= "http://s3.51cto.com/wyfs02/M01/80/E9/ Wkiol1dea-rwwet0aaf8ebqzhuy565.png "alt=" Wkiol1dea-rwwet0aaf8ebqzhuy565.png "/>

Create a document name and click Confirm.

650) this.width=650; "title=" Tune 3.png "style=" Float:none; src= "http://s4.51cto.com/wyfs02/M02/80/EB/ Wkiom1deaviipkalaafpnnoyt0u281.png "alt=" Wkiom1deaviipkalaafpnnoyt0u281.png "/>

On the edit page, you can create a questionnaire question and customize the answer form.

650) this.width=650; "title=" Tune 5.png "style=" Float:none; src= "http://s5.51cto.com/wyfs02/M00/80/E9/ Wkiol1dea-yxqfenaaci1tg6wr8810.png "alt=" Wkiol1dea-yxqfenaaci1tg6wr8810.png "/>

650) this.width=650; "title=" Tune 6.png "style=" Float:none; src= "http://s2.51cto.com/wyfs02/M00/80/EB/ Wkiom1deavmguntkaaccilcviia559.png "alt=" Wkiom1deavmguntkaaccilcviia559.png "/>

Once you've customized the questionnaire, click "Save and View" or click "Share Survey" to copy the link to the object you want to share.

650) this.width=650; "title=" Tune 7.png "style=" Float:none; src= "http://s5.51cto.com/wyfs02/M01/80/EB/ Wkiom1deavugldwaaahanfxj57a304.png "alt=" Wkiom1deavugldwaaahanfxj57a304.png "/>

650) this.width=650; "title=" Tune 8.png "style=" Float:none; src= "http://s4.51cto.com/wyfs02/M01/80/E9/ Wkiol1dea-6j9yfgaaat5jil8mc926.png "alt=" Wkiol1dea-6j9yfgaaat5jil8mc926.png "/>

If you want to be more convenient to share to more users, you can use the QR code generator, join the link, generate a QR code.

then save the QR code as a picture, save it on the site, copy URL.

650) this.width=650; "title=" Tune 9.png "style=" Float:none; src= "Http://s1.51cto.com/wyfs02/M02/80/E9/wKioL1dEa-_ Akurtaafcp25tm6e302.png "alt=" Wkiol1dea-_akurtaafcp25tm6e302.png "/>

650) this.width=650; "title=" Tune 10.png "style=" Float:none; src= "http://s2.51cto.com/wyfs02/M02/80/EB/ Wkiom1deav7zy5nvaafwktwpj6q137.png "alt=" Wkiom1deav7zy5nvaafwktwpj6q137.png "/>

Select the pinion in the top right corner of the website and click "Edit Page".

650) this.width=650; "Width=" "height=" 482 "title=" 11.png "style=" Float:none; "src=" http://s5.51cto.com/wyfs02/ M00/80/eb/wkiom1deav_jojfpaaea80owxla985.png "alt=" Wkiom1deav_jojfpaaea80owxla985.png "/>

Add Web Part, select "Media and Content", picture Viewer, Add.

650) this.width=650; "title=" Tune 12.png "style=" Float:none; src= "Http://s4.51cto.com/wyfs02/M00/80/E9/wKioL1dEa_ Sanyabaadv6e_v4x4342.png "alt=" Wkiol1dea_sanyabaadv6e_v4x4342.png "/>

Click on "Open Tool pane" to set the QR code image The URL is copied in.

650) this.width=650; "title=" Tune 13.png "style=" Float:none; src= "Http://s4.51cto.com/wyfs02/M00/80/E9/wKioL1dEa_ Bw545zaae3oq3lvp0143.png "alt=" Wkiol1dea_bw545zaae3oq3lvp0143.png "/>

650) this.width=650; "title=" Tune 14.png "style=" Float:none; src= "Http://s2.51cto.com/wyfs02/M01/80/E9/wKioL1dEa_ Adbdiwaaboyepfum8138.png "alt=" Wkiol1dea_adbdiwaaboyepfum8138.png "/>

Save the edit page and you're done.

650) this.width=650; "title=" Tune 15.png "style=" Float:none; src= "http://s4.51cto.com/wyfs02/M02/80/EB/ Wkiom1deawwc2jbkaafq2kpanqs507.png "alt=" Wkiom1deawwc2jbkaafq2kpanqs507.png "/>

Please take out your cell phone, open it, sweep it, and see the results.

650) this.width=650; "title=" Tune 16.png "style=" Float:none; src= "Http://s1.51cto.com/wyfs02/M02/80/E9/wKioL1dEa_ Qbt72kaagqiyybv58147.png "alt=" Wkiol1dea_qbt72kaagqiyybv58147.png "/>

Okay, back to Excel will see that a person has already answered the questionnaire. The information collection no longer needs to be manually processed several times.

650) this.width=650; "title=" Tune 17.png "style=" Float:none; src= "Http://s5.51cto.com/wyfs02/M00/80/E9/wKioL1dEa_ Vx7qdaaad9h0i2d9y604.png "alt=" Wkiol1dea_vx7qdaaad9h0i2d9y604.png "/>

It's very simple. HA ~ ~

Mira, Jin Tong

This article is from the "Mira said Microsoft Cloud" blog, please be sure to keep this source http://mira04.blog.51cto.com/10769231/1782758

How to create a questionnaire in SharePoint Online