Tami,
It looks like you make things unnecessarily complicated.
Assumed you have a field
testID number
and want to show whether it contains a number with "Yes",
you simply can use this field, put it on a layout and format it as
boolean showing "Yes" for true and nothing for false.
If testID is empty it won't show anyway.
If testID contains a zero when not set, you could say
showID = Case ( testID ; testID )
which automatically returns an empty string when testID is zero.
So what's the (true) purpose of all these calculations? I don't want
to download anything, really. Please put it in words.
In FM7-9 False returns zero and True returns one. There are NO quotes!
Winfried
On 29.08.2008, at 05:58, Tami Williams wrote:
You can download a FileMaker 6 file and a FileMaker 9 file that
demonstrates this from http://www.asktami.com/site.lasso?
fuseaction=client.listfiles&link=demo
In FileMaker 6 Yes, Y, True and T all translated to 1 and No, N,
False and F all translated to 0.
So, you could do stuff like have a serial number field "testID"
and have a text field "testYDisplay" with a the word "Yes" in it
and have another field "testCalc Txt" - a calc field with the
result = text - with this calc:
If(Left(testYDisplay, 1), testID, "")
and the result would be that the testID value would show in the
testCalc Txt field.
This works in FileMaker 6. It does NOT work in FileMaker 9.
Is there something I'm missing? Is there a way to get this to work
in Filemaker 9? Or do I have to find all the calcs like this and
make them:
If(Left(testYDisplay, 1) = "Yes", testID, "")
Thanks in advance. (I'm converting a FMP 6 solution to FMP 9 and
this is a problem...)
Tami Williams
Creative Computing
