# Multiple substring matching in entity chooser popups

**URL:** <https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488>\
**Category:** Ideas & Features\
**Created:** [December 1, 2023, 8:21pm UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488 "2023-12-01T20:21:16Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [December 1, 2023, 8:21pm UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488/1 "2023-12-01T20:21:16Z")

</div>

When searching for an entity using a relation field popup, the existing search works well if you only need to match a single substring anywhere in the entity name:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/7f84dedd3415bca825809c90fcca03298913adf8.png)

HOWEVER, if you want to search for two or more substrings, you are out of luck as soon as you hit `space` – now you get no matches:

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b3d5292d1b40d91a9b50875de72906a4e981da18.png)

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/26ccd64f1266fb308478fa1fe191f7e921fdff27.png)

If I have 150 entities that match “Calendar”, and I want to find the ones named “Calendar _something_ Zoho …”, **I have to know the entire entity Name and type it exactly** starting from the beginning. There is no way to show all the names that match two or more substrings.

Searching for entities by name is important - it should be more flexible, and allow matching multiple substrings anywhere in the entity Name.

At the moment it does not do a good job helping us discover entity names except in the simplest cases.

---

<div class="post-metadata">

**Author:** ![Oshyan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/oshyan/32/11431_2.png) [@Oshyan](https://community.fibery.io/u/Oshyan)\
**Post date:** [December 1, 2023, 10:04pm UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488/2 "2023-12-01T22:04:28Z")

</div>

Removed a vote from another feature to vote here! 😁

---

<div class="post-metadata">

**Author:** ![njyo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/njyo/32/923_2.png) [@njyo](https://community.fibery.io/u/njyo)\
**Post date:** [December 2, 2023, 2:06am UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488/3 "2023-12-02T02:06:50Z")

</div>

YES! Great FRQ! Maybe, if performance is an issue it could only match beginnings of words rather than anything inside a word?

PS: While I should do what @Oshyan did, so believe we should get more votes over time. 😉

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [December 2, 2023, 10:55am UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488/4 "2023-12-02T10:55:13Z")

</div>

It’s not a real fix, but you could temporarily apply a relation filter with the search criteria you need:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/6fe3ce7b0f61b76eed253db7eddd27fe849fea5a.png)

---

<div class="post-metadata">

**Author:** ![vkhrapski](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/vkhrapski/32/9159_2.png) [@vkhrapski](https://community.fibery.io/u/vkhrapski)\
**Post date:** [April 6, 2024, 8:32pm UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488/5 "2024-04-06T20:32:40Z")

</div>

An example from Salesforce world.  
Salesforce has search layouts and allows to put additional fields in lookups.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0dbb7facd9b44051048d28254600c3e3d3ea91a5.png)  
I would be happy to see a similar option in Fibery

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [April 7, 2024, 7:48am UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488/6 "2024-04-07T07:48:24Z")

</div>

How would you imagine that Fibery determines which (extra) fields should be shown? Should the user configure this for every database somehow?

---

<div class="post-metadata">

**Author:** ![vkhrapski](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/vkhrapski/32/9159_2.png) [@vkhrapski](https://community.fibery.io/u/vkhrapski)\
**Post date:** [April 9, 2024, 8:21am UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488/7 "2024-04-09T08:21:33Z")

</div>

Search layouts are configurable through setup per each object and profile.  
For current Fibery design, it seems global search layout could be sufficient.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3617561ec3ec1bab5012f648f20b0ead32d79353.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [April 9, 2024, 8:29am UTC](https://community.fibery.io/t/multiple-substring-matching-in-entity-chooser-popups/5488/8 "2024-04-09T08:29:00Z")

</div>

> [@vkhrapski](#):
>
> For current Fibery design, it seems global search layout could be sufficient.

Given that each Fibery database has different fields, I’m not sure what you mean by a ‘global search layout’.  
In your salesforce example, it seems like the search results include the country, when searching for the account. If your Fibery workspace contains an Account db, with the field Country, then someone (the database creator?) has to decide that this field is one that should show up in search. If you have another database, say Tasks, it will not have this field, so someone has to decide which fields from the Task db should show up when searching for a task.

I don’t see how there can be anything that you could call a ‘global layout’ except one which only included fields that are guaranteed to exist in all dbs (Name, Created by, Creation Date, Modification date).
