Donkick Posted October 5, 2007 Share Posted October 5, 2007 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? Link to comment Share on other sites More sharing options...
comment Posted October 5, 2007 Share Posted October 5, 2007 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. Link to comment Share on other sites More sharing options...
Donkick Posted October 8, 2007 Author Share Posted October 8, 2007 Thats it! The calculation result was set as a number not text. Thanks, I won't make that mistake again Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6137 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now