You need to sign in to do that
Don't have an account?

Copy Long text Area value to a number field?
Hello All,
Im trying to use process builder and update a value from a long text area datatype field to a number data type field (both in the same object)
the long text area field is validated to be a number, is this possible with a formula and process builder ?|
It sounds crazy to use a long text area field for a number, but i can't change that data type field due to data loss
Im trying to use process builder and update a value from a long text area datatype field to a number data type field (both in the same object)
the long text area field is validated to be a number, is this possible with a formula and process builder ?|
It sounds crazy to use a long text area field for a number, but i can't change that data type field due to data loss
As the Long Text Area field will support up to 131,072 characters you'll need to make sure only 255 characters are copied to your Text Area Field when using a field update in a workflow rule. The Text area fields only support up to 255 characters. Please use the following syntax in your formula:
LEFT( LongTexFieldName, 255 )
Please refer the below link for reference.
- https://help.salesforce.com/articleView?id=000220149&type=1
Let us know if it helps.Please mark it as best answer if the information is informative.so that question is removed from an unanswered question and appear as a proper solution.
Thanks
Rahul Kumar
But i need to this "Use a Formula for a field update to copy the value of a Long Text Area to a Number"
Shouldnt the formula be VALUE(LEFT(LongTextFieldName, 18)) if its a Number field?