You need to sign in to do that
Don't have an account?
Kstead
Validation Rule Help
I've created a validation rule that allows for a field to become mandatory when it meets certain requirements; works great. However I now need to have this rule not apply to a specific record type and I'm having problems adding it to the rule.
Here's the original rule:
AND( OR( BEGINS( "FL", Account_State_Province__c ), BEGINS("USA", Account_Country__c ) ), ISBLANK( TEXT( Agent_Sales_Rep__c )))
the record type is called BBA_Service_Programs and the Id is 01250000000UKIF
I tried adding it on the end using AND but it keeps coming up with errors.
Help is appreciated!
Okay you don't want the DeveloperName and you also don't wan't the API Name of the Record Type, you want the literal name, so your VR will kinda look like this:
All Answers
Can you post the Formula and errors you're getting? Something like this should work.
Hi STeve,
doesn't seem to be working and with the testing I don't think my original validation rule is working properly; not pulling out FL for Florida.
I can't seem to past the error in here. But get and error from the Record Type that shouldn't have the error on.
So here's what I want.
If the Account_Country-c is USA and Account_State-Province-c is FL then Agent Sales Rep field to be mandatory. Not on the following Record Types BBA_Service_Programs and BBA_Strategic_Account_Opportunity.
thanks!!
Here's the rule
AND( $RecordType.DeveloperName = "BBA_Strategic_Account_Opportunity",OR( BEGINS( "FL", Account_State_Province__c ), BEGINS("USA", Account_Country__c ) ), ISBLANK( TEXT( Agent_Sales_Rep__c )))
Okay you don't want the DeveloperName and you also don't wan't the API Name of the Record Type, you want the literal name, so your VR will kinda look like this:
You Rock Steve!!! thanks was the name thing; all looks good; added another Record type Syntax good!
thanks again!