Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8424 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I want to search a value list so that when the user enters the first alphabet of the word it shows all the items from the list with the first alphabet and then when he enters the second it searches for combination of first and secod alphabet and so on.Is it possible to be done using file maker.

Thank You

Posted

FM does this automatically for fields defined with a value list display as a "pop-up list". It does not show only those items matching the letters you type, but will move to the first matching item as you type the letters.

-bd

Posted

Maybe I am doing something wrong here.If I type in an alphabet the valuelist does not filter to the items with the starting alphabet.It doesn't do anything other than you select from a list.

Posted

It sounds like you want "type-ahead". It can be done in FMP, it's not that difficult but it's a bit of work and requires quite a bit of knowledge.

There used to be a sample file on the www.databasepros.com web site under the name "clairvoiance."

Posted

It's there under the "Resources" section, on page 6. Look again.

Posted

Well I have found a solution to this I created a related file and used the relation for the value list.The realtion would be based on a Calculation field using left(valuelistfield,1).So it filters the item starting with the first letter.I am just wondering if there is a way it just pops with out click on the field while just entering the data

This topic is 8424 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.