Solved

Survey form in SharePoint WSS 3.0

Posted on 2010-11-09
14
797 Views
Last Modified: 2012-05-10
As I am new in SharePoint, can someone explain me how I can put a Survey questioner of 25-35 qustions including comments section. It can be database driven. It can be infopath 2007 or sharepoint form. I need step by step instructions which are easier to follow.
0
Comment
Question by:nsdlsandy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
  • +1
14 Comments
 
LVL 15

Assisted Solution

by:AmmarR
AmmarR earned 150 total points
ID: 34099526
It can be infopath 2007 and sharepoint form.

but sharepoint form will be much simpler to start with.

Just create a custom list in SharePoint,  create columns and decide the data type
and the form will be automatically created to add values.

after creating the Sharepoint list, you can use the sharepoint form.

if you want to use infopath, you will need to create a form library in Sharepoint. its just similar to the way you create a list.

Infopath looks nicer than a sharepoint form but it needs you to read a bit about infopath and how to create a form with it.

i suggest you just start with sharepoint since your new.

check these links to create infopath with sharepoint

http://office.microsoft.com/en-us/infopath-help/create-a-form-library-on-a-sharepoint-site-HP001096804.aspx

http://blah.winsmarts.com/2006-10-InfoPath_2007_Forms_Server_MOSS_2007.aspx

comparing sharepoint with infopath
http://blogs.msdn.com/b/infopath/archive/2010/04/22/comparing-list-and-form-library-forms.aspx

good luck
0
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34099539
0
 
LVL 15

Expert Comment

by:melli111
ID: 34101823
I agree with Zephyr to use the built-in survey on SharePoint, unless you meant that one of your requirements is to have this survey pull or push data from an existing database?
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 1

Author Comment

by:nsdlsandy
ID: 34102878
I do have requirement to push and pull data using database.
0
 
LVL 15

Expert Comment

by:AmmarR
ID: 34109281
do you mean you want to migrate data between database and sharepoint

there are many tools out there, its called ETL (extract, transfer and Load)

for Microsoft there is SSIS

http://www.sqlmag.com/article/database-administration/build-a-simple-etl-system-with-ssis.aspx
0
 
LVL 1

Author Comment

by:nsdlsandy
ID: 34112496

Thanks for your response. I need to build the Survey so users can take it on Sharepoint. Once they take the Survey, I need to get the data and display in reports to be sent by email.

So my confusion is where is this Survey data stored. Is it in Database in some table which I can access from outside of Sharepoint using some Reporting tools?

Please let me know.



0
 
LVL 1

Author Comment

by:nsdlsandy
ID: 34112545
Another thing is, users who take survey shouldn't know the answers posted by other users.
Can we do this in built in survey of sharepoint?
0
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34113287
to answer your question about where the data is stored:
it depends on how you have it configured.  if you have it configured to save the data in sharepoint, then it will be in the sharepoint content db, and you can access it there for reporting.  my guess is that this is the way you'll want to configure it (save to sharepoint).

and yes, you can control security so that users can only see their own.
0
 
LVL 1

Author Comment

by:nsdlsandy
ID: 34123252
Zephyr,

Thanks for your response. Like I mentioned I am new in Sharepoint and I would appreciate if youcan tell me how we can control security, so that users can only see their own response.

thanks
0
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 350 total points
ID: 34138146
create a view on the list with a filter where Created By = [Me]

this will hide items that the user did not create themselves.
since you are using a workflow, you may need to verify that Created By is being set to the user's name.  if it's not, then either do so using your workflow, or set another field to the user's name and filter that in such a way that  column = [Me]
0
 
LVL 1

Author Comment

by:nsdlsandy
ID: 34149675
This works. Thanks for guiding me towards a right solution.
0
 
LVL 1

Author Closing Comment

by:nsdlsandy
ID: 34154324
thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question