I have a process builder process that populates a field on the opportunity level with one present on the opportunity product. The code is as follows:

|| ISCHANGED([OpportunityLineItem].OppProdCustomField1__c ))

&&(NOT(CONTAINS([OpportunityLineItem].Opportunity.Description, [OpportunityLineItem].OppProdCustomField1__c)))

The process saves fine without the syntax errors but it will not populate at all! If I remove the second part it works fine BUT I need the value in the Opportunity Field to be unique - it must not add to it if the same figure is there (no duplicates)

Second part being:

&&(NOT(CONTAINS([OpportunityLineItem].Opportunity.OppCustomField1__c, [OpportunityLineItem].OppProdCustomField1__c)))
  • Whats the relation bw Opportunity.OppCustomField1__c and OpportunityLineItem.OppProdCustomField1__c? – Mahmood Mar 3 '17 at 9:52
  • The one on opportunity level is actually a standard field (Description) the one on opportunity product is a text custom field. I have updated the question above also... – TheAdmin Mar 3 '17 at 9:58
  • Why are you checking if the field (Description) has text from the OppLineItem.CustomField__c? I wanna know the business requirement here. – Mahmood Mar 3 '17 at 10:02
  • I want to avoid the PB populating the Description with the same value of the OppLineItem.CustomField__c if it is already in there (to avoid having 10s of duplicate OppLineItem.CustomField__c values in there since it runs when the record is created OR when it is Updated) – TheAdmin Mar 3 '17 at 10:05
  • Have you check the values residing in both of these fields? – Mahmood Mar 3 '17 at 10:24

Description field on Opportunity object is a TextArea field and you can't refer them in formulas.

There is an idea to provide support for certain functions support on text area fields. You can upvote that.

  • 1
    Waw a 7 years old Idea, still in status not planned :p – benahm Mar 3 '17 at 10:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.