MonthDatePicker

Introduction

This is a simple Month Date Picker.  It is highly modularized and flexible.  It is debuting at the FileMaker Developer’s conference 2013.

Download

JSON

Provides native support for JSON in FileMaker. It will parse JSON encoded text into a format that can easily be read via custom functions. It will also convert text encoded by custom functions into JSON.

Read more

#Parameters

#Parameters

 

Overview

#Parameters is a set of custom functions for serializing name-value pair (dictionary) data in Let Notation, such as for passing multiple parameters to a script. (If you aren’t familiar with Let Notation, it basically looks like the variable-setting part of a call to FileMaker’s Let function. FileMakerStandards.org documents the format and best practices.) Installation instructions are available in the module file. Additional documentation and discussion of this module is available on FileMakerStandards.org.

Credits

This module is the result of work from several contributors to FileMakerStandards.org.

License

Anyone may do anything with this software. There is no warranty.

Download

This module is a subset of the FileMakerStandards.org custom function repository on GitHub. If you are not comfortable working with GitHub, you can download the repository directly. The module file is located at Functions/#Name-Value/FM-Parameters.fmp12 in the repository.

Downloading From GitHub

Several folks have expressed frustration with Downloading from Github. While Github has been quietly changing the rest of the coding world it is not widely used within the FileMaker world. As a result lots of FM people don’t know how to “download something from GutHub”.  It’s pretty easy actually.  But like anything new, it can be a bit confusing at first. Here is how it works.

On the main project page for every GitHub project, you will find a “Download Zip” button. It looks like this

 

jbante_FM-VirtualValueList

Click it.  Thats it!

If you still need more help.  Check out the video.

[pl_video type=”youtube” id=”2I8LCT0LEQk”]

Virtual Sort

Virtual Sort Screen Shot

Overview

Virtual Sort lets users sort records in FileMaker portals and found sets by any combination of fields they choose.

This module includes custom functions that require a copy of FileMaker Pro Advanced to install in another FileMaker file. The functions are not absolutely necessary, but I do strongly recommend them.

Credits

This module is based on a demo by John Ahn.

License

Anyone may do anything with this software for any purpose. There is no warranty.

Download

Download from GitHub. If you are not comfortable working with GitHub, you can download the repository directly.

Virtual Value List

VirtualValueList

Overview

Virtual Value List helps developers build transient value lists based on the contents of global variables. By basing value lists on global variables, developers can be spared most of the schema overhead associated with other techniques for value lists with programmatically specified values. This module extends techniques demonstrated by other developers by supporting arbitrarily many simultaneous virtual value lists and by preserve the sort order of the values as they are provided to the module.

You must use a copy of FileMaker Pro Advanced to install the custom functions for this module.

Credits

This module is based on value list demos by John Ahn and Andries Heylen, and a technique by Marcelo Piñeyro for coercing value list ordering.

License

Anyone may do anything with this software. There is no warranty.

Download

Download from GitHub. If you aren’t comfortable working with GitHub, you can download the repository directly.

Local Backup

Local Backup Screenshot

Overview

Local Backup creates backups of non-hosted FileMaker solutions. Many developers work on files locally, not hosted by a server, by necessity or by choice. By doing so, they miss out on the backup features of FileMaker Server. This module gives developers a substitute backup mechanism.

Credits

This module is inspired by (copied from) solutions by Kevin Frank (with help from Bruce Robertson) and Michael Rocharde.

License

Anyone may do anything with this software. There is no warranty.

Download

Download from GitHub. If you are not comfortable working with GitHub, you can download the repository directly.

Propa-Gator: Modular Record/Request Creation

propa-gator-wide

Features Overview

Propa-Gator allows for creation of new records and requests.  The goal was to create a module that accomplished the following:

  • Create a record or request on a target layout and set any number of fields in that record to any desired value (calc, literal, field)
  • Allows data values to have paragraph returns
  • Immune to field renaming
  • No required dependencies
  • Traps and returns various errors
  • Returns the ID of the created record
  • Allows for specification of refresh type using a refresh subscript (NEW with version 1.0.2)

Applications

  • Related record creation
  • Log record creation
  • Flat record normalization
  • Record creation from global UI inputs
  • Scripted find request creation

License

Anyone may do anything with this software. There is no warranty.

Support

Feedback and questions are welcome via darren_burgess@mightydata.com or twitter: @darrenburgess.

There is a blog post documenting and describing the script parameter technique for this module at www.MightyData.com.

Download

05-07-2013: version 1.0.1 – added ability to include paragraph returns in data values.  See internal documentation for syntax.

07-19-2013: version 1.0.2 – added Refresh subscript.  Allows refresh of window as required – none, cache, external, both, cartesian.  See internal documentation.

12-11-2013: version 1.0.3 – bug fix. Insert of data would fail if the data contained “::” or “$”

Download Propa-Gator V 1.0.1.fmp12

Download Propa-Gator V 1.0.2.fmp12

Download Propa-Gator V 1.0.3.fmp12

Restore Tabs

restoreTabs

Overview

Restore Tabs will save and restore tabs as you move from layout to layout in FileMaker.

Features

  • Works with nested tabs
  • Can be called from another script, a button, or by script triggers
  • Easy to install
  • No custom functions
  • Can easily be adapted to use across sessions

Dependencies

Tabs to be saved and restored must have an object name

Optional: If saved tabs are to be saved into a field instead of a variable, field needs to be created and designated in Configuration script.

License

Completely Free

Credits

Todd Duell at Formulations Pro for sharing an elegant solution demonstrating how to accomplish restoring nested tabs.

Download

Download Restore Tabs

Browser Navigation

BrowserNavMain

Overview

BrowserNav adds web browser like layout navigation history and requires a single script, one custom function (Optional) and back and forward buttons.  Once the script and custom function have been added to your file, just paste the back and forward buttons onto each layout you wish to include in the navigation history and you’re done.  This module has been designed to be really easy to retrofit to existing solutions; deciding where to put the buttons on your layouts will probably be the most difficult part of the implementation!

There are now three versions:

  • BrowserNav for FileMaker 16 incorporates the following changes:
    1. Rewritten to use the new native JSON functions, BrowserNav now uses only a single global variable.
    2. The actual navigation now uses Layout Number rather than Layout Name to avoid issues when multiple layouts have the same name.
    3. Both single and multiple windows are supported, the latter with either individual or shared history.
  • BrowserNav Multiple Windows obviously added support for multiple windows for FileMaker pre version 16.
  • BrowserNav Single Windows is the original version for FileMaker pre version 16

All versions now have the option to turn off the saving of layouts to the history; this gives more control when running scripted processes that may move through several layouts.

To upgrade to BrowserNav for FileMaker 16, just replace the contents of the custom functions: BrowserNav.SaveNavHistory and BrowserNav.Tooltip.

Features

  • Very easy to retrofit to existing solutions
  • Works with scripted and native layout navigation
  • Back and forward buttons show tooltip of destination layout
  • Button arrows grey if no-where to go
  • History ignores layouts with no back and forward buttons (scripts going to developer layouts for example)
  • Toggle history saving with a global variable
  • No duplicate entries if the layout refreshed
  • Separate button and button text layout objects for easy customisation
  • Central customisation of Tooltips
  • Layout 1 now uses a FileMaker Button Bar for the navigation buttons (added 23.12.2015)

Dependencies

None.  I encourage you to use the version with the custom functions unless you do not have access to FileMaker Pro Advanced.  This allows the save history function and tooltips the be easily modified in one place even if the solution has a large number of layouts with the navigation buttons.  The latest change is a great example of this.  Adding the ability to toggle the saving of layouts requires only a change to the ‘Save’ custom function regardless of how many layouts the navigation has been added to.

License

Completely Free!

Download

The link to download the latest versions is….

BrowserNav Downloads

I do hope it’s useful.

 

What’s Next?

I am planning to add the option to include the the ability to return to the most recently viewed record with each entry in the history.  It seems that there are a number of possible scenarios so any and all input is welcome…