lookup第一篇：如何在salesforce增强lookup搜索功能，实现搜索所有可用记录和实现搜索同一对象下的all field

最新推荐文章于 2024-02-22 20:51:13 发布

sf_wilson

最新推荐文章于 2024-02-22 20:51:13 发布

阅读量2.2k

点赞数 3

Sales Cloud 同时被 2 个专栏收录

150 篇文章 17 订阅

订阅专栏

Salesforce Experience

148 篇文章 20 订阅

订阅专栏

The Problematic Situation:
When you add any lookup in Salesforce on a layout from one object to another, and try searching for available values, you face the below issues:
1-You can only search by record name. (main value) – Default settings

2-You need at least 2 characters to for the search to work

3-You cannot search for values in any other field, your search is limited to the main field.
4-System will only display by default recent viewed items (by you) and not all the available values.
Therefore users are expected to know all possible values of the record name field, usually a challenge for users.

The Workaround solution:
First let us go over the search tools and options that are provided by Salesforce :
1-The Wild Search (*)
Salesforce provides a wild search, *, but you need to provide along with it at least 2 characters to work.
This is a great feature, right, but not good enough to find all possible options.

2-The “All Fields” Search
This is also a great feature where you can search not only the main field, but all fields within an object.

In order to enable this options , called Enhanced Lookups, of a certain object, go to
Setup>Customize > Search > Search Settings and check the Enhanced Lookups.

You will not have a new option on the lookup search “All Fields”

3-The workaround.
If you wish to display all available value, all you need to do is create a new field on the destination object, of Type Text with default value “ALL”

You may display or hide the field from the layout, below is an example.

Note: for existing records, you will need to update this field manually(手动地) with the “All” value. While for any new record, it will automatically take the default value “All”
Solved!
Now you can do a lookup search, searching for the value “All” using the “All Fields” option.