Brian Dunning's FileMaker Custom Functions

Search Results

33 functions found:

1 .   AddRemoveItem( theList, value, AddRemoveAuto )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Allows you to Add or Remove an item from a list either automatically or directly (will not create duplicate items)
   
2 .   DateRange ( Range )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Creates a searchable date range to populate any date field while in Find Mode
   
3 .   FoundCt( pk_Field )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Looks up the table using the primary key field to determine how many records exist in that table
   
4 .   FoundSet_List ( field, isUniqueList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Create a List or a Unique List of values from one field from the found set of records.
   
5 .   GetAsFMTimestamp ( source )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts any date or timestamp (including Unix and UTC) to a valid FileMaker formatted timestamp
   
6 .   GetAsFMTimestamp_Offset( source; HrsOffset; Include_Seconds )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Similar to my other Function GetAsFMTimestamp, but provides 2 additional parameters
   
7 .   GetDuration ( tsStart, tsEnd, DurationType )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Calculates the duration between 2 timestamps in
   
8 .   GetFieldRepetitionCount ( FieldName )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Allows you to easily look up the maximum number for repetitions for a field
   
9 .   GetNumberListAsText ( numList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Used to convert a list of ids or numbers to a string of text
   
10 .   IsEven
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Is the number Even?
   
11 .   IsNumeric (text)
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Is the string numeric? (is it a number?)
   
12 .   IsValidJSON( JSON )
    Average rating: 5.0
  Kyle Williams, Dreamclinic Massage
  Used to determine if we are passing valid JSON
   
13 .   JSON.GetValueLists ( isVirtualList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  This creates JSON that can be used to look up an id or JSON designed to populate a Virtual List
   
14 .   JSON.List_Layouts
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Creates a List of all Layouts and Layout IDs in JSON format
   
15 .   JSON.List_Tables
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Lists all Table information in JSON format
   
16 .   JSON.PrependArray( JSON )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  This will add a new item to the beginning of a JSONArray
   
17 .   JSON.stringify
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts JSON to a string of text
   
18 .   JSONCountKeys ( JSON )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Counts the Keys in your JSON to provide a Found Count.
   
19 .   JSONFormat( JSON )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Formats JSON and eliminates BOM (invisible) characters
   
20 .   JSONGetElementsAsVariables ( JSON; Globals; Prefix )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts JSON to Variables or Global Variables (Supports JSON sub arrays)
   
21 .   JSONMergeListOfArrays ( ListOfArrays )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  This allows you to use a summary List or use List( table::name ) to look at a JSON array for several single records and merge them into one.
   
22 .   LeadingZeros( value, numDigits )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts any number into a string and pads the number with leading zeros until the number of required digits is achieved.
   
23 .   MatchFirstName ( Name1, Name2, ShowMatchList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Used to help match/merge duplicate client entries (should always try matching with email/phone/birthdate first)
   
24 .   MatchFirstName_Multi ( Name1, Name2, ShowMatchList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Match Multiple first names.
   
25 .   NextDateRange ( StartDate ; TimePeriod ; WholePeriod ; FindPrevious )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Generate Date Ranges for Creating Daily, Weekly, Monthly, or Yearly Reports
   
26 .   PhoneFormat (Phone)
    Average rating: 4.1
  Kyle Williams, Dreamclinic Massage
  (A simplified version of phone.format)
   
27 .   PhoneFormatList ( PhoneList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Formats all of the phone numbers in a list of phone numbers
   
28 .   SpellNumber ( Amt )
    Average rating: 4.0
  Kyle Williams, Dreamclinic Massage
  Converts Currency into Text (does not require any other functions)
   
29 .   sqlF( field )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts a field reference to a valid ExecuteSQL field reference
   
30 .   sqlT( field )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts table name into quoted text of the table name
   
31 .   _GetAsBoolean ( value )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts common boolean text entries in addition to numbers to 1 or 0
   
32 .   _GetAsTimestamp ( tsDate, tsTime )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Use this to merge a Date and a Time into one timestamp
   
33 .   _UniqueValues( _list )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Creates a list of unique values without the trailing return carriage...
   

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 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: