You need to sign in to do that
Don't have an account?
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.
solution provided by phiberoptik here:
http://success.salesforce.com/questionDetail?qid=a1X30000000evmlEAA
All Answers
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.
solution provided by phiberoptik here:
http://success.salesforce.com/questionDetail?qid=a1X30000000evmlEAA