I need a little help getting a formula layout the way I want.
I've got 6 fields that I need formated in a formula field in this exact way:
product-license -c <customer_name> \
-a <product_type> \
-b <support_plan> \
-c <seats_admin> \
-d <expiration_date> \
-e <license_key>
Merge fields from fields in Sfdc:
Customer name - text field
Product Type - text field
Seats - number field
Expiration date - date field
license key - text field
I've tried concatenating using &" "&, but I can't get the format the way I want, specifically the line breaks. Any help is greatly appreciated!
I will be at Dreamforce giving free hugs! :)
11 Antworten
+1 Try this =
'product-license' + ' -c "' + Customer_Name__c + '" \\' + BR() +
' -a "' + Product_Type__c + '" \\' + BR() +
' -b "' + Support_Plan__c + '" \\' + BR() +
' -c "' + TEXT(Seats__c) + '" \\' + BR() +
' -d "' + TEXT(Expiration_Date__c) + '" \\' + BR() +
' -e "' + License_Key__c + '"'
