Check if container has data

[gardenlevel]

I want to create a report where there will be a check mark if a container field has data. I figured I would do this by creating a container field and a calculation field to go with the first. How would I you write that script to check if the container field has data?

What do I set for the IF statement to automatically fill in a check box? Say IF ( Container; has data; XXXXX )

[mr_vodka]

You can simply use a IsEmpty () as a check.

BTW. If you use a checkbox as a boolean with a value list of just 1. You can have your calc be simply:

not IsEmpty ( container )

Edited March 13, 2008 by Guest
Added BTW

[mr_vodka]

Also since you are using FileMaker 9, you can leverage the ability of conditional formatting. you do not have to create an additional calculation just to display a checkbox.

So on your report, you can use a certain character with either a Webding font or Wingding font to display the checkmark. Then you can use conditional formatting to change the text color to the same color as the background of your report (most likely white) if the container field is Empty.

lowercase 'a' in Webdings will give you a checkmark

For wingdings: ü will give you a checkmark and þ will give you a checkmark within a box.