Brian Dunning's FileMaker Custom Functions

Search Results

23 functions found:

1.   DateByDayOccur ( yearNum ; monthNum ; dayOfWeekNum ; dayOccurance )
    Average rating: 4.4
  Jonathan Mickelson
  Returns the date of a specific occurrence of a day of the week, for a given month and year. Ideal for holiday calculations.
   
2.   FieldRepetitionLast ( field ; maxRepetition )
    Average rating: 4.0
  Jonathan Mickelson
  Returns the highest non-empty repetition for a repeating field.
   
3.   FormatAsFileName ( text ; extension ; lengthLimit )
    Average rating: 4.4
  Jonathan Mickelson
  Simplifies concatenation of a data into a suitable length OS filename.
   
4.   GetNthRecordSet ( fieldName ; recordNumStart ; recordNumEnd )
    Average rating: 3.9
  Jonathan Mickelson
  Calculates a return delimited and sorted, values list from related, or local, field data.
   
5.   GetObjectNames ( nameOfFile ; nameOfLayout ; nameOfField )
    Average rating: 4.3
  Jonathan Mickelson
  Given a field name, search a specifc layout for it's object name(s).
   
6.   HolidayListByYear ( yearNumber )
    Average rating: 4.5
  Jonathan Mickelson
  Creates a list of holiday names and dates for a given year.
   
7.   HolidayNameByDate ( myDate )
    Average rating: 4.3
  Jonathan Mickelson
  Returns the Holiday Name matching a Date, i.e. for a calendar. A dynamic holiday list is built within for stand-alone operation.
   
8.   JSONFromFieldList ( json ; fieldNameList )
    Average rating: 5.0
  Jonathan Mickelson
  Builds a JSON Object {} or Array [] with each field listed as an element
   
9.   LayoutCalcHTML ( text )
    Average rating: 4.4
  Jonathan Mickelson
  Layout Calculations - Builds a complete web page as HTML source, to output the text in a Web Viewer
   
10.   NumberRange_Explode ( numberRangeText )
    Average rating: 4.4
  Jonathan Mickelson
  Receives a string of numbers separated by commas, hyphens, or any multiple or combination or both, and returns a return delimited list of all whole numbers within the input ranges
   
11.   numOrdinalSuffix ( number )
    Average rating: 4.6
  Jonathan Mickelson
  Returns the appropriate ordinal number suffix (-st, -nd, -rd, -th) for a supplied number. Thus, 12 would return a superscript
   
12.   RemoveByValueList ( text ; valueList )
    Average rating: 4.2
  Jonathan Mickelson
  Removes matching words from a text string, based upon words contained in a value list.
   
13.   TimeFormatAs ( theTime ; type12or24 )
    Average rating: 4.3
  Jonathan Mickelson
  Formats time data as 12 or 24 hour time at the data level, rather than field format display level. Especially useful for users that desire 12-hour formatted time data.
   
14.   TimeFormatAsText ( theTime )
    Average rating: 4.7
  Jonathan Mickelson
  Formats a valid time value to be written out in long form with the words for how many
   
15.   TimeRound ( theTime ; increment ; forceUpDn )
    Average rating: 4.2
  Jonathan Mickelson
  Rounds a time field by a time interval and allows optionally forcing the rounding up or down
   
16.   TimeStampsBetweenList ( startTimeStamp; endTimeStamp; increment )
    Average rating: 4.3
  Jonathan Mickelson
  Calculates all the timestamps between two start and end timestamps with the given incriment value.
   
17.   TimeZoneAdjustTime ( startTime ; startTimeZoneUTC ; desiredTimeZoneUTC )
    Average rating: 5.0
  Jonathan Mickelson
  Converts a time from one time zone to another
   
18.   VariableDestroyAll
    Average rating: 4.4
  Jonathan Mickelson
  When used in conjunction with
   
19.   VariableGlobalize ( LocalVariableName )
    Average rating: 4.2
  Jonathan Mickelson
  Changes the scope of a Local variable to a Global variable of the same name, with the same contents.
   
20.   VariableInitialize ( name ; initialValue )
    Average rating: 4.4
  Jonathan Mickelson
  Creates a Global, or Local, variable with the value specified AND logs it's instantiation to a centralized variable log
   
21.   VariableLocalize ( GlobalVariableName )
    Average rating: 4.0
  Jonathan Mickelson
  Changes the scope of a Global variable to a Local variable of the same name, with the same contents.
   
22.   WindowAlignCalc ( SEE ARGUMENTS BELOW IN DESCRIPTION )
    Average rating: 4.5
  Jonathan Mickelson
  Calculates window coordinates from a desired window size for easy placement relative to common FM application objects, including an active field for dynamic window orientation to the users cursor in a field.
   
23.   WorkDaysList ( dateStart ; numberOfDays ; daysOfWeek ; excludeDatesList )
    Average rating: 4.8
  Jonathan Mickelson
  Creates a return delimited list of matching dates, from a starting date, for a set number of days, for select
   

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.