How to create a search bar or search option in appsheet?

[krishankant]

I have a sheet which is having a list of order details.

Now I want customers to check their order status in real time using my app.

Customers will come to the app and will search their mobile number, then app will display the record as per the search. This search functionality I created using a form and LINKTOFILTEREDVIEW function.

But the search button is displaying all mobile numbers as a dropdown.

I just want a simple search bar with no dropdown where users can easily search and check their order status.

Kindly help me how to achieve this functionality where customers cannot see other customers mobile number.

[Marc_Dillon]

Assuming that you're using something like table[column] in your valid_if, to suppress the dropdown, change it to:

AND( TRUE , IN( [_THIS] , table[column] ) )

[Optomed_Diagnos]

how did you achieve to have a search bar in your drop down? i just have a dropdown with no searchbar.

[Marc_Dillon]

There aren't enough dropdown options for it to display the search.

[fred2kid]

Hi, i actually want to create something like this? Can you guys share?