Jump to content

Google Style Search in Drop-down List ?

Recommended Posts

Hi All, wow, it's been awhile since I was last here !

I am playing around with FM18 to see what's new since the days of FM7 and discovered "Google style searches" with a global field and a portal that shows "filtered" results as I type - all good.

Is there a way do do the same thing BUT to use it instead of a drop-down list ? 
I have a WorkOrder table with a clientID field that links to a Clients table to get the client info for that work order.
What seems like the simple way to get the info is :  a drop-down list showing all records from Client using a value list.

What I would like is to replace the drop-down by the result of a google type search so that as I type characters my choices are filtered and I select the desire record with a click.

The 1st problem I am having is that my layout is based on the WorkOrder table and the client info is in the Client table. Is there a way to do a google style search without changing layout ?
The scripting bits I found here and there as well as video examples all seem to search from the current table - I am not trying to filter down to find the correct Work Order - I am trying to filter down
the clients table to select the one I want to associate to this current WorkOrder record.

My 2nd problem, does anyone have thoughts on how to show/hide the portal that is needed for that style of search field ??  I was thinking of a slide control or tab control placed just under the search field and then showing it when the field is entered and hiding it when the user selects the chosen record -- clicking on it -- hides the tab or slide and puts the clientID in the proper field on the WorkOrder layout.

Thanks for the help.

Share this post

Link to post
Share on other sites

Thank you for this, it seems promising. One question because I have never used card style windows....

What does the Install OnTimer Script do in relation to the revealing the card and dealing whit what was selected by the user ? 

Without those OnTimer steps my FM18 freeze and the screen is dimmed but no window appears on top of the main window.


Thanks, Dan

Share this post

Link to post
Share on other sites

The onTimer is a key part of the technique. Once the window closes, the handler script takes over. Card windows are a wonderful way to present another context to a user without the need to build a relationship. 

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

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