Hi friends,

In account Object i have two fields.

1.Website
2. Alexa ranking

AWS has an API that you must subscribe to, that charges per request monthly. Seems like it's not too expensive and may be worth it for my Team. Has anyone had/not had luck implementing this API? Or any insight on how to implement a crawl of Alexa that maps to an account?

I'm working on a validation rule that when a checkbox is checked and a picklist is on a certain value, an error message is generated.  

 

Basically when the Send Updated GO Contract is checked and the Offer stage picklist is set to 1. Awaiting Client Approval - I need to generate an error message . . .   Not sure how to write the formula field to correctly evaluate the picklist value. Any help is appreciated.

 

AND (Send_Updated_GO_contract__c = TRUE,
ISPICKVAL(CONTAINS (TEXT(Offer_Stage__c ),"1 - Awaiting Client Approval")))