calculations and tests in data entry forms

[Orby]

help with calculations and tests in data entry forms

Hi all,

I have a data entry form with several values that could be calculated and entered if I knew how. The FAA requires logging and tracking values that result in the following fields:
TimeSEL
TimeXC
TimeNight
TimeDay
TimeDual
TimePIC
TimeTotalFlight

My last flight resulted in entering 3.4, 3.4, 0, 3.4, 0, 3.4, 3.4

My question is: is it possible to add some sort of test expression in the TimeXC field which would examine an associated check box (i.e. "Was flight XC?") and if it was checked then would automatically calculate the flight hours (TachStop-TachStart) and enter the value in the TimeXC field?

Thanks for any help.

 

[krunalprajapati]

u can write OnClick event on checkbox.

if checkbox.value = True then
TimeXC = TachStop-TachStart
endif

u can lock the field too if u do not want to change it manually

 

[Orby]

krunalprajapati

Many thanks for the "if then" code. It is up and running happily now.

Orby