Selectors
SeedCodeComplete3.Selectors History
Hide minor edits - Show changes to output
Added lines 24-33:
This makes it very easy to change which fields show on the Selectors.
!! Control File Selector Scripts
These scripts are actually pretty simple and basically consist of going to a layout in the Control File and doing a find, sorting the results and then returning the list of IDs using the ListOf Summary field. That's why all tables in the Model file have the ListOfIds summary field in them.
Since these script use standard FileMaker, they're relatively easy to modify, so you can extend the keyword to other fields, for example.
%center% %newwin width=440px% [[http://www.seedcode.com/rootimages/stikipad/complete13/Control.png|http://www.seedcode.com/rootimages/stikipad/complete13/Control.png]]
Added lines 20-23:
These calculation fields are then linked to Table Occurrences of the appropriate table so fields from these tables can be placed in the Selector Portal.
%center% %newwin width=440px% [[http://www.seedcode.com/rootimages/stikipad/complete13/RowsTables.png|http://www.seedcode.com/rootimages/stikipad/complete13/RowsTables.png]]
Changed lines 1-20 from:
to:
!! Selectors In SeedCode Complete
Selectors (aka pickers) are one of the common design patterns in SeedCode Complete. Linking records from one to the other is an important part of any database and Complete relies on Selectors to accomplish this.
When you want to link a Contact to an invoice, you will be brought to the Contact Selector where you can quickly look up existing Contacts by typing there name in the Keyword field. By default, this search is done using [[TypeAheads]] locally or on the LAN, but not on WebDirect or the WAN.
%center% %newwin width=440px% [[http://www.seedcode.com/rootimages/stikipad/complete13/Selector.png|http://www.seedcode.com/rootimages/stikipad/complete13/Selector.png]]
If the desired Contact is not found, then a New Contact may be created from the Selector using the '''New Contact''' pop-over button.
%center% %newwin width=440px% [[http://www.seedcode.com/rootimages/stikipad/complete13/NewContact.png|http://www.seedcode.com/rootimages/stikipad/complete13/NewContact.png]]
!! Behind The Scenes
The Selector works by doing a FileMaker find in the '''Control File''' and returns the IDs of the records found as a script result back to the SeedCodeComplete file. The Control File is hidden in the background using the [[MVC]] architecture so does not cause any flashing or disturbance to the SeedCode Complete file.
Once the IDs are returned they are loaded into a Global Variable where they are in turn read by calculation fields in the '''Rows''' Table.
%center% %newwin width=440px% [[http://www.seedcode.com/rootimages/stikipad/complete13/Rows.png|http://www.seedcode.com/rootimages/stikipad/complete13/Rows.png]]
Selectors (aka pickers) are one of the common design patterns in SeedCode Complete. Linking records from one to the other is an important part of any database and Complete relies on Selectors to accomplish this.
When you want to link a Contact to an invoice, you will be brought to the Contact Selector where you can quickly look up existing Contacts by typing there name in the Keyword field. By default, this search is done using [[TypeAheads]] locally or on the LAN, but not on WebDirect or the WAN.
%center% %newwin width=440px% [[http://www.seedcode.com/rootimages/stikipad/complete13/Selector.png|http://www.seedcode.com/rootimages/stikipad/complete13/Selector.png]]
If the desired Contact is not found, then a New Contact may be created from the Selector using the '''New Contact''' pop-over button.
%center% %newwin width=440px% [[http://www.seedcode.com/rootimages/stikipad/complete13/NewContact.png|http://www.seedcode.com/rootimages/stikipad/complete13/NewContact.png]]
!! Behind The Scenes
The Selector works by doing a FileMaker find in the '''Control File''' and returns the IDs of the records found as a script result back to the SeedCodeComplete file. The Control File is hidden in the background using the [[MVC]] architecture so does not cause any flashing or disturbance to the SeedCode Complete file.
Once the IDs are returned they are loaded into a Global Variable where they are in turn read by calculation fields in the '''Rows''' Table.
%center% %newwin width=440px% [[http://www.seedcode.com/rootimages/stikipad/complete13/Rows.png|http://www.seedcode.com/rootimages/stikipad/complete13/Rows.png]]