How to stop search from showing existing fields?

CMD
Bronze 1
Bronze 1

Hey there!

I'm pretty new to AppSheet, I have been building a booking application for work and I am trying to edit the way search appears,

Screenshot 2023-07-21 at 10.54.16 PM.png

Ideally would like this to be a search box that shows results as you type them more like predictive text, as it's customer information and having a long list isn't practical without narrowing it down first,

This is a ref to a database table with all the customer's data stored there.

Any help would be great!

0 1 148
  • UX
1 REPLY 1

If I understand correctly, you wish for the dropdown list to show as blank and then as you type in the search field the list shows items that match.   This is not possible at this time.

Instead, you should write your expression for the dropdown to take into account the context of the previously entered items on the Form and adjust/reduce the list based on those field entries.  You can force this to happen by hiding the dropdown until the dependent fields have been entered, then show the dropdown field with the reduced set of options to chose from.  This prevents the user from prematurely choosing an item that doesn't make sense with the context of the Form entry.

This is know as a "dependant dropdown".  You can find more details in the article below

Dependent drop-downs