+ Start a Discussion
Supriyo Ghosh 5Supriyo Ghosh 5 

Add constant in a formula field


I want to copy one custom fields value to another custom fileds with a suffix value.For example
Code = 65892001
I want to put one A before this number and save it to another filed.(Like New code = A65892001).Is it possible??
Krishna SambarajuKrishna Sambaraju
You can create a formula field set the value of this formula field as "A" + <field name goes here>
You can create a formula field as 'Suffix'+TEXT(Customfield1)
SandhyaSandhya (Salesforce Developers) 
Hi Supriyo,

Step1. Create a custom field say constant with (number as datatype.)

step2.create formula field say suffix (text as return data type)

in the formula field suffix write below code
"A" +TEXT(contant__C)

​Please accept my solution as Best Answer if my reply was helpful. It will make it available for other as the proper solution. If you felt I went above and beyond, you can give me kudos.
Thanks and Regards