I have a custom field in LEAD obejct which is also there in MARKETO and grabs data from MARKETO evrytime there is a value added to that field in MARKETO/ Everytime the value is changed the respective is updated in salesforce. I only want the intial value(INSERT) but not the values edited/added later(UPDATE). Am trying to write a formula field as follows:
IF( ISBLANK( GA_term__c ) , GA_term__c , NULL)
Am writing this value to populate the new field but am not knowing how to stop the new field from continuously updating the value when ever the value of "GA_term__c" is changed with respect to MARKETO.
Can anyone help with this issue?
I also tried to create a third field and the formulas were as follows
1st field - GA_term__c - text
2nd Field - GA_term_formula__c - formula
IF( ISBLANK( GA_term__c ) , GA_term__c , NULL)
3rd Field - GA_term_final__c - formula
IF( NOT ISBLANK( GA_term__c ) || GA_term__c != GA_term_formula__c, GA_term_formula__c, NULL)