The book page states "You can include values from other fields in math expressions. The math field result will be dynamically updated via ajax on the form as soon as the necessary fields are populated." This is true when other fields are static values. e.g. field_a and field_b are BOTH math expressions. Field_b is "dependent" on the value of field_a. When other static fields are changed, which affect field_a, it updates fine, however field_b does NOT.
IF, you "preview" before saving then field_b updates correctly. After "saving" the record and viewing, field_b is updated correctly. Is there some way to force an update of field_b, while in the "edit" mode? Can't the module be updated to cause this "dynamic" update? Thanks for any advise.
Comments
Comment #2
jakerogers commentedComment #3
jakerogers commentedI ended up just repeating the calcs from field_a in figuring field_b...it works fine but is very error prone in writing, due to so many interdependent calcs. For anyone who needs to calculate True Air Speed as a function of Density Altitude, here's the answer...
[field_ias]/(1-((6.8755856*10^-6)*(([field_ialt])+(145442.2*(1-([field_atm]/29.92126)^0.190261))+(((288.15-(.0019812*(([field_ialt])+(145442.2*(1-([field_atm]/29.92126)^0.190261)))))/.0019812)*(1-(((288.15-(.0019812*(([field_ialt])+(145442.2*(1-([field_atm]/29.92126)^0.190261)))))/([field_ta]+273.15))^.234969))))))^2.12794
where ias is IndicatedAirSpeed(feet), ialt is IndicatedAltitude(feet), atm is barometric pressure("Hg) and ta is AirTemperature (degrees C).