1 Reply Latest reply on May 13, 2010 1:50 PM by comment_1

    How to display a Boolean field?

    t_e_x

      Title

      How to display a Boolean field?

      Post

      I am new to Filemaker development (though I do have database experience).  I am using Filemaker 8 Pro on a Mac.

       

      I am trying to implement a "text box" show if a job is currently active or not.  I have a boolean field within the table called boolActive.  If the value is false, the job has been completed.

       

      Within a layout, I would like next to the check box "Job Active" or "Job Completed" with conditional formatting.

       

      However, I have unable to figure out how to make a textbox based on a function [if(boolActive= TRUE), "JOB ACTIVE", else "Job Completed"]

       

      Thanks for the help,

       

      M