If Empty Calculation

[Donkick]

What am I missing?

I have a field "Inventory" as a check box.

I have a calculation field called "inventory flag".

The calculation is:

Case ( IsEmpty (Inventory) ; ""; " INV. ")

I want the user to check the box in the field "Inventory" and have Filemaker put the letters INV into the field "inventory flag".

the contents of the field (Inventory flag) only show up when the field is selected?

[comment]

Make sure the result of your calculation is set to Text, and that the calculation is evaluated when all referenced fields are empty.

BTW, you probably don't need this field, because the Inventory field itself could serve as a flag.

[Donkick]

Thats it!

The calculation result was set as a number not text.

Thanks, I won't make that mistake again