AnsweredAssumed Answered

How to display a Boolean field?

Question asked by t_e_x on May 13, 2010
Latest reply on May 13, 2010 by comment_1

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

Outcomes