Auto Complete Text Option?

Hi there, quick question…instead of a list of our clients, I am seeking to have an “auto complete” search engine like response when a user is searching for a particular client. I am making a Truck Dispatching App.

Thank you for your help in advance. :slight_smile:

Hi @nimble777,

Can you give some more information? Where is the search? In a column when you add/update a row? or in “overview” like a deck view?

Maybe there is a valid_if option or a lot of other formulas that can help you. But for me the information you give is not enough to help.

I am very new to App Sheet, so I am not sure how to toggle between the two views yet, but my goal is for the end user to be able to search the list of clients within the database by putting in a few letters, for instance, “JB” and the field automatically being populated “JB Hunt”.

Please let me know if this helps answer your query.


I send you a private message.