Unfortunately as of Now we don’t have any option available to check this without using APEX. You need to use APEX and STRING function to check for the string and you need to write trigger to get same experience. Based on this Idea Text Area (Long) Formula support it doesn’t look like SF is providing this functionality in near future.
Table of Contents
How to create a text area (long) data type in Salesforce?
On the Add to layout page, click the “Save & New” button. We successfully created a text area (Long) data type field in the salesforce object. After clicking the “Save & New” button, we are automatically forwarded to the “New Custom field” page.
What are the data type fields in Salesforce CRM?
Salesforce CRM can give many data type fields to get a difference of information from users and store in our org. Text and Text area data type field is most commonly used in salesforce org to store a combination of letters and numbers. In this article, we are planning to create five types of fields in salesforce objects.
Is it possible to filter text area of a long field?
I think long text area field cannot be filtered, not sure about text area. You can check this with isFilterable () function on Describe field. If you really want to implement the filter function, you can try to use the formula field to copy the text area values, and filter on that. But this will have some limitation on the field length.
What are some other string methods?
We have some other String methods like.. startswith, indexof which can be used to filter.
Can you use text area fields in SOQL?
All Answers. Prafull G. You can not use text area fields in SOQL and SOSL filter criterias. Alternative is to fetch all records and then iterate (using for loop) to check your filter criteria.