Return to FileMaker.com
Calculation field help
Say we have three fields: A, B, C
Field A is a text fieldField B is a text field that has a global valueField C is a calculation field
I want to make the calculation field C to be equal to the values of field A and B if field A is not empty, but I would like for the calculation field C to stay empty if field A is blank.
Can anyone help me please?
Seems simple. Try this:
case ( not isempty (A), A & B )
Retrieving data ...