The Primary Product (picklist) Field Name: Opportunity_Name1__c
Customer Name(Account Lookup) Field Name: Account.Name
End User (Account Lookup) Field Name: End- End_User__C
The formula I currently use: TEXT( Opportunity_Name1__c ) & "-" & Account.Name & "-" & End_User__c
This works fine however, we sometimes do not know the end user so we may want to return a text value her instead for example "Customer Unknown"
Can anybody please provide the forumla for acheiving this.
답변 3개
Another question if the account name is really long is there any code I can use to limit its length ?
