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

    Paid Status Field



      Paid Status Field


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


      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.



        • 1. Re: Paid Status Field

          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

            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

              "Your DA Man" Phil...thanks.

              Sometimes even the simplest things esccape


              • 4. Re: Paid Status Field

                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.