It seems as though i have a question every day now...which is a reason why i love this forum so much!!
I'm wondering if i can have an auto enter text field to where the auto enter picks the filled in field between 2 fields..( that doesn't make that much sense)
For instance....i have 2 fields (test 1 and test 2). I want a my auto enter text field to enter in the value of whichever field (test 1 or test 2) that has something entered into it.
So if test 1's value is "Valid" and test 2's value is "", then my auto enter text field will enter in "Valid".
I'm hoping this is possible. :)
Thanks for the help!
IF ( isEmpty ( test 2 ) ; Test 1 ; Test 2 ) (If you have more than two fields, use a case function.)