1 Reply Latest reply on Feb 22, 2015 3:09 PM by philmodjunk

    Calculation Help



      Calculation Help


      I'm building an ed solution to manage test registration and need help with some calculation logic dealing with testing accommodations.


      Testing accommodations are only allowable if a student has an IEP/504 (e.g. IEP/504 = "Yes").

      Each accommodation is permissible only on certain Test Type values  (e.g. Math, Reading, or Writing).

      The Read-Aloud accommodation is allowable on Math or Reading tests only (not Writing). I'm trying to create an auto-calculation & validation logic that would indicate "N/A" if the student does not have an IEP/504, but allow for the user to select "Yes" or "No" from a value drop-down list if the student does have an IEP.

      Case (

      ${IEP/504 Plan} = "No" ; "N/A" ;

      Test= "Writing"; "N/A";

      ???Then just select from the default value list defined for this field (i.e. "Yes" or "No")???



      Any suggestions?

        • 1. Re: Calculation Help

          Interesting. I just finished updating a part of our system to manage selecting testing accommodations in our database.

          I think that you have oversimplified your explanation as (at least here in California), Testing Accommodations are not specified only for 504 (physical challenges) but also for various learning challenges specified in a regular IEP.

          But if you are using FileMaker 13, I'd stack two objects, one on top of the other and use reciprocal "hide object when" expressions to make either the layout text: "N/A" or your value list formatted field of accommodations visible depending on which should be visible for a given student record.

          PS. I used a filtered selection portal inside a popover for building a list of accommodation statements for each of two different tests in my employer's system. I built on the concepts described for selection portals inside popovers found in:

          "Adventures in FileMaking #2 - Enhanced Value Selection".

          I didn't need the technique that I am describing here as we use a related record on a dedicated layout for students with special needs so one doesn't even get to the layout where you can select this unless the student already has been identified as having the necessary special needs designation and associated IEP. (Individual Education Plan)