Skip to main content
Hi,

I am new to Trigger. I want to update field if formula field value is changed. Could you please suggest.

Object: Ticket__c

Field if changed: Bill_to__c

update field: updaterequired__c

trigger Checkprojectbilltoaccount on Ticket__c (before update){

    for(Ticket__c newchange:Trigger.new) {

    Ticket__c oldchange = system.trigger.oldMap.get(newchange.Id);

    if (oldchange.Bill_To__c !=newchange.Bill_To__c) 

        {

              newchange.UpdateRequired__c = True;

              

        }

        }
7 answers
  1. Feb 13, 2018, 10:08 PM
    Trigger should be after update 

     

    trigger projectbilltoaccount on Ticket__c (after update){

    for(Ticket__c newchange:Trigger.new) {

    Ticket__c oldchange = system.trigger.oldMap.get(newchange.Id);

    if (oldchange.Bill_To__c !=newchange.Bill_To__c)

    {

    Ticket__c temp=[select id, Bill_To__c, UpdateRequired__c from Ticket__c where updateRequired__c=false];

    temp.UpdateRequired__c=True;

    Update temp;

    }

    }

    }

     
0/9000