Hello -

 

My company has 11 opportunity record types based on the 11 product services we sell. Each product has a fixed product ID. I would like to create a field that automatically populates with the product ID based on opportunity record type for that record. Is a formula field the best option for setting this up and what would the formula look like.

 

Product and ID examples

 

ISDN = 001

VPN = 002

 

Any advice would be much appreciated.