How to display a Boolean field?
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,