Brian Dunning's FileMaker Custom Functions

Search Results

24 functions found:

1.   CheckReservedSQL ( keyword )
  Average rating: 0.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.
 
2.   colorContrast ( color )
  Average rating: 0.0
Jonni™
Returns a 0 for dark and 1 for bright
 
3.   coloris ( defaultColour ; swatches ; targetScript )
  Average rating: 0.0
Jonni™
Returns html and javascript for coloris colour picker to be rendered in a webviewer.
 
4.   coloris.js
  Average rating: 0.0
Jonni™
javaScript functions for coloris custom function
 
5.   colorTint ( color ; tint ; output )
  Average rating: 0.0
Jonni™
Returns a colour tint of given hex colour
 
6.   containerAttributesAsJSON ( container ; attributeName )
  Average rating: 0.0
Jonni™
Returns container attributes as JSON array with added filetype if file has file extension
 
7.   convertWeight ( value ; input ; output ; precision ; separator )
  Average rating: 0.0
Jonni™
Converts input of weight to grams, ounces or pounds
 
8.   distanceToTarget ( targetLat ; targetLng ; startLat ; startLng )
  Average rating: 5.0
Jonni™
Returns distance between two sets of gps coordinates in metres.
 
9.   doOnOrientationChange ( fmScript )
  Average rating: 0.0
Jonni™
Triggers a designated FileMaker Script upon device orientation change
 
10.   fullTableSQLasJSON ( tablename ; condition )
  Average rating: 0.0
Jonni™
Performs SQL query on designated table and returns response wrapped as JSON.
 
11.   getObjectLeftPosition ( object ; offset )
  Average rating: 0.0
Jonni™
Returns objects left position on Layout
 
12.   getObjectTopPosition ( object ; offset )
  Average rating: 0.0
Jonni™
Returns objects left position on Layout
 
13.   isUUID ( uuidString )
  Average rating: 1.0
Jonni™
Test if input string is a uuid
 
14.   JSON.eSQL ( field ; modifier ; table ; join ; condition ; group ; order )
  Average rating: 0.0
Jonni™
Returns ExecuteSQL as a JSON in FileMaker Data API structure
 
15.   JSON.MakeArrayObject ( ValueList ; Separator )
  Average rating: 0.0
Jonni™
Simple function that wraps a list of values in an array object.
 
16.   JSON.URLParameters ( JSONpayload )
  Average rating: 0.0
Jonni™
Returns JSON as url parameters
 
17.   listWeekDays ( startsOnSunday ; dayLength )
  Average rating: 0.0
Jonni™
Returns a list of weekday names in language (locale) set by operating system
 
18.   locationJSON ( accuracy ; timeout )
  Average rating: 0.0
Jonni™
Returns response from Location function as JSON instead of return delimited text
 
19.   locationValuesJSON ( accuracy ; timeout )
  Average rating: 0.0
Jonni™
Returns response from LocationValues function as JSON instead of return delimited text
 
20.   passwordGenerate ( pwLength )
  Average rating: 0.0
Jonni™
This function generates a random password that includes uppercase letters, lowercase letters, digits, and special characters, ensuring diversity and security.
 
21.   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”).
 
22.   roundToNumberInList ( target ; array ; operator )
  Average rating: 0.0
Jonni™
Round a target value to nearest number in given list
 
23.   SQLasJSON ( tablename ; fields ; condition )
  Average rating: 0.0
Jonni™
Performs SQL query on designated table and returns response from declared fields wrapped as JSON.
 
24.   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: