9 Replies Latest reply on Feb 4, 2012 9:37 AM by kdefilip

    Yes/No in a number field in Filemaker Pro 11?

    SibenMadze

      Title

      Yes/No in a number field in Filemaker Pro 11?

      Post

      For some reason when I use a boolean statement such as "YES" or "NO" in a number type field FMP isn't calculating that field as a 0 or 1...

      I've tried to use a few different calculations including Set Field, Insert a Calculation and even just summing the the field with another summary type field. 

      If I just change it to a straight up number it works fine and it works to then format it to boolean but I don't want the number to be seen at all...

      I've gotten around it with a script and another field for the number value but this doesn't seem very elegant..

      I am new to FMP but I thought that this would work..

      I am using Filemaker Pro 11 for Mac.