Field Content Calculation

[SteveS]

Hello,

I am seeking assistance with a calculation problem. This involves a search within one record based on the values entered in a text field called, "Classification." I have a script that prints to a particular layout, based on the text entered in the classification field. This classification field has a value list of six, "Class A" "Class B" and so on. I tried the following. IF[involved layout::Classification = "Class A" or "Class B" or "Class C" Go to print layout one. The calculation works with only one Class entered.

I have been at this problem for a while now and have decided to ask the experts.

[mr_vodka]

First, the test should be

IF[involved layout::Classification = "Class A" or

Involved layout::Classification = "Class B" or Involved layout::Classification = "Class C" ]

Also, assuming that you are using a checkbox for your classification field, each time you check a value, it actually is makeing the value of the field to be each value checked seperated by a pilcrow (carriage return).

So if Class A, Class B, Class C has been checked then it actually:

Class A¶

Class B¶

Class C

Therefore, when you do your test of IF[involved layout::Classification = "Class A"] it will not work because the values do not match.

You can either create individual fields for each Class and have it as a checkbox ( preferably boolean ) or Use PatternCount to find if teh value has been selected.

[SteveS]

I would like to thank you for your quick response.

Would this calculation work if I used the value list as a drop down list? Or would it look at each entry as a carriage return.

Steve

[mr_vodka]

How is your current classification field setup? You want to be able to assign each record muliple classifications correct?

[SteveS]

It is set up as a text field, with a value drop down list containing the the different classes, "Class A" "Class B" etc.

[mr_vodka]

Ok, then use the step that I posted earlier.

If[involved layout::Classification = "Class A" or

Involved layout::Classification = "Class B" or Involved layout::Classification = "Class C" ]

Go to Layout [ "Layout1" ]

Else

Go to Layout [ "Layout2" ]

End If

[SteveS]

mr_vodka

THANK YOU SO MUCH FOR YOUR HELP, it worked!!!

You have saved me many hours of aggravation.

Steve