/
Validation rule: USyd_Last_three_digit_must_be_numeric

Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au

Validation rule: USyd_Last_three_digit_must_be_numeric

Validation rule Details

Name

USyd_Last_three_digit_must_be_numeric

Label

USyd_Last_three_digit_must_be_numeric

Object

AQB__RecurringGift__c

Active

Yes

Formula

AND(
LEN ( USyd_Last_three_digits_of_Credit_Card__c ) > 0,

NOT (ISNUMBER(USyd_Last_three_digits_of_Credit_Card__c ))
)

Error message

The value must be numeric.

Error location

Last three digits of Credit Card

Description

Validates the last three digits of a credit card are numeric if not blank. The field is using text to suppress the default comma when a number field is used.

Related content

Validation rule: USYD_Check_Last_4_card_digits
Validation rule: USYD_Check_Last_4_card_digits
More like this
Validation rule: Check_Last_4_card_digits
Validation rule: Check_Last_4_card_digits
More like this
Validation rule: Non_Negative_Integer_Required
Validation rule: Non_Negative_Integer_Required
More like this
Validation rule: Primary_Credit_Cannot_Exceed_100
Validation rule: Primary_Credit_Cannot_Exceed_100
More like this
Validation rule: USYD_Must_Have_Segment_Three
Validation rule: USYD_Must_Have_Segment_Three
More like this
Validation rule: USYD_Must_Have_Segment_One
Validation rule: USYD_Must_Have_Segment_One
More like this