TOPIC:

is there a solution for my problem?

i have a select list with a lot of entries (> 300).

i need a comfortable solution for search in the select list. i think of a textfield, where i can make entries to restrict the selection in the select list.

when i choose in the select list, the cursor jump only to the letter with the word beginn ( i need also a search in the middle of the word or parts of the word) - (sorry for my school english - was in the 80 and 90 years)

see the picture -


thx for help....

Hello,

I have answered on the ServiceDesk ticket that you have created:

After some looking into this, I have come up with a quite simple solution.

Just do as follows.
Go to the Advanced properties of the "search" field and in the Actionscript section set Type to Custom.
Under Actions check the "Change" checkbox.
In the code area below that appeared, put the following code:

function ff_search_action(element, action)
{

jQuery('option').prop('hidden', false);
jQuery('option').not(jQuery('option:contains('+element.value+')')).prop('hidden', true);

} // ff_search_action

This should work as you wanted. In the select list, only options containing the string that was entered in the search field will be shown.
NOTE: The change in select list options based on the search field will be made after you click anywhere on the form.

Let me know whether you have managed to apply this to your form and whether this is working as you wanted.

We can continue our conversation through the ticket raised.

Regards,

Mihaela

Hello Mihaela.

How to make the same thing work when you have several lists on the same form? How to target the search on a specific list?

@mihaela
thank you very much - works absolutely fine -

is there a possibly that the select list is always "open" when i make an input in the textfield "search".

then can i see the choise directly in the select list

thanks again

here is the example form

also works with insert the data from database

form pieces --> costum before form

$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library
$db = JFactory::getDBO();//Get Database Object

//Create your own query here
$db->setQuery('Select FIELD From #__Database ');

$result = $db->loadColumn(); //load the result from the query
$test = "";
for ($i = 0; $i < count($result); $i++)
{
$test .= "0;".$result[$i].";".$result[$i]."\n";
}

function ff_setSelectList($name, $value)
{
global $ff_processor;
for ($r = 0; $r < $ff_processor->rowcount; $r++)
{
$row =& $ff_processor->rows[$r];
if ($row->name==$name)
$row->data2 = $value;
unset($row);
} // for
} // ff_setSelectList

ff_setSelectList('select1', $test);[

Hello,

Eddy, here is how you can target a specific select list only.NOTE: You have to replace selectlistname with the name of the select list element that you want to apply the search to.

Furthermore, here is the improved version of the code that will make the search case INSENSITIVE:Basically, a new selecteor is defined which finds strings that contain another string regardless of uppercase/lowercase.

@Karlheinz68 as I wrote on the ticket, there is a way to make the select list always "open". You can go to Properties of the select list element and check there the "Multiple" checkbox.
NOTE that this will allow the user to choose more options in that select list.

Let me know whether this helped.

Regards,

Mihaela