You need to sign in to do that
Don't have an account?
Farhan Noor
Concatenate fields to Create Opportunity name
Hi,
I need to concatenate 3 fields to create opportunity name.
Account name (Lookup field) =Test
Product(Picklist)= ABC
Close date(Date)=11-08-2016
Opportunity name(Read only) = Account name +Product+Date
Opportunity name =Test-ABC-11-08-2016
Can you guys help. Thanks
I need to concatenate 3 fields to create opportunity name.
Account name (Lookup field) =Test
Product(Picklist)= ABC
Close date(Date)=11-08-2016
Opportunity name(Read only) = Account name +Product+Date
Opportunity name =Test-ABC-11-08-2016
Can you guys help. Thanks
You can create a workflow rule on opportunity with field update action to update opportunity name using below formula (assuming Product__c is field on account).
Account.Name & TEXT(Account.Product__c) & TEXT( CloseDate )