+ Start a Discussion
sudha76sudha76 

Trying to update custom picklist field based on the value entered in the TEXT field.

This Rule below, ensures that if the Account Source = Data.com , then the Account Name should have a "-" and end with the value from the "Site_City" field.

 

IF(ISPICKVAL(AccountSource, "Data.com"),FALSE,OR(FIND( " - ", Name ) = 0, FIND( Site_City__c , Name ) = 0))

 

This works fine.

 

I wanted to do a similiar thing in the custom picklist field called = Site_Country.

 

If the Account Source = Data.com, then the value from the BillingCountry should be copied over to the picklist field Site_Country field.

 

How can I do this.

 

 IF(ISPICKVAL( AccountSource , "Data.com"),FALSE,
OR( ISPICKVAL( Site_Country__c , " "),
 FIND(search_text, text [, start_num])

 

I am stuck here and unable to understand how can I update this picklist field using FIND function, like it is done above in the first rule.

 

please help.

Best Answer chosen by Admin (Salesforce Developers) 

All Answers

phiberoptikphiberoptik

If my answer on your Answers question worked for you, please post it over here to share incase someone finds this version of your question and not the Answers one.

Rahul_sgRahul_sg
This was selected as the best answer