Lookup Objects - Autocomplete

[toms]

Hi Steven,

Is there a way to enable autocomplete for lookup objects?

nuBuilderPro:
http://wiki.nubuilder.net/nubuilderv3/i ... tocomplete

[admin]

toms,

1- If you enter a Code in a Lookup that exactly matches what you have typed in, then that will populate the Lookup.

2 - Otherwise if you enter the first part of a Code and there are Codes that start with what you have entered, it will open the Lookup window showing these records.

3 - If you enter a Code that doesn't match 1 or 2, the Lookup will be set to blank.

BTW While your cursor is in a Browse Search field, you can use the up and down arrows to scroll through the list.
And hitting Enter will select the highlighted record.

It's not quite autocompleting but its still a fast way of typing part of what you want and using the keyboard to make the final selection.


Steven

[toms]

Steven,

1- If you enter a Code in a Lookup that exactly matches what you have typed in, then that will populate the Lookup.

2 - Otherwise if you enter the first part of a Code and there are Codes that start with what you have entered, it will open the Lookup window showing these records.

3 - If you enter a Code that doesn't match 1 or 2, the Lookup will be set to blank.

Yes this works!

BTW While your cursor is in the Search field, you can use the up and down arrows to scroll through the list.
And hitting Enter will select the highlighted record.

This doesn't work for me.


In nuBuilderPro I can enter a part of the description (not the code) and it will show this additinal autocomplete dropwdown

nu3.png

[admin]

toms,

You should be able to use up and down arrows while in the green Search field.

There is no actual autocomplete.

key_scroll.png

Steven

[toms]

toms,

You should be able to use up and down arrows while in the green Search field.

Steven

I think you're talking about a different type of field. Mine is an object of the type lookup (with an icon graphics/magnify.png next to it)
The up and down arrows have no effect there.


To my undestanding, ui-autocomplete-input was implemented in nuBuilderPro ( https://api.jqueryui.com/autocomplete/)
but this is not there anymore in nuBuilderForte.

[admin]

toms,

I know the list you are talking about, I have removed it for 3 reasons.

1. - It looked a bit cheap.

2. - It was just another question the developer had to answer when creating a Lookup.
(even if it had a default, it was a field that people had to read, making nuBuilderPro 1 or 2 percent more confusing to use.

3. - Now with Forte if you type the first few letters and hit tab, and there is no exact match, you will get a lookup list of records with codes that start with what the user typed in. eg.

This list is built from a where clause like this...

Code: Select all

1. - WHERE pro_code LIKE 'aa%'

And this Lookup can now be scrolled through with up and down arrows and selected with enter. (like nuBuilderPro's list - without using the mouse).

If people would prefer, I can change that to...

Code: Select all

2. - WHERE pro_code LIKE '%aa%' OR  pro_description LIKE '%aa%'

Giving the ability to search within both code and description fields.



I know it's not instantaneously visible as nuBuilderPro's list but it is more consistent with the rest of the way Forte looks and works.

Let me know what you think people would prefer. (where clause 1 or 2)

Steven

[toms]

If people would prefer, I can change that to...

Code: Select all

2. - WHERE pro_code LIKE '%aa%' OR  pro_description LIKE '%aa%'

Giving the ability to search within both code and description fields.

Steven, I would go for this option, since in many cases you don't know the codes but the description. (in my case employee numbers vs. employee names)

[admin]

toms,

I have made that change (now on Github)

Let me know if it works the way you think it should.

Steven

[toms]

Perfect - thanks!

[admin]

.