Can I have a search function for the enumlist drop down

[happy_farmer]

Hi guys,

I need multiple input to my row.
That’s why I used Enumlist as a column type.

Enumlist with Ref to another table. Anyhow, the enumlist drop down shows nothing. Due to that I setup Valid_if formula to reference to the data source data, and then the enumlist drop down shows something.

Can I have a search bar on top of the enumlist drop down to key in some keywords to further filter down the drop down ?

Thanks guys !!

[khuslid]

Hi.
All enum and enumlist have a standard search field on top.
If you use enumlist in combination with REF, you nedd to create a list of the REF values eg. FILTER() or SELECT() etc.
You gave to little detailed info to know your issue.

[happy_farmer]

Hi Khuslid,

I know enum and enumlist hava a standard search field on top.
But i don’t know why it doesn’t appear on my app…

And below is my column setup…can you found anything wrong ?

Thank you!

[Suvrutt_Gurjar]

Is it possible to know how many options you have under Fruits ID in the backend table? Currently, image of the drop down shows 5 options.

[happy_farmer]

Hi Suvrutt !

I have 6 entires, i also dont know why the last entry doesn’t populate into the enumlist…

Thank you.

[Suvrutt_Gurjar]

Thank you. Can you please try adding say 6 more (making total 12) and try the drop down again?

[LeventK · Accepted solution]

@happy_farmer
1.) It seems you haven’t specified the item delimiter/seperator
2.) Unless your enumlist dropdown values are limited and not scrolling, there’s no searching functionality because there’s no meaning for it
3.) With which expression are you populating the enumlist values? You haven’t specified any values to it, so you shall be using either a Valid_If or Suggested_Values property to populate the content with an expression.

[Suvrutt_Gurjar]

LeventK:

2.) Unless your enumlist dropdown values are limited and not scrolling, there’s no searching functionality because there’s no meaning for it

Hi @LeventK,

Eaxctly. Thank you. It is the reason I had requested @happy_farmer to add another 6 so that scrolling starts showing.

He seems to be using valid if for populating the field.

happy_farmer:

Due to that I setup Valid_if formula to reference to the data source data, and then the enumlist drop down shows something.

[happy_farmer]

Hi Survrutt,

Yup i add more fruits into the list and yes i am using valid if to populating the field.

I wonder why we need to populating the field by using Valid_If…

Doesn’t this not enough to define the field ? But anyway, I learned something from your guys. Thanks for teaching!!

[happy_farmer]

Hi LeventK

I followed your suggestion, and it is working now!

I have another question:

1. Am i using the Valid_If correctly ? Refer to below photo.
2. Do you know any sample app or links for me to understand Suggested_Values ? This is also new to me.

[LeventK]

happy_farmer:

Am i using the Valid_If correctly ? Refer to below photo.

That’s OK as long as list values appear to be unique in the column.

happy_farmer:

Do you know any sample app or links for me to understand Suggested_Values ? This is also new to me.

You are using a REF type enumlist. Using Suggested_Values property, will add the New item to the beginning of the dropdown list which will let the user to be able to add a new fruit record. If that’s not the intention, keep the expression in Valid_if.

[happy_farmer]

Hi @LeventK,

Fully understand what you are trying to say !
Thank you very much!

If you would have time please help me also on my another problem…

Seeking for Advise. Goods Ordering App Questions

Hi Appsheet family, I am building an app for Goods Ordering. I have some Goods at warehouse, for example like below Description = Item 1_, Parts number = 111, Price = 100 Description = Item 2_, Parts number = 222, Price = 200 Description = Item 3_, Parts number = 333, Price = 300 Description = Item 4_, Parts number = 44, Price = 250 Item 4 is actually an combination of: Item 1 + Item 2. Which means if part number 44 was ordered, customer will get both Item 1 & 2. Item 4 was a slightly ch…

Thank you so much!

[Lynn]

@happy_farmer
Maybe check this thread and solution by @Suvrutt_Gurjar

Why there is no search box or menu options in my views Questions

Please take a look at the following setting [Menu Search]

[LeventK]

Lynn:

Maybe check this thread and solution by

@Lynn,
I’m afraid the solution that @Suvrutt_Gurjar had proposed in that thread is to hide the hamburger menu and the magnifying glass on top tier of the app. The issue that @happy_farmer is trying to query is totally different.

[Lynn]

OOps

[happy_farmer]

Hi Lynn,

Thanks for the information !

I tried that one, but that’s not the solution for my trouble…

Thank you !

[happy_farmer]

@LeventK & @Suvrutt_Gurjar

thanks for the solution both of you. There’s only 1 post that can be selected as “solution”, sorry for that.

If you guys would willing to give some advise to me for my another problem…

Seeking for Advise. Goods Ordering App Questions

Hi Appsheet family, I am building an app for Goods Ordering. I have some Goods at warehouse, for example like below Description = Item 1_, Parts number = 111, Price = 100 Description = Item 2_, Parts number = 222, Price = 200 Description = Item 3_, Parts number = 333, Price = 300 Description = Item 4_, Parts number = 44, Price = 250 Item 4 is actually an combination of: Item 1 + Item 2. Which means if part number 44 was ordered, customer will get both Item 1 & 2. Item 4 was a slightly ch…

Please and thank you very much!

[Suvrutt_Gurjar]

Hi @happy_farmer,

Glad that your issue is solved. Could you please mark @LeventK’ s post as the solution, His solution post was more detailed with proper reasoning.

[happy_farmer]

Hi @Suvrutt_Gurjar,

Yup, i marked @LeventK post as solution. Done It

If you would have time please help me on my other problem…

Seeking for Advise. Goods Ordering App Questions

Hi Appsheet family, I am building an app for Goods Ordering. I have some Goods at warehouse, for example like below Description = Item 1_, Parts number = 111, Price = 100 Description = Item 2_, Parts number = 222, Price = 200 Description = Item 3_, Parts number = 333, Price = 300 Description = Item 4_, Parts number = 44, Price = 250 Item 4 is actually an combination of: Item 1 + Item 2. Which means if part number 44 was ordered, customer will get both Item 1 & 2. Item 4 was a slightly ch…

Thank you very much!