Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Filter portal list on each keystroke

Filter portal list on each keystroke

Filter portal list on each keystroke


I would like how to filter a portal list on each keystroke.

Let's say I'm searching for a name in a portal list.
I Type A; then Anna, Adam, Adolf comes up.
When I type the next letter D (ad), then only Adam and Adolf comes up.

How can I make this work??

Thank you for the effort!


RE: Filter portal list on each keystroke

Apart that I don't see why you want to do this in a portal, yes it is possible.

With the Auto-complete function.

However, if you want this for each given value or letter, a more advanced technique is needed.

The auto complete function is based upon the first characters of  a word.
For every given value, you need a custom function that will index every part of a word in a field.

Out of this calculation you create a valuelist and format the imput field with this valuelist.
Together with an auto-enter on that datafield, you can capture the first matching record based upon a relationship.
The key fields for this relationship are the result of the custom functions (which is basically a multiline key) and the values in the datafield.

The custom function for the words can be something along these lines:
Case (

WordCount ( Text ) > 1 ;

CF_WordBeginsWith ( LeftWords ( Text ; WordCount ( Text ) - 1 ) ) & "¶" & FieldBeginsWith ( RightWords ( Text ; 1 ) ) & "¶" ; FieldBeginsWith ( RightWords ( Text ; 1 ) ) & "¶"


And you need another one for the field content.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close