Calculation problems, Should be easy, I am just dumb this morning
Like my subject line says, this should be easy. I just don't see it today.
last4 is a text field containing either the last 4 numbers of a credit card or the paypal transaction ID. Posable values are a 4 digit number, or a 12 digit string, or empty.
Payment type is a text field containing Payment type. Posable values are Visa, PayPal, or empty
The auto enter caculation for payment type is designed to check if the proper payment type is associated with the field last4. (Paypal transaction can not be less then 12 digits long.
The calculation is:
If ( Length ( last4 ) ≤ 4 and Length ( last4 ) > 1 and payment type = "PayPal"; payment type = "Visa"; payment type)
My intentions are if the field payment type is PayPal and last4 is a 4 digit number, last4 should automatically revert to Visa. With the current formula, when last 4 is a 4 digit string and payment type is paypal payment type changes to 0.