Calculation Field

[kkungle]

I am trying to create a script that checks a field to see if there is data, if there is data include Parentheses around the data, if not leave blank.

I am kind new to Filemaker, any suggestions would be helpful. Thanks!

[QuinTech]

Hi K. First off, if the parentheses are to represent negative numbers (accounting convention), you don't need a script. In layout mode, select the field in question, then go to Format>Number>Format as decimal>Negative>Format as>(1234).

Otherwise: might you be better off using a calc field? If the original field is called Number, your calculation would be:

If ( IsEmpty ( Number ) , Number , "(" & Number & ")" )

HTH.

Jerry