SET_REQUIRED

Resource: Property, Field : EstimatedBuyerFinancing

Description

When listing is pending or active under contract, EstimatedBuyerFinancing is required.

Error Messages

1) ERROR, the standard status has changed to 'pending', indicate that the field is required.
2) ERROR, the standard status has changed to 'active under contract', indicate that the field is required.

Fields referenced within this rule

EstimatedBuyerAgentMlsId 

EstimatedBuyerFinancing 

EstimatedCloseDate 

EstimatedClosePrice 

PropertyType 

StandardStatus 

Syntax with comments and error messages

//[ErrMsg1^ERROR, the standard status has changed to 'pending', indicate that the field is required.|LogicBlk1^TRUE|LogicBlk2^TRUE]
//[ErrMsg2^ERROR, the standard status has changed to 'active under contract', indicate that the field is required.|LogicBlk1^TRUE|LogicBlk3^TRUE]
// The property type is 'residential', 'residential income', 'land', or manufactured in park' and the permission access is not of type administrator and...
(/*[LogicBlk1]*/(PropertyType.IN.('Resi','Rinc','Land','Manu')).AND..NOT.(.USERCLASS..IN.('BANGG','BANGP','BANGQ'))).AND.
// the standard status has changed to 'pending' and the old value is not empty and...
(/*[LogicBlk2]*/(StandardStatus.IN.('P')).AND..NOT.((LASTStandardStatus.IN.('P')).AND.(.OLDVALUE. = .EMPTY.).AND.
// the estimated buyer agent MLS ID is empty and the entry is empty and the estimated close date is empty and the estimated close price is empty or...
(EstimatedBuyerAgentMlsId = .EMPTY.).AND.(.ENTRY. = .EMPTY.).AND.(EstimatedCloseDate = .EMPTY.).AND.(EstimatedClosePrice = .EMPTY.))).OR.
// the standard status has changed to 'active under contract' and the old entry value is empty and...
(/*[LogicBlk3]*/(StandardStatus.IN.('U')).AND..NOT.((LASTStandardStatus.IN.('U')).AND.(.OLDVALUE. = .EMPTY.).AND.
// the estimated buyer agent MLS ID is empty and the entry is empty and the estimated close date is empty and the estimated close price is empty.
(EstimatedBuyerAgentMlsId = .EMPTY.).AND.(.ENTRY. = .EMPTY.).AND.(EstimatedCloseDate = .EMPTY.).AND.(EstimatedClosePrice = .EMPTY.)))

Syntax only

((PropertyType.IN.('Resi','Rinc','Land','Manu')).AND..NOT.(.USERCLASS..IN.('BANGG','BANGP','BANGQ'))).AND.((StandardStatus.IN.('P')).AND..NOT.((LASTStandardStatus.IN.('P')).AND.(.OLDVALUE. = .EMPTY.).AND.(EstimatedBuyerAgentMlsId = .EMPTY.).AND.(.ENTRY. = .EMPTY.).AND.(EstimatedCloseDate = .EMPTY.).AND.(EstimatedClosePrice = .EMPTY.))).OR.((StandardStatus.IN.('U')).AND..NOT.((LASTStandardStatus.IN.('U')).AND.(.OLDVALUE. = .EMPTY.).AND.(EstimatedBuyerAgentMlsId = .EMPTY.).AND.(.ENTRY. = .EMPTY.).AND.(EstimatedCloseDate = .EMPTY.).AND.(EstimatedClosePrice = .EMPTY.)))

Rule Unique ID

8b838d1f-d6b6-4577-ad5f-04fede96af12

Rule Number

72