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,
Filemaker doesn't do layout calculations. You need to define a calculation field (with a Text result) for this.
Another option is to format the Boolean field as Boolean (under Format > Number…) - but the number of characters you can use is fairly limited.