Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SriRamya BeramSriRamya Beram 

IF(RecordType.Name== 'Purchase Order', Name ='po-' CC_OrderNumber__c- CC_Sales_Order__r.CC_OrderNumber__c , Name ='so-' CC_OrderNumber__c - CC_Project__r.Name )

IF(RecordType.Name== 'Purchase Order', Name ='po-' CC_OrderNumber__c- 
CC_Sales_Order__r.CC_OrderNumber__c ,
 Name ='so-' 
CC_OrderNumber__c - 
CC_Project__r.Name )
Error: Syntax error. Missing ')'
Sami ShakithSami Shakith
Hi SriRamya Beram,

Try this

IF(RecordType.Name== 'Purchase Order', Name ='po-'+CC_OrderNumber__c+'-'+CC_Sales_Order__r.CC_OrderNumber__c,
 Name ='so-'+CC_OrderNumber__c+'-'+CC_Project__r.Name) )
SriRamya BeramSriRamya Beram
i tried your changed code but again im getting error
IF(RecordType.Name== 'Purchase Order', Name ='po-'+CC_OrderNumber__c-CC_Sales_Order__r.CC_OrderNumber__c ,
 Name ='so-'+CC_OrderNumber__c-CC_Project__r.Name )
Error: Incorrect parameter type for operator '-'. Expected Number, Date, DateTime, received Text
 
Sami ShakithSami Shakith
I think that formula field is not text. Can you please tell me the data type of all fields which are used inside this formula.
SriRamya BeramSriRamya Beram
IF(RecordType.Name== 'Purchase Order', Name ='po-'+CC_OrderNumber__c+'-'+CC_Sales_Order__r.CC_OrderNumber__c,
 Name ='so-'+CC_OrderNumber__c+'-'+CC_Project__r.Name)Again im getting error 'Error: Formula result is data type (Boolean), incompatible with expected data type (Text).'
Sami ShakithSami Shakith
What is your expected result? just give me an example.
SriRamya BeramSriRamya Beram
Only Name is Text remaining all are autonumbers
Sami ShakithSami Shakith
What is the data type of the formula field?
SriRamya BeramSriRamya Beram
Text
 
Sami ShakithSami Shakith
what is RecordType.Name? can you please share the snipshot of formula page?
Sami ShakithSami Shakith
Actually we cant assign values to any field using formula field. Sorry i dint notice at first. Use this. This will be helpful to you

IF(RecordType.Name== 'Purchase Order', 'po-'+CC_OrderNumber__c+'-'+CC_Sales_Order__r.CC_OrderNumber__c,
 'so-'+CC_OrderNumber__c+'-'+CC_Project__r.Name)