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.