+ Start a Discussion
AlokVAlokV 

Adding product into a custom objects lookup field

Hi,

 

 

I am trying to populate a filed on Subscription object from custom Product object. Product name is a lookup field on Subscription.t. I want that if product name is selected, porduct frequency is auto populated on Subscription object from Porduct object frequency.Frequency is a picklist on Product object.

When I write this formula for product frequency

 

Product_Name__r.Frequency__c,  I get below error

 

Field Frequency__c is a picklist field. Picklist fields are only supported in certain functions.

 

How can this be done?

 

Thanks,

Alok

Best Answer chosen by Admin (Salesforce Developers) 
AlokVAlokV

Using text (value) resolved the issue.

All Answers

AlokVAlokV

Using text (value) resolved the issue.

This was selected as the best answer
Vinita_SFDCVinita_SFDC

Hello,

 

Try using:

 

TEXT(Product.Frequency__C)