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 | |