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 respuestas
Another question if the account name is really long is there any code I can use to limit its length ?
