This is a tip I often use to select a client from my database. You could even perform multiple selection using a text field instead of a global, then select a script (I use it for e-mailing when I cannot select the clients through a scripted find)

I find it very useful and this could be a good solution for others.

From Bob Bowers/Chris Moyer Advanced FM

While a Classic Type-Ahead solution would match the first few words of a text field, this solution provides a way to match even those "text strings" inside the text field.

Therefore, you would find a Match for University of Chicago while entering "The Univ", "Chic", ...

or at reverse would find "The University of Chicago", even if you entered "Univer...",...

A necessary little script though.

TypeAheadAdvanced.fp5.zip

Ugo

You're a star! I've been trying to do this for a week... and your first sample (Type-ahead) is almost exactly what I wanted.

The only modification I'd like to make is to be able to toggle between displaying prospects only or clients only, or showing all records in the top portal (relationship: selfoncfilter). How should I do this? I tried a few ideas, but without success...

Thanks again

Dave E

This is an old one !

Have a look to this thread for other links to Type-ahead portals and a modified version of this one, which does what you're looking for

Type Ahead thread

Ugo

Sorry to be a nuisance... the link in your post doesn't work. I did a search, but didn't find the modified version.

Dave E

Ugo,

Great solution to a problem I had, too. Thanks for the file.

Question - is it possible to make it truly "type ahead" - like Quicken or Outlook? This would be where the records in the portal will change as you type. Or, as you type, suggested possibilities appear.

Obvious benefit would be that users could see if they are getting results as they type.

I attempted it with Loop, but it seems way to clunking. Basically, it is hitting search after each letter.

Thanks again!

Dave,

sorry for the "no link"...

New Type Ahead + filter

About the other issue, you'd need an exit record to have it work, so there is AFAIK no solution at the moment to have it as dynamic as you wish too. I don't think a loop will help as it would exit the field, or may be with a copy paste or some stuff. Don't know.

Anyway I can get a windows example?

Hmm...

Thought this one was zipped.

Type-Ahead.fp5.zip