function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
steve456steve456 

Help with a trigger

 

Trigger on Order Entry 

 

 

ON CREATE ONLY

 

IF(RecordType.Name == "PG" && Product__r.Group__c == 'Data Plan) THEN

 

IF(LEFT(Order_Number__r.Inventory__r.Product__r.Name__c, 8) == "V-Portal" && Order_Number__r.Date__c >= 2013-02-11) THEN

            Additional_Revenue__c = 15

ELSE

            Additional_Revenue__c = 0

            ENDIF

 

 

******************How do I write a trigger as it has three cross references

 

Field on Order Entry :  Order Number    (Master Detail)

 

Field on OrderNumber : Inventory

 

Field on Inventory : Product

 

Field on Product :Name

 

*************************************************

 

Can you please help me write a trigger for the logic mentioned on top

 

Thanks in advance

prakash_sfdcprakash_sfdc
trigger updateAddRevenue on Order_Entry__c(before insert)
{
ID rId=[SELECT ID FROM RecordType WHERE Name='PG' AND sObjectType='Order_Entry__c LIMIT 1].ID;

for(Order_Entry__c ode:Trigger.new){
if(ode.RecordTypeId==rId && ode.Order_Number__r.Inventory__r.Product__r.Group__c == 'Data Plan')
{
String pName=ode.Order_Number__r.Inventory__r.Product__r.Name__c.substring(0, 8);
if(pName=='V-Portal' && ode.Order_Number__r.Date__c>=2013-02-11)
ode.Additional_Revenue__c = 15;
else
ode.Additional_Revenue__c = 0;

}
}
}
steve456steve456

Can I use cross references for over more than three objects for navigation

 

ode.Order_Number__r.Inventory__r.Product__r.Name__c
prakash_sfdcprakash_sfdc
Yes. You can use.