Brian Dunning's FileMaker Custom Functions

Search Results

27 functions found:

1.   AssignWindowName ( Text )
    Average rating: 4.8
  Koji Takeuchi, TonicNote, Inc.
  Add " - num" to Text when the Text is not unique in WindowNames.
   
2.   Commas ( Number ; Digit )
    Average rating: 4.7
  Koji Takeuchi, TonicNote, Inc.
  Insert commas into numbers.
   
3.   ConditionalSummary ( TypeField ; Type ; SumField )
    Average rating: 4.5
  Koji Takeuchi, TonicNote, Inc.
  Sum a SumField for records where TypeField matches
   
4.   CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp )
    Average rating: 3.0
  Koji Takeuchi, TonicNote, Inc.
  List every table names of current file followed by count of records which modified within StartTimestamp and EndTimestamp.
   
5.   DateByNthDOW ( tYear ; tMonth ; tDayOfWeek ; tNum )
    Average rating: 4.2
  Koji Takeuchi, TonicNote, Inc.
  Pick Nth day of week in specified year and month.
   
6.   ErrorJP_11 ( ErrorCode )
    Average rating: 4.6
  Koji Takeuchi, TonicNote, Inc.
  Return Description of specified Error Code of FMP11 in Japanese.
   
7.   EvalCalcInserts ( Text )
    Average rating: 3.9
  Koji Takeuchi, TonicNote, Inc.
  Replace "Calc" to value of Calc Evaluated.
   
8.   FindValues ( Values ; Pattern )
    Average rating: 4.4
  Koji Takeuchi, TonicNote, Inc.
  Return values including Pattern.
   
9.   GeneratePW ( Digit ; Option )
    Average rating: 4.5
  Koji Takeuchi, TonicNote, Inc.
  Generate random password string.
   
10.   GetFrontPanels
    Average rating: 4.1
  Koji Takeuchi, TonicNote, Inc.
  Return object name(s) of every frontmost panel(s) on current layout.
   
11.   GetSourceFileName ( NameTableOccurrence )
    Average rating: 4.1
  Koji Takeuchi, TonicNote, Inc.
  Return source file name by table occurrence name.
   
12.   ListColumnValue ( Value ; NumberOfColumn ; ColumnSeparator ; RowSeparator )
    Average rating: 4.7
  Koji Takeuchi, TonicNote, Inc.
  Get return-separated value of specified column in Value. Like List function for multi-column array.
   
13.   ListValues ( Field )
    Average rating: 4.2
  Koji Takeuchi, TonicNote, Inc.
  Return return separated value of Field data in current found set.
   
14.   MatchValues ( Values ; Pattern ; StartsOrEndsOrPartialOrExact )
    Average rating: 5.0
  Koji Takeuchi, TonicNote, Inc.
  Return values by matching Pattern with option (Starts with, Ends with, Partial, Exact).
   
15.   MilliTimestamp ( OffsetTimeFromUTC )
    Average rating: 4.6
  Koji Takeuchi, TonicNote, Inc.
  Get Timestamp data with milli-seconds.
   
16.   NthDOWbyDate ( tDate )
    Average rating: 4.7
  Koji Takeuchi, TonicNote, Inc.
  Pick Nth day of week in month of specified date.
   
17.   PickTag ( Text ; Prefix ; Suffix )
    Average rating: 4.7
  Koji Takeuchi, TonicNote, Inc.
  Pick strings between Prefix and Suffix with Prefix and Suffix itself.
   
18.   PickTagContent ( Text ; Prefix ; Suffix )
    Average rating: 4.6
  Koji Takeuchi, TonicNote, Inc.
  Pick strings between Prefix and Suffix without Prefix and Suffix itself.
   
19.   PositionValues ( Text ; Value )
    Average rating: 4.6
  Koji Takeuchi, TonicNote, Inc.
  Return value number of Value in Text.
   
20.   QuoteTOName ( Field )
    Average rating: 4.7
  Koji Takeuchi, TonicNote, Inc.
  Pick TO name from FQFN and quote it for ExecuteSQL function.
   
21.   RemoveEmptyValues ( Text )
    Average rating: 4.5
  Koji Takeuchi, TonicNote, Inc.
  Remove empty lines of return-seperated text.
   
22.   RemoveValue ( Values ; ValuesToRemove )
    Average rating: 4.4
  Koji Takeuchi, TonicNote, Inc.
  Opposite version of FilterValues ().
   
23.   RepeatValue ( Text ; NumRepeat )
    Average rating: 4.5
  Koji Takeuchi, TonicNote, Inc.
  Return return separated text of "Text" repeated "NumRepeat" times.
   
24.   ReplaceOnMultipleValues ( Value ; Start ; NumberOfCharacters ; ReplacementText )
    Average rating: 4.0
  Koji Takeuchi, TonicNote, Inc.
  Execute "Replace ()" function on each line of multiple lines.
   
25.   SetVariable ( Variable ; Value )
    Average rating: 4.8
  Koji Takeuchi, TonicNote, Inc.
  Set local ( when you use in script step ) or global variable, conditionally.
   
26.   SortValue ( Value ; AscDes )
    Average rating: 4.0
  Koji Takeuchi, TonicNote, Inc.
  Sort return-separated text.
   
27.   SQLFieldName ( Field )
    Average rating: 4.4
  Koji Takeuchi, TonicNote, Inc.
  This function is like GetFieldName () for ExecuteSQL function. Make FQFN quoted and dot separated for ExecuteSQL function.
   

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:

Under construction. Email me your wish list for improvements.