Summary to 3x3 Grid

[rdean13]

Based on a user's answers of 2 questions on (n) Records, I need (ValueList)summary results to be displayed on a fixed grid. I have downloaded the "Checkbox Summary" example and searched the forum, but not found enough information to help me get over the hump.

I am attaching a base file and left out any relationship definitions in hopes that someone can get me going in the right direction. I have simplified my overall need to a 3x3 grid.

Thank you very much,

Robb

Summary_Grid.fp7.zip

[John Mark Osborne]

I have attached a solution that uses the GetSummary and GetNthRecord inside a looping script to get the results you want fairly dynamically. It works really well as long as you always have a record for every question and answer. If you don't, the results will be in the wrong column or row. It is possible to add a test for whether one of the grid spaces should be skipped if there are no records. This will require you to provide FileMaker with a list of the order of the values so it can determine if the next set of records it is summarizing should go in the next grid or the following. I haven't provided this but I have created a more complicated solution that does handle this. You can download it from my DevCon 2002 presentation in the Resources area of my web site. The files are written in FileMaker 6 but they certainly can be converted to .fp7 to help you write the rest of this script.

Summary_Grid.fp7.zip

[rdean13]

Superb! Looking forward to reviewing your DevCon file too. Thank you so very much for your help and taking the time!

Cheers!

Robb

[comment]

The example does not make much sense (to me). It seems the subject is required to select a single reply from 9 possible choices. Why do we need two fields to hold a single choice?

[rdean13]

Sorry for any confusion- I was only providing a small slice of a greater need with the hope of getting pointed in the right direction. In this case, Mr. Osborne nailed it & I am off and running.

In the actual solution the user will need to answer a series of questions & I am attempting to summarize their response on a fixed graphic. The two fields were intended to represent two distinct questions.