Brian Dunning's FileMaker Custom Functions

Search Results

12 functions found:

1.   AddressBlock ( com ; cont ; a1 ; a2 ; a3 ; a4 ; c %3
    Average rating: 3.9
  Steve Gerow, Abrazos Data Consulting
  Calculated Address block from separate fields - handles missing elements
   
2.   AmtCompounded_cf ( principal ; rate ; iterations )
    Average rating: 4.2
  Steve Gerow, Abrazos Data Consulting
  Calculates compounded amount from principal, interest and number of iterations.
   
3.   DateDueHolidays ( StartDate ; TransitDays ; HolidayList )
    Average rating: 4.7
  Steve Gerow, Abrazos Data Consulting
  Due date from Start Date plus intervening days, adding Holidays from user-entered table
   
4.   DateHolidayFlag ( datefield )
    Average rating: 4.6
  Steve Gerow, Abrazos Data Consulting
  Holiday Weekend conditional formatting calc for date field
   
5.   DatePlusMinus ( datefield ; internal param )
    Average rating: 4.6
  Steve Gerow, Abrazos Data Consulting
  Enters current date, subtracts a day or adds a day
   
6.   DateShipByHolidays ( DueDate ; TransitDays ; HolidayList )
    Average rating: 4.4
  Steve Gerow, Abrazos Data Consulting
  Similar to ShipByDate but includes user-entered holidays from a table.
   
7.   ForceZero ( NumExpression )
    Average rating: 4.4
  Steve Gerow, Abrazos Data Consulting
  Forces a number calc field to display zero if is empty
   
8.   gsp
    Average rating: 4.4
  Steve Gerow, Abrazos Data Consulting
  Using shorthand for common functions
   
9.   NextLetter ( MyNum )
    Average rating: 4.3
  Steve Gerow, Abrazos Data Consulting
  Increments letter sequence A - Z.
   
10.   TimeEasy ( mytime ; transtime )
    Average rating: 4.6
  Steve Gerow, Abrazos Data Consulting
  Time auto-formatting with assumed AM & PM during normal working hours. Allows input of abbreviated numbers, i.e. 7 for 7:00 AM and 3 for 3:00 PM. Allows override by use of one letter, for instance 10p for 10:00 PM.
   
11.   ToggleField ( myField ; value )
    Average rating: 4.4
  Steve Gerow, Abrazos Data Consulting
  Alternately sets and clears a field
   
12.   ToggleFlag_cf ( myfield ; myVL ; pos ; neg )
    Average rating: 4.6
  Steve Gerow, Abrazos Data Consulting
  Toggles between All and Clear for setting checkbox sets
   

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: