+ Start a Discussion
Vipin K 10Vipin K 10 

Name Generator Field

Hi All,

I have a requirement where i need to create a field which would be a name generator - (Sum of some field values)
Ex : if i have 4 different picklist field and 1 number and 1 year field.
Values of picklist field (Name - Vipin, Country - India, Number - 04, year - 2017)

I want to add a feild which would pull these value and substitue to smaller words and add.

Like : Vipin_IND_04_2017 (Where IND is uppercase)

It should populate when we save the record.

How to do this? Your help would be appricated.
LBKLBK
Can this be a formula field?

Here is your formula.
 
TEXT(Name) + '_' + UPPER(TEXT(Country)) + '_' + TEXT(Number) + '_' + TEXT(Year)
If you have to substitute India with IND, IF or CASE statement can help you (as long as you don't have too many records to handle.