Brian Dunning's FileMaker Custom Functions

Search Results

26 functions found:

1.   DateRange ( Range )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Creates a searchable date range to populate any date field while in Find Mode
   
2.   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
   
3.   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.
   
4.   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
   
5.   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
   
6.   GetDuration ( tsStart, tsEnd, DurationType )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Calculates the duration between 2 timestamps in
   
7.   GetNumberListAsText ( numList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Used to convert a list of ids or numbers to a string of text
   
8.   IsEven
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Is the number Even?
   
9.   IsNumeric (text)
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Is the string numeric? (is it a number?)
   
10.   IsValidJSON( JSON )
    Average rating: 5.0
  Kyle Williams, Dreamclinic Massage
  Used to determine if we are passing valid JSON
   
11.   JSON.List_Layouts
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Creates a List of all Layouts and Layout IDs in JSON format
   
12.   JSON.List_Tables
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Lists all Table information in JSON format
   
13.   JSON.PrependArray( JSON )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  This will add a new item to the beginning of a JSONArray
   
14.   JSON.stringify
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts JSON to a string of text
   
15.   JSONFormat( JSON )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Formats JSON and eliminates BOM (invisible) characters
   
16.   JSONGetElementsAsVariables ( JSON; Globals; Prefix )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts JSON to Variables or Global Variables (Supports JSON sub arrays)
   
17.   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)
   
18.   MatchFirstName_Multi ( Name1, Name2, ShowMatchList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Match Multiple first names.
   
19.   NextDateRange ( StartDate ; TimePeriod ; WholePeriod ; FindPrevious )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Generate Date Ranges for Creating Daily, Weekly, Monthly, or Yearly Reports
   
20.   PhoneFormat (Phone)
    Average rating: 4.1
  Kyle Williams, Dreamclinic Massage
  (A simplified version of phone.format)
   
21.   PhoneFormatList ( PhoneList )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Formats all of the phone numbers in a list of phone numbers
   
22.   SpellNumber ( Amt )
    Average rating: 4.0
  Kyle Williams, Dreamclinic Massage
  Converts Currency into Text (does not require any other functions)
   
23.   sqlF( field )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts a field reference to a valid ExecuteSQL field reference
   
24.   sqlT( field )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts table name into quoted text of the table name
   
25.   _GetAsBoolean ( value )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Converts common boolean text entries in addition to numbers to 1 or 0
   
26.   _GetAsTimestamp ( tsDate, tsTime )
    Average rating: 0.0
  Kyle Williams, Dreamclinic Massage
  Use this to merge a Date and a Time into one timestamp
   

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: