Any text (not ID number) based value list can be enabled with auto complete. One simple example of that may be found here:
FileMaker 12 users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fmp12
Pre FileMaker 12 Users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fp7
And portals can be set up to update with each keystroke to show fewer and fewer matching records in the portal. Clicking a portal row then clicks a button to select that item from the search portal:
Users with FileMaker 12 or newer can use Open from FileMaker's File menu to open the file and produce a copy converted to the .fmp12 file format. This search portal method also works well in FileMaker Go on iOS devices where the auto-complete type value list won't won't auto-complete.
Haven't played with the idea in a long time. The challenge is in getting all possible combinations of an * wild card to work since it represents an unknown number of characters.
Just got it all working, and it works a treat!
Thanks again, it's really pimped my FM
I am trying to use the patterrncount variation of this (the one in the bottom left corner):-
and can't get it to work. I have a layout called companies on which I have a global field called gsearch field companies. My portal is called companies for portal and there is a field called search refresh which is an auto enter calculation evaluated from the context of companies for portal:-
companies for portal::search refresh = companies: gsearch field companies
and there is a script :-
companies:gsearch field companies = companies:gsearch field companies
which is assigned to companies:gsearch field on the layout. The relationship between the two tables is shown in the screenshot below. However upon doing this, no filtering occurs. can somebody explain why ? thanks
have now figured it out. thanks