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: