FileMaker and Lasso Code

Lasso, FileMaker Pro, MySQL, Ajax and jQuery demos and code examples.

Lasso + Ajax / jQuery
Chained selects with Lasso, MySQL, jQuery and JSON / no JSON
Shows how you can dynamically populate a select dropdown using Lasso, MySQL and jQuery with either JSON or non-JSON values for the select options. Once you select a value from the first select dropdown, some other form fields will automatically fill in, and a search will run using your selected value to get the related options for the second select dropdown.
view

download (JSON)

download (no JSON)
Autopopulate Multiple Fields and do a Conditional Search using jQuery AutoComplete and Lasso
A demo using jQuery Autocomplete and Lasso on more than one field to find and select from a list of values and use that selection to autopopulate other form fields, load record data, and conditionally filter a searchable dropdown list on yet another field by using the previously selected value.
view

download
Ajax Form Within Form (Ajax Nested Form)
For when you want add records to a database where (for groups of records) most of the information remains the same and only a couple of fields may change, or you want to add, edit and delete records in a list without reloading the whole page.
view
LassoFusebox + Ajax / jQuery
Ajax Auto Complete (Dynamic Select List), jQuery DatePicker and Conditional Field Display, jQuery Country/State Select Lists
Miscellaneous examples combining LassoFusebox with Ajax / jQuery.
view
LassoFusebox
LassoFusebox Core Files
last update 04-28-12
Latest version of the LassoFusebox core files. Now runs in browser immediately, without any modifications. These files were originally updated 09-20-08 to better protect against cross-site scripting and cross-site request forgery attacks by adding encode_html to user supplied input before its used inside any page + encode_sql to action_params being auto-converted to string variables. On 01-27-10 I removed the encode_sql from section 4 of fbx_LassoFusebox3.inc (auto-converting action_params to variables) because a) it was causing double-encoding (saving "can't" stored and displayed "can\'t") and b) it was unneeded because raw, un-html encoded action_params are never used, instead action_params are set to variables before being used or displayed and only action_params inside MySQL SQL statments are encoded_sql. Find out more about LassoFusebox at LassoFusebox.org.

All examples are based on these files.
The downloads for the examples contain code for Lasso 6 tru Lasso 9.


core files for Lasso 8.5 thru Lasso 9.1.4



core files for Lasso 6.0 thru Lasso 8.0
Mail Form
last update 04-28-12
A simple contact form. This demo sends email to the email address entered in the form, but it can be easily reversed and used as a "contact us" form. The code supports the creation of LassoApps. (The "View" link will take you to the LassoFusebox.org site, where this app currently resides.)
view

download
ContactApp
last update 04-28-12
This sample contact manager demonstrates basic add, update and delete forms within LassoFusebox. The Lasso 8 code has been updated to support making a LassoApp. (The "View" link will take you to the LassoFusebox.org site, where this app currently resides.)
view

download
SimpsonFamily
last update 04-28-12
This LassoFusebox Nested Layout example shows both an unframed and a framed version and how to use the "stopLayout" variable to to turn off nested layouts for a particular circuit.
view

download
Portal_Frames
last update 04-28-12
A demonstration of recursive calls to populate sections of the layout and an alternative frames-based layout of the same content. Inspired by Bjork's Portal example.
view

download
Portal Frames Version 2.0
last update 04-28-12
A demonstration of how to populate sections of a layout without using recursive calls and an alternative frames-based version of the same content. Inspired by Bjork's Portal example.
view

download
asktamiStoreDemo
Uses inlines and inspired by Blueworld's original "Classic Lasso Syntax Shopping Cart Example".
view
Lasso
Custom Report Creator (for Lasso 8 and Lasso 9)
Demonstrates how to build create a report from data contained within MySQL or FileMaker databases; the user selects which fields they want to use for the search criteria, chooses which fields they want to include in their report, then can download the report in Excel or tab separated text format or view it on line (HTML).
view

download
asktami_UploadDemo
    Lets the user do the following:
  • upload a file
  • rename the file they're uploading, or
  • overwrite an existing file with the same name
  • upload a file to a folder for a specific database record and then update that record with the number of files in that folder
  • upload a text file to a folder then import the record data from that text file into a database table
  • paste text into a text area and then upload the record data from that text file into a database table
The Lasso 9 version has been tested using Lasso 9.1.4 on Mac OS X 10.8; the Lasso 8 version has been tested using Lasso 6.0.4 - Lasso 8.5.6 on Mac OS X 10.4.11 and Lasso 8.5.6 on Mac OS X 10.8.
download
FileMaker
Duplicate Related Items - FileMaker 6.x
Shows you how to duplicate an Invoice and its related Invoice Items.
download
Calculate Dates - FileMaker 4.x
Calculations for the last day of the next month, the date 2 months from now, and the first, second, third, etc. Monday, Tuesday, Wednesday, etc. of any month once the user provides a starting date. Uses the mod function.
download
Conditional Value Lists - FileMaker 4.x
These 2 files allow you to select a value in one value list, then have another value list display different information depending on the value selected.
download
Conditional Value Lists - FileMaker 5.x
Uses the new value list based on a relationship feature. These 2 files allow you to select a value in one value list, then have another value list display different information depending on the value selected.
download
Conditional Value Lists in a Portal - FileMaker 4.x
Another tip that shows how to create conditional popup menus but this time the magic happens from within a portal.
download
Conditional Value Lists in a Portal - FileMaker 5.x
Uses the new value list based on a relationship feature. Another tip that shows how to create conditional popup menus but this time the magic happens from within a portal.
download