Search this forum for “questionnaire”.
Why don't you post your file so that we can take a look for you?
Note that when posting a file, (as suggeseted by Keywords) you can post a clone; or a file with dummy records if you don't want to others to view your data.
First, each nominee should have a unique ID. A number field with an auto-entered serial number works fine for this.
Next, each judge should get a FileMaker account in the file, e.g. their names, as long as they are unique.
Next, I would make a Scores table. It will have fields for:
- the nominee ID
- the judge login name
- a field for each category
- a calc field that adds up the categories and figures out the total weighted score.
You can script the creation of these records. There will be one per judge per nominee, i.e. 400 records. Does that sound like a lot? Don't worry, that is nothing really. Remember, each record only has a handful of fields.
You can set up a privilege set in Security where you can limit record viewing and editing with a calculation like this:
Get ( AccountName ) = yourScoresTableJudgeField
That way, each judge will only see their own scores. The nice thing about this method is that it works when you do a Find or in portals.
To add up the final results, you could either make a relationship from Nominees to Scores -- using that unique ID -- and calculated field like this: Sum( Scores::totalScore )
You could create a sub-summary report in the Scores file.
Tom's advise is appropriate.
I would differ in one respect.... I would have a single field for Category so that each score per person has 4 records. This variation will allow sorting and dealing with the categories separatelty... therefore enabling you to separately evaluate each winner of each category. It would also allow to have separate judges for each category and not see the scores for the other categories if that is suitable.
- a field for each category
First off, I hope you've been enjoying a restful Thanksgiving weekend (assuming you're American, that is).
Second, I apologize for the very long delay in even acknowledging your response many weeks ago. When I read your response I figured it was the one that most understood what I was trying to do. Further, I didn't attempt to apply your advice until the middle of last week, when I figured that I'd have some uninterrupted time to carefully push my FMP knowledge.
I'm stumped! I can't for the life of me figure out how to set the privilege set in Security to Get ( AccountName) = yourScoresTableJudgeField
I've set up an admin account for me and a test user account where I'd apply the privilege set -- but I can't find a window in the Security setting routine that allows me to specify a formula like this -- like the window that exists in defining field parameters.