8 Replies Latest reply on Dec 6, 2014 4:51 PM by indyj

    Hide object when calculation problem



      Hide object when calculation problem


           Hi all,

           This is probably a really stupid question, but I am new to Filemaker. I am trying to hide some fields based on the content of another field, but I can't figure out how to do the calculation for more than one condition. 

           I have a field "Bone" that will contain the names of different bones, chosen from a dropdown. I also have a group of fields that I want to hide when the selected bone is NOT a cranial bone. But there are many cranial bones, and I can't figure out how to write the calculation so that the fields become invisible when one of many bone names are chosen - I tried without a function: just "Hide object when: Inventory::Bone  ≠  "Cranium" or "Frontal" or "Parietal" etc etc , or as an If ( Inventory::Bone  ≠  "Cranium" or "Frontal"; 1) and Case function (I tried repeating Inventory::Bone  ≠ after each 'or" as well), but I can't get it to work for more than one bone. What am I doing wrong?

           I appreciate the help! Thanks!