March 18, 201411 yr I have a check box thats currently having some on/off issues. The field of the checkbox (QuotedStatus) can be checked with the value "Quoted" I have another field that basically says if QuotedStatus = "Quoted" Then... However its not working... its not recognizing the "Quoted" when the box is checked. Anything I'm missing?
March 18, 201411 yr Author Its a portal filtered by this: BWIA2 FMP11 2::ACCT CODE 1 = "RQ" and Month ( Get ( CurrentDate )) & "/" & Year ( Get ( CurrentDate ) ) = Month ( BWIA2 FMP11 2::EFFECTIVE DATE ) & "/" & Year ( BWIA2 FMP11 2::EFFECTIVE DATE ) and BWIA2 FMP11 2::PRODUCER CODE = "3" and BWIA2 FMP11 2::QUOTED STATUS = "Quoted"
March 18, 201411 yr I have a check box thats currently having some on/off issues. The field of the checkbox (QuotedStatus) can be checked with the value "Quoted" I suggest that you a number field with a 1/0 value list for your Boolean fields; they can only be in one of two states, the meaning is clear from the field name, you can add a label on the layout (there are even Boolean formatting options for short texts), and calculations boil down to a simple query like this one: Case ( quoted? ; // your result … ) have another field that basically says if QuotedStatus = "Quoted" Then... However its not working... its not recognizing the "Quoted" when the box is checked. Anything I'm missing? For your current issue: if in doubt, display the field as edit box and inspect its contents. The checkbox means a certain value is present, but not necessarily that the field is identical to that value.
Create an account or sign in to comment