November 18, 201213 yr Newbies I would greatly appreciate any advice. I think what I am trying to do is simple, I just can not figure it out. I have a field "LotA" and a field "LotAcres". I am trying to write a calculation for LotAcres field that will automatically put 4.6 in to the field if the "LotA" field is NOT empty... If the "LotA" field is empty then the "LotAcres" field I want to remain empty. Thank you for your help.
November 18, 201213 yr Hi skiSystems, welcome to FMForums. :-) Would you ever need the ability to manually override or change that LotAcres? If not then the field should a calculation (result is number) and look like this: Case ( not IsEmpty ( LotA ) ; 4.6 ) If you need ability to override then it should be number with auto-enter by calculation and uncheck 'Do not Replace'. Oops notice calc change adding another parenthesis.
Create an account or sign in to comment