Skip to main content
Topics#Data ManagementRenee Jones-Sparks's Question
Renee Jones-Sparks (IBM) asked in #Data Management
Jul 20, 2018, 3:10 PM

Is there a way to insert a field value into a Text Field Update?

I have a Text Field Update that is populating text into a Long Text Area field.  The update is working perfectly, but I would like to know if there is a way to insert a value from a field on the same object into the Text Field Update.  Below is an example of what I'm trying to do.

 

Current Field Update

 

"Thank you for your interest in Bob's Burger Barn.  You have purchased ____ pressure cooker devices.

 

Desired Field Update

 

"Thank you for your interest in Bob's Burger Barn.  You have purchased [INSERT FIELD VALUE HERE] pressure cooker devices.

 

This would save my user from having to add the value in the space that I provided in the Field Update.  The field value that I'm trying to insert is on the same object where the Field Update is being inserted. 
3 answers
  1. Sunil Sarilla (M&G Investments)
    Jul 20, 2018, 3:16 PM
    Hi Renee,

     

    Yes absoultely.

     

    Change the field update formula to the below

    "Thank you for your interest in Bob's Burger Barn.  You have purchased  " + FieldAPIName "+"pressure cooker devices."

    Use the insert field button to replace the FeldAPI Name with the actual API Name of the field.

     

    I have assumed your field is a text field

     

    If its a picklist field the syntax will be

    TEXT(FieldAPIName)
Write an answer...
0/9000