Universal Search

/3 Comments/in , /by

Universal_Search

“Universal Search” is 100% reusable, modular search code. It can be used to run any number of search requests (“FileMaker” style or SQL), in any context (layout), using dynamically specified (not stored) search fields and search terms. “Universal Search” works on any FileMaker file you paste it into. It works locally as well as a Remote Procedure Call (“Perform Script On Server”, on FileMaker Server 13 and up). It can execute your SQL queries or your traditional FileMaker search requests. It works on iOS and on the Desktop.

 

Version 1.0.1 Update

Trivial navigation and UI tweaks (tutorial navigation bug fix, layout field label change)

Click on this link to download source code with demo tutorial.

 

Picker Window

SQL Picker Window

/2 Comments/in , , , /by

This module provides a FileMaker Pro developer with the layout structure, schema and scripts needed to make a generic but portable picker window.  I use this module as a way to assign a value to foreign key fields in my systems.  This module makes use of a virtual list table with calculated repeating fields, Execute SQL, and a popup modal window.  The popup window will be sortable and searchable, and as long as you’re comfortable with FileMaker’s ExecuteSQL function, then you’ll find this a breeze to set up and use.

 

Picker Window

Picker Window Screen Capture

Features

  • Smart scripting that will enhance the SQL that you pass ( will automatically add the “ID” field, and will automatically sort records if you don’t specify a sort order)
  • UI provided for sorting of records displayed
  • UI provided for QuickFinding of records displayed
  • SQL Picker Window is displayed in a modal window
  • Easy to integrate, and very flexible

 

How To Install

  1. Copy VirtualPickerWindow table into your solution
  2. Reset next serial number to 1 (applies to VirtualPickerWindow::zc__recordSerial)
  3. Copy all scripts to your solution
  4. Paste all VirutalPickerWindow layout objects to your solution (Your layout should be called “VirtualPickerWindow” –> you can use the one that FileMaker automatically created for you.  Just delete all layout objects from it, and paste all the layout objects from this module over)
  5. Add an OnObjectEnter script trigger to one of your foreign key fields ( Script = “Initialize Picker Window”, Parameter = SQL Select statement that would return all of the fields that you want to display in the window)

 

Side Notes

  • It’s entirely possible that you may need customize some of the scripts in this module to make it work with your solution.  This module will require you to make use of a very strict naming convention for your primary keys.  It’s currently setup to expect that all of your primary keys are named “ID”
  • Since this module makes use of virtual lists, it means that the fields displayed in the picker window will actually be unstored calcs.  Be aware of this, because it means that should you choose to display a large volume of records in it, then the QuickFind will probably perform slowly.

Download SQL Picker Window