You need to sign in to do that
Don't have an account?
Carolyn juliana 7
How to create a truncated version of field for 255 characters
Hi Gurus,
Our BI team can't pull in our description field from Cases because it's too long. and we need to created a truncated version of this field for 255 characters
my question is what's the best way to do this? on existing data and new data
Regards,
carolyn
Our BI team can't pull in our description field from Cases because it's too long. and we need to created a truncated version of this field for 255 characters
my question is what's the best way to do this? on existing data and new data
Regards,
carolyn
Try the below and The formula will be
LEFT(Long_Text_Field__c, 200)
but please note the above formula will not work if you are creating this is a custom formula field as long text fields are not supported directly in a custom formula field
You will need to create a workflow on the object and have a field update action, that will update the text field with the first 200 characters from the long text field and then use the above formula as the formula for your field update.
I hope you find the above information is helpful. If it does, please mark as Best Answer to help others too.
Thanks.
All Answers
Try the below and The formula will be
LEFT(Long_Text_Field__c, 200)
but please note the above formula will not work if you are creating this is a custom formula field as long text fields are not supported directly in a custom formula field
You will need to create a workflow on the object and have a field update action, that will update the text field with the first 200 characters from the long text field and then use the above formula as the formula for your field update.
I hope you find the above information is helpful. If it does, please mark as Best Answer to help others too.
Thanks.
I got error as
And I suspect Long_Text_Field__c field is not present in your Org.