Jump to content

Portal Search Filter for any term


Jon Crain
 Share

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

Recommended Posts

I seem to be full of questions this week...

Sorry again if this has been talked about before.

What I'm trying to do is create a script step that will filter all results of a field so that the portal only shows what you're looking for. It's easy to do if its not a portal.

What I have is 5000+ songs that people can play if they select them. Sometimes the name might not match what the people will be thinking so a search works much better in this case than filtering based on the first couple letters in the title.

I'll attach the file, I'm currently just working on the songs layout to get it to work properly.

jon

Wheatland.zip

Edited by Guest
Link to comment
Share on other sites

There are a couple ways to do this.

If you want to allow partial matches starting from the beginning of each word, or from anywhere in the word, you'll need FileMaker 8 Advanced to install some recursive custom functions, like I talk about here:

http://www.fmforums.com/forum/showpost.php?post/183594/

If you just want to allow partial matches starting from the beginning of the text, then you can use FileMaker's range relationships to filter the relationship, like John demonstrates in his Type Ahead demo:

http://www.filemakerpros.com/TYPEAHEAD.sit

Link to comment
Share on other sites

Ok, for the most part I'm starting to understand what's going on. I have the custom functions set up correctly (as far as I can tell) and have the calc keys setup (not sure if those are right...) but I'm not seeing much change in my portal.

So I think I have the backend setup right, but the post you mention doesn't say much about the UI.

Any help?

See attached file for example.

jon

Wheatland.zip

Edited by Guest
Link to comment
Share on other sites

This topic is 5606 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
 Share

×
×
  • Create New...

Important Information

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