How do I make a Cascading AutoComplete return more than 10 results?

[Lynda]

I have a large table (Foods) that the user will search to add Food items to their Food Diary. The Foods table is already filtered by FoodType (Virtual1)

The Cascade works. As the user types, up to 10 results are returned.

The problem is two-fold: 1) If the user types in the whole word of what they are looking for, it does not appear in the results because it's too far down the list. 2) The list only returns the first 10 results and does not provide the user the ability to locate the food they are looking for.

I need the "Contains" option, as searching on "Starts With" is not helpful to my users.

Can anyone help? Does anyone have a solution?

 

[autonumber]

Hi @Lynda - I have a similar issue and it seems that this is a current platform limitation of Caspio. It only allows you to return 10 results. 

[cheonsa]

Hi!

I also have a similar issue. Caspio Support told me to submit a request in their ideabox to communicate with their Product team and for others to vote. However, it seems that other users already have an entry. We can submit our votes here:

https://caspio.uservoice.com/forums/164206-caspio-bridge/suggestions/6732346-it-would-help-if-we-could-determine-the-amount-of
https://caspio.uservoice.com/forums/164206-caspio-bridge/suggestions/17981896-can-autocomplete-be-modified-by-user-or-system-to

 

 

[Queso]

Hello, unfortunately this is a limitation of the cascading autocomplete. The limitation is set because more than 10 results might affect your DataPage's performance.

[Lynda]

This is just wrong.  Shouldn't this be our decision to how many records are returned? We can define how many records are returned on a page. Why not on a control?

On other websites and platforms, this is a standard feature. Why is Caspio putting us at a disadvantage? Why are they treating it like a feature and doing us a favor? 

JMO

Lynda