1

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:

(AND(NOT(ISBLANK([OpportunityLineItem].OppProdCustomField1__c)))
|| 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)))
Improve this question
7
  • Whats the relation bw Opportunity.OppCustomField1__c and OpportunityLineItem.OppProdCustomField1__c?
    – Mahmood
    Commented Mar 3, 2017 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
    Commented Mar 3, 2017 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
    Commented Mar 3, 2017 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
    Commented Mar 3, 2017 at 10:05
  • Have you check the values residing in both of these fields?
    – Mahmood
    Commented Mar 3, 2017 at 10:24

1 Answer 1

Reset to default
2

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.

Improve this answer
1
  • 1
    Waw a 7 years old Idea, still in status not planned :p
    – benahm
    Commented Mar 3, 2017 at 10:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .