# How to search multiple column in the same collection
**URL:** https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685
**Category:** Get Help
**Created:** [April 11, 2020, 4:48pm UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685 "2020-04-11T16:48:27Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@ahmedferdaus](https://forum.adalo.com/u/ahmedferdaus)
#### Post date: [April 11, 2020, 4:48pm UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/1 "2020-04-11T16:48:27Z")
How to search multiple column in same collection, such as I want search by name or by designation or by contact number. Please help me
---
### Author:  [@dosandco](https://forum.adalo.com/u/dosandco)
#### Post date: [April 11, 2020, 6:06pm UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/2 "2020-04-11T18:06:07Z")
You need to create a new text field in your collection and then have that set up as ‘[name] [designation] [contact number]’
Eg:
‘John Smith Director 01234 567890’
Then you can search by that text field contains whatever your search box contains.
---
### Author:  [@ahmedferdaus](https://forum.adalo.com/u/ahmedferdaus)
#### Post date: [April 12, 2020, 5:22am UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/3 "2020-04-12T05:22:40Z")
Thanks for your suggestion, if I create a extra field in my collection doesn’t my database become slow or consume extra memory? for example: I have thousands or millions of data in that case application performance remain same? Again thanks for your solution.
---
### Author:  [@dosandco](https://forum.adalo.com/u/dosandco)
#### Post date: [April 12, 2020, 8:16am UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/4 "2020-04-12T08:16:02Z")
Quite possibly - I guess the best way is to try? It’s the only current way to achieve what you want to achieve with Adalo.
---
### Author:  [@ahmedferdaus](https://forum.adalo.com/u/ahmedferdaus)
#### Post date: [April 12, 2020, 8:32am UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/5 "2020-04-12T08:32:30Z")
Thanks buddy!! 😍 😍
---
### Author:  [@ldyer](https://forum.adalo.com/u/ldyer)
#### Post date: [June 26, 2020, 1:50pm UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/6 "2020-06-26T13:50:34Z")
> [@dosandco](#):
>
> ‘[name] [designation] [contact number]’
Is there any documentation on this? I am having a hard time following. Currently, I have a collection that only lets me search the first column which is first name. I would love to also be able to search last name.
---
### Author:  [@ahmedferdaus](https://forum.adalo.com/u/ahmedferdaus)
#### Post date: [June 26, 2020, 1:59pm UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/7 "2020-06-26T13:59:10Z")
Hello @ldyer !
Here is the way I’m following [Creating Custom Searches and Search Bars in Adalo](https://forum.adalo.com/t/creating-custom-searches-and-search-bars-in-adalo/1324)
Hope this will help you
---
### Author:  [@ldyer](https://forum.adalo.com/u/ldyer)
#### Post date: [June 26, 2020, 2:29pm UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/8 "2020-06-26T14:29:58Z")
Thanks, I guess I leached onto the wrong thread. I am talking about the back-end within adalo. and searching more than just the primary key.
I am already doing what you suggested above on the front-end 🙂
---
### Author:  [@dosandco](https://forum.adalo.com/u/dosandco)
#### Post date: [July 1, 2020, 7:02am UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/9 "2020-07-01T07:02:40Z")
Hi @ldyer, if you’re already doing this on the front end, could you drag the search column to the top (above ‘name’) to achieve the same thing?
---
### Author:  [@bibipac](https://forum.adalo.com/u/bibipac)
#### Post date: [July 1, 2020, 9:20am UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/10 "2020-07-01T09:20:15Z")
Guys, you might want to vote for a similar feature request here 😉
[new concatenate format property](https://ideas.adalo.com/feature-requests/p/new-property-with-concatenate-format)
---
### Author:  [@guifilizzola](https://forum.adalo.com/u/guifilizzola)
#### Post date: [February 24, 2021, 12:18am UTC](https://forum.adalo.com/t/how-to-search-multiple-column-in-the-same-collection/685/11 "2021-02-24T00:18:51Z")
Tks. How could I do it? I tried to add an automatic field on the record creation form, but I wasn’t able to pick up the fields on magic text.