Managing data & options - Help!!

[cookier18]

I am not sure whether this is very easy or very hard, but what I would like
to do is to collate data from an appraisal form into an excell document. ie:
collate names and scores from Infopath and manage them in excel.

Also is it possible to only provide a list of options once a box or button
has been ticked. For example a set list of questions appear if you check the
"not sure" box.

I hope this is clear and appreciate any help!!

Thanks

 

[Clay Fox]

Data Aggregation is a natural desire once you start collecting data but is
often dificult unless you set things up properly.

One option is SharePoint, but it is still difficult to get the bulk data.

What I have implemented many times is storing the data in SQL. Then you can
connect to it with Web reports or Excel or whatever reporting medium you want.

For your second question, add your check box.
Add a new section with your optional questions.
Then in the section properties use conditional formating where if the
checkbox is unchecked hide the section.