Interactive Data App

Hi,

I have a dataset with foods, chemical food compounds an measurement values.

Now I want to build an interface via component which has a text input window, where different foods are suggested depending on the input.

For example:

If I write into the text window: “a” → all foods with a are suggested via dropdown

If I write further to “apple” → all apples are listed.

Then I can choose one of the displayed entries and my table with the food compounds and measurement values are displayed.

Does anyone know, how to build such a dropdown?

Best

Paul