One of the best things about Google search-results is that they often provide excerpts from the pages that match your search, so you can see the context in which your search term occurs.

My database of journal entries and reports (I work as a writer) has hundreds of records. Currently, if I perform a search of this database, the results of the find are presented in a list arranged by record title in alphabetical order. Unfortunately, the context in which those matches occur is not provided.

Can a FileMaker database be programed to provide 'find' results similar to the Google-style results described above?

If yes, where do I start?

Thanks in advance,

Sydneytim

Interesting problem.

Could this serve as a starting point?

context.zip

use a result layout, not showing the acual fields but xx characters left & right from the search term.

You will have to enter the search term in a global, then do a scripted search, resulting in a special layout.

I downloaded your attachment... I could use it also, my question is this: Is there a way to double click on the found set of text in the cContext portal and have it return you to that text in theText text box?

In theory at least, you could add buttons that would select the relevant occurence in the text.

In practice, however, I find that Set Selection script step doesn't perform as advertised ("Data selected out of visual range is scrolled into view").

Meanwhile I've made this primitive workaround - perhaps someone else might come up with a better solution.

BTW, cContext is a repeating field, not a portal, and AFAIK there's no double-click in FMP.

context.fp7.zip