function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
thuskerthusker 

Formula based on long text field???? Can it be done?

Apparently, you cannot use any long text fields in Worklfow Rule conditions . . . which stinks because I need to make a field update based on a long text field not having certain things in it. 
 
Therefore . . . is it possible to have a formula field that can return a text value (let's say "Check Errors") if a long text field is not NULL or does not contain the word "Success"? 
 
 
JakesterJakester
I'm pretty sure you can't right formulas or code of any kind against long text fields. This is really common; I know SQL won't let you do any sort of code against them either. It makes sense - all it would take is a few thousand 20,000-character entries to completely bog down a server while it ran code on these entries.