0

I need to copy data from a long text field (source field a) into 3 other fields: field b = lines 1-40 of source field a field c = lines 41-80 of source field a field d = lines 81-end of source field a

hoping there is a way in process builder to write a formula for so I don't need to ask for a trigger.

  • Process Builder isn't particularly well-suited for the task that you propose. The Formula language advanced enough to easily find, as you say, the 40th line of text. Even if you built such a formula, and it allowed it, it would use probably 100 times more CPU time than just using a trigger. – sfdcfox Nov 29 '16 at 17:40
  • 1
    You can't bring long text area fields into formulas so that eliminates formula, workflow field update, and I think process builder as they all use the same formula building functionality so I assume that limit is spread across those features. This feels like a trigger use case. – Dan Wooding Nov 29 '16 at 19:31
1

I have created 3 fields in Account SObject:

  • Long Text Area (text area long field)
  • Text B (text field)
  • Text C (text field)

And created a Process Builder in Account SObject:

Process Builder

I'm updating the fields Text B & Text C when I change the value of Long Text Area. For example:

  • I'm using LEFT([Account].Long_Text_Area__c, 40) to assign the first 40th characters to the Text B field.
  • RIGHT([Account].Long_Text_Area__c,40) to Text C.

Result:

Restult on change

EDIT:

Take a look this documentation to operate with TEXT in formulas: Formula Operators and Functions: TEXT

  • Thanks both for the input. Figured but never hurts to ask. – user39769 Dec 4 '16 at 16:51
  • 1
    OP is looking for the 41st line, not 41st character – cropredy Dec 5 '16 at 2:49
  • yes thanks so much for trying but was looking for line. I appreciate the attempt. – angela.addison Dec 5 '16 at 21:56

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.