Brian Dunning's FileMaker Custom Functions

Search Results

21 functions found:

1.   AddOrdinalSuperscript ( number )
  Average rating: 0.0
Paul, Peak 14 LLC
Adds a superscripted ordinal text to the passed number
 
2.   ExtractListSegment ( list ; divider ; SegmentNum )
  Average rating: 5.0
Paul, Peak 14 LLC
Use when you have a list that contains multiple values per list item and you only want a single value.
 
3.   FilterLayoutObjectNames ( searchString )
  Average rating: 0.0
Paul, Peak 14 LLC
Use to get a list of all object names on the current layout that contain the searchString
 
4.   FormatTimestamp ( theTimestamp; format )
  Average rating: 0.0
Paul, Peak 14 LLC
Formats a timestamp using the excel format method
 
5.   GetBaseTableName ( fieldOrTO )
  Average rating: 5.0
Paul, Peak 14 LLC
Gets the base table name (how it's listed in database management) from a field or table occurance
 
6.   GetCurrentTimeZoneUTCOffset ()
  Average rating: 0.0
Paul, Peak 14 LLC
Returns a number that is the current timezone's UTC offset
 
7.   GetDataFileID ( path )
  Average rating: 0.0
Paul, Peak 14 LLC
Returns the ID of the OPEN file with the passed path
 
8.   GetFrontPanels ( objectNameList )
  Average rating: 0.0
Paul, Peak 14 LLC
Use to find the name(s) of the current front panels. If objectNameList is null, will use all object names on layout
 
9.   GetIncrimentValue ( currentValue ; theList ; operator )
  Average rating: 0.0
Paul, Peak 14 LLC
Get the next value in a list based off the current value
 
10.   isField ( reference )
  Average rating: 5.0
Paul, Peak 14 LLC
Use to find out if a string is a reference to a field or not. Can be an actual field reference or just the same text as a field
 
11.   IterateThrough ( listOrArrayOrObject; thisVariableName; iterationVariableName )
  Average rating: 0.0
Paul, Peak 14 LLC
Iterates through a list, array or object
 
12.   JSONArrayAppendList ( json ; path ; appendList ; jsonType )
  Average rating: 5.0
Paul, Peak 14 LLC
Appends a list of values onto a JSON Array. Maintains existing null values
 
13.   ListMax ( theList )
  Average rating: 0.0
Paul, Peak 14 LLC
Finds the max value of a list
 
14.   PerformEquationOnList ( theList ; equation ; listItemKey ; errorReplace ; option)
  Average rating: 0.0
Paul, Peak 14 LLC
Performs a mathmatical calculation on each line item and returns the option
 
15.   Range ( start, stop, step )
  Average rating: 0.0
Paul, Peak 14 LLC
Returns a list of numbers given the parameters
 
16.   SetVariable ( varName ; varValue )
  Average rating: 0.0
Paul, Peak 14 LLC
Use when you want to set a variable with a variable name or not in a script.
 
17.   SQLGetColumn1Where ( returnField ; whereField ; whereValue; andSearch )
  Average rating: 0.0
Paul, Peak 14 LLC
Does a simple SQL Statement with where query(ies). If the whereField is left blank, will return all of the values in returnField
 
18.   SQLGetField ( field )
  Average rating: 0.0
Paul, Peak 14 LLC
Use to get the table name for SQL use from a field. Can use a reference as a field so it doesn't matter if the field or table name changes
 
19.   SQLGetTable ( field )
  Average rating: 0.0
Paul, Peak 14 LLC
Use to get the table name for SQL use from a field. Can use a reference as a field so it doesn't matter if the field or table name changes
 
20.   SumList ( theList )
  Average rating: 0.0
Paul, Peak 14 LLC
Sums a list. Normally this would be very quick and easy, but sometimes having null values can mess up what would otherwise be a very simple process.
 
21.   TimeRounder ( theTime; toTheNearest )
  Average rating: 0.0
Paul, Peak 14 LLC
Rounds the time to the nearest amount
 

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 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: