So I have a list of fields for a score sheet I am using as part of a datasheet in my internship. Each field has 5 boxes which are checked according to never, infrequently, sometimes, fairly often and always. I was wondering how I could assign numbers to these checkboxes (0-4 respectively) and have filemaker add up all the values for a final score.

I'd suggest the following:

1. Create a Value List with the preset values:

Never

Infrequently

Sometimes

Fairly Often

Always

2. Define a text field called 'Freq' and format it as a radio button (not a check box).

3. Define a calculation field to convert 'Freq' to a number:

Case ( Freq = "Never" ; 0 ; Freq = "Infrequently" ; 1 ; Freq = "Sometimes" ; 2; Freq = "Fairly Often"; 3 ; Freq = "Always"; 4)