Brian Dunning's FileMaker Custom Functions

Search Results

22 functions found:

1.   AddTimes ( Time1 ; Time2 )
  Average rating: 4.7
Bill Thurmes, MDCA
Add two times, in h:mm:ss format, together
 
2.   ComparativeValuePosition( VList ; Comparator ; Value )
  Average rating: 0.0
Bill Thurmes, MDCA
Quickly search for a comparative (>, <) number in an ascending number value list. Returns the value closest to the boundary that meets the criterea
 
3.   Contains ( Text ; SearchStrings )
  Average rating: 4.4
Bill Thurmes, MDCA
Determine whether Text contains any of the strings contained in SearchStrings ('or' logic)
 
4.   ContainsAll ( Text ; SearchStrings )
  Average rating: 4.6
Bill Thurmes, MDCA
checks to see whether all values in SearchStrings are contained in Text
 
5.   ContainsAllExact ( Text ; SearchStrings )
  Average rating: 4.5
Bill Thurmes, MDCA
Checks whether all values in SearchStrings are exactly (capitalization) found in Text
 
6.   ContainsExact ( Text ; SearchStrings )
  Average rating: 3.5
Bill Thurmes, MDCA
checks whether at least one of the values in SearchValues is an exact match for a portion of Text
 
7.   DeleteValue ( VList ; VNo )
  Average rating: 4.7
Bill Thurmes, MDCA
Removes a value from a value list
 
8.   FullList ( Field ; NumberOfReps )
  Average rating: 4.7
Bill Thurmes, MDCA
FullList is like List, except that it includes repetitions that are empty or zero.
 
9.   MaxListValue18 ( lst ; Type_1Text_2Numb_3Date_4Time_5TS )
  Average rating: 0.0
Bill Thurmes, MDCA
Determines the maximum value from a ¶-delimited value list, depending on data type, and requires FileMaker 18 or later
 
10.   MinListValue18 ( lst ; Type_1Text_2Numb_3Date_4Time_5TS )
  Average rating: 0.0
Bill Thurmes, MDCA
Determines the minimum value from a ¶-delimited value list, depending on data type, and requires FileMaker 18 or later
 
11.   PutValue ( ValueList ; ValueNumber ; ReplaceString )
  Average rating: 5.0
Bill Thurmes, MDCA
Replaces a designated value in a value list with another value
 
12.   PutValue18 ( ValueList ; ValueNumber ; ReplaceString )
  Average rating: 0.0
Bill Thurmes, MDCA
Replaces a designated value in a value list with another value
 
13.   SplitLists18 ( CompoundList ; Delimiter )
  Average rating: 0.0
Bill Thurmes, MDCA
Takes an array and moves rows to columns and columns to rows; breaks a typical EQSL result into columns
 
14.   SQLRefSimple ( FldRef ; Option1TO2Fld3Both )
  Average rating: 3.0
Bill Thurmes, MDCA
Makes it possible to refer indirectly to field and table occurrence names in SQL queries
 
15.   SubtractTimes ( Time1 ; Time2 )
  Average rating: 4.8
Bill Thurmes, MDCA
Subtract one time from another; both times in h:mm:ss format
 
16.   ValCorrelationCoeff ( XValueList; YValueList; Xmean; Ymean; XStdDev; YStdDev )
  Average rating: 4.5
Bill Thurmes, MDCA
calculates the correlation coefficient for a least-squares fit
 
17.   ValLeastSquaresSlope ( XValueList; YValueList; Xmean; Ymean )
  Average rating: 3.5
Bill Thurmes, MDCA
Calculates the slope of a set of X,Y pairs by least squares fit
 
18.   ValStdDev( ValueList ; ArithMeanValue )
  Average rating: 4.4
Bill Thurmes, MDCA
Gives the standard deviation of a value List of numbers
 
19.   ValStdDevS( ValueList ; ArithMeanValue )
  Average rating: 4.1
Bill Thurmes, MDCA
Gives the standard deviation of a sample, where the set of numbers are in a value list
 
20.   ValueArithmetic ( List1 ; List2 ; operation )
  Average rating: 5.0
Bill Thurmes, MDCA
Does basic arithmetic between two value lists, doing one operation (add, subtract, multiply, divide, raise) at a time
 
21.   ValueMath ( List1 ; List2 ; operation )
  Average rating: 3.3
Bill Thurmes, MDCA
Do mathematical calculations on corresponding members of two value lists
 
22.   ValueMean ( ValueList )
  Average rating: 4.7
Bill Thurmes, MDCA
Gives the mean / average of a value List of numbers
 

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: