4 Replies Latest reply on Feb 12, 2015 1:24 PM by amandahbell

    Field validation using calculation of calculated field not validating after operator in calculated field changes

    amandahbell

      The Set-up:

       

      I have three fields:

      WaterTemp

      WaterTempUnits

      WaterTempCelsius

       

      I need to make sure that the combination of WaterTemp and Units is within  -10.0 - 50.0 °C.

       

      WaterTempCelsius is a calculated field with the following Calculation:

      Case (

      WaterTempUnits = "Celsius";WaterTemp;

      WaterTempUnits = "Kelvin"; WaterTemp - 273.15;

      WaterTempUnits = "Fahrenheit"; ((WaterTemp-32)/1.8);

      )

      I turned off Indexing in hopes that would cause it to always calculate.

       

      The Validation for WaterTemp is:

      WaterTempCelsius  ≥  -10  and WaterTempCelsius ≤  50

      I added a Message that states the range it is supposed to be. I have the "Always" checked for Validate in this Field and not allowing user override.

       

      The Problem:

      When I put in a WaterTemp that is within the range in Celsius (say 0) and have the units set to Celsius. I do not get an error.--GOOD

      When I put in a WaterTemp that is within the range in Celsius (say 0) and then CHANGE the units to Kelvin (result -273.15 °C). I do not get an error.--BAD

      When I modify the WaterTemp with the units selected it validates.--GOOD


      The Question:
      How do I make sure the validation is run if I change the Units?


      I've only had FileMaker for 4 days, so be gentle.