Brian Dunning's FileMaker Custom Functions

Search Results

35 functions found:

1.   badgeStack ( width ; height ; defaultArray ; badgeArray )
  Average rating: 0.0
Jonni™
Generates overlapping circular badges with custom text and styles from JSON, rendered in SVG for display in a FileMaker Web Viewer.
 
2.   chartColumnStacks ( width ; height ; defaultArray ; dataArray )
  Average rating: 0.0
Jonni™
Draws stacked vertical columns based on range and value input using SVG. Customisable with JSON for appearance, padding, stroke, and alignment.
 
3.   chartDoughnut ( width ; height ; defaultArray ; dataArray )
  Average rating: 0.0
Jonni™
Displays a multi-segment doughnut chart using SVG, with support for custom colours, stroke width, segment padding, and end caps.
 
4.   chartRowStacks ( width ; height ; defaultArray ; dataArray )
  Average rating: 0.0
Jonni™
// Draws stacked horizontal rows based on range and value input using SVG. Customisable with JSON for appearance, padding, stroke, and alignment.
 
5.   CheckReservedSQL ( keyword )
  Average rating: 5.0
Jonni™
This function checks if a given keyword is an SQL reserved word or contains invalid characters, returning either an “OK” message or a warning.
 
6.   colorContrast ( color )
  Average rating: 0.0
Jonni™
Returns a 0 for dark and 1 for bright
 
7.   coloris ( defaultColour ; swatches ; targetScript )
  Average rating: 0.0
Jonni™
Returns html and javascript for coloris colour picker to be rendered in a webviewer.
 
8.   coloris.js
  Average rating: 0.0
Jonni™
javaScript functions for coloris custom function
 
9.   colorTint ( color ; tint ; output )
  Average rating: 0.0
Jonni™
Returns a colour tint of given hex colour
 
10.   containerAttributesAsJSON ( container ; attributeName )
  Average rating: 0.0
Jonni™
Returns container attributes as JSON array with added filetype if file has file extension
 
11.   convertWeight ( value ; input ; output ; precision ; separator )
  Average rating: 0.0
Jonni™
Converts input of weight to grams, ounces or pounds
 
12.   distanceToTarget ( targetLat ; targetLng ; startLat ; startLng )
  Average rating: 5.0
Jonni™
Returns distance between two sets of gps coordinates in metres.
 
13.   doOnOrientationChange ( fmScript )
  Average rating: 0.0
Jonni™
Triggers a designated FileMaker Script upon device orientation change
 
14.   fullTableSQLasJSON ( tablename ; condition )
  Average rating: 0.0
Jonni™
Performs SQL query on designated table and returns response wrapped as JSON.
 
15.   getObjectLeftPosition ( object ; offset )
  Average rating: 0.0
Jonni™
Returns objects left position on Layout
 
16.   getObjectTopPosition ( object ; offset )
  Average rating: 0.0
Jonni™
Returns objects left position on Layout
 
17.   isUUID ( uuidString )
  Average rating: 1.0
Jonni™
Test if input string is a uuid
 
18.   JSON.eSQL ( field ; modifier ; table ; join ; condition ; group ; order )
  Average rating: 0.0
Jonni™
Returns ExecuteSQL as a JSON in FileMaker Data API structure
 
19.   JSON.MakeArrayObject ( ValueList ; Separator )
  Average rating: 0.0
Jonni™
Simple function that wraps a list of values in an array object.
 
20.   JSON.URLParameters ( JSONpayload )
  Average rating: 0.0
Jonni™
Returns JSON as url parameters
 
21.   LastSaturdaysInRange ( startDate ; endDate )
  Average rating: 0.0
Jonni™
Returns a return-separated list of FileMaker-formatted dates representing the last Saturday of each month between the start and end dates.
 
22.   LastSaturdaysInRangeSQL ( startDate ; endDate )
  Average rating: 0.0
Jonni™
Returns a comma-separated list of SQL-formatted dates representing the last Saturday of each month between the start and end dates.
 
23.   listWeekDays ( startsOnSunday ; dayLength )
  Average rating: 0.0
Jonni™
Returns a list of weekday names in language (locale) set by operating system
 
24.   locationJSON ( accuracy ; timeout )
  Average rating: 0.0
Jonni™
Returns response from Location function as JSON instead of return delimited text
 
25.   locationValuesJSON ( accuracy ; timeout )
  Average rating: 0.0
Jonni™
Returns response from LocationValues function as JSON instead of return delimited text
 
26.   passwordGenerate ( pwLength )
  Average rating: 5.0
Jonni™
This function generates a random password that includes uppercase letters, lowercase letters, digits, and special characters, ensuring diversity and security.
 
27.   passwordStrength ( password )
  Average rating: 0.0
Jonni™
This function evaluates the strength of a password based on various characteristics and assigns a strength level (“Weak,” “Medium,” “Strong,” or “Very Strong”).
 
28.   pillCloud ( width ; height ; defaultArray ; pillArray )
  Average rating: 0.0
Jonni™
Generates a responsive SVG-based group of pill-shaped chips from a JSON configuration, suitable for use in a Web Viewer.
 
29.   progressBarSingle ( width ; height ; radius ; colorBackground ; colorFilled ; pctFilled )
  Average rating: 0.0
Jonni™
Generates a horizontal progress bar based on a single percentage value, using two custom colours to indicate completed and remaining progress.
 
30.   progressBarStacked ( width ; height ; radius ; backgroundColor ; segmentArray )
  Average rating: 0.0
Jonni™
Creates a horizontal progress bar composed of multiple coloured segments, defined by a JSON input with individual percentage values.
 
31.   progressDoughNut ( width ; height ; defaultArray ; dataArray )
  Average rating: 0.0
Jonni™
Generates a customisable, rounded progress doughnut using SVG for display in a FileMaker Web Viewer.
 
32.   progressRings ( width ; height ; defaultArray ; dataArray )
  Average rating: 0.0
Jonni™
Draws a multi-ring SVG progress doughnut using customisable ring data.
 
33.   roundToNumberInList ( target ; array ; operator )
  Average rating: 0.0
Jonni™
Round a target value to nearest number in given list
 
34.   SQLasJSON ( tablename ; fields ; condition )
  Average rating: 0.0
Jonni™
Performs SQL query on designated table and returns response from declared fields wrapped as JSON.
 
35.   URLParameters.JSON ( payload )
  Average rating: 0.0
Jonni™
Returns url parameter format as JSON
 

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: