Drop Down menu limitation

Ask the community
,
1

Hi
I have a database with more than 5K items (stocks).
I created a drop down menu that should display all the stocks in the database so the user should be able to choose one of them.
It seems like there is item limitation in the drop down menu list because i’m not seeing all the items from the database.
Is there any place where i can change that limitation?.

I just checked and the limitation is 1000 items. I need to bypass that limitation :(.

Thank you.

2

Do you actually need to display all 5k+ stock items in a drop down?

Can you not list them in a table or repeater for example with dropdowns to filter the list down to what the user needs or is looking for.

Then they can simply click on the stock items that they need to get.

I would rather have that option rather than having to scroll through a drop down list of over 5000 items!

3

It’s probably the collection query limitation, not the drop-down limitation.
So you can query 5 times (with skip() ).
However from UX perspective having so many options in a dropdown is quite an awful experience as GOS said. So you should reconsider.

4

I’m trying to understand what do you mean, can you please show me some example?.
My goal is to let the user choose stock from the list and after that submit the form and update the database.
Thank you.

5

J.D. is spot on, you can only limit 1000 at a time, if you want to do more just search this forum as it has been asked before many times.
https://www.wix.com/corvid/forum/community-discussion/dataset-query-for-3000-items

As for filtering your table or repeater, you simply have a table or repeater with your items in it from a dataset with dropdowns or some other user input that the user can use to filter that list down from 5k items to either the exact product or a group of items like a certain product range for example.

Or just break your items into product ranges for example so you are not showing such a long list and let the first drop down be a choice of product range and then the other dropdowns being for that certain product range.

Have a look here for a starting point.
https://support.wix.com/en/article/corvid-about-creating-searches-and-filters-of-displayed-data

6

ok, thanks.
Is there any option to type the the first character of the stock symbol and and search bar will show the list of that stocks?. small search bar inside the form so the user can write the name of the stock and i will fetch the list automatically from the database.

7

I’m sorry buy i really trying to understand how can i solve my problem with the suggested solutions.
That’s the form that i have:

704×130 15.9 KB

the user should choose items from the drop downs menus and submit that form.
“AMGN” is the dropdown list that has more than 5k items.
How a repeater or table can help me to filter that dropdown menu?.

thank you lot!.

8

@meirhasin It’s up to you, but you can:

  1. let the user search for the item by typing keywords.
  2. display a table with the option and filter on row selection.
  3. same as #2 but with a repeater.

Any way, in my opinion, it makes no sense to think that anyone will go over a list of 5k items. So options 2 & 3, only makes sense if you display short a category of items in the table/repeater, and once the user selects a category you display a table of subcategories and inside a subcategory you show a short list of items (browse).

9

Hi
I configured the sub category option.
The user can choose category and after that he can see dropdown menu with all the stocks from that category.
Thanks a lot for the help!