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