+ Start a Discussion
lil_rangerlil_ranger 

Rule to update field

I'm trying to update a number field with field that is a text field  in another object.  Is this possible?

 

Field to Update: Contract Number

Field Data Type: Number

 

Update with: Entitlement.Contract_Number__c which is a text field

 

Best Answer chosen by Admin (Salesforce Developers) 
Navatar_DbSupNavatar_DbSup

Hi,

 

You can use VALUE to convert that into number.
VALUE(text)
Converts a text string that represents a number to a number

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

All Answers

Navatar_DbSupNavatar_DbSup

Hi,

 

You can use VALUE to convert that into number.
VALUE(text)
Converts a text string that represents a number to a number

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

This was selected as the best answer
lil_rangerlil_ranger

Thank you!!  That worked.  Would you happen to know how to update a field when it involves a picklist?

 

Field to update: Category

Field type: Text

 

Updated with: Entitlement.Category which is a picklist

 

 

 

 

Navatar_DbSupNavatar_DbSup

Hi,


May be workflow will help you to do this. If not through workflow then you have to write a trigger.