Resource: Property, Field : CoBuyerAgentStateLicense

Description

CoBuyerAgentStateLicense cannot have the same number reapeated more than 7 times.

Error Messages

1) ERROR, the CoBuyerAgentMlsId field format is invalid.

Fields referenced within this rule

CoBuyerAgentMlsId

CoBuyerAgentStateLicense

StandardStatus

Syntax with comments and error messages

//[ErrMsg1^ERROR, the CoBuyerAgentMlsId field format is invalid.|LogicBlk1^FALSE|LogicBlk2^TRUE|LogicBlk3^FALSE]
// Administrator bypass clause or....
(/*[LogicBlk1]*/.USERCLASS..IN.('BANGG','BANGP','BANGQ')).OR.
// If entry in not empty and has changed...
IIF((/*[LogicBlk2]*/(.ENTRY. != .EMPTY.).AND.(.ENTRY. != .OLDVALUE.)),
// then check if standard status is 'closed' and digits are repeated 7 to 20 times...
(/*[LogicBlk3]*/IIF((StandardStatus.IN.('S')),.NOT.(MATCH('(^1{7,20}$)|(^2{7,20}$)|(^3{7,20}$)|(^4{7,20}$)|(^5{7,20}$)|(^6{7,20}$)|(^7{7,20}$)|(^8{7,20}$)|(^9{7,20}$)|(^0{7,20}$)',TRIM(.ENTRY.))),.TRUE.)),
// Else accept if entry is empty.
.ENTRY. != .EMPTY.)
//(.USERCLASS. .IN. ('BANGG','BANGP','BANGQ')) .OR.
/ / (IIF(StandardStatus.IN.('S'),.NOT.(MATCH('(^1{7,20}$)|(^2{7,20}$)|(^3{7,20}$)|(^4{7,20}$)|(^5{7,20}$)|(^6{7,20}$)|(^7{7,20}$)|(^8{7,20}$)|(^9{7,20}$)|(^0{7,20}$)',TRIM(CoBuyerAgentMlsId))),.TRUE.))

Syntax only

(.USERCLASS..IN.('BANGG','BANGP','BANGQ')).OR.IIF(((.ENTRY. != .EMPTY.).AND.(.ENTRY. != .OLDVALUE.)),(IIF((StandardStatus.IN.('S')),.NOT.(MATCH('(^1{7,20}$)|(^2{7,20}$)|(^3{7,20}$)|(^4{7,20}$)|(^5{7,20}$)|(^6{7,20}$)|(^7{7,20}$)|(^8{7,20}$)|(^9{7,20}$)|(^0{7,20}$)',TRIM(.ENTRY.))),.TRUE.)),.ENTRY. != .EMPTY.) / / (IIF(StandardStatus.IN.('S'),.NOT.(MATCH('(^1{7,20}$)|(^2{7,20}$)|(^3{7,20}$)|(^4{7,20}$)|(^5{7,20}$)|(^6{7,20}$)|(^7{7,20}$)|(^8{7,20}$)|(^9{7,20}$)|(^0{7,20}$)',TRIM(CoBuyerAgentMlsId))),.TRUE.))

Rule Unique ID

d8e579a0-62cf-47be-8877-01cf472698b6

ACCEPT