Brian Dunning's FileMaker Custom Functions

Search Results

17 functions found:

1.   AddTimes ( Time1 ; Time2 )
    Average rating: 4.7
  Bill Thurmes, MDCA
  Add two times, in h:mm:ss format, together
   
2.   Contains ( Text ; SearchStrings )
    Average rating: 4.4
  Bill Thurmes, MDCA
  Determine whether Text contains any of the strings contained in SearchStrings ('or' logic)
   
3.   ContainsAll ( Text ; SearchStrings )
    Average rating: 4.6
  Bill Thurmes, MDCA
  checks to see whether all values in SearchStrings are contained in Text
   
4.   ContainsAllExact ( Text ; SearchStrings )
    Average rating: 4.5
  Bill Thurmes, MDCA
  Checks whether all values in SearchStrings are exactly (capitalization) found in Text
   
5.   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
   
6.   DeleteValue ( VList ; VNo )
    Average rating: 4.7
  Bill Thurmes, MDCA
  Removes a value from a value list
   
7.   FullList ( Field ; NumberOfReps )
    Average rating: 4.7
  Bill Thurmes, MDCA
  FullList is like List, except that it includes repetitions that are empty or zero.
   
8.   PutValue ( ValueList ; ValueNumber ; ReplaceString )
    Average rating: 5.0
  Bill Thurmes, MDCA
  Replaces a designated value in a value list with another value
   
9.   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
   
10.   SubtractTimes ( Time1 ; Time2 )
    Average rating: 4.8
  Bill Thurmes, MDCA
  Subtract one time from another; both times in h:mm:ss format
   
11.   ValCorrelationCoeff ( XValueList; YValueList; Xmean; Ymean; XStdDev; YStdDev )
    Average rating: 4.5
  Bill Thurmes, MDCA
  calculates the correlation coefficient for a least-squares fit
   
12.   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
   
13.   ValStdDev( ValueList ; ArithMeanValue )
    Average rating: 4.4
  Bill Thurmes, MDCA
  Gives the standard deviation of a value List of numbers
   
14.   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
   
15.   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
   
16.   ValueMath ( List1 ; List2 ; operation )
    Average rating: 3.3
  Bill Thurmes, MDCA
  Do mathematical calculations on corresponding members of two value lists
   
17.   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 15 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: