# Searching by keywords and not by exact string of words

**URL:** <https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235>\
**Category:** Database\
**Created:** [February 15, 2021, 4:37pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235 "2021-02-15T16:37:18Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Regis](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/regis/32/20871_2.png) [@Regis](https://forum.adalo.com/u/Regis)\
**Post date:** [February 15, 2021, 4:37pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/1 "2021-02-15T16:37:18Z")

</div>

Hi everyone,  
I am working on a sneakers app with Adalo. Since our database includes 25k+ items, I am looking for ways to simplify the searching experience.

Let’s take an example. Currently we use the classic filter offered in Adalo where a user can search a sneaker whose Name contains Search Input.  
In that situation, if a user wants to find, let’s say the **Nike SB Dunk Low Safari** he has to type at least 2 or 3 words of the full name in the correct order (ex: “dunk low safari”).  
But if he types **“dunk safari”** the search engine won’t return any result, because the user has not typed the exact string of words.

That’s why I would like to find a way to search by keywords that would allow users to find shoes in a more intuitive way.

Does anyone have an idea of how I could do this?  
Sorry if I am not clear.

---

<div class="post-metadata">

**Author:** ![bhanu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bhanu/32/6859_2.png) [@bhanu](https://forum.adalo.com/u/bhanu)\
**Post date:** [February 15, 2021, 5:01pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/2 "2021-02-15T17:01:58Z")

</div>

Try to use “contains” instead of “equals to” , that might work.

Are you using Adalo database or external collection?

---

<div class="post-metadata">

**Author:** ![Regis](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/regis/32/20871_2.png) [@Regis](https://forum.adalo.com/u/Regis)\
**Post date:** [February 15, 2021, 5:09pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/3 "2021-02-15T17:09:55Z")

</div>

Thanks, but actually I already use the “Contains” filter and it seems to only work for exact sequences of words, unfortunately 😕

I am using an Adalo database.

---

<div class="post-metadata">

**Author:** ![bhanu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bhanu/32/6859_2.png) [@bhanu](https://forum.adalo.com/u/bhanu)\
**Post date:** [February 15, 2021, 5:12pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/4 "2021-02-15T17:12:18Z")

</div>

I don’t think you have a capability to perform dynamic searches in Adalo.

If you’re using external databases, you’ll have flexibility in building faceted searches to meet your need. Unfortunately there’s no other solution i can think of within Adalo

---

<div class="post-metadata">

**Author:** ![Regis](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/regis/32/20871_2.png) [@Regis](https://forum.adalo.com/u/Regis)\
**Post date:** [February 15, 2021, 5:17pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/5 "2021-02-15T17:17:27Z")

</div>

Alright, too bad.  
I’ll try to use filters instead! Thanks for your help.

---

<div class="post-metadata">

**Author:** ![alberto.vargasz](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@alberto.vargasz](https://forum.adalo.com/u/alberto.vargasz)\
**Post date:** [February 16, 2021, 1:32am UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/6 "2021-02-16T01:32:26Z")

</div>

I have the same problem with my Adalo database, haven’t found a proper solution yet. It makes performing searches within your app unnecessarily complicated for users. Searching by keywords seems to be the standard way to navigate any spreadsheet out there.

---

<div class="post-metadata">

**Author:** ![Regis](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/regis/32/20871_2.png) [@Regis](https://forum.adalo.com/u/Regis)\
**Post date:** [February 16, 2021, 8:03am UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/7 "2021-02-16T08:03:24Z")

</div>

Agreed, the current way of filtering isn’t the most intuitive for users, especially when you start having large databases.

Hope someone at Adalo could hear us!

---

<div class="post-metadata">

**Author:** ![bhanu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bhanu/32/6859_2.png) [@bhanu](https://forum.adalo.com/u/bhanu)\
**Post date:** [February 16, 2021, 8:18am UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/8 "2021-02-16T08:18:00Z")

</div>

It’ll ideal to raise a feature request for it, forum requests rarely goes into the roadmap.

> **[Adalo Feedback](https://ideas.adalo.com)**
>
> Give feedback to the Adalo team so we can make more informed product decisions. Powered by Canny.

---

<div class="post-metadata">

**Author:** ![Regis](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/regis/32/20871_2.png) [@Regis](https://forum.adalo.com/u/Regis)\
**Post date:** [February 16, 2021, 8:52am UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/9 "2021-02-16T08:52:58Z")

</div>

Just added it! [Search More than One Property | Voters | Adalo](https://ideas.adalo.com/feature-requests/p/searching-by-keywords-and-not-by-exact-string-of-words)

---

<div class="post-metadata">

**Author:** ![dazzycoffee](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@dazzycoffee](https://forum.adalo.com/u/dazzycoffee)\
**Post date:** [February 17, 2021, 3:35pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/10 "2021-02-17T15:35:35Z")

</div>

I do have a question about search. Is there anyway not to show all the record before filtering.  
I would like to type in the search box and as letters are type a list starts to display and the user can select an item from the list and then be taken to another page.

![pic1](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/3f18eb2d6271f57d9ad845e24cbaf57e6a0ac6ce.png)

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

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [February 17, 2021, 4:09pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/11 "2021-02-17T16:09:21Z")

</div>

To do this you would add another filter for\> all medication contains \> form inputs: **search**

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/95a716a5cca7dbdca1419797d38d2eb0d8851149.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/5/5b61345dca31510b7f8f36b383dfa2c3551c3b63.png)

---

<div class="post-metadata">

**Author:** ![dazzycoffee](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@dazzycoffee](https://forum.adalo.com/u/dazzycoffee)\
**Post date:** [February 17, 2021, 6:26pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/12 "2021-02-17T18:26:26Z")

</div>

Thanks James…  
I think thats the problem there is no link back from the list to the information in the input component.  
I only see all as a choice All, no reference back to input box.

I’m trying to do this:  
The input box is blank, the list is blank. I type something in the lnput box the list begin to populate then I select what is in the list.  
Thanks Again

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [February 17, 2021, 6:30pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/13 "2021-02-17T18:30:30Z")

</div>

Could you take a screenshot of it?

---

<div class="post-metadata">

**Author:** ![dazzycoffee](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@dazzycoffee](https://forum.adalo.com/u/dazzycoffee)\
**Post date:** [February 17, 2021, 6:42pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/14 "2021-02-17T18:42:15Z")

</div>

Hope you can help this is a real issue. I have a large medical database.

 ![pic3](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/d4898ff51e9fb990702163b6b20a17db48151171.png) ![pic4](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/3bdca31a3e543cd7c55dd289141a6d0b61500c6f.png)

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [February 17, 2021, 6:50pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/15 "2021-02-17T18:50:14Z")

</div>

@dazzycoffee Could I get access to your app so I could fix it? It’s just easier instead of relpy backing and forth. You add me to your app in settings.

[jagib07@gmail.com](mailto:jagib07@gmail.com)

---

<div class="post-metadata">

**Author:** ![dazzycoffee](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@dazzycoffee](https://forum.adalo.com/u/dazzycoffee)\
**Post date:** [February 17, 2021, 6:53pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/16 "2021-02-17T18:53:48Z")

</div>

Im just on the free serice right now. don’t know if this will work.If this can be fixed I will be moving to a paid plan

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [February 17, 2021, 6:55pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/17 "2021-02-17T18:55:07Z")

</div>

It doesn’t matter if you’re on the free or paid plan. It’s just a simple mistake.

If you don’t know how to add someone to your app. Then click add team member

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/37bc0ba31292ed5157081c3280e3647ca204ccda.png)

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [February 17, 2021, 6:59pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/18 "2021-02-17T18:59:02Z")

</div>

@dazzycoffee I believe you added me wrong. You need to go to the specific app’s settings and add me as a team member for that app.

> **[Status on Form.webm](https://drive.google.com/file/d/1u7vGKiz3WKgJken9zsLLgWs2xDG5lIgD/view)**
>
> Google Drive file.

---

<div class="post-metadata">

**Author:** ![dazzycoffee](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@dazzycoffee](https://forum.adalo.com/u/dazzycoffee)\
**Post date:** [February 17, 2021, 7:09pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/19 "2021-02-17T19:09:09Z")

</div>

Hey did I get it right this time?

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [February 17, 2021, 7:13pm UTC](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235/20 "2021-02-17T19:13:11Z")

</div>

No, I didn’t get an email saying that you added me to the app.

[Next page](https://forum.adalo.com/t/searching-by-keywords-and-not-by-exact-string-of-words/9235.md?page=2)
