How do I make sure the validation is run if I change the Units?
First thing that comes to mind is:
Try setting up a calculation that reverses the Celsius result calculation, and validate that value; i.e.,
WaterTempUnits = "Celsius" ; WaterTemp ;
WaterTempUnits = "Kelvin" ; WaterTemp + 273,15 ;
WaterTempUnits = "Fahrenheit"; ( WaterTemp + 32 ) * 1,8
adjustedValue ≥ -10 and adjustedValue ≤ 50
Please check the math; I simply used the reverse operators from the other calc …
PS:: Like your neat
What if you apply the same validation to the WaterTempUnits field?
In this particular case I would put a trigger on the modifiable fields that runs a script whenever there are changes, see enclosed example. No validation on the contents themselves.
waterTemp.fmp12.zip 66.0 K
I used the Let functions and then figured out I made a rookie mistake and didn't un-click the Validate only on modification box.