AnsweredAssumed Answered

Need aid on generating a report from a survey layout.

Question asked by DanFlores on Dec 12, 2011
Latest reply on Apr 29, 2018 by philmodjunk


Need aid on generating a report from a survey layout.


First time using FM pro and I've hit a snag. This is what I've been tasked with:

Translate the paper version of our survey to a FM database.

Set up layout for the survey.

Generate a report that tallies the number of times a given choice ( 1-5 ) is chosen for each question.

i.e Section A Question 1:  5 "1s',  3 "2s" , 4 "3s" etc.

I am also tasked with collecting all comments from each section ( there are 4 sections ) and displaying them in the report one after another. 

i.e. Section B Comments: It was ok, I think it needs this, poorly implemented ...etc

I've hit a road block as how to generate the report with the tallies and the comments. I have a field for each Question and set up radio buttons for the 1-5 choices, just not sure how to tally them.

I have no clue about gathering the comments, I was thinking from a programming stand point of searching the comment fields then sort and separating with commas in a new record, but not knowable enough of FM pro to implement that.

Any and all advice is welcome.