survey help

[jordioni]

I really tried to figure this out but I need to go to the pro's. I am building a yes/no survey with 25 questions for 4 stores. There will be 12 responses per store

I would like to sub summarize by store and total for each Q.

Thus far I have one layout with fields for each question and a checkbox value list for yes.

I appreciate any help in advance.

[Ender]

Hi Jordioni,

Your structure is not entirely clear, but I suspect that you have a Survey table with multiple fields for the questions. Although this structure gives great flexibility with the layout, it makes it hard to summarize the results when you want to see the summaries for multiple questions on one page.

Attached is a technique for summarizing the data from such a survey. It puts the results into a separate Results file/table. Although this example was created in FM6, it can be converted and the same technique can be used in FM7.

Another structure could be used instead, where instead of having a separate field for each question, you use a Question table and an Answer table in addition to the Survey table. The Question table holds the master list of questions for all surveys. The Answer table holds one record for each Question for each Survey. Setting up the interface and Answer record creation for this structure is more complicated, but the advantage is that it's really easy to generate reports within the Answer table.

Good Luck!

Survey.zip

[jordioni]

[color:green]Thank you. I will attempt both solutions.

[jordioni]

Your template is great but how can I modify to subsort by store?

[Ender]

Add a Sub-Summary by Survey::Store part in the Response file, and add Survey::Store to the Sort order.