Database driven auto-completes?

[Devan]

Ok, I was nervously waiting the day from when this would happen, and today was it!

A client asked me if they could 'simplify' their EIP Browse 'form' (currently asking for product code before populating the product description automatically) by allowing the user to begin typing in the product description, and have the system drop down a list of close matches and allow the user to select a product from the drop down to backfill the product code.

I know these sorts of auto completes are possible in jQuery itself, but am wondering it is already has/being planned to be added to NetTalk?

Basically, the underlying logic would have to take the user input and do a partial search (e.g. DESCRIPTION LIKE '&UserVar&') ?  I am kind of hoping that this is magically already in NetTalk and that I have missed it in the last slew of upgrades!

Cheers,
Devan

[kevin plummer]

Could be your lucky day. There was an auto complete update in Feb but I have not used as yet so not sure if it works in EIP Browses.

6.18 (3 February 2012)
Add: (WebServer) Server-side Auto-Complete option for Strings.

[Bruce]

>> I am kind of hoping that this is magically already in NetTalk and that I have missed it in the last slew of upgrades!

While this may seem like an approach lacking in a suitable amount of technical expertise, it seems to be working for you.

cheers
Bruce

[Devan]

Arr... I found the auto-complete tab.  It appears to be in the WebForm procedure only at this stage, which is all cool, but my client wanted it on an EIP browse and as yet, it is not on the EIP validation pages... 

I think I will find this useful on a couple of other forms I am using, but by the looks of it, it will only update the current field contents.  It would be good if, like the lookup validation, it could populate another field as well, i.e. Do the autocomplete search on the Product Description, but when selected, it populates the Product Code with the correct Code as well...

[Bruce]

>> .. but my client wanted it on an EIP browse

that'll come, but probably not for a build or two.

>> I think I will find this useful on a couple of other forms I am using, but by the looks of it, it will only update the current field contents.

you're not looking hard enough <g>

>>  It would be good if, like the lookup validation, it could populate another field as well,

If the field is also a lookup field, then the lookup settings "More Assignments" will happen after an auto-complete as well.

I will tweak it I think to allow this "More Assignments" on the auto-complete (without lookups) as well.

cheers
Bruce