AnsweredAssumed Answered

Conditional Field Calculation

Question asked by wrobinson on Nov 3, 2012
Latest reply on Nov 3, 2012 by wrobinson


Conditional Field Calculation


     I'm new to calculations in FileMaker, and I'm trying to have one field respond to the entries of two other fields. I've tried using the 'or' function, but haven't found a way to make it work.

     For example, on the table at left, if a '0' is entered under column one and a '0' is entered again under column two, then column three results in a '1'. I have achieved this using the Case logical function, but have not figured out how to expand to all of the other combinations. Ideally, entering any of the four digits in column one into a field, and then entering any of the corresponding digits in column two into a second field, would yield the corresponding number in the third column into the third field. 

     Here are the two tables that I'd like to automate using this calculations. Any feedback would be greatly appreciated!