4 Replies Latest reply on Feb 11, 2011 3:17 PM by projay

    Paid Status Field

    projay

      Title

      Paid Status Field

      Post

      I Can't seem to get this to work, it seems pretty simple.

      Field[PaidStatus]

      If BalanceDue=0 then mark [PaidStatus] field "PAID"

      Am I missing something...also does it go under Auto-Enter or Validation Tab...I tried both.

      Thanks in advance.

      -Jay

      PAIDSTATUSS.jpg

        • 1. Re: Paid Status Field
          philmodjunk

          Not under validation.

          You have two options:

          Both would use this basic expression:  If ( balanceDue = 0 ; "Paid" ; "" )

          1) define a field of type calculation and enter the above expression, selecting "text" as the calculation field's return type.

          2) Define a field of type text and use the above expression as an auto-enter expression. Make sure to also clear the "Do not replace existing value..." option.

          Note option 2 will fail to update automatically if its calculation refers to a field in another record.

          • 2. Re: Paid Status Field
            Sorbsbuster

            If this is a calculation field (as I would expect it to be) there is something funny going on, as FM is expecting a Boolean result.  Are you defining the field PaidStatus as a calculation field?

            • 3. Re: Paid Status Field
              projay

              "Your DA Man" Phil...thanks.

              Sometimes even the simplest things esccape

              -Jay

              • 4. Re: Paid Status Field
                projay

                Sorbsbuster>I defined it as a text with validation...and as you mentioned it should of been a calculation
                Changed to Calculation and it worked.

                Thanks!

                -Jay