Software Venture Consulting
ToMarket

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

1578 Custom Functions Found...

1. BuildRSSFeed( rssTitle ; rssPubDate ; IDLink ; rssLink ; rssDescription ; rssXMLurl ; rssEnclosure )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com
  The easiest way to build RSS Feeds
   
2. BuildRSSFeedLib ( SubstitionCode )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com
  XML coding used by BuildRSSFeed
   
3. MaskPassword(Text; ReplacementChar), CountPassword(Text; ReplacementChar)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Priyabrata Sahoo, Mindfire Solutions
http://mindfiresolutions.com
  Custom function to encrypt or masking a password field inputs in Filemaker.
   
4. #AlAradan( #metin ; #aranan1 ; #aranan2)
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Kadir Kaleli, Yordam
http://www.yordam.com
  cümleden parça alma ; getting piece from text
   
5. #NthDayOfWeek ( MyDate )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Mehmet KAYA, Beyaz Bilgisayar
http://www.filemakerturk.com
  NthDayOfWeek returns the occurence of the weekday of AValue in the month. // Ceiling ( Day ( date ) / 7 )
   
6. #ParcaEle ( #metin ; #aranan )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Kadir Kaleli, Yordam
http://www.yordam.com
  Aranan jokerli parçayi yoket ; Replace string with wildcard
   
7. #TL ( #rakam )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Kadir Kaleli, Yordam
http://www.yordam.com
  To translate a number into text.
   
8. @PowerMod ( BASE ; EXPONENT ; MODULUS ; RESULT )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Alexander Zueiv, N/A
N/A
  Up to 1024-bit RSA encryption
   
9. ƒilter ( text ; AZazƒ09etc )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Thomas Seidler, The Good Book Company
http://www.harmlesswise.com/it
  FilterC built to handle foreign characters (and a bit more)
   
10. ฺBookRentalCal ( BookingStart; 1.5)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Watchara Yarnu,
http://www.giggogchang.wordpress.com
  Book Rental Calculation
   
11. AbbreviateText ( text )
 
RatingRatingRatingRatingRating
  Average rating: 2.5
  François Goulet,
  Returns the first letter of each word in a text (in upper case), each seperated by a period and a space. See also the
   
12. AbbreviateTextCustom ( text ; spaces; hyphens ; periods )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  François Goulet,
  Returns acronyms or initials.
   
13. AbbrMonthName(monthNumber)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Mike Beargie, Anvil Dataworks
http://www.anvildataworks.com
  Return Abbreviated Month Name from Month Number
   
14. Abscind ( text ; margin )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Ray Cologon, NightWing Enterprises
http://www.nightwing.com.au/FileMaker
  Adds or repositions line breaks in supplied text so it wraps to specified margins.
   
15. AbsolutePaddingZeroes( number; digits )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.gudthlandum.no
  Pads a number to have static length of digits
   
16. Academic ( theDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Matt Wills, Virtual Vermont
http://www.virtualvermont.com/FMP/
  Returns the academic season of a given date.
   
17. Accordion( NumberedList; selectedGroup; showNumbers )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Bruce Robertson, Concise Design
http://concise-design.com
  Given a numbered list and a selected group number, collapse all items in unselected group.
   
18. Acos ( number )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Brian Dunning, BrianDunning.com
http://www.briandunning.com/
  Returns the arc cosine of a given number.
   
19. Acronym ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Ray Cologon, NightWing Enterprises
http://www.nightwing.com.au/FileMaker
  Returns the first letter of each word in phrase (in upper case).
   
20. ActualLineCount ( Text ; CharsPerLine )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/
  Determine if text is overflowing field bounds on layout.
   
21. AddComma ( number ; digits )
 
RatingRatingRatingRatingRating
  Average rating: 1.0
  Shingo Fukasawa, Kotobuki Shoukai
http://kotovuki.co.jp/
  Put a comma in the specified number of digits.
   
22. AddConstantToListValues ( theList ; theConstant )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Simon Plint, Thanks For The Memories
http://www.thanks.com.au
  Concatenate each value in a list with constant piece of text.
   
23. AddConstantToString( string; fillchar; posit ; direction; iter)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Martti Tumanto, Martinova Oy
http://www,martinova.fi
  Adds a constant string to very Nth position of a string
   
24. AddDays ( theDate; DaysToAdd )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Andrew Sasaki, n/a
n/a
  Given a date and a number of days, returns the date that many days later.
   
25. AddDollarFormat ( Number )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Jeremiah Small, Soliant Consulting
http://jsmall.us
  Turn unformatted number into dollars with commas rounded to nearest penny.
   
26. AddEllipsis ( theText ; theLength )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Simon Plint, Thanks For The Memories
http://thanks.com.au
  Truncates theText if longer than theLength and adds ...
   
27. AddPrefixSuffixToList ( theList ; prefix ; suffix )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com
  add a prefix or suffix to each line in a list
   
28. AddProperty ( propertyList ; propertyName ; propertyValue )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Shaun Flisakowski, spf-15
http://www.spf-15.com/
  Add a new name/value pair to an existing property list
   
29. AddRemove ( value ; content )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Matt Petrowsky, ISO Productions, Inc.
http://www.filemakermagazine.com
  A custom function which allows simple addition or extraction of values from a list.
   
30. AddRemoveListItem ( theList ; value )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  David Head, uLearnIT
http://www.ulearnit.com.au/
  Add a value to or remove an values from a list of values
   
31. AddRemoveListItems( theList; thevalues )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Bruce Robertson, Concise Design
http://concise-design.com
  Add or remove item from list, also remove empty lines
   
32. AddressBlock ( com ; cont ; a1 ; a2 ; a3 ; a4 ; c %3
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com
  Calculated Address block from separate fields - handles missing elements
   
33. AddressLabel ( Name ; Address ; City ; State ; ZIP ; Country )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au
  Address Labels - slide-up missing text in an address label
   
34. AddTextRight ( text ; number ; addedtext )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Drew Boone, Doulos Ministries, Inc.
http://www.douloscorp.com
  Adds text to the right of a specified string the specified number of times
   
35. AddTimes ( Time1 ; Time2 )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Bill Thurmes, Miyota Development Center of America
http://sorry, none
  Add two times, in h:mm:ss format, together
   
36. After ( text ; searchString ; occurrence ; include_1 )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  extracts text after search string
   
37. Age ( Birth; theDate; Format )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Geoff Wells, DataIsland Software LLC
http://www.dataisland.com
  Calculates Age in three formats
   
38. AGE ( BirthDate )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  meddved, meddved
www.meddved.bg
  Calculate the correct Age :)
   
39. age ( birthday )
 
RatingRatingRatingRatingRating
  Average rating: 2.7
  Bailey Kessing, NCI-Frederick
http://kessing.com
  calculates the correct age
   
40. Age ( birthday; today; Format )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Kevin Kurpe, Proponent
www.YourProponent.com
  This calculation determines a person's age based upon their birthday and a given date.
   
41. Age ( date )
 
RatingRatingRatingRatingRating
  Average rating: 2.6
  Rob Mertens, Alkulux BV
http://www.alkuplus.nl
  Simple but eefective calculation of years since a certain date
   
42. age ( date1 ; date2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Winfried Huslik, Huslik Verlag GmbH
http://fmdiff.com
  Calculates the number of years, months, and days between any two dates
   
43. Age ( DOB )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Chris Stasny, EducatorsInc
http://EducatorsInc.com
  Converts date of birth to an age in years
   
44. AgeCalculation( Date( 4 ; 12 ; 1980 ) ;
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Watchara Yarnu,
http://www.giggogchang.wordpress.com
  Calculates how old a person or a thing was, is, or will be on a user-defined date, based on the date of birth of the person or thing.
   
45. All ( relatedField ; rFieldCount ; soughtValue )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Edwin M. Hopkins, personal, not part of any company
do not have a web site
  Permits evaluation of portal contents to determine if all related records contain the desired value
   
46. AllCombinations (theString)
 
RatingRatingRatingRatingRating
  Average rating: 2.0
  Michael Kupietz, Michael Kupietz FileMaker Consulting
http://www.kupietz.com
  Lists all possible combinations of one or more characters contained in a string
   
47. AllFields ( start )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Daniele Raybaudi, ACI
www.aci.it
  Returns the content of all the fields of a layout
   
48. AllMonthNames ( startMonthNumber )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Daniele Raybaudi, ACI
www.aci.it
  Returns all the month's names from a given month number
   
49. AllTextCombinations ( theText ; stackDepth )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Jeremy Bante, OshVay Systems, Inc.
http://www.oshvay.com
  recursively subsets a text string into [almost] all possible subsets, return delimited, debatably suitable for multi-line key foreign side of Portal search relationships
   
50. AllTextCombinations(theText)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Peter Gort, Denbigh International
http://www.denbigh.com.au
  recursively subsets a text string into all possible subsets, return delimited, suitable for multikey right side of Portal search relationships
   
51. AllWordCombinations (theWords)
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Michael Kupietz, Michael Kupietz FileMaker Consulting
http://www.kupietz.com
  List all possible subsets from a string of words
   
52. Alpha2Int ( Alpha )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  JT Hughes, Queuedom
http://notapplicable.com
  Converts Alpha string to its integral equivalent
   
53. alterDate ( entryDate ; m ; d ; y )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  John Knight, dB SPL
http://www.filemaker.com
  Can be used to change any or all of the month, day and/or year by adding/subtracting simple values, calculations, number/calc fields, or by substitution.
   
54. AmbiguousDate( Text )
 
RatingRatingRatingRatingRating
  Average rating: 2.7
  Lewis Buckingham, None
none
  Returns an approximate date for unspecific date input
   
55. Amortization_CFpub ( principal ; interest ; periods ; payment; term ; currency)
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  James Hea, James Hea
http://www.jameshea.com
  Produces the principal remaining at the end of a fixed rate amortization period.
   
56. Amount2CSV ( amount )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Martin Spanjaard, Trias Digitaal
http://www.triasdigitaal.nl
  Formats an amount in csv format
   
57. AmtCompounded_cf ( principal ; rate ; iterations )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com
  Calculates compounded amount from principal, interest and number of iterations.
   
58. AnnuallySerial ( AEfield ; digit )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Daniele Raybaudi, ACI
www.aci.it
  Autoenter a serial number that increments annually
   
59. antiFilter (textToFilter ; filterAllow ; filterSubChar ; start ; stop ; textBuilt )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Michael Rauch, ShopWorks
http://www.shopworx.com
  replace any character not specified in the allowed list with the substitute character
   
60. AntiFilterValues( ListA; ListB )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Bruce Robertson, Concise Design
http://concise-design.com
  Return values only contained in ListA
   
61. Any ( relatedField ; rFieldCount ; soughtValue )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Edwin M. Hopkins, personal, not part of any company
do not have a web site
  Permits evaluation of portal contents for any occurrence of desired value
   
62. AnyBaseToDec(number; base)
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Ferry, NCOI
http://www.ncoi.nl
  Converts any base to decimal (max 32 base)
   
63. ApplescriptGetURL ( URLtoGet ; FieldtoSet )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Jim Main, Main Solutions
http://www.mainsolutions.org
  Getting a web page via Applescript
   
64. AppleScript_Choose_Color ( result_field ; format )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Thomas Siebert, Thomas Siebert
http://www.t-seabird.de
  Opens the Apple color chooser to choose a color and return the rgb or HEX results to a FileMaker field
   
65. AppleScript_Choose_from_List ( myList ; window_title ; message ; allow_multiple ; allow_empty ; default_items ; OK_button_name ; result_field )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Thomas Siebert, Seabird
http://www.t-seabird.de
  creates a dialog with a chooser list to choose one or multiple items
   
66. APPLESCRIPT_CTI_Dialing_TipTel ( pPhoneNumberFieldname )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Ralph Nusser, Sogetes Fileker-Services
http://www.sogetes.com
  Dial phone number of TipTel phone connected by USB to Mac
   
67. AppleScript_Dialog ( Text; Button1; Button2; Button3 ; window_title ; giving_up_after; default_answer; hidden_answer; default_button; cancel_button; caution; result_field )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Thomas Siebert, Thomas Siebert
http://www.t-seabird.de
  Generates an dialog box with a number of options
   
68. AppleScript_Fontlist ( result_field )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Thomas Siebert, Thomas Siebert
http://www.t-seabird.de
  Returns a list of fontnames compatible to FileMaker Pro using the "FontBook" application.
   
69. AppleScript_set_clipboard ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Thomas Siebert, Thomas Siebert
http://www.t-seabird.de
  Set the clipboard to the content of a field that is not present in the current layout or set it to a text string.
   
70. Apply ( function ; value )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Debi Fuchs, Aptworks Consulting
http://www.aptworks.com
  Apply an "inline" function to a value, handling the value either as a number/expression or as text.
   
71. ApplyToList ( function ; listOfValues ; separator )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Debi Fuchs, Aptworks Consulting
http://www.aptworks.com
  Speedily (using limited recursion and avoiding GetValue) apply an "inline" function across a list of up to one million items, handling them either as numbers/expression or as text.
   
72. ApplyToList( ListA; function, separator )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Bruce Robertson, Concise Design
http://concise-design.com
  Apply FUNCTION to each item in list
   
73. ApplyToRange ( function ; start ; end ; step ; separator )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Debi Fuchs, Aptworks Consulting
http://www.aptworks.com
  Speedily (and using limited recursion) apply an "inline" function across a range of up to one million numbers.
   
74. ApproxDateRange ( date1 ; date2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Fritz Mills, Media LightBridge, LLC
http://www.medialightbridge.com/
  Evaluates two dates and returns a text string that describes the difference between them to an approximately half-month precision. It doesn't matter which date is more recent.
   
75. APV ( payment ; rate ; type ; nper ; futureval )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Lee Dolereit, Sharp ABT
http://www.sharpabt.com.au
  Advanced Present Value
   
76. Arcfactorial ( product ; numberOfFactors )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Jeff Drake, Drakeling Technologies
http://www.drakeling.com
  returns the inverse factorial of a given integer
   
77. areaCalcsByCoords ( xlist ; ylist )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Bill Holt, Notesoft
http://www.notesoft.com
  Calculates the area within any shape defined by a series of coordinates.
   
78. AreaConvert ( Width , Wunit , Height , Hunit , OutUnit )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Ibrahim Bittar, Eikonsys
http://www.eikonsys.com
  Calculates areas based on multiple units
   
79. Arithmetic_Mean ( Field ; MaxLoopCount ; StartIndex ; MeanValue )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Kevin Woods, KWoods
http://www.RivieraCouches.co.uk
  Calculate the arithmetic mean of a set of numbers.
   
80. array.cellValueByColNum ( array ; rowName ; column ; delimiter )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Tim Anderson, Tim Anderson Group
http://www.timanderson.co.uk
  A function to return the column value from an array by specifying the row name.
   
81. array.cellValueByColTitle (array ; rowName ; column ; delimiter ; useTitle )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Tim Anderson, Tim Anderson Group
http://www.timanderson.co.uk
  A function to return the cell value from an array by specifying the row name and column title
   
82. ArraySetValue ( array ; index ; data )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Jeremy Bante,
https://github.com/jbante/
  Set a cell value in an arbitrary-dimensional array
   
83. ArrayValue ( array ; index )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Jeremy Bante,
https://github.com/jbante/
  Retrieves a cell from an arbitrary-dimensional array
   
84. Asc ( char )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Theo Ros, n/a
n/a
  Returns the Ascii code for the given character
   
85. AscAlphaNum ( str )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Tim Oehlke, Ecolab, Inc.
http://www.ecolab.com
  returns an alphanumeric character's ASCII code value
   
86. AscIIToBase64 (string)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Roberto Pellegrini, gestione datu
http://www.gestionedati.net
  Convert text AscII To Base64
   
87. AscIIToBase64 (string)
 
RatingRatingRatingRatingRating
  Average rating: 2.6
  Frank Seipel, Lilly's Media Logistics
http://www.lillysmedialogistics.com
  Converts an arbitrary text string to BASE64. English functnion name version.
   
88. ASCII_Code ( char )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au
  Returns the ASCII Code value for any character
   
89. ASFolderPath ( UnixFolderPath )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Allan Hunter [AHunter3], FileMaker Solutions Developer
http://members.bellatlantic.net/~adhdah/FmPro/fmdevindex.html
  Converts Unix-style file paths to the reverse-order verbose form used by AppleScript
   
90. ASFPCoreFx (UnixP2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Allan Hunter [AHunter3], FileMaker Solutions Developer
http://members.bellatlantic.net/~adhdah/FmPro/fmdevindex.html
  this is a subfunction of CF named ASFolderPath; useless unto itself
   
91. Asin ( number )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Brian Dunning, BrianDunning.com
http://www.briandunning.com/
  Returns the arc sine of a given number.
   
92. assembleBarGraph ( theList )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Edward Souza, Nossoestudio Som & Imagem, ltd
n/a
  assembleBarGraph is a recursive Custom Function based on a clever Web Viewer's example
   
93. AssignWindowName ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Koji Takeuchi, Splash, Inc.
http://www.splash.jp/
  Add " - num" to Text when the Text is not unique in WindowNames.
   
94. Astrological_Sign(date)
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  John Pollard, Generic Human Studies
http://www.selfparenting.com
  Determines a person's astrological sign based on their birthdate
   
95. AS_ChooseFile ( _resultTOGlobalCellName ; _prompt ; _defaultLocation ; _extensionVL )
 
RatingRatingRatingRatingRating
  Average rating: 4.8
  Thomas Seidler, The Good Book Company
http://www.thegoodbook.co.uk
  MAC ONLY. Generates applescript to choose file & returns result
   
96. AS_ChooseFolder ( _resultTOGlobalCellName ; _prompt ; _defaultLocation )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Thomas Seidler, Harmlesswise.com
http://www.harmlesswise.com/it
  MAC ONLY. Generates applescript to choose folder & returns result
   
97. AS_FolderPathListing ( _resultTOGlobalCellName ; _folderPath ; _extensionVL )
 
RatingRatingRatingRatingRating
  Average rating: 4.8
  Thomas Seidler, Harmlesswise.com
http://www.harmlesswise.com/it
  MAC ONLY. Generates Applescript to obtain folder listing & returns result as ValueList.
   
98. atan2 ( y ; x )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Michael George, Michael George Consulting
mailto:mgeorge@coresupport.com
  returns the base angle (arctan) of a triangle with the sides X and Y.
   
99. AutoUpdateErrorToEnglish (ErrorNum)
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Andrew Duncan, Databuzz
http://www.databuzz.com.au
  Returns the English description for the AutoUpdate Error Number for the FMSAUC_UpdatePlugIn function
   
100. Backwards( _Field )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Alexander Baier, FM Tutorial
http://www.fm-tutorial.de
  return a string backwards (mirror writing)
   
101. balance( theText; openbracket; closebracket )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Bruce Robertson, Concise Design
http://concise-design.com
  Get text to length that balances open/close markers
   
102. base10_to_base64( integer )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Martin Sorich, FMBiotech
http://www.fmbiotech.com
  Converts base 10 integer to base 64 alphanumeric character
   
103. Base64ToAscII ( string )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Frank Seipel, Lilly's Media Logistics
http://www.lillysmedialogistics.com
  Convert text Base64 to AscII
   
104. Base64ToAscII (String)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Roberto Pellegrini, gestione dati
http://www.gestionedati.net
  Convert text Base64 to AscII
   
105. BaseConvert ( string; baseFrom; baseTo )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Debi Fuchs, Aptworks Consulting
http://www.aptworks.com
  Convert a number (up to 10 billion) from one base to another.
   
106. BaseEncode ( inputInt ; base )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Cory Alder, Davander Mobile Corporation
http://mobile.davander.com
  Base64, or base62 encode any integer
   
107. BaseX ( Integer ; Base )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  JT Hughes, Queuedom
http://notapplicable.com
  Converts Integer to base Base, where Base is between 2 and 36, inclusively.
   
108. Before ( text ; searchString ; occurrence ; include_1 )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  extracts text before search string
   
109. BetragToESR ( Betrag )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Pavel Buncak, MacTech Buncak AG
http://www.mactech.ch
  Num to ESR
   
110. Between (text; searchString1; occurrence1; include1_1 ; searchString2; occ
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  extracts text between two search strings
   
111. BetweenNext ( _text ; _searchString1 ; _occurrence1 ; _include1_boolean ; _searchString2 ; _occurrence2 ; _include2_boolean )_
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  extracts the middle of a text in between delimiters, based on search strings and an occurrence numbers
   
112. Bezier ( t ; controlPoints )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Jeremy Bante,
https://github.com/jbante/
  Calculates points on Bezier curves
   
113. BillingDay ( DayOfMonth )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Brian Dunning, BrianDunning.com
http://www.briandunning.com
  Makes sure the DayOfMonth given is actually a day in the current month.
   
114. Bin ( number ; binNames ; binSizes )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
  Returns the name of the bin containing the number.
   
115. Bin2Dec ( bin ; dmy )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  F. Osman Cabi, Cabitas
http://www.cabitas.com
  Converts binary number to decimal number
   
116. Bin2Hex ( binary )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Vaughan Bromfield, Vaughan Bromfield Design
mailto:vbromfield@optusnet.com.au
  A function to convert a binary number to a hex string.
   
117. BinBitOperation_cf ( bin1 ; bin2 ; optype ; i ; result )
 
RatingRatingRatingRatingRating
  Average rating: 1.0
  Christopher Gauntt, Cordega Solutions
http://cordega.com
  Applies NOT, OR, AND, XOR operations to two binary numbers
   
118. BinomDist ( successes ; trials ; probability ; cumulative )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
  Returns the binomial probability distribution of obtaining the number of successes out of a fixed number of trials, where the result of each trial can be only success or failure, and the probability of success is constant throughout the experiment. BinomDist can calculate the probability that two out of the next three babies born will be male.
   
119. Bisiesto ( Anio, Tipo )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Miguel A. Aguerrea, Alquimia Digital
http://www.alquimia-digital.com
  Calcula si un año es o no bisiesto.
   
120. BitAnd ( x ; y )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Shaun Flisakowski, spf-15
http://www.spf-15.com/
  Bitwise AND operation on two numbers
   
121. BitChange ( value ; bit )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Theo Ros, *
http://notapplicable.com
  Toggles a bit in a value
   
122. BitClear ( value ; bit )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Theo Ros, *
http://notapplicable.com
  Clears a bit in a value
   
123. BitLsbOperation( OPC ; OP1 ; OP2 )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Erich Schmidt, Schmidt-IT-Beratung
http://www.schmidt-it-beratung.de
  bitwise logical operation
   
124. BitOperation( BitNr ; RC ; OPC ; OP1 ; OP2 )
 
RatingRatingRatingRatingRating
  Average rating: 1.0
  Erich Schmidt, Schmidt-IT-Beratung
http://www.schmidt-it-beratung.de
  bitwise logical operation
   
125. BitOperationX( wordNr ; RC ; n ; OPC ; OP1 ; OP2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Erich Schmidt, Schmidt-IT-Beratung
http://www.schmidt-it-beratung.de
  bitwise logical operation
   
126. BitOr ( x ; y )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Shaun Flisakowski, spf-15
http://www.spf-15.com/
  Bitwise OR operation on two numbers
   
127. BitSet ( value ; bit )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Theo Ros, *
http://notapplicable.com
  Sets a bit in a value
   
128. BitTest ( value ; bit )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Theo Ros, *
http://notapplicable.com
  Checks if bitnumber 'bit' in value 'value' is on or off
   
129. BitTest2 ( value ; bit )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Stephen Drake, Synergy
n/a
  Checks whether bit 'bit' in value 'value' is on or off
   
130. BiweeklyFrom ( From Date ; After Date )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Kevin Hayes, KevTools
http://www.kevtools.com
  Calculates the biweekly date based on From Date following After Date
   
131. BoldItalicEncode ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Tom Robinson, Kōwhai Computing
http://www.tomrobinson.co.nz/
  Encode any bold or italic text with tags
   
132. BoldRed ( input )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Dwayne Wright, dwaynewright.com
http://www.dwaynewright.com
  Simple use of combining two text formatting functions into one streamlined custom function
   
133. BubbleSort ( inputValues ; iterations )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Greg Lane, The Moyer Group
http://www.moyergroup.com
  Sorts a list of return-separated values.
   
134. BubbleSort_SlideValue ( inputValues ; target )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Greg Lane, The Moyer Group
http://www.moyergroup.com
  BubbleSort_SlideValue is used by the BubbleSort function.
   
135. BusinessDays ( startDate ; endDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Jeremy Bante,
https://github.com/jbante/
  Returns the number of business days between two dates (inclusive)
   
136. BusinessHolidays ( calendarYear )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Jeremy Bante,
https://github.com/jbante/
  Returns a list of observed holidays in calendarYear
   
137. BusinessHours( )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com
  Select when to send business email
   
138. ButtonValue ( Number )
 
RatingRatingRatingRatingRating
  Average rating: 2.2
  Matt Petrowsky, ISO Productions, Inc.
http://www.filemakermagazine.com
  Useful to make it easier for passing multiple parameters to a script from a button.
   
139. ByteSize ( bytes ; precision )
 
RatingRatingRatingRatingRating
  Average rating: 2.5
  Jeremy Bante,
https://github.com/jbante/
  Converts bytes to a magnitude-appropriate unit of measure
   
140. CalcDaysBetween ( startDate ; endDate ; numDays ; $$HolidayList ; countWeekends ; returnNeg )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Shan Younker, Shan Younker
none
  Calculates number of days between dates, accounts for holidays and weekends
   
141. calcEndDate ( startDate; numDays; loopCount; holidayList; allowWeekends; direction )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Shan Younker, Shan Younker
-none
  Calculate date by adding or subtracting days, option for skipping weekends
   
142. CalculateEndDate ( startDate ; days ; wkEnds )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Steve Allen, Richard Carlton Consulting, Inc.
http://www.rcconsulting.com
  Calculate End Date given Start Date and number of days, inclusive; handles weekends. NOT Recursive.
   
143. Calendar ( c_Date )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Jerry, D
http://www.canada.com
  Require FM8+. Shows monthly calendar view with different colour for previous/next month days, Sundays and today. Custom function can be used as calculation field.
   
144. CalendarDiff ( thedate ; gregorian )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Theo Ros, *
http://notapplicable.com
  Returns the number of days between a the Julian Calendar for a given date and the Gregorian Calendar
   
145. CamelCasePrefix ( name )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Marc Wood, studentpress.org
http://studentpress.org
  isolate first word of camelCase-formatted names
   
146. CardinalToText ( Amount )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Clement Hoffmann, none
none
  Converts Numbers to Text in French (...from 999 billions to the tenth of unit...)
   
147. CardinalToText_Utility ( value ; quantifier )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Clement Hoffmann, none
none
  called by http://www.briandunning.com/cf/573
   
148. CaseStatus ( theText )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Michael Pease, KPM
http://www.whitehouse.org/
  Determines if text is all upper case, all lower case, or mixed case (ignoring non a-Z chars)
   
149. CC_Expired ( ExpirationDate ; Checkdate )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Kevin Bache, None
www.none.com
  Checks if credit card expiration date has past.
   
150. celciusFromFahrenheit
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.gudthlandum.no
  Celcius From Fahrenheit
   
151. CelsToFahr ( degreesCelsius )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Brian Dunning, BrianDunning.com
http://www.briandunning.com/
  Converts degrees Celsius to degrees Fahrenheit.
   
152. CenterWindow in Window vert horiz (demension)
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Todd Dignan, Dignan Consulting Inc
http://www.dignanconsulting.com
  Center Window in Window
   
153. CF.RGBtoHex ( DRGB )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Thomas Hellwig, DELASOCIAL GmbH
http://www.delasocial.com/
  Converts RGB color string into a Hex color string
   
154. cfActiveLayout
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Nicky Naessens, Aussiewords
  Shows the name of the active file, table and layout
   
155. cfCode128 ( pString; pCodeSet )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Tammo Fornalik / Felix Hausberner, dbyte solutions
http://www.dbyte-solutions.com
  composes the final barcode Code128 of symbology A,B or C from a given alphanumeric string.
   
156. cfColorByIndent (pText ; pIndentChar ; pRgbColorList)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Tammo Fornalik / Felix Hausberner, dbyte solutions
http://www.dbyte-solutions.com
  emphasizing thread-depths in a forum or indentations in text
   
157. cfGetData ( field )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Michele Olson, AppleSauce Productions, Inc.
http://www.applesaucepro.com
  Returns the contents of a list of fields, recursive function.
   
158. cfGetEveryNthValue ( pList ; pStart ; pIncrement ; pInputSeparator ; pOutputSeparator )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Kevin Frank, Kevin Frank & Associates
http://www.kevinfrank.com
  Extract every Nth item from a list; allow starting value and list separators to be specified
   
159. cfHiliteText( text; searchText; colorRGB ; textStyle )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Martin D. Brunner, -
http://-
  a customFunction for hiliting text in a field with following advantages:
   
160. cfISRC (pMode ; pISRC_Code ; pRGB_OnError)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Tammo Fornalik / Felix Hausberner, dbyte solutions
http://www.dbyte-solutions.com
  ISRC formatting / validating
   
161. cfLayoutLister( whichFile; counter; fieldName; onlyLayouts; result)
 
RatingRatingRatingRatingRating
  Average rating: 4.8
  Bruce Robertson, Concise Design
http://www.concise-design.com
  List layouts and fields for specified file. Option to limit to match by field name.
   
162. cfMatch ( value_to_test; match_Value; match_operator )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Bruce Robertson, Concise Design
http://concise-design.com
  Test input to see whether it equals, contains, less than etc for match_value, returns boolean result
   
163. cfStackAppendSlide( pInput; pVariableName; pStackDepth )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Tammo Fornalik / Felix Hausberner, dbyte solutions
http://www.dbyte-solutions.com
  Append a new entry to a stack (global var) _and_ delete first entry if count of values exceeds stack depth.
   
164. cfTab ()
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Michele Olson, AppleSauce Productions, Inc.
http://www.applesaucepro.com
  Provides a tab character for formula use
   
165. CF_blzcheck(BLZ;MAXIMUM)
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Frank F. Hautog, Datenbank & Design
http://www.wendland-design.de
  Check Banknumber
   
166. cf_CenterWindowLeft ( width )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Stephen Dolenski, Ocean West Consulting, Inc
http://www.fmforums.com
  Center window on creation using GTRR dialog box
   
167. cf_CenterWindowTop ( height )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Stephen Dolenski, Ocean West Consulting, Inc
http://www.fmforums.com
  Center window on creation using GTRR dialgo box
   
168. cf_CMYK2RGB ( Cyan; Magenta; Yellow; Black )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Andrew Mallison, Mallison
http://www.mallison.biz
  Convert CMYK colour values to a similar RGB values.
   
169. cf_convertHexRGB( HexNumber; Separator )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Klemens Müller, Klemens Müller
http://www.klemenso.de
  Convert hexadecimal RGB values
   
170. CF_FechaEspanol(Fecha)
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Rigoberto Carbonell And Luis González, AFS Group, Inc.
http://www.afsgroup.us/
  Translate the date into Spanish Completely, including day of the week.
   
171. CF_Generate_QR_Barcode ( Text ; Size ; Encoding )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Patrick Weh, Sansibar
http://www.sansibar.de
  Converts a string into a QR code using the Google API
   
172. cf_GetElement ( SearchString ; KeyList ; ElementList )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Gary Tate, TGI Solutions
http://www.tgisolutions.co.uk
  Find a value from a second list, based on a search of a key field in a first list.
   
173. cf_getElementNo( SearchString ; ElementList )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Klemens Müller, Klemens Müller
http://www.klemenso.de
  Get the line number of sought-after element in a list
   
174. CF_HTMLtoFMP_styledText ( text ; num )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Chaim Bacon, Click Connection Corporation
http://www.productiveit.co.uk
  Converts data between predefined HTML tags into FMP bold / italic etc. As well as standard HTML tags, you can also define your own custom tags.
   
175. CF_HTMLtoFMP_styledText_sub ( text ; openTag ; closeTag ; replaceWith )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Chaim Bacon, Click Connection Corporation
http://www.productiveit.co.uk
  Converts data between predefined HTML tags into FMP bold / italic etc. As well as standard HTML tags, you can also define your own custom tags.
   
176. cf_ListR( Field ; Counter ; Maxi )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Klemens Müller, eichhorn. frankfurt
http://www.eichhorn-frankfurt.de
  List-Function as counterpart to the new function in FileMaker 8.5
   
177. CF_ListToCommas ( ListOfItems; And_Or_Parameter; MaxNumber )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Nick Stockbridge, Transmedia Training
http://transmedia.co.uk
  Converts a carriage-return delimited list to one separated by commas, with the word
   
178. cf_MacPath_AppleScriptPath(_path)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Edward Souza, Duana A. S. Designs
http://none
  Formatting from Mac path to AppleScript path
   
179. CF_ReplicaCar ( CadenaOriginal ; CantidadVeces ; CadenaResultante ))
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Luis Gonzáles and Rigoberto Carbonell, AFS Group, Inc.
http://www.afsgroup.us/
  Replicate CantidadVeces Times a Character or String, on resultan String
   
180. cf_RomanNumeral ( _number ; _digit ; _Kmarker )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Christopher Gauntt, Cordega Solutions
http://cordega.com
  Swaps out arabic numbers for roman numerals
   
181. CG_CVFP ( vars ; vals ; tail )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Thomas Mokwa, CG Software
http://www.cgsoftware.com
  Create Variables from Parameters
   
182. ChaosDecrypt ( cipherText ; key )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Jeremy Bante,
https://github.com/jbante/
  Decrypt text enciphered by the ChaosEncrypt() function
   
183. ChaosEncrypt ( text ; key )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Jeremy Bante,
https://github.com/jbante/
  Encrypt text with a chaos-based stream cipher
   
184. ChaosHash ( text ; hashLength )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Jeremy Bante,
https://github.com/jbante/
  Uses a chaotic process to create a hash of the specified length.
   
185. Check Zip ( Address ; City ; State ; Zip )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Mark P, SIP Corporation
www.sipgrinder.com
  Creates the URL for the USPS Check Zip Code Web Page
   
186. CheckCF ( Codice Fiscale )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Daniele Raybaudi, ACI
www.aci.it
  Only for Italian People
   
187. CheckdigitDamm ( digitSequence )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Jeremy Bante, Beezwax Datatools, Inc.
http://beezwax.net
  Calculates a check digit using the Damm algorithm
   
188. CheckdigitDammVerify ( digitSequence )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Jeremy Bante, Beezwax Datatools, Inc.
http://beezwax.net
  Verifies a digit sequence containing a Damm check digit
   
189. CheckDigit_GTIN_14 ( IndicatorDigit ; CompanyPrefix ; SerialNo )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  W Brent Simon, Sweet Pea Data Solutions
http://www.SweetPeaData.com
  Generates the check digit for GTIN 14 number
   
190. CheckDollarValue (number)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Ryan Thorpe, Vanguard Research & Title Services, Inc.
http://vgrti.com
  counts the number of characters to the right of the decimal
   
191. checkEffectiveBitSize ( value )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Jeff Hough, Pre1 Software LLC
http://www.pre1.com
  Test the strength of a password entered by the user.
   
192. CheckIBAN ( IBAN )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Christoph Kaufmann, CLK
http://clk.ch
  Checks whether the IBAN is correct or not
   
193. CheckIBAN (IBAN)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Michael Bijnens, freelance developer
/
  check if given iban number is correct ( EU version )
   
194. CheckSofi (Sofi)
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Hartger Visser, Teuker Beheer BV
http://www.teuker.nl
  Validater for the Dutch Sofinumber against the '11-proef'.
   
195. ChecksumAdler32 ( asciiText )
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Jeremy Bante, Fugue
fuguedata.co
  Computes an Adler-32 checksum
   
196. ChecksumAdler32 ( text ; seed1 ; seed2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Vaughan Bromfied, Vaughan Bromfield design
http://google.com
  Creates a checksum of the input text bases on the Adler-32 algorithm.
   
197. ChecksumCRC16 ( asciiText )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Jeremy Bante, Beezwax
http://beezwax.net
  Computes a CRC16 checksum
   
198. ChecksumCRC32 ( asciiText )
 
RatingRatingRatingRatingRating
  Average rating: 2.0
  Jeremy Bante, Fugue
fuguedata.co
  Returns a 32 bit cyclic redundancy check
   
199. CheckVatBE (vat)
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Michael Bijnens, freelance developer
/
  Check if VAT number is correct ( BELGIUM )
   
200. ChgWordOccWNums F1 ( _list ; F1StartNum ; ChgWord )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Pavle Ancevski, NYHTC PAN
http://NA.com
  Change word occurrences in a list with consecutive numbers
   
201. ChooseFolder
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  NicoWeb, NicoWeb
http://www.nicoweb.com
  Choose Folder opens a folder selector windows and returns path folder
   
202. Chr ( ascii )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Theo Ros, n/a
n/a
  Returns the character for the given ascii value
   
203. circleArea ( radius )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Scott Love, The Moyer Group
http://www.moyergroup.com/
  Calculates the area of a circle of specified radius.
   
204. CleanText ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Tim Cimbura, Cimbura.com Technology
http://www.cimbura.com
  Strips out illegal text characters and simplifies.
   
205. ClearRepeatingVariable ( variableName ; startIndex ; endIndex )
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Kevin Frank, Kevin Frank & Associates
http://www.kevinfrank.com
  Clears a range of repetitions for a specified variable
   
206. Clock()
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com
  CF for displaying a running time in a webviewer
   
207. ClosestDate( TestDate; ValueList)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Ken Newell, Hamilton Glaucoma Center
  Find the closest date between a one to many relationship.
   
208. Codify( theText; code_option )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Bruce Robertson, Concise Design
http://concise-design.com
  Encode/decode any input text using native code() & char() functions
   
209. Codigos de Bancos
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Paco Caetano, TRAMANO SERIGRAFIA
http://www.notengoweb.com
  Al insertar los 4 digitos del codigo del banco te dice el banco al que pertenece.
   
210. CollapseList ( listOfValues )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
  Collapses a list of values by replacing serially incrementing sections with their range boundaries.
   
211. Color ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Geoff Coffey,
  Use a color name to specify a color in FileMaker rather than RGB values.
   
212. Color_HEX_Random
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Thomas Siebert, Thomas Siebert
http://www.t-seabird.de
  generating a random color in HEX format
   
213. ColumnsAcross ( listOfValues ; numberOfColumns ; columnDelimiter )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Transforms a list of values into a tabular text array.
   
214. ColumnWrap ( Text ; StartRow ; NofRows )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Martin D. Brunner, Zurich Financial Services
http://www.mdb.bz
  Non recursive custom function for colum break after a certain amount of linebreaks
   
215. CombineLists ( Start; End; ListFieldsObjects; Separator; Function )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html
  concatenate n FieldsLists or ObjectsList
   
216. CombineValues ( list1 ; list2 )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/
  Combines two lists of values, sort of like php's array_combine function
   
217. CombineValues( list1, list2, divider )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Jeff Drake, Excelisys, Inc.
http://www.excelisys.com
  returns a grid of all values in two lists
   
218. ConcatListAndConstant ( theList ; Constant ; Place ; Separator)
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Matt Wills, Virtual Vermont
http://www.virtualvermont.com/FMP/
  Concatenate a constant with each value in a return-separated list, as prefix or suffix
   
219. ConditDateRange ( StartDate ; EndDate ; Weekend )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Miguel Angel, n/a
n/a
  Date range that may include weekends or not.
   
220. ConditionalSummary ( TypeField ; Type ; SumField )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Koji Takeuchi, Splash, Inc.
http://www.splash.jp/
  Sum a SumField for records where TypeField matches
   
221. ConsecCount ( ItemList ; StartingItem )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Howard Schlossberg, FM Professional Solutions
http://fmprosolutions.com
  Counts how many consecutive years (or other numbers) are in a field from a particular starting point.
   
222. ContainerSize ( Container ; Precision )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Robert Schaub, Starr Data
http://starrdata.com
  Get the size of your container
   
223. Contains ( Text ; SearchStrings )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Bill Thurmes, Miyota Development Center of America
http://sorry, none
  Determine whether Text contains any of the strings contained in SearchStrings ('or' logic)
   
224. ContainsValue ( listToSearch ; startIndex ; value )
 
RatingRatingRatingRatingRating
  Average rating: 1.0
  Andres Cabezas, Domador Software
http://www.domador.net
  Indicates if a list contains the specified value.
   
225. ContrastText ( foregroundText ; bgRedPercent ; bgGreenPercent ; bgBluePercen
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Joe Rovang, none specified
N/A
  Colors foregroundText black or white as appropriate for the specified background color.
   
226. Convert ( number ; from ; to )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Marco Terrile, ChefMaTe
http://www.chefmate.it
  Units converter for kitchen use ;-)
   
227. ConvertFMPath(FMPath)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com
  Convert FileMaker Path to Windows Path
   
228. ConvertFractToNum ( number )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Colin Keefe, IT Solutions Consulting, Inc
http://itsolutions-inc.com
  Converts a fraction to a real number.
   
229. ConvertFromBase ( str ; base ; charSet )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Steven R. Allen, Richard Carlton Consulting, Inc.
http://www.rcconsulting.com
  Convert any base to decimal
   
230. ConvertMins_hh:mm( MinutesInput )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Sean Libin, Stride
http://www.stridemgmt.com
  This converts number of minutes to hh:mm format
   
231. ConvertNumber ( RC ; decimal ; NbrOfDigits ; digits)
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Erich Schmidt, Schmidt IT-Beratung
http://www.schmidt-it-beratung.de
  number conversion
   
232. ConvertTextDate ( TextDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Darryl Oliver, N/A
N/A
  Convert text date to a FileMaker date
   
233. ConvertTimeStamp ( unixTimeStamp )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com
  Convert unix timestamp to FMP timestamp
   
234. ConvertToBase ( number ; base ; charSet )
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Steven R. Allen, Richard Carlton Consulting, Inc.
http://www.rcconsulting.com
  Convert a decimal number to any other base
   
235. Convert_Arabic_to_Chinese( number )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Lukas Frey, DePuis Synthes
http://Synthes.com
  Convert Arabic numbers to Chinese letter
   
236. convert_gps_gausskrueger2wgs84( coordinate ; error)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  TS Wolf,
  Converts an Gauß-Krüger-coordinate (as used by O2) to an comma-seperated WGS84-coordinate
   
237. convert_gps_gausskrueger2wgs84_sub (Latitude ; CartOutputXMeters ; CartOutputYMeters ; CartOutputZMeters)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  TS Wolf,
  Recursive subclass to convert_gps_gausskrueger2wgs84 and cannot be used on ist own
   
238. Convert_Text_to_Base64 ( string )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Mogens Brun, fmIntegrator ApS
http://fmIntegrator.com
  Converts a FileMaker text string to a Base64 string.
   
239. Convert_Text_to_UTF8 ( string )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Mogens Brun, fmIntegrator ApS
http://fmintegrator.com
  Converts a FileMaker text string to a UTF-8 string.
   
240. CorrespondingValue ( indexValues ; searchValue ; listOfValues )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Finds the first occurrence of searchValue in indexValues and returns the corresponding value in listOfValues.
   
241. cosSeries ( angleInRadians ; series ; k )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Jeremy Bante, OshVay Systems, Inc.
http://www.oshvay.com/
  cosSeries returns the cosine of an angle as precise as you want, without the limitations of the built-in cosine function.
   
242. CountPermutations ( string )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  maarten witberg, maarten witberg
http://none
  To determine the number of permutations for a string of characters
   
243. CountWeekday.cf ( StartDate ; EndDate ; CustomIgnoreList_as_ddmmyyyy )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Jonathan Jeffery, igeek
http://www.igeek.co.uk
  Counts the number of weekdays between two dates
   
244. CountWordOccurrences ( text ; searchWord )
 
RatingRatingRatingRatingRating
  Average rating: 4.7
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Returns the number of occurrences of searchWord as word in text.
   
245. CreateConstantMatrix (
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Ronald W. Satz, Transpower Corporation
http://www.transpowercorp.com
  Creates a matrix of size (Rows, Columns) with a ConstantValue for each element (each element is followed by a semi-colon).
   
246. CreateVariables ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Chris Bartlett, .
  Create variables from a text string like "Name=Jai;Age=1"
   
247. CreditCardName ( CreditCardNumber )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Geoff Wells, DataIsland Software LLC
http://www.dataisland.com
  Returns the CC type from the number
   
248. CropYield ( Moisture ; Weight ; RowLength ; RowWidth ; RowCount ; CropAdjustment)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Tim Griffith, Developer
Tim Griffith
  Calculates Crop Yields
   
249. Crossfoot ( value )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Christoph Ivo Mattle, Christophs
http://www.christophmattle.ch
  1-digit Crossfoot calculation
   
250. CSStoFMText (text)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Christopher Gauntt, Cordega Solutions
http://www.cordega.com
  Converts CSS inline styles to FileMaker Pro Text
   
251. csv.getColumn( array; returnColumn; delimiter)
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Bruce Robertson, Concise Design
http://concise-design.com
  Get designated column from delimited array
   
252. csv.getColumn.if( array; matchColumn; matchValue; returnColumn; delimiter)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Bruce Robertson, Concise Design
http://concise-design.com
  Get column from array for match in another column
   
253. csv.getrows.if( array; matchColumn; matchValue; delmiter)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Bruce Robertson, Concise Design
http://concise-design.com
  Return entire rows where value of matchColumn = matchValue
   
254. csv.getValue
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Nicolas Bourré, Me, Myself and I
http://nbourre.ep.profweb.qc.ca/blogue
  Returns a specific cell or row in a CSV table
   
255. CTI_Dialer_Snom ( pPhoneIP ; pPhoneNumber ; pOutgoingIdentity )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Ralph Nusser, Sogetes FileMaker-Services
http://www.sogetes.com
  Dial SNOM phone by URI
   
256. CullNulls ( listOfValues )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Debi Fuchs, Aptworks Consulting
http://www.aptworks.com
  Speedily (and with no recursion) remove empty items from a list.
   
257. Currency(Amount, Code, Lead, Trail, ShowDecimal, RedNegative)
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au
  Format currency as text in many formats (inc. red negative)
   
258. CurrencyFormatForText ( ValueText )
 
RatingRatingRatingRatingRating
  Average rating: 2.0
  John Shields, Chester County Intermediate Unit
http://www.cciu.org
  Translate numbers stored as text into US Dollars (currency)
   
259. CurrencyToText_SP (Monto , Currency , Sufijo)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Ibrahim Bittar Torres, Eikonsys
http://www.eikonsys.com
  Converts Numbers to Text in Spanish (up to 18 digits)
   
260. Current Month_Abreviation
 
RatingRatingRatingRatingRating
  Average rating: 2.4
  Walter Noia, Digi
http://www.digidelta.pt
  Easy Way of getting a short Month (Of current Month Date)
   
261. CustomList ( Start ; End ; Function )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html
  Update for FileMakerServer. Update for FileMakerGo. Update, new version - customized lists - not recursive - Unlimited
   
262. CustomListOLDVersion ( Start; End; Function)
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Agnes Barouh, TicTac
http://www.tictac.fr/CoinFileMaker/Page.html
  [old version] Custom Lists - For all native functions with a number
   
263. CustomList_BottomUp ( Start ; End ; Function )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html
  customized lists - Reverse list - Not recursive
   
264. CV ( Principal ; Rate; Frequency; BegDate; EndDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Timothy Brown, Antidote Solutions
http://www.antidotesolutions.com
  Current Value of an Investement based on compounded interest
   
265. c_YYMMDD ( c_date )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Andrew Burt, Stockdale ACS
http://www.stockdaleacs.com.au
  Display date in YYMMDD form
   
266. DailySerial ( AEfield ; digit ; format )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Daniele Raybaudi, ACI
www.aci.it
  Autoenter a serial number that increments daily
   
267. DashInsert ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Daniele Raybaudi, ACI
www.aci.it
  Returns the given text with dashes between numbers and chars
   
268. DataFormattata ( testo )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Daniele Raybaudi, ACI
www.aci.it
  Restituisce il testo inserito nella formattazione data: gg/mm/aaaa
   
269. DataType ( Stuff )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Matt Navarre, MSN Media
http://www.msnmedia.com
  Returns type of data, ie Integer, Date, Email, Phone, Text
   
270. date.format ( theDate ; format )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Tim Anderson, TAg
http://www.timanderson.co.uk/
  A function to return a date in a text format specified at the time.
   
271. DateAgeDisplay ( aTimeStamp )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Daniel Wood, Digital Fusion Ltd
http://www.digitalfusion.co.nz
  Display the age of a timestamp in a facebook-style display in either seconds/minutes/hours/days
   
272. DateByDayOccur ( yearNum ; monthNum ; dayOfWeekNum ; dayOccurance )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Jonathan Mickelson, Thought Deveopment Corp.
http://thought-dev.com
  Returns the date of a specific occurrence of a day of the week, for a given month and year. Ideal for holiday calculations.
   
273. DateByName ( dname ; curdate )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Gustav Hobel, Purple Phaze Productions
n/a
  Returns the next date based on a day name.
   
274. DateByNthDOW ( tYear ; tMonth ; tDayOfWeek ; tNum )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Koji Takeuchi, Splash, Inc.
http://www.splash.jp/
  Pick Nth day of week in specified year and month.
   
275. DateDDlongMonthYYYY(xDate)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au
  Converts a date to DD longMonth YYYY format. i.e. 1 Jan 2006
   
276. DateDDshortMonthYYYY(xDate)
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au
  Converts a date to DD shortMonth YYYY format. i.e. 1 Jan 2006
   
277. DateDif( date1 ; date 2 ; flag )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Brett Buchmiller, No Company
http://filemaker.com
  Simulates Excel function of same name and provides for text labeling with correct grammer.
   
278. DateDifference ( date1 ; date2 ; format )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Paul Jansen, APJ Ltd
http://www.apjuk.com
  Calculate age ( years, months, weeks and days between 2 any two dates
   
279. DateDueHolidays ( StartDate ; TransitDays ; HolidayList )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com
  Due date from Start Date plus intervening days, adding Holidays from user-entered table
   
280. DateFormat
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Eilert Sundt, Eilert Sundt Systemdesign
http://www.eilert.no
  Returns a representation of a file's current date format
   
281. DateFormat( Entered_Date )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Veselko Pesut, PLANet Systems Group
http://www.planetsg.com
  When you want to format date in non-date field.
   
282. DateFormatUSA (textDate)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Henry Iriawan, - HI TECH -
http://www.xozoshop.com
  USA date's format using Month Name. It will make FM read date from text date format. If you find this useful, please comment. Thank you :)
   
283. DateHolidayFlag ( datefield )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com
  Holiday Weekend conditional formatting calc for date field
   
284. DateNameFormat ( theDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  David Goetzka, Untoil Software Group
http://untoil.com
  change date format to day name and ordinal date
   
285. DateOffset ( startdate ; monthoffset ; dayoffset ; yearoffset)
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Erik Wegweiser, Intelligent Database
http://intelligentdb.com
  Returns a start date, plus or minus a specified number of months, days or years.
   
286. DateOfWeek ( week ; yearOfWeek ; type )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Reinder Wolting, ABECON
http://www.abecon.nl
  Calculate the first date of a given week and year
   
287. DatePlusMinus ( datefield ; internal param )
 
RatingRatingRatingRatingRating
  Average rating: 4.7
  Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com
  Enters current date, subtracts a day or adds a day
   
288. DateQuarterAsRange ( theDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Chiyoko Yoshida, chiyofm
http://www.chiyofm.com/
  Pass any date and get the quarter END date based on input date.
   
289. DateQuarterBegin ( theDate )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Chiyoko Yoshida, chiyofm
http://www.chiyofm.com/
  Pass any date and get the quarter start date based on input date.
   
290. DateQuarterEnd ( theDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Chiyoko Yoshida, chiyofm
http://www.chiyofm.com/
  Pass any date and get the quarter END date based on input date.
   
291. DateRange ( StartDate ; EndDate ; RangeLimit )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Andrew Persons, Excelisys
http://www.excelisys.com/
  Creates a multi-key field containing a range of dates.
   
292. DateRange ( startDate ; finishDate ; returnType )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Michael Richards, itraining
http://www.itraining.com.au
  Calculate the number of days "d", months "m" or years "y" between two dates
   
293. DateRangeBySpan ( Begin ; End ; Term)
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Robert Schaub, Robert Schaub
http://none.com
  Gives a date range separated by the term you input
   
294. DateRangePast ( refdate; mos )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Atalanta, Imagination Design
http://www.goldapples.com
  Starting with your reference date calculate a range backward x months
   
295. DateRangeVal( LowDate ; HighDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Alex Babkov, Real Evolution
http://www.realevolution.com.au
  Date Range Validation
   
296. DateRangewoWe ( ID ; StartDate ; EndDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Holger Bolecke, fmworks.de
http://www.fmworks.de
  Creates date ranges without weekend days
   
297. DateRSSPubDate ( theDate )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Hal Gumbert, CampSoftware
http://www.campsoftware.com
  Formats the Date as 'Fri, 29 Aug 2008'.
   
298. DateShipByHolidays ( DueDate ; TransitDays ; HolidayList )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com
  Similar to ShipByDate but includes user-entered holidays from a table.
   
299. DatesToMonths ( Date1 ; Date2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Timothy Brown, Antidote Solutions
http://www.antidotesolutions.com
  This show the number of months between 2 dates
   
300. DateTimeAsSerial ( DateTime; ElemSep ; SectSep )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Doug Larsen, August Technology
http://www.AugustTech.com
  Returns the date and time in a TEXT string that can be ordered properly.
   
301. DateTimeString(theDate, theTime)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Don Wieland, D W D a t a C o n c e p t s
http://www.dwdataconcepts.com
  Turns any Date and Time into a STRING to be used for searching by range
   
302. DateTime_From_TimeStamp ( FM_TimeStamp )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Gary Czychi, GC Consulting
http://www.Czychi.com/
  Takes a FileMaker Timestamp value and returns a MySQL DATETIME string
   
303. DateToJD ( thedate ; gregorian )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Theo Ros, *
http://notapplicable.com
  converts a date into a Julian Day number
   
304. DateToSortableText ( thedate )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Theo Ros, *
http://notapplicable.com
  Returns a sortable textual representation of a date value
   
305. DateTranslate ( d ; lang ; format )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  LingoJango, AIB
http://www.aibcnet.com
  Date output in different languages and formats
   
306. DateValues( date1 ; date2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/
  Generates a return delimited list of date for the given range.
   
307. DateValuesStrict ( dateBegin ; dateEnd )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/
  Generate a return delimited list of date for the specified range.
   
308. DateWrittenOut ( datefield )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Jonathan Ray, Richard Carlton Consulting
http://www.rcconsulting.com
  Converts a date field to written text
   
309. DayCounter ( Date_Start ; Date_End; Days_of_Week )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Joshua Morton, JEM Consulting
http://jemconsulting.net
  Counts number of times a day or days occurs over a date range
   
310. DayCounterHolidays ( Date_Start ; Date_End ; Days_of_Week ; Holidays )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Joshua Morton, JEM Consulting
http://jemconsulting.net
  Counts number of types of days between 2 dates excluding holidays
   
311. DayLightSavings ( TargetDate ; TargetTime; Hours )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Tim Brown, Antidote Solutions
http://www.antidotesolutions.com
  Day Light Saving Time
   
312. DaylightSavingsBegins
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Yvonne Dutreaux, Cordblood Registry
http://www.cordblood.com
  Returns the timestamp of beginning of Daylight Savings Time
   
313. DaylightSavingsEnds
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Yvonne Dutreaux, Cordblood Registry
http://www.cordblood.com
  Returns the timestamp of end of Daylight Savings Time
   
314. DayNameDates ( theDayName ; StartDate ; EndDate )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Peter Vinogradov, Peter Vinogradov Consulting
http://petervinogradov.com
  returns a list of dates for "theDayName" that occur between StartDate and EndDate
   
315. DayNameList ( LocaleID )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Theo Ros, n/a
n/a
  Returns a list of Day names according to the given LocaleID
   
316. DayNameToDayOfWeek ( theDayName )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Daniele Raybaudi, ACI
www.aci.it
  returns the day of week of a given day name
   
317. DayOccur ( selDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com
  Calculates what Week Occurence and DayName in a month.
   
318. DayofFiscalYear ( TheDate ; StartingDay ; StartMonth ; StartDay )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Jason L. DeLooze, Nocturnal MicroSystems
http://n/a
  A companion to the WeekofFiscalYear custom function; returns the Day Number of TheDate in the defined Fiscal Year.
   
319. DayofMonthbyWeek ( DayofWeekWanted_Sunday_1 ; WeekWantedasNum ; MonthasNum ; YearasNum )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Yvonne Dutreaux, Cordblood Registry
http://www.cordblood.com
  Find the weekday of a given month by week, ie: the 3rd Wednesday of the Month
   
320. DaysDifference ( Date1 ; Date2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Andrew Sasaki, n/a
n/a
  Returns the number of days difference in two dates; returns a negative number if the second date is earlier than the first.
   
321. DaysDifferenceAbs ( Date1; Date2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Andrew Sasaki, n/a
n/a
  Returns the number of days difference in two dates.
   
322. DaysOfFebruary( myDate )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.developer.no
  Gives you then number of days in February the year of myDate
   
323. DaysToNextBirthday ( birthdate )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Theo Ros, *
http://notapplicable.com
  Returns the number of days to the next birthday
   
324. Days_Diff ( date1 ; date2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Ron Smith, PaperCutPro
http://www.papercutpro.com
  Days difference part between two dates.
   
325. DayWeekYear2Date ( dayNR ; weekNR ; yearNR )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Arjen van der Ree, Maxperts
http://www.maxperts.nl
  Turns DayNr. WeekNr. & Year into a Date
   
326. DCount (inputValues; value)
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Rolf Clausen, Mallverkstan AB
http://www.mallverkstan.com
  Counts the number of values.
   
327. Debug ( )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Matt Petrowsky, ISO FileMaker Magazine
http://www.filemakermagazine.com
  Used to output environment data within a Show Dialog script step.
   
328. Dec2Bin ( decimalNumber ; binaryNumber )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Ronald W. Satz, Transpower Corporation
http://www.transpowercorp.com
  Converts decimal number (positive integer) to binary number
   
329. Dec2Bin9 ( decnum )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  M S Pease,
  Converts a decimal number to its binary equivalent.
   
330. Dec2Hex ( theNumber ; num0s )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Samuel Herschbein, Comsultant
http://www.oz.net/~samh
  Convert Decimal # to Hex Text
   
331. Dec2HexNoLeading0s ( theNumber )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Samuel Herschbein, Consultant
http://www.oz.net/~samh
  Convert Decimal # to Hex Text with no leading zeros
   
332. DecimalAsTime (xDecimal)
 
RatingRatingRatingRatingRating
  Average rating: 1.0
  Michael Bijnens, freelance developer
/
  Convert decimal time ( x,xx ) into normal formatted time ( hh:mm:ss )
   
333. DecimalToFraction ( number )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Michael Myett, FileMaker Apps
http://filemakerapps.biz
  convert decimal numbers to fractions
   
334. DecimalToHrMin ( aNumber )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com
  This CF will return a decimal value in a format of hour and minutes
   
335. DecodeAccents ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Sean Dellis, Technical Designer
http://seandellis.com
  Converts most upper and lower case latin accented characters into standard alphabetical characters.
   
336. DecToAlpha ( decimal )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
  Returns the representation of a decimal number as a variable-length alphabetic text string.
   
337. DecToAnyBase ( decimal ; base )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
  Returns the representation of a decimal (base-10) number in the alphabet of the specified base.
   
338. DectoBin( Dec )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Alexander Baier, FM Tutorial
http://www.fm-tutorial.de
  Calculate decimal into binary
   
339. DecToHexRGB ( Dec )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Federico Severin, Sevesoftware Engineering
http://www.sevesoftware.it
  Converts decimal RGB string to hexadecimal RGB string
   
340. DeDupe ( startstring ; valuelist )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Rob Westergaard, DataStorm Solutions
http://www.datastorm-solutions.com/
  This function removes duplicate values from an alphabetical value list.
   
341. DeduplicateList ( input ; output )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Peter Roots, N/A
N/A
  Removes duplicates from a return-delimited list of values
   
342. DeleteDuplicatesList ( listOfValues )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  HAZI, none
http://hazisarashi.com/
  Delete all duplicate values from a list.
   
343. DeleteMiddleText ( Value ; StringStart ; StringEnd )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Ruben van den Boogaard, Infomatics Software
http://infomatics.nl
  Delete text between markers
   
344. DeleteValue ( list ; index )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Theo Ros, n/a
n/a
  Returns a list with value at position 'index' removed
   
345. DeleteVariableText ( Value ; StringStart ; StringEnd ; Pos ; Start ; End ) )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Daniel Wood, Digital Fusion Ltd
http://www.digitalfusion.co.nz
  Substitute out blocks of text, defined by a start/end string of characters - whose inner contents are of variable width
   
346. DepreciationReducingBalanceRate ( Cost ; ResidualValue ; NoYrsDepreciation)
 
RatingRatingRatingRatingRating
  Average rating: 4.8
  Ed Bullock, Camise Solutions Limited
http://www.camise.co.uk
  Returns the annual rate as a % of depreciation when using the Reducing Balance method of calculationg depreciation
   
347. DepreciationStraightLineAmount ( Cost ; ResidualValue ; NoYrsDepreciation )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Ed Bullock, Camise Solution Limited
http://www.camise.co.uk
  Calculates the value at which an asset depreciates annually when using the straight line method of calculating depreciation
   
348. dfAlphaNumericFilter(Text;ReplaceText)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Caspar Harmer, Digital Fusion Ltd
http://www.digitalfusion.co.nz
  Replace non alphanumeric characters with anything (or nothing)
   
349. DialByWord ( phoneNumberString )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Geoffrey Gerhard, Creative Solutions Incorporated
http://www.creativesltns.com
  Formats a numeric string to match a template supplied as a parameter (i.e. Phone, Social Security, Federal ID formats)
   
350. Dialog OK Cancel ( Position 1; Position 2; Title; Width; Dialog Text
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Brian Hightower, J Hightower, Inc
http://www.homesolution.ws
  24u Dialog with a default OK and Cancel Button
   
351. Dice ( N ; S )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Barbecue, Le Kastelo de Barbakoa
http://www.milleniumhandandshrimp.com
  Generates random integers simulating dice-rolling or coin-flipping
   
352. DifferenceValues(ListA; ListB)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Koen Van Hulle, SHpartners
http://www.shpartners.com
  Returns a single instance of all lines that are in ListA but not in ListB
   
353. Digitise ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  John Bochan, private
private
  Returns same psuedo-random number for same text input
   
354. digitSum( _Zahl )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Alexander Baier, FM Tutorial
http://www.fm-tutorial.de
  The digit sum of a given integer is the sum of all its digits
   
355. DirectionFrom ( Lat1 ; Lon1 ; Lat2 ; Lon2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Chris Pye, Mactec
http://mactec.com.au
  Calculates the approximate direction in cardinal (compass) points from one location on earth to another.
   
356. Distance ( lat1 ; lon1 ; lat2 ; lon2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Dmitriy Bogdan, CIA
http://fmpug.ru
  Calculate distance between two geo points in kilometers.
   
357. DistanceBetweenPoints ( Lat1; Lon1; Lat2; Lon2; Units )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Vaughan Bromfield, Vaughan Bromfield Design
http://www.google.com.au/
  Calculates the distance between any two points on Earth.
   
358. DistanceGeoCoord ( Lat1deg ; Lat1mm ; Lat1ss ; Lon1deg ; Lon1mm ; Lon1ss ; Lat2deg ; Lat2mm ; Lat2ss ; Lon2deg ; Lon2mm ; Lon2ss ; U ; Version )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Edward_Souza, n/a
n/a
  Measure the distance between two geographic coordinates
   
359. DistanceList ( BaseLat ; BaseLong ; ListOfLatLongIdentifiers ; Delimiter ; Units ; SortableDistance )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Hal Gumbert, CampSoftware
http://www.campsoftware.com
  Prefixes a Value List containing Latitude, Longitude, and an Identifier with the Distance to the Base Lat, Long
   
360. Distribution( uniqueList; dataList)
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Bruce Robertson, Concise Design
http://concise-design.com
  For each item in list 1, counts occurrences in list 2
   
361. DistributionTR ( uniqueList; dataList)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Bruce Robertson, Concise Design
http://concise-design.com
  For each item in list 1, counts occurrences in list 2
   
362. DQ_Count ( deque )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Stephen Hanna, Stephen J. Hanna Consulting
http://www.sjhanna.com
  Returns the number of items in a deque (stack, queue)
   
363. DQ_New ( initialContents )
 
RatingRatingRatingRatingRating
  Average rating: 2.0
  Stephen Hanna, Stephen J. Hanna Consulting
http://www.sjhanna.com
  Creates a double-ended queue (DeQue)
   
364. DQ_Push ( deque ; value )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Stephen Hanna, Stephen J. Hanna Consulting
http://www.sjhanna.com
  Push an item onto the front (top) of a double-ended queue
   
365. DQ_Put ( deque ; item )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Stephen Hanna, Stephen J. Hanna Consulting
http://www.sjhanna.com
  Puts a new item at the front of a deque or queue
   
366. DuoTrigesimalToNum ( DTGString )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Tim Griffith, None
None
  Converts Duotrigesimal strings into numbers
   
367. DupesInList ( ValueList )
 
RatingRatingRatingRatingRating
  Average rating: 2.5
  Daniele Raybaudi, ACI
http://www.aci.it
  Returns duplicate values from a list.
   
368. EANofISBN ( pool ; ISBNnr )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Reinder Wolting, ABECON
http://www.abecon.nl
  Generate the EAN barcode for the given ISBN#
   
369. Easter ( myDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Mike Duncan, Duncan Creations
http://www.duncancreations.com
  Show when Easter falls in the calendar year for any given date.
   
370. Easter ( theYear )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Reinder Wolting, ABECON
http://www.abecon.nl
  Calculates the date of Easter sunday of a given year
   
371. Easter ( theYear, method )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Lewis C. Lorenz, Lorenz Companies
www.LorenzCom.com
  Returns Julian, Orthodox, or Gregorian Easter dates for years 326 to 4000 (or 4099).
   
372. Easter ( y )
 
RatingRatingRatingRatingRating
  Average rating: 2.3
  Phil Caulkins aka PhilModJunk, Caulkins Consulting
Http::www.Don'tHaveASite
  Given the year, Y, computes the Easter date for years 1583 to 4099
   
373. Easterday ( Date )
 
RatingRatingRatingRatingRating
  Average rating: 4.7
  Johan Söderberg, Distingo
http://www.distingo.nu
  Calculates the date for any easterday according to Gauss formula.
   
374. Easter_Sunday ( TheYear )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Menno van Beek, STB Automatisering & Advies BV
http://www.stb.nl
  Calculate gregorian easter sunday method by Gauss
   
375. EDATE ( evalDate ; months )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Jorge Kluchnik,
  Replicates the EDATE function from Excel
   
376. Edate ( thedate ; months )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Barry Maskell, Real Estate Navigator
http://www.realestatenavigator.com.au
  Excel style EDATE function
   
377. EightBall ( Question )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Chris Kubica, Application Architects, LLC
http://www.applicationarch.com
  Ask the Eightball a Question and Get An Answer
   
378. Elapsed ( StartDate ; EndDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Lee Smith, Smith and Associates
none
  Elapsed Date to Text
   
379. ElapsedbyIno ( StartDate ; EndDate ; Type )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Aleksandar Rubeša, Q.com doo
http://q-com.hr
  For rest of us ISO: D M Y or ANSI: Y M D
   
380. ElapsedTime ( TStampBegin; TStampEnd; Format )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Geoff Wells, DataIsland Software LLC
http://www.dataisland.com
  Calculates elapsed time from Timestamps
   
381. ElapsedTime_CFpub( tsStart ; tsEnd)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  James Hea, None
None
  Elapsed Time in Years, Months, Days, Hours, Minutes and Seconds
   
382. EliminatePrefix ( value; prefix )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Martin Brunner, Zurich Financial Services
http://www.zurichconnect.ch
  Recursively eliminate any prefixes
   
383. EmailAddressProper ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Esa Niiniranta, Bittihiisi
http://bittihiisi.net
  Returns the proper form of an email address
   
384. EmailName ( account )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Dwayne Wright, dwaynewright.com
http://www.dwaynewright.com
  Returns the name associated with the email (sans domain)
   
385. Employ (StartDate, EndDate)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Pascal Dimopoulos, Primary School Education
http://uesrs.otenet.gr/~dnapas
  Estimates the employment time between two dates.
   
386. EmptyRep ( field )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Tom Guise, Siso Systems
http://www.sisosystems.co.uk
  Returns the repetition number of the next empty repetition of a repeating field
   
387. EnclosingObjects (_objectName )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  not recursive. A list of all enclosing objects of a layout object.
   
388. Encode ( text ; code ; startValue )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Daniele Raybaudi, ACI
www.aci.it
  A simple encoder
   
389. encodeEmail ( email ; rName )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Hunter Chisholm, Protean Solutions
http://proteansolutions.com/
  Encode HTML mailto link as hexadecimal string
   
390. EncodeURL_CF ( textToCode )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Paul Spafford, Spafford Data Solutions
http://www.paulspafford.com
  Encodes all urls enclosed in square brackets for html.
   
391. EncryptDate (TheDate)
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Ibrahim Bittar Torres, Eikonsys
http://www.eikonsys.com
  Converts a date in a pseudo activation code format
   
392. endDate(theDate; months)
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Tim Brown, Antidote Solutions
http://www.antidotesolutions.com
  Calc the end date based on number of months to preserve the day of month.
   
393. EnDeCoder( Text ; Code2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Charles Garr, cgarr software
http://havenone.com
  Simple decoder and encoder in one
   
394. eParse ( text )
 
RatingRatingRatingRatingRating
  Average rating: 2.2
  d.schellenberg, rivet design communications
http://www.rivetcom.ca
  parse an e-mail addres from a string of text
   
395. ErrorCode( ErrorNum )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com
  Updated Filemaker Error codes to english
   
396. ErrorDescription (errorNumber)
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Andrew Duncan, Databuzz
http://www.databuzz.com.au
  Returns the English description for the FileMaker Pro v12 error number returned by the Get(LastError) function
   
397. ErrorDescription v13 ( errorNumber )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Andrew Duncan, Databuzz
http://www.databuzz.com.au
  Returns the English description for the FileMaker Pro v13 error number returned by the Get(LastError) function
   
398. ErrorFunctionInverse ( x )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Jeremy Bante,
http://github.com/jbante
  Calculates the inverse error function via Taylor series expansion
   
399. ErrorJP_11 ( ErrorCode )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Koji Takeuchi, Splash, Inc.
http://www.splash.jp/
  Return Description of specified Error Code of FMP11 in Japanese.
   
400. ErrorToEnglish ( ErrorNum )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Jeremiah Small, Soliant Consulting
http://jsmall.us
  Translate FileMaker error codes to the English language description.
   
401. EscapeForOsascriptShell ( escapeThis )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Daniel A. Shockley, NYHTC
http://www.nyhtc.org
  Escapes a value so that it can be used in a nested AppleScript/shell/AppleScript command
   
402. EscapeXML ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Ibrahim Bittar, Eikonsys, S.A. de C.V.
http://www.eikonsys.com
  Simple function to escape characters for XML
   
403. EvalCalcInserts ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Koji Takeuchi, Splash, Inc.
http://www.splash.jp/
  Replace "Calc" to value of Calc Evaluated.
   
404. Even Odd Week Today
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Steve Lelle, Steve Lelle Enterprises, Inc.
http://lelle.com
  Returns "Odd" or "Even" for Currant Date
   
405. EvenCharacters ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Daniele Raybaudi, ACI
www.aci.it
  Returns even-numbered characters of text.
   
406. EventCount ( DateBegin ; DateEnd ; Frequency ; When )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/
  Counts the number of times a repeating event will occur between two dates.
   
407. Ex@ct ( originalText ; comparisonText ; wildChar )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Compares two text strings, allowing for a wildcard character.
   
408. ExcelNumberToTime ( ExcelNumber)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Daniele Raybaudi, ACI
www.aci.it
  Returns the time in correct format for FM
   
409. Exclude ( TextToFilter; FilterText )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html
  Exclude the characters to be filtered
   
410. ExitLoop ( ExitValue ; LoopLevel )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Arend van Asselt, Easy to Work
http://www.easytowork.com
  Exits loop when $i = ExitValue
   
411. ExplodedKey ( ID ; StartDate; EndDate )
 
RatingRatingRatingRatingRating
  Average rating: 2.1
  Darren Terry, Pacific Data Management
http://pdm-inc.com
  Combines a text constant (ID) with each date in a date range to make a multi-key that has the text constant on each line
   
412. ExplodedString ( Field )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  David Woodyard, Woody Digital
http://www.woodydigital.com
  Generates a multi-key field containing all leading characters of each word from a string of text entered into a text field.
   
413. ExplodedString_Work( field )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Michael Alexander, none
no website
  Exploded String Variant
   
414. ExtractData ( XML ; Attribute ; Instance )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Andy Knasinski, NRG Software
http://www.nrgsoft.com/
  Extract specific data out of XML formatted text without using FileMaker's built-in XML functionality.
   
415. ExtractEmailAddresses ( text ; placeholder )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Bart Bartholomay, HAB Marketing
http://habmarketing.com
  Extract Email Addresses
   
416. ExtractEmails ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Ilya Shuvalov, SUI Solutions
http://filemaker.suisolutions.com
  Extracts list of e-mails found in Text
   
417. ExtractFromText( TextBody ; keyText )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Tim Anderson, TAg
http://www.timanderson.co.uk/
  Returns strings/values from text
   
418. ExtractLine ( TextField ; LineNumber )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Michael Haymore, N/A
http://www.my-xanadu.net
  Return a specific line out of a text field.
   
419. ExtractPhoneNumbers ( text ; placeholder )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Bart Bartholomay, HAB Marketing
http://habmarketing.com
  Extract Phone numbers
   
420. ExtractPortion ( textField ; prePortion ; postPortion )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Doug Elam, US Home Systems, Inc.
http://www.ushomesystems.com/
  Extract a portion of a text field
   
421. ExtractTableCell ( HTML ; cellNumber )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Returns the contents of the specified cell in HTML table.
   
422. ExtractXMLAttributeList__cf ( _xml ; _attribute ; _instance )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Steve Hearn, CoreSolutions Software Inc
http://coresolutions.ca
  Extracts a list of values that are contained within the XML attribute tag
   
423. FadeGreentoRed ( text ; score ; lowest ; highest )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Ryan Brandys, Branmuffin Industries
http://www.branmuffinindustries.com
  Adjusts the color of 'text' between greeen->yellow->orange-red based upon the 'score' value.
   
424. FahrToCels ( degreesFahrenheit )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Brian Dunning, BrianDunning.com
http://www.briandunning.com/
  Converts degrees Fahrenheit to degrees Celsius.
   
425. FastDateInput ( input ; format )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  Allows user to input a date faster
   
426. FastTimeInput ( _Time )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Paul Sazonov, APS
http://www.briandunning.com/
  Fast time input
   
427. fechaDesdeTexto ( texto )
 
RatingRatingRatingRatingRating
  Average rating: 2.3
  Emilio Luengo, Emilio Luengo
http://www.briandunning.com
  returns a date as text from a text entered
   
428. Fedex_Country ( Country )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Yvonne Dutreaux, CBR
None
  Converts country name into the two character country code used by FedEx
   
429. Fibonacci ( n )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Steve Allen, Richard Carlton Consulting, Inc.
http://www.rcconsulting.com
  Formula calculation of the number at n in the Fibonacci sequence. No recursion.
   
430. Fibonacci ( N )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Rob Poelking, Excelisys
http://www.excelisys.com
  Nth result of the Fibonocci series
   
431. Fibonacci ( Seed1; Seed2; Iterations )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Geoff Wells, DataIsland Software LLC
http://www.dataisland.com
  Returns a Fibonacci series
   
432. FieldAndContentList ( TypeField ; AddFieldList ; Contain ; NotContain ; TagField ; TagValue ; EmptyValue )
 
RatingRatingRatingRatingRating
  Average rating: 4.7
  Agnès Barouh, Tic Tac
http://http://www.tictac.fr/CoinFileMaker/Page.html
  returns field names and contents of all the field are on a layout (repeatingField and related records included)
   
433. FieldBeginsWith ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Andrew Persons, Excelisys
http://www.excelisys.com/
  Creates a multikey field containing all the increments of the beginning of the supplied text.
   
434. FieldMaxRepetitions ( Field )
 
RatingRatingRatingRatingRating
  Average rating: 2.3
  HAZI, none
http://hazisarashi.com
  Returns the number of Repetitions of the field maximum.
   
435. FieldNames2FieldValues ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Ilya Shuvalov, SUI Solutions
http://filemaker.suisolutions.com
  Replaces field names with field values in Text
   
436. FieldRepeats ( repeatingField ; 1 )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Theo Ros, n/a
n/a
  Returns the true number of repetitions for a repeating field
   
437. FieldRepeatsByName ( "fieldName" )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Theo Ros, n/a
n/a
  Returns the true number of repetitions for a repeating field
   
438. FilenameContainer ( ContainerAsText )
 
RatingRatingRatingRatingRating
  Average rating: 2.3
  Hal Gumbert, CampSoftware
http://www.campsoftware.com
  Returns a FileMaker Container Field Filename.
   
439. FilePathToHFS ( FMFilePath )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Tom Robinson, Kōwhai Computing
http://www.tomrobinson.co.nz/
  Convert from FileMaker filepath to HFS filepath (superseded by FilePathToOS)
   
440. FilePathToOS ( FMFilePath )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Tom Robinson, Kōwhai Computing
http://www.tomrobinson.co.nz/
  Convert from FileMaker filepath to OS filepath (HFS or NTFS)
   
441. FilePathToURL ( FMFilePath )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Tom Robinson, Kōwhai Computing
http://www.tomrobinson.co.nz/
  Convert from FileMaker filepath to URL
   
442. FillProperties (PropertyList ; PropertyValues ; Separator ; Blanks)
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Peter Vinogradov, Peter Vinogradov Consulting
http://www.petervinogradov.com
  Populates a full property list from a potentially incomplete list of values
   
443. FilterASCII ( text ; extended )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Removes characters from text, retaining only printable ASCII characters.
   
444. FilterC ( text ; AZaz09etc )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Thomas Seidler, The Good Book Company
http://www.harmlesswise.com
  not quite a regex filter, but easier than
   
445. FilteredPortalList ( fieldObjectName ; startingPortalRow )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Howard Schlossberg, FM Professional Solutions
http://fmprosolutions.com
  Returns a field from each row of a FILTERED portal, up to the first blank row
   
446. FilterFileName ( text ; filetype )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Michael Myett, FileMaker Apps
http://filemakerapps.biz
  filtering field contents as a file name when exporting record set to Excel or Acrobat file
   
447. filterLines(filterField;filterValue;Result)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Rob Atkinson, Webwyz Systems
http://www.webwyzsystems.com
  Examines a list of values, removing lines that do not contain a given filter value.
   
448. FilterList ( beginsWith ; oldList ; newList ; iteration )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Chris McCue, Chris McCue
http://www.imccue.com
  This recursive function will take a list and return a new list without list values that start with the supplied beginsWith string.
   
449. FilterList ( ListA ; Attribute ; ListB ; CaseSensitive )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html
  to compare and filter values, lists with different attribute : Equals - NotEquals - Contains - NotContains - BeginsWith - NotBeginsWith - NotEndsWith - EndsWith
   
450. FilterListItems_Filtrate.cf( MyList ; FilterList )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Jonathan Jeffery, igeek
http://www.igeek.co.uk
  Opposite of Filtervalues
   
451. FilterValuesByTest ( text ; varName ; test ; include_1 )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  Returns a text filtered by a test
   
452. FilterWordsByTest ( text ; varName ; test ; include_1 ; mode )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  Returns a text filtered by a test
   
453. Filter_Stopwords ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Thomas Seidler, The Good Book Company
http://www.harmlesswise.com/it
  simple one function stopwords remover
   
454. FindDay (StartDate;EndDate;DayN)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Priyabrata Sahoo, Mindfire Solutions, Mindfire Solutions
http://www.mindfiresolutions.com/
  Find Dates for week days in an Data range.
   
455. FindInList( array; value )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Michael Rhodes, Allied Data Service
http://allieddataservice.com
  Get the valuenumber of a value in a list
   
456. FindMonday(input)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Darrin Morton, Neocode Software
http://www.neocodesoftware.com
  finds date of Monday in week of any given date
   
457. FindRepetition ( searchString; repeatingField; start; occurrence; end; partialMatch ; matchCase )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Peter Wagemans, SHpartners
http://www.shpartners.com
  Calculates the repetition number where a search string can be found in a repeating field
   
458. FindValues ( list ; searchString ; matchcase )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Theo Ros, n/a
n/a
  Returns a list of all values from the original list that contain the given search string.
   
459. FindValues ( Values ; Pattern )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Koji Takeuchi, Splash, Inc.
http://www.splash.jp/
  Return values including Pattern.
   
460. FirstBlankRepetition ( RepeatingField ; StartingRepetition )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Brian Dunning, BrianDunning.com
http://www.briandunning.com
  Finds the first blank repetition in a repeating field.
   
461. FirstCapitalPosition ( text ; textLength )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Marc Wood, studentpress.org
http://studentpress.org
  finds first capital letter position in text
   
462. FirstDayThisWeek ( StartDay )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Matt Wills, Virtual Vermont
http://www.virtualvermont.com/FMP/
  Date of first day of current week
   
463. FirstMonday ( themonth ; theyear )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Theo Ros, *
http://notapplicable.com
  Returns the date for the first Monday in a given month
   
464. FirstQuartile ( valueList )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Daniele Raybaudi, ACI
www.aci.it
  returns 1st quartile of a value list
   
465. FiscalQuarter ( date ; startingMonth ; startingDay ; nameByEnd )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Returns the fiscal year and quarter in which date occurs.
   
466. FiscalYear ( TheDate ; FYStartMonth )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Mike Zarin, Mike Zarin Consulting
http://www.mikezarin.com
  Enter a date and FY starting month and the function will give as result the fiscal year the date belongs to.
   
467. FiveCharsPermutations(text;number)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Daniele Raybaudi, ACI
www.aci.it
  Returns all 120 simple permutations of the five characters of the field
   
468. FiveFieldsPermutations (field1;field2;field3;field4;field5;number)
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Daniele Raybaudi, ACI
www.aci.it
  Returns all 120 simple permutations of the contents of five fields
   
469. FixedLength ( text ; char ; charsNumber ; align )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Daniele Raybaudi, ACI
www.aci.it
  Returns a fixed length string.
   
470. Fixed_DecimalDigits ( Num ; DecCount )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  AnKe, N/A
N/A
  format a number to a predefined number of decimal digits - recursive
   
471. FlagGender ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Peter Vinogradov, Peter Vinogradov Consulting
http://www.petervinogradov.com
  Flags gender pronouns in text with caps and brackets.
   
472. FlexCeiling ( number ; precision )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Kevin Frank, Kevin Frank & Associates
http://www.kevinfrank.com
  An expanded "Ceiling" that accepts a precision argument
   
473. FlexFloor ( number ; precision )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Kevin Frank, Kevin Frank & Associates
http://www.kevinfrank.com
  An expanded "Floor" that accepts a precision argument
   
474. FlipACoin
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Chris Kubica, Application Architects, LLC
http://www.applicationarch.com
  Auto Enter The Result of a Coin Flip Into a Text Field
   
475. FlipDigits ( value )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Theo Ros, *
http://notapplicable.com
  flips decimal digits for textual sort purposes
   
476. FMGrowl(title, description, sticky, message)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Douglas Alder, HomeBase Software Publishing Ltd.
http://hbase.net
  Add Growl notification to your FileMaker solutions.
   
477. FMP7ProtocolRegFix
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Andrew Butt, Drewsol
http://www.drewsol.com
  This CF returns the text contents of the Windows registry file needed to re-associate the FMP7 protocol with the user's installed FileMaker Pro application. For instructions: http://www.drewsol.com/fmtips/fmtip_fmp7_registry_fix.php
   
478. FMPToTRIO( FMP_GetPath )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com
  Converts FMP GetPaths to TROI File Plug-in Paths
   
479. FM_Name_ID ( _Name_ID ; _TLFSV ; _fileName ; _layoutName )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  Returns FileMaker item Name or ID, given the other
   
480. fnAddressParser ( address ; type )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Andrew Butt, Drewsol
http://www.drewsol.com
  This CF parses address parts, allowing developers to create calculation fields for single address fields for display and sorting.
   
481. fnALSourceParse ( source ; attribute )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Jeremy Upton, DME Supply Group
http://www.dmesupplygroup.com
  Returns a list of values for the supplied attribute from the source code of a webpage. See - fnHTMLAttributeList
   
482. FNameLNameOrg ( FName ; LName ; Org )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com
  Helps to parse different combinations of entries for a Name Display.
   
483. fnBMI ( Height ; Weight )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Travis L Herring, Travis L Herring MD PA
http://drherringmd.com
  Compute Body Mass Index (BMI) from Height (in) and Weight (lbs)
   
484. fnCalendar ( date_field ; option ; iteration ; x_start_on_monday ; x_highlight_weekends ; holiday_list )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Drew Wesley, Drewsol
http://www.drewsol.com
  c. 2009-2012 Drewsol. This CF consolidates a simple calendar display and selection tool complete with limitless iterations, highlights, holidays, and tooltips.
   
485. fnCalendarLite ( date_field ; option ; iteration ; x_start_on_monday ; x_highlight_weekends ; holiday_list )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Drew Wesley, Drewsol
http://www.drewsol.com
  fnCalendar minus documentation and integrated holiday list.
   
486. fnGetExcelColumnName ( rep )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Drew Wesley, Drewsol
http://www.drewsol.com
  Converts numbers to related Excel column names (ie. 1 = A, 2 = B, 27 = AA, 28 = AB...)
   
487. fnGoogleLineChart ( chtitle ; xtitle ; ytitle ; xfield ; yfield ; color )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Jeremy Upton, DME Supply Group
http://www.dmesupplygroup.com
  Extremely simple line chart solution using a web viewer and Google API
   
488. fnGoogleMap (Address; City; State; Zip; Zoom)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Jeremy Upton, DME Supply Group
http://www.dmesupplygroup.com
  (updated: 4/15/2014) Shows embedded (map only portion) Google Map within a web viewer object. No API required!
   
489. fnHTMLAttributeList ( object ; attribute )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Jeremy Upton, DME Supply Group
http://www.dmesupplygroup.com
  To be used with the custom function - fnALSourceParse
   
490. fnLatLon.bearing ( lat1 ; lon1 ; lat2 ; lon2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Michael George, Michael George Consulting
mailto:mgeorge@coresupport.com
  Calculates initial bearing between two points on Earth's surface.
   
491. fnNameParser ( name ; type )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Andrew Butt, Drewsol
http://www.drewsol.com
  c. 2012 Drewsol. This CF parses specified name parts (first, last, middle) from a single name field for the flexibility of sorting and/or display. fnNameStraight now handles Spanish names, and some middle-eastern names.
   
492. fnNumberFormat ( number ; decimals ; dec_point ; thousands_sep )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Andrew Butt, Drewsol
http://www.drewsol.com
  This CF simply emulates PHP's number_format() function using identical parameters (http://us2.php.net/number_format).
   
493. fnPhone(text)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Timothy Trimble, Data Design Labs
http://www.DataDesignLabs.com
  Phone Number Formatting
   
494. fnRandom ( minValue ; maxValue )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Rob Poelking, Excelisys
http://www.excelisys.com
  A better random, between a min and max value
   
495. fnSetGlobalVar ( Name; Value )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Rob Poelking, Excelisys
http://www.excelisys.com
  Dynamically sets a global variable with a single script line.
   
496. fnVertexAngle ( sides ; base )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Michael George, Michael George Consulting
mailto:mgeorge@coresupport.com
  Calculate the angle the vertex of an isosceles triangle.
   
497. ForceZero ( NumExpression )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com
  Forces a number calc field to display zero if is empty
   
498. format.UkTelNumber ( telNo )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Tim Anderson, Tim Anderson Group
http://www.timanderson.co.uk
  A function to format phone numbers into my preferred uk format
   
499. formatAmount( amount ; decimalSign )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Martin Spanjaard, Trias Digitaal
http://www.triasdigitaal.nl
  Formats an amount. Needs my other custom function formatN
   
500. FormatAsDate ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Daniele Raybaudi, ACI
www.aci.it
  Returns the given text as the valid complete formatted date: gg/mm/aaaa
   
501. FormatAsFileName ( text ; extension ; lengthLimit )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Jonathan Mickelson, Thought Development Corp.
http://thought-dev.com
  Simplifies concatenation of a data into a suitable length OS filename.
   
502. FormatAsPrice ( input ; separator ; currency ; Leading_1 )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  text formatting
   
503. FormatDate( DatetoFormat )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Catherine Dillimore, Digital Fusion Ltd
http://www.digitalfusion.co.nz
  //Returns Mon, Dec 8
   
504. FormatDateAsText ( baseDate ; Format )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Eilert Sundt, Eilert Sundt Systemdesign
http://www.eilert.no
  Formats a date with a specifiable format
   
505. FormatDateLocale ( thedate ; formatstring ; LocaleID )
 
RatingRatingRatingRatingRating
  Average rating: 2.6
  Theo Ros, n/a
n/a
  Formats a date according to a Format string and a given language ID
   
506. FormatDateTime ( dateValue, timeValue, format )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Lewis C. Lorenz, Attorney at Law
http://www.LorenzCom.com
  Returns the dateValue or timeValue formatted as specified in format, using PHP-like coding, and allowing for escaped non-formatted text.
   
507. FormatLike ( text ; template )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Peter Vinogradov, Peter Vinogradov Consulting
http://www.petervinogradov.com
  Applies the formatting of 'template' to 'text'
   
508. FormatList( TheList ; Adjust ; LenX )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Therese Telepski, Art + Promotion
http://www.art-promo.de
  Format of every element of a given List
   
509. FormatMonthName ( monthTxt )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Tim Cimbura, Cimbura.com LLC
http://www.cimbura.com
  Returns a fully written out month name from an abbreviation or numeric value
   
510. formatN ( naturalNumber ; separator )
 
RatingRatingRatingRatingRating
  Average rating: 4.7
  Martin Spanjaard, Trias Digitaal
http://triasdigitaal.nl
  formats a natural number with thousand separators
   
511. FormatNumber ( Number ; ThousandSep ; DecSep )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  SL, ITC
  The passed valueNumber is formatted with the passed Thousand & Decimal separators
   
512. FormatNumber ( number, format )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Lewis C. Lorenz, Lorenz Companies
www.LorenzCom.com/software
  Returns text string of number in the requested format. Function allows complete FileMaker Pro number formatting using an intuitive free-form format structure.
   
513. FormatNumberAsText ( number ; currency ; separator ; decimal ; precision )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Geoffrey Gerhard, Creative Solutions Incorporated
http://www.creativesltns.com
  Number to text, padded/rounded to a specified number of decimal places
   
514. FormatNumbers ( Number )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Emily Parks, Bulldog Marketing
http://www.bdogm.com
  Formats Numbers by rounding them and placing thousand separators where they should be.
   
515. FormatNumber_Sub ( Number ; Counter ; ThousandSep )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  SL, ITC
  Needs
   
516. FormatOneLine ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Tim Cimbura, Cimbura.com LLC
http://www.cimburatech.com
  Formats entered text as one line removing formatting, extra returns, tabs, and spaces
   
517. FormatPercent ( Number ; Decimals )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Will Loving, Dedication Technologies, Inc.
http://dedicationtechnologies.com
  Formats a number as a percentage text string with specified number of decimal places
   
518. FormatPhone ( phone )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Sravan Puttagunta, Mann Consulting
http://www.mann.com
  Auto formats all US based phone numbers, along with extensions.
   
519. FormatPhone ( PhoneIn; AreaCode )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Chris Harvey, Bank of Bermuda
http://www.bankofbermuda.bm
  Masks or refomats North American phone numbers
   
520. FormatPostcodeNL ( TheCode )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Henk Brendel, Data 33
http://www.data33.nl
  Function for formatting dutch postcodes
   
521. FormatSWEPhone ( phone )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Rolf Clausen, Mallverkstan AB
http://www.mallverkstan.com
  Format a phone number according to Swedish standards.
   
522. FormattaPhone( num )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Massimo, Risca
http://www.gescom.it
  Format phone for Italian Standards
   
523. FormattedBytes ( Bytes ; Rounding ; bitsOrBytes ; DecimalOrBinaryIEC )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Stefano Monti, Plan Art
http://www.planart.it
  Convert bit and byte to a formatted output
   
524. FormattedNumber ( number ; thousandSep ; red )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Daniele Raybaudi, ACI
www.aci.it
  Returns any gived number as a number formatted with thousand and decimal separators.
   
525. FormatTelNL ( TelNr ; Divider )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Henk Brendel, Data 33
http://www.data33.nl
  Format telephone nrs from the perspective of dutch users
   
526. FormatThousands ( Number ; Precision ; Separator )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Rob Poelking, Excelisys
http://www.excelisys.com
  Formats a number separating the thousands by a user specified character.
   
527. formatTime ( numbersOnlyMilitaryTime )
 
RatingRatingRatingRatingRating
  Average rating: 4.8
  Timothy Hall, beezwax datatools, inc.
http://beezwax.net
  Takes input of numbers (only) and converts to properly formatted military time
   
528. FormatTimestamp ( format ; tstamp )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Tim Mansour, Neologica Print & Promotions
na
  Formats a time/date any way you like using a format string
   
529. FormatTimestamp ( _ts ; _f )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Thomas Seidler, The Good Book Company
http://harmlesswise.com/it
  PHP standards 4 timestamp, date and time formatting
   
530. FormatTimestamp( TheTimestamp; FormatString
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Charles Ross, Charles Ross
http://homepage.mac.com/chivalry/resume.html
  Uses the flags available in the Unix date tool to format a timestamp.
   
531. Formatting ( text ; styles )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Rob Westergaard, DataStorm Solutions
http://www.datastorm-solutions.com/
  This function applies text formatting using a variable input field.
   
532. Format_Expr ( ExpirationDate )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Kevin Bache, None
www.none.com
  Formats a credit card expiration date, returning it in the form "MM/YY"
   
533. Format_Text_LikeTemplate__CFpub ( aString ; aTemplate )
 
RatingRatingRatingRatingRating
  Average rating: 2.2
  Toby Beedell, na
http://na
  Use to Format Numbers or Text for displaying in a structured way, for instance Phone Numbers or Bank Codes
   
534. FormulaCall(formula; param)
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Bruce Robertson, Concise Design
http://concise-design.com
  Universal custom function - write your function outside the CF editor
   
535. FoundList ( field ; start )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Eilert Sundt, Eilert Sundt Systemdesign
http://www.eilert.no
  List the values of a field across a found set
   
536. Fraction ( number )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Theo Ros, *
http://notapplicable.com
  Returns a number as fraction text.
   
537. Fraction ( _a_b ; _operator ; _c_d )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Thomas Seidler, The Good Book Company
http://www.harmlesswise.com/it
  Enables common fraction operations, keeping results in fractions.
   
538. FractionDenominator( fraction )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Brett Buchmiller, None
www.Filemaker.com
  Extracts denominator from a string representing a fraction
   
539. FractionMath( fraction1 ; Fraction2 ; Operator )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Brett Buchmiller, None
www.filemaker.com
  Allows basic mathematical operations leaving fractions in fractional form, reduced form.
   
540. FractionNumerator
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Brett Buchmiller, None
www.filemaker.com
  Extracts numerator from a string representing a fraction.
   
541. FractionReduce( fraction )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Brett Buchmiller, None
www.filemaker.com
  Takes string representing fraction and reduces it to most simple form.
   
542. FractionToDecimal( fraction )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Brett Buchmiller, None
www.filemaker.com
  Convert fraction string to decimal
   
543. FractionType( fraction )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Brett Buchmiller, None
www.filemaker.com
  Reports from string if a valid fraction and if improper or mixed number
   
544. FriendlyPasswords
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Douglas Alder, HomeBase Software
http://www.hbase.net
  Generate more memorable passwords from user selected phrase
   
545. FrontTabs( layoutObjects; parent )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Bruce Robertson, Concise Design
http://www.concise-design.com
  Provides a list of frontmost tab(s) and any enclosed selected tabs
   
546. FrontTabsPanelsList ( Layout )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html
  Returns a list of front and visible Tabs panels on a layout.
   
547. FTPCopy ( URL ; user ; password ; directory ; file ; localdirect
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Greg Torok, Northwest Radiologists
http://nwrads.com
  Creates a calculated Applescript to copy a file from a directory on an FTP server to a local folder.
   
548. FTPdelete(remotePath, host, user, password)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Nico, NicoWeb
http://www.nicoweb.com
  delete remote file via FTP
   
549. FTPDownload ( remotePath ; localPath ; host ; user ; password )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Mark DeNyse,
  Downloads a file from the specified FTP directory.
   
550. FTPList ( URL; user; password; directory)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Greg Torok, Northwest Radiologists
http://nwrads.com
  Creates a calculated Applescript to get the contents of an FTP server directory and copy to the clipboard.
   
551. FTPMove ( URL ; user ; password ; directory ; file ; localdirect
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Greg Torok, Northwest Radiologists
http://nwrads.com
  Creates a calculated Applescript to move a file from a directory on an FTP server to a local folder and delete the original from the FTP server.
   
552. FTPUpload ( URL ; user ; password ; directory ; file ; localdirectory ; localfile )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Alan Deffenderfer, ABD Booksellers
http://www.abdbooksellers.com
  Function to Upload file using curl and applescript
   
553. func_ActiveTab
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Michael Kupietz, Michael Kupietz, FileMaker Pro Consultant
http://www.kupietz.com
  Return the number of the currently active tab in a tab object
   
554. FutureDate ( text)
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Jeff Yurka, Real Mac Solutions
http://yurka.net
  Allow user to speedily enter dates using codes. Field must be text.
   
555. FYQ ( Start ; theDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Matt Wills, Virtual Vermont
http://www.VirtualVermont.com/FMP
  Fiscal year and quarter of a given date
   
556. FYQ( StartMonth; StartDay; theDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Tim Brown, Antidote Solutions
http://www.antidotesolutions.com
  Determine Fiscal Quarter
   
557. Gaussian ( _x ; _height ; _center ; _sigma )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Thomas Seidler, The Good Book Company
http://harmlesswise.com/it
  Gaussian function to enable a controllable bell shaped graph.
   
558. gCalender ( vPara )
 
RatingRatingRatingRatingRating
  Average rating: 2.5
  Matijas Federspiel, ComZuWeb-Datasystem
http://www.comzuweb-datasystem.de/
  genius Kalender (ala ABAS)
   
559. gcd( _a ; _b)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Alexander Baier, FM Tutorial
http://www.fm-tutorial.de
  Greatest Common Divisor
   
560. GCF ( A ; B )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Scott Morrison, InDev
http://www.indev.ca
  Greatest Common Factor of two numbers
   
561. GeneratePW ( Digit ; Option )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Koji Takeuchi, Splash, Inc.
http://www.splash.jp
  Generate random password string.
   
562. GeoBox(latitude;longitude; radius)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Steve Murray, Steve Murray
http://www.nurse.tv
  Calculates latitude and longitude boundaries at radius of a location.
   
563. GeoBoxBounds ( latitude ; longitude ; radiusInMeters )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Jeremy Bante,
https://github.com/jbante/
  Calculates coordinates for search bounding box around a location
   
564. GeoDistance ( latitude1 ; longitude1 ; latitude2 ; longitude2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Jeremy Bante,
https://github.com/jbante/
  Distance between two geo-spatial coordinates
   
565. GestationalAge(date)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Rafael Burgos, USAF
http://www.af.mil
  Calculate number of weeks and days from a given last menstrual period
   
566. GestationalAgeEDD(date)
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Rafael Burgos, USAF
http://www.af.mil
  Calculate number of weeks and days from a given last menstrual period
   
567. Get3PixColumnState
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  returns 1 if the 3 pixel wide column next to the status area is turned on
   
568. getActiveSelection
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Bob Majors, na
na
  Returns selection in a text field.
   
569. GetAge ( birthdate )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Danny Leung, Bloomington Public Schools
http://www.bloomington.k12.mn.us
  Calculates the number of years, months, & days based on your birthdate
   
570. GetAsArabic( romanNumber )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Jeremy Bante, OshVay Systems, Inc.
http://www.oshvay.com
  GetAsArabic( romanNumber ) returns the arabic number equivalent for a roman number.
   
571. GetAsKilometerMile( Distance ; Km_M )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Ursus, LeoSoft
http://www.don't_have_a_Web_site.com
  Convert Miles to Kilometer or Kilometer to Miles
   
572. getbetween(text, starttext, stoptext,occurrence)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Bailey Kessing, NCI-Frederick
http://kessing.com
  gets the text between two search values
   
573. getBroadcastAddressOctet ( Ip4Octet ; SubnetOctet )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  John Ahearn, none (yet)
http://none.com
  Returns Broadcast Address Octet given Ip4 Octet and Subnet Mask Octet
   
574. getchar(text, start, stop)
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Bailey Kessing, NCI-Frederick
http://kessing.com
  gets the text between specified range of text positions
   
575. GetColumn ( text ; columnNumber ; columnDelimiter )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Returns a list of values from the requested column in text.
   
576. GetContainerSize ( Container ; Precision )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Dennis Sirotkine, SUI Solutions
http://filemaker.suisolutions.com
  Returns container size in bytes, kilobytes or megabytes with the corresponding abbreviation.
   
577. GetCountryCodeFromCountry ( Country )
 
RatingRatingRatingRatingRating
  Average rating: 2.2
  Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com
  Get Country Code from Full Country Name
   
578. GetCountryFromCountryCode ( CountryCode )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Andy Knasinski, nrg Software, LLC.
http://www.nrgsoft.com
  Get full country name from country code
   
579. GetCurrentDirectory ()
 
RatingRatingRatingRatingRating
  Average rating: 4.8
  Iwein De Smedt, Freelancer
http://www.freelancer.com/
  Returns the path to your database folder.
   
580. GetDates ( text )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  extracts all dates from a text field
   
581. GetDayOccurrence ( TheDate; Weekday; Reps )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Ken Newell,
  Returns a date from a selected date for a specific day of the week that is N away.
   
582. getDomain ( theAddress )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Andrew Sasaki, n/a
n/a
  parses the domain name from an email address or URL
   
583. GetDownloadsPath
 
RatingRatingRatingRatingRating
  Average rating: 2.0
  Mike Beargie, Anvil Dataworks
http://www.anvildataworks.com
  Calculates the system download folder by modifying the document folder path.
   
584. GetDynamicStat ( Function ; TableOccurrenceName ; Field )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Ugo Di Luca, DLSYSTEMS
http://www.dlsystems.fr
  Get a Dynamic Aggregate result by chosing either the function, the related Table Occurrence and the field
   
585. GetEmail ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Daniele Raybaudi, ACI
www.aci.it
  It grabs all the emails of a given generic text
   
586. GetEmailAddr(Text)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Denham Morgan, NeuroScience Associates
http://http://www.neuroscienceassociates.com/
  Extracts email addresses from text
   
587. GetEuroSummerTime(numYear ; txtParameter)
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Mark de Haas Meijer, Emlogic
http://www.emlogic.nl
  Calculates the start or end date of the European Summer Time
   
588. GetExtensionsPath
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Jens Rasmussen, Fimano
http://fimano.dk/filemaker/toolbox.html
  Calculates the path in which to put plug-ins
   
589. GetFieldDataTypeFromObject ( ObjectName )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Federico Severin, Sevesoftware Engineering
http://www.sevesoftware.it
  Get field data type from object name
   
590. GetFieldList ( fieldName ; recordNumStart ; recordNumEnd )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com
  Gets a Range of field values for local or related field
   
591. GetFieldsAsXML ( theFields )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com
  Convert a list of fields to XML data
   
592. GetFieldStat ( Function ; Field )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Ugo DI LUCA, DLSYSTEMS
http://www.dlsystems.fr
  Do stats from values in a field or a value list
   
593. GetFieldType ( TableOccurrenceName ; Field )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Ugo Di Luca, DLSYSTEMS
http://www.dlsystems.fr
  Determine the targetted field type
   
594. GetFileName ( FullName )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  William Donelson, Mine
http://www.none.com
  Extracts Filename from the Full Path Name
   
595. GetFirstName(FullName)
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Steve Bush, Intellisoft Development Inc.
http://www.intellisoftdevelopment.com
  Returns A Contact's First Name from a Full Name
   
596. GetFMVersionNumber
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Dennis Sirotkine, SUI Solutions
http://filemaker.suisolutions.com
  Returns the FileMaker version number.
   
597. GetFOI ( y ; m )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Roberto Degano, DLV
http://www.deleveste.it
  A simple function to get the FOI Index (from Italian ISTAT)
   
598. GetFontFamily( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Joe Gold, Angel City Data
http://www.angelcitydata.com
  Returns the font of a text
   
599. GetFontSize(text)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Daniele Raybaudi, ACI
www.aci.it
  Returns the size of the text font
   
600. GetFontStyle( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Joe Gold, Angel City Data
http://www.angelcitydata.com
  returns style of a text
   
601. GetFoundSet ( FieldName )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Howard Schlossberg, FM Professional Solutions
http://fmprosolutions.com
  Gets a field's value across either the current found set or related records
   
602. GetItemRank ( item ; ValueList )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  returns the item rank in a list
   
603. GetKeys
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  returns a list of keys held by user (Shift, Caps Lock, Control, Alt, Command)
   
604. GetLastName(FullName)
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Steve Bush, Intellisoft Development Inc.
http://www.intellisoftdevelopment.com
  Returns an Individual's Last Name From A Full Name
   
605. GetLastRepNumber ( repfield ; maxrep )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Michael Bijnens, freelance developer
/
  get the last repetition number that is not empty
   
606. GetLatitudeLongitude ( ukPostcode )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  ChrisJ, CJ
http://gmail.com
  Retuns a value list with the latitude and longitude for a UK Postcode.
   
607. GetLayout (value)
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Michael Bijnens, freelance developer
/
  Get layoutid or layoutname from given value
   
608. GetLayout#(layout name)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Bill Moseid, Model Masters
http://www.fmpsolutions.com
  Data driven layout navigation. A button calls a script, passing a layout name as a script parameter. Navigation is to that layout.
   
609. GetLayoutID ( layout )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Ulf Carlsson, Studentlitteratur AB
http://www.studentlitteratur.se
  Gets the layout ID of current or named layout
   
610. GetLayoutNumberFromID ( layoutID )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  Ulf Carlsson, Studentlitteratur AB
http://www.studentlitteratur.se
  Gets the Layout order number from the layout with ID
   
611. getLine ( value ; List1 )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Timothy Brown, Antidote Solutions
http://www.antidotesolutions.com
  returns the line number of a value from a list using a paragraph return as the line delineator
   
612. GetListAsXML ( theList ; Element )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Andy Knasinski, NRG Software, LLC.
http://www.nrgosft.com
  Easily convert a list to XML
   
613. getListODatesApartFromSatnSun ( startDate ; endDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Richard Howland-Bolton, none
http://howlandbolton.com
  simple recursive function that gives a list of dates
   
614. GetListParameter ( ParameterList ; ParameterName )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Will Loving, Dedication Technologies, Inc.
http://dedicationtechnologies.com
  Extract a value by name from any list
   
615. GetLocalSystemPath( i )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.gudthlandum.no
  i = FMPath
   
616. getMaxValue ( theList )
 
RatingRatingRatingRatingRating
  Average rating: 2.3
  Bob Patin, Longterm Solutions LLC
http://www.longtermsolutions.com
  Returns maximum value in a list
   
617. GetMonthAsNumber ( monthTxt )
 
RatingRatingRatingRatingRating
  Average rating: 2.7
  Simon Brown, Beezwax Datatools, Inc.
http://beezwax.net/
  Converts month name to it's ordinal value
   
618. GetNthRecordFiltered ( primary_fieldname ; controlvalue_fieldname, recordNumStart; recordNumEnd; filterValue )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Kenneth Durrum, Released Solutions
http://www.releasedsolutions.net
  This function enables you to select a set of related records of a single field based on a value of a second field that is filtered by a keyword.
   
619. GetNthRecordSet ( fieldName ; recordNumStart ; recordNumEnd )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Jonathan Mickelson, Thought Deveopment Corp.
http://thought-dev.com
  Calculates a return delimited and sorted, values list from related, or local, field data.
   
620. GetNthRecordXML ( theFields ; recNum ; encodeFlag )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Bruce Robertson, Concise Design
http://www.concise-design.com
  Returns record data in XML format for nth record
   
621. GetNthRecSetUnq ( fieldName ; recordNumStart; recordNumEnd )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  doug Jacobs, Restylers' Choice, LLC
http://www.restylerschoice.com
  Calculates a return delimited and sorted, values list from related, or local, field data. Eliminating duplicate values fromthe list.
   
622. GetNthRow( fieldlist , N , delim)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Bruce Robertson, Concise Design
http://www.concise-design.com
  Get multiple fields for Nth record
   
623. GetNthRowObjectList( ObjectList; N; delim )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Bruce Robertson, Concise Design
http://concise-design.com
  Get data from named layout objects such as fields in portals or record lists.
   
624. GetNumberRepetitionsInMultivalue ( _Multivalue)
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Maryse Charbonneau, ACA
http://-
  returns the number of not empty repetitions in a multivalue
   
625. GetObjectNames ( nameOfFile ; nameOfLayout ; nameOfField )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Jonathan Mickelson, Thought Development Corp.
http://www.thought-dev.com
  Given a field name, search a specifc layout for it's object name(s).
   
626. getParameter ( FieldContent ; Number )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Timothy Brown, Antidote Solutions
http://www.antidotesolutions.com
  get Parameter - set a global field with multiple fields with a pipe bar between them, then be able to extract the data out
   
627. GetParameter ( ParameterName )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Daniel Kaan, Data Organisation Pty Ltd
http://www.dataorganisation.com.au
  Recall one of multiple parameters passed to a script by the name you assigned that parameter
   
628. GetParameter( subParameter )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Jeff Drake, Excelisys, Inc.
http://www.excelisys.com
  Returns the specified “sub-parameter” of a given script parameter.
   
629. getPathPart( Pathname ; Number )
 
RatingRatingRatingRatingRating
  Average rating: 4.7
  Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com
  Parses pathname for each part
   
630. GetPermutations ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Jed Verity, Verity Solutions
mailto:junk@veritys.com
  Finds all permutations of a return-delimited list of values.
   
631. GetPermutationsSub ( values ; counter ; output ; subcounter )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Jed Verity, Verity Solutions
mailto:jed@veritys.com
  No longer valid. See GetPermutations
   
632. GetPlatformName ( SysPlatform ; SysVersion ; AppVersion )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  HazMatt, N/A
http://www.hazmatt.net/
  Returns the complete system platform and version in a more friendly output.
   
633. GetPlural (test ; RSTY )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  John Buckingham, microGuidance
http://www.microguidance.co.uk
  Returns Plural if test <> 1
   
634. GetProperty ( propertyList ; propertyName )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Shaun Flisakowski, spf-15
http://www.spf-15.com/
  Extract a property's value from a property list
   
635. GetProperty( propertyList ; propertyName ; separator )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Koen Van Hulle, SHpartners
http://www.shpartners.com
  Extract a property's value from a property list with a separator
   
636. GetResultParameter( ParameterName )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Will Loving, Dedication Technologies, Inc.
http://dedicationtechnologies.com
  Extract a value by name from a ScriptResult
   
637. GetRGB ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Michael Horak, *COMMENT Visual realisation
http://comment.cjb.net/
  Returns set/s of RGB values representing the colors of text. If text contains multiple colors, multiple sets of RGB values are returned.
   
638. GetRows ( fieldList, N , delim )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Bruce Robertson, Concise Design
http://www.concise-design.com
  Get multiple fields across multiple records
   
639. GetRowsObjectList( ObjectList; N; delim1; delim2 )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Bruce Robertson, Concise Design
http://concise-design.com
  Retrieve data from named fields in a portal or record list.
   
640. GetRowsXML( fieldList; startRow; endrow; type; encodeFlag)
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Bruce Robertson, Concise Design
http://www.concise-design.com
  Returns data in XML format for multiple fields and multiple records
   
641. GetRowsXMLMatch(fieldlist ; startRow; endrow; type; matchexpression; encodeF
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Bruce Robertson, Concise Design
http://www.concise-design.com
  Get records in XML format for records meeting match criteria
   
642. GetScriptParameter(Number)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au
  Parse multiple script parameters in stead of just one
   
643. GetSelection ( fieldName; numberOfValues )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Michael Rhodes, Allied Data Service
http://allieddataservice.com
  Akin to SelectionToArray in other programs, returns all values of a specified field from a given count of found records.
   
644. GetStatusAreaWidth
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  returns the status area width
   
645. GetStyledWords ( text ; style )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Daniele Raybaudi, ACI
www.aci.it
  Returns all the styled words ( in list view ) within the given text
   
646. getSubnetAddressOctet ( IpOctet ; SubnetOctet )
 
RatingRatingRatingRatingRating
  Average rating: 2.3
  John Ahearn, none (yet)
http://none.com
  Returns subnet address octet given ip address octet and subnet mask octet
   
647. GetSystemOS
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Colt Majkrzak, Christian James Inc
http://www.christianjames.net
  Returns the OS Version in a more human read-able format.
   
648. GetTextAsDate (dateTxt; formatTxt)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Simon Brown, beezwax datatools, inc.
http://beezwax.net/
  Convert a date string of various formats into a FMP date value
   
649. GetTextBetween ( text ; from ; to ; occurrence )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Ulf Carlsson, Studentlitteratur AB
http://www.studentlitteratur.se
  Gets the text between the nth "occurence" of string "from" and string "to"
   
650. GetTextColor( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Joe Gold, Angel City Data
http://www.angelcitydata.com
  Returns the text color in an integer format.
   
651. GetTextSize ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Joe Gold, Angel City Data
http://www.angelcitydata.com
  returns the font text size, taking into account subscript and superscript
   
652. GetTextStyle (text)
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Marco Terrile, ChefMaTe
http://www.chefmate.it
  Get text formatting assigned to a field or text
   
653. GetThailandSummerTime ( Start ; End )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Watchara Yarnu,
http://www.giggogchang.wordpress.com
  custom function to get summertime in thailand
   
654. getTopLevelDomain ( theAddress )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Andrew Sasaki, n/a
n/a
  Parses the top level domain from an email address or URL
   
655. GetUniqueValues.cf ( TextList ; ExceptionsList )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Jonathan Jeffery, igeek
http://www.igeek.co.uk
  Gets unique values from a list (excluding values specified in the second list)
   
656. GetValueCust(text;delimiter;number)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Dubi Doo, XYZ Co.
http://www.website.com
  Retrieve a value from a valueList using a delimiter other than ¶
   
657. GetValueCustom ( text ; delimiter ; valueID )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  David Tinoco, Saturn Productions, LLC
http://saturnprods.com
  Retrieve values from lists not delimited by returns
   
658. GetValueFromInputField ( fieldname ; sourcecode )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Brian Dunning, BrianDunning.com
http://www.briandunning.com
  Gets the value of an input field from HTML source.
   
659. GetValueFromURLString ( paramname ; sourcecode )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Brian Dunning, BrianDunning.com
http://www.briandunning.com
  Gets a parameter name from a URL string in an HTML document.
   
660. GetValueIndex (valueList, valueString, matchCase, occurrence)
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Lewis C. Lorenz, Attorney at Law
http://www.LorenzCom.com
  Return index to value in valuelist. Search case sensitive or insensitive. Search for occurrence from front or end.
   
661. GetValueIndexByPosition (valueList, valueString, matchCase, occurrence, positionLCR)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Lewis C. Lorenz, Lorenz Companies
http://www.LorenzCom.com
  Retrieve the index of the value in valueList containing the matching valueString.
   
662. GetValueNumber ( listOfValues ; value )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Sander Selover, Andante Systems
http://andantesystems.com
  Gets the value number of a specified value
   
663. GetValues ( list ; start ; stop )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Matt Petrowsky, ISO FileMaker Magazine
http://www.filemakermagazine.com
  Extends the standard GetValue function to extract multiple values in a return delimited list
   
664. GetValueSet_MultiLevel ( child ; parent ; startValue ; childMarker ; c
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Don Levan, Small Company
http://smallco.net
  This function returns a valueset in a subsummary format within a field.
   
665. GetVersionAsNumber ( Version )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Eilert Sundt, Eilert Sundt Systemdesign
http://www.eilert.no
  Converts a software version number to a decimal number regardless of location
   
666. GetWeekNumber ( selDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com
  Gets the Week Number within in the Month of a selected date.
   
667. GetWord ( text ; number )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  David Head, uLearnIT
http://www.ulearnit.com.au/
  Get a specified single word from a string
   
668. GetWords ( text ; string )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Daniele Raybaudi, ACI
www.aci.it
  It returns all the words that contain a given string
   
669. GetXMLNode ( XML ; XPath )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Michael Wallace, Richard Carlton Consulting
http://www.rcconsulting.com
  Navigate XML tree and return results using XPath type functionality (Nonrecursive)
   
670. get_params
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  steve harley, paper-ape
http://ihavenowebsitethanks.com
  automatically turns named script parameters into local variables
   
671. Get_Row_Number ( relatedkey ; key )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Colin Keefe, IT Solutions Consulting, Inc
http://www.itsolutions-inc.com
  Return the portal row number of a matching key in a self join relationship
   
672. GlobalList ( KeepTable ; ExcludeTable ; KeepGlobal ; ExcludeGlobal ; Attribute ; Option ; View )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/PageGlobalList.html
  Have a list or content of globalFields for the whole or part of a file.
   
673. GlobalVarsFromLayout ( )
 
RatingRatingRatingRatingRating
  Average rating: 1.0
  Joris Aarts, ClickWorks
http://www.clickworks.be
  returns a list of all merge variables in named objects on the layout
   
674. gmail ( to ; subject ; body ; cc ; bcc )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Graham Young, Englishcomp
http://www.englishcomp.com
  Creates an email using client users gmail account
   
675. Google Maps ( Latitude ; Longitude ; Zoom )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Robinson Ogberaha, MTN Nigeria
http://www.mtnonline.com
  Search Location on Google MAPs via coordinates
   
676. Google2DBarcode ( Width ; Height ; Data )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Bill K, BRC
http://private.com
  This simple little calc will create a URL to generate a 2d barcode to be viewed in a web viewer
   
677. GoogleDirections ( Street1 ; Suburb1 ; State1 ; Zip1 ; Country1 ;%
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Chris Pye, Mactec
http://www.mactec.com.au
  Creates URL to display Google Directions from address data
   
678. GoogleMap ( Street ; Suburb ; State ; Zip ; Country )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Chris Pye, Mactec
http://www.mactec.com.au
  Creates URL to display a Google Map from address data
   
679. GoogleMapsByAddress ( Street ; Suburb ; State ; PostCode ; Zoom ; WebViewerObjectName )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Benjamin Hadfield, Knowledge & information Management (KiM)
http://www.kim.net.au
  Google Maps Address from fields in iframe
   
680. GoogleMapsbyCoords ( Latitute ; Longitude ; Zoom ; WebViewerObjectName )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Yvonne Dutreaux, self
none
  Shows embedded Google Map in a webviewer by Lat/Lon coordinates
   
681. GoogleSat( Address ; City ; State ; Zip ; Zoom ; Maptype )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Sandy DuMond, Red Shoe Dev Co
http://www.redshoedev.com
  Google Satellite Map
   
682. GotoFieldByName ( FieldName )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Ryan Grgurich, CRS Manufacturing, Inc.
www.crsmfg.com
  lets you goto a field by name, uses Applesctipt
   
683. GrayScale ( color )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Theo Ros, n/a
n/a
  Returns the given color turned to grey as compound RGB color
   
684. Greys ( pText; pPercent )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Klaus-Dieter Brügmann, kade project
http://www.kade-project.de
  set the text color to grey in percent from 0 (white) to 100 (black)
   
685. GroupRelationInfo ( FileTarget ; TableTarget ; Result )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html
  To retrieve a list of occurrences or fields only for a group of links.
   
686. gsp
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com
  Using shorthand for common functions
   
687. GSP(num)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Tim Anderson, Tim Anderson Group
http://www.timanderson.co.uk/
  Shorthand Script Parameters
   
688. Hanoi ( source ; destination ; via ; height )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Christoph Ivo Mattle, Christophs
http://www.christophmattle.ch
  Tower of Hanoi
   
689. HashFNV1a32 ( text ; empty )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Vaughan Bromfield, Vaughan Bromfield Design
mailto:vbromfield@optusnet.com.au
  Computes the 32 bit binary FNV-1a has for the input text.
   
690. HashFNV1a64 ( text ; empty )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Vaughan Bromfield, Vaughan Bromfield Design
mailto:vbromfield@optusnet.com.au
  A function to calculate the 64 bit FNV-1a hash of a text string.
   
691. Haversine ( angleInRadians )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Brian Dunning, BrianDunning.com
http://www.briandunning.com/
  Returns the haversine of a given angle.
   
692. Hex2RGB ( hex ; delimiter ; alert )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  F. Osman Cabi, Cabitas
http://thefilemakerblog.blogspot.com/
  Converts hex color codes to decimal RGB
   
693. Hex2Txt ( string)
 
RatingRatingRatingRatingRating
  Average rating: 2.5
  Benjamin, EfficientBizz GmbH
http://www.medicalbizz.ch
  convert Hexadecimal to Text
   
694. HexC2DecC (Hex)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Christopher Gauntt, Cordega Solutions
http://www.cordega.com
  Convert six character hexadecimal color into integer
   
695. HexCode_Colors
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Edward Souza, Duana A.S. Designs, LLC - Nossoestudio
n/a
  A CF to show all Hex Code Colors inside Webviewer.
   
696. HexToDec ( hexString )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Theo Ros, *
http://notapplicable.com
  converts a hexadecimal number string into a decimal number
   
697. HexToDecRGB ( Hex )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Federico Severin, Sevesoftware Engineering
http://www.sevesoftware.it
  Convert hex color format string to RGB color format string
   
698. HexToRGB ( Hex ; RGorB )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Jeremiah Small, Soliant Consulting
http://jsmall.us
  Returns a decimal integer that represents a color obtained by converting standard 6 character hexadecimal input.
   
699. HexToRGBspecial ( Hex ; Output )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Doug Jacobs, Restylers' Choice, LLC
http://www.restylerschoice.com
  Converts Hex into RGB value showing, R, G, or B depending on
   
700. HidePortalScroll ( dph; dprc; dwch; id_portalRecord )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  David Sparrow, Sparrow Design
http://sparrow-designs.com/
  Hide portal scroll bar unless extra data rows are hidden
   
701. HideText
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Tim Scoff, Medical Database Consultants
http://www.mdcdatabase.com
  Replace a text string with bullets
   
702. HighlightOccurrence ( ListToTest ; ListToCompare ; ColorMatch ; ColorNoMatch )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  maarten witberg, maarten witberg
http://none
  this function will recursively color code values in ListToTest by determining if they occur in ListToCompare
   
703. HighlightWords ( theText ; searchString ; start ; range )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Ryan Brandys, Branmuffin Industries
http://www.branmuffinindustries.com
  Formats occurences of searchString within theText to look like the results of a Google search!
   
704. Hilite(SourceText; SearchText; R; G; B)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Ray Cologon, NightWing Enterprises
http://www.nightwing.com.au/FileMaker
  This function highlights all occurrences of a specified word or phrase in a block of text.
   
705. HiliteMulti ( text ; searchValues ; color )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Returns text with every occurrence of each value in searchValues in text changed to the specified color.
   
706. HiliteSingle ( text ; searchString ; color )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Returns text with every occurrence of searchString in text changed to the specified color.
   
707. hlSection ( theText ; Values ; Red ; Green ; Blue ; Style )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Matt Wills, Virtual Vermont
http://www.virtualvermont.com/FMP/
  Highlight everything between specified words with Text Color and Styles
   
708. HolidayListByYear ( yearNumber )
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Jonathan Mickelson, Thought Development Corp.
http://thought-dev.com
  Creates a list of holiday names and dates for a given year.
   
709. HolidayNameByDate ( myDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Jonathan Mickelson, Thought Development Corp.
http://thought-dev.com
  Returns the Holiday Name matching a Date, i.e. for a calendar. A dynamic holiday list is built within for stand-alone operation.
   
710. HolidaysAUS ( theYear )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Vaughan Bromfield, Vaughan Bromfield Design
http://google.com
  Creates a paragraph-delimited list of dates for Australian national holidays.
   
711. HoraMinutoSegundo ( HoraInicial ; HoraFinal )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Miguel Angel Fernandez, n/a
n/a
  Spanish version of HourMinuteSecond ( StartTime ; EndTime )
   
712. HourMinuteSecond ( StartTime ; EndTime )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Miguel Angel Fernandez, n/a
n/a
  Adds the words 'hour, minute, second' to a calc time field.
   
713. HSBtoRGB ( hueDegrees ; satPercentage ; briPercentage )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Joe Rovang,
/
  Converts color from HSB/HSV values to RGB percentages.
   
714. HSLtoRGB ( hueDegrees; satPercentage; liPercentage )
 
RatingRatingRatingRatingRating
  Average rating: 2.0
  Joe Rovang, /
http://null
  Converts color from HSL values to RGB percentages.
   
715. HTMLPayPalCart( itemname ; description ; mypaypalemail ; amount ; shippi
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Ryan Brandys, Branmuffin Industries
http://www.branmuffinindustries.com
  Generates an HTML Paypal ADD TO CART Button with the parameters you specify.
   
716. HTMLtoText ( text ; returns )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Mogens Brun, FM Integrator
http://filemakerintegrator.dk
  Convert HTML text to text preserving bold and italic styles (v. 1.04).
   
717. HTMLtoText_convertStyle ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Mogens Brun, FM Integrator
http://filemakerintegrator.dk
  Subordinate Custom Function to HTMLtoText to parse bold and italic styles (v. 1.04).
   
718. HTMLtoText_deleteTags ( text )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Mogens Brun, FM Integrator
http://wwwfilemakerintegrator.dk
  Subordinate Costum Function to HTMLtoText to remove HTML tags (v. 1.04).
   
719. HTML_Parser_Cell(Source_Field;Start_String;Start_Occurrence; Middle_String;Middle_Occurrence;Middle_Gap;End_String;End_Oc
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Joel Englander, Joel Englander
http://www.asymptotes.com
  HTML Parser Cell
   
720. HTML_Parser_Text(Source_Field;Start_String;Start_Occurrence; Middle_String;Middle_Occurrence;Middle_Gap;Middle_String
 
RatingRatingRatingRatingRating
  Average rating: 2.5
  Joel Englander, Joel Englander
http://www.asymptotes.com
  HTML Parser Text
   
721. HTML_to_Text ( Text )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Oliver Gatzki, Studio Gatzki
http://www.gatzki.de
  Convert named entities in HTML to Text ( ISO 8859-1)
   
722. Html_Txt_Mail ( H_T_Obj ; H_T_From ; H_T_To ; H_T_Cc ; H_T_Body ; H_T_SendYN )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Paolo Marchetto, freelance
http://www.medicalhosting.org
  Send HTML mail with applescript
   
723. HypGeomDist ( sampleSuccesses ; sampleSize ; populationSuccesses ; ... )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
  Returns the hypergeometric probability distribution of obtaining the number of successes in a sample, based on the success rate of the general population. Given the overall failure rate of a production line, HypGeomDist can calculate the probability of 3 items being defective in a shipment containing 100 items.
   
724. icio_linewrap ( Text; Size; Originalsize)
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Chris Jones, Inter-CIO Limited
http://www.inter-cio.com
  A recursive line formatter/breaker and word wrapper that implements Knuth's algorithm
   
725. IdentifyDupes ( Original_List, i, Dupes )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  Jon Rosen, ErgoSoma
http://www.ergosoma.com
  Returns only unique duplicate values from a list. Most of the time we're trying to identify the unique values in a list. This CF returns the values in a list that have duplicates.
   
726. IDFromName ( _Name ; _Type ; _File )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Thomas Seidler, The Good Book Company
http://www.harmlesswise.com/it
  Gets static FileMaker IDs for layouts, scripts, fields, tables, valuelists
   
727. ImportoInLettere ( importo )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Federico Severin, Federico Severin
http://ilseve.altervista.org
  Re-writes amounts in words in Italian language (1/3)
   
728. ImportoInLettereRicorsiva ( parteIntera ; scala )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Federico Severin, Federico Severin
http://ilseve.altervista.org
  Re-writes amounts in words in Italian language (2/3)
   
729. IncDateOneMonth ( StartDate ; LastDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com
  Increments a Date field one month based on a starting date
   
730. InchFraction ( Number )
 
RatingRatingRatingRatingRating
  Average rating: 4.6
  L. Allen Poole, Creative Database Solutions NW
http://www.cdsnw.com
  Returns a carpenter's fraction approximating a number between 0 and 1
   
731. IncrementDate ( StartDate ; Frequency )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Kevin Bache, None
www.none.com
  Returns a date incrementally later than StartDate.
   
732. IndexList ( size )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Debi Fuchs, Aptworks Consulting
http://www.aptworks.com
  Speedily (and with limited recursion) return a list of up to one million integers from 0 to (size-1).
   
733. indonesian_date(date)
 
RatingRatingRatingRatingRating
  Average rating: 2.7
  Andrew, Gbi wtc serpong
http://gbiwtcserpong
  Indonesian Date Format
   
734. InsertChar (inText ; insertChar ; atInterval ; outText)
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Michael Rauch, ShopWorks
http://www.shopworx.com
  Insert character at regular intervals within text
   
735. InsertCharacter ( text ; index ; char )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  George Norsworthy, Bell Mountain Assoc.
http://bellmountainassoc.com
  Inserts a specified character in between each character of a specified string.
   
736. InsertValue ( list ; value ; index )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Theo Ros, n/a
n/a
  Returns a list with value 'value' inserted at position 'index'
   
737. insert_commas ( number )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Matthew Stetson, Antidote Solutions
http://www.antidotesolutions.com
  Insert commas in a number
   
738. Int2Alpha ( Integer )
 
RatingRatingRatingRatingRating
  Average rating: 2.8
  JT Hughes, Queuedom
http://notapplicable.com
  Converts an integer to its alphabetic equivalent
   
739. InterestRateBalloon ( principal; balloon; payment; periods; rate )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Ralph Lilienkamp, Self
none
  Find the interest rate for a balloon note
   
740. Interpolate ( x1 ; y1 ; x2 ; y2 ; x )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Bill Holt, Notesoft
http://www.notesoft.com
  Linear interpolation or extrapolation from two coordinate points
   
741. interpolate(x;y;t;0;0)
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Wilhelm Werner, n/a
n/a
  Polynomial interpolation of arbitrary degree
   
742. Intersection Set ( ListA ; ListB )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Peter Gort, Denbigh International
http://www.denbigh.com.au
  Outputs a list of the unique values present in both of the value lists supplied
   
743. InverseColor ( color )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Theo Ros, n/a
n/a
  Returns the negative color for a compound RGB color
   
744. InverseText ( text )
 
RatingRatingRatingRatingRating
  Average rating: 4.5
  Roberto Degano, Studio Immobiliare De Le Veste S.a.s.
http://www.deleveste.it
  To obtain an inverted string of the "text"
   
745. IP2IPLong (IP)
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Dick Impens, snepmi.nl
http://www.snepmi.nl
  Converts IP to IPLong
   
746. IP6abbreviate ( IP6fullInput ; inputType )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Tim Griffith, NA
NA
  This function will create a hexadecimal abbreviated IP6 address.
   
747. IP6fullAddress ( Input )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Tim Griffith, NA
NA
  This function will convert a properly abbreviated IP6 into its full address ( 8 sets of 16bit [hexadecimal] numbers ).
   
748. IP6fullBinAddress ( Input )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Tim Griffith, NA
NA
  This function will convert a properly abbreviated IP6 into its full binary address.
   
749. IP6Num2Bin ( decNumber ; binary )
 
RatingRatingRatingRatingRating
  Average rating: 1.3
  Tim Griffith, NA
NA
  This is a dependent function for 'IP6fullBinAddress' but will function on its own to convert a decimal number to a binary number.
   
750. IP6numericAddress ( Input )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Tim Griffith, NA
NA
  This function will convert a properly abbreviated IP6 into its full decimal address.
   
751. IPLong ( number )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Dick Impens, snepmi.nl
http://www.snepmi.nl
  Creates a real IP address of an IP long number
   
752. IPToSortableText ( IPaddress )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Theo Ros, n/a
n/a
  Returns a sortable textual representation of an IPaddress.
   
753. IRR ( cashFlowsList ; guessRate )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Lewis C. Lorenz, Lorenz Companies
http://www.LorenzCom.com/software
  Calculate Internal Rate of Return of a value list of cash flows with an initial guessed rate-of-return, using the Newton-Raphson method.
   
754. IRR ( cf0 ; cf1 ; cf2 ; cf3 ; cf4 ; cf5 ; cf6 ; cf7 ; cf8 ; cf9 ; cf10 ; cf11 ; x1 ; x2 ; accuracy )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Pascal Marazzi-de Lima, Wuest&Partner
http://www.wuestundpartner.com
  Calculates the internal rate of return (IRR)
   
755. IRR ( IRR1; IRR2 ; NPV1 ; NPV2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Barry Maskell, CB Richard Ellis
www.cbre.com.au
  IRR - Calculate the IRR through 'Interpolation'
   
756. ISBN ( language ; publisher ; book )
 
RatingRatingRatingRatingRating
  Average rating: 2.7
  Reinder Wolting, ABECON
http://www.abecon.nl
  Generate the ISBN# including the check digit
   
757. ISBN10Check ( ISBN10 ; text )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Larry Nichols, n/a
n/a
  validates ISBNs
   
758. ISBN13 ( ISBN )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Rolf Clausen, Mallverkstan
http://www.mallverkstan.com
  Converts an old ISBN number to the new ISBN13 format.
   
759. ISBN13Check ( ISBN13 ; text )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Larry Nichols, n/a
n/a
  validates ISBN-13
   
760. IsControlChar ( f_Char )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Neal Elward, Extreme Reach
http://www.extremereach.com
  Tests if a character is an ASCII control character
   
761. IsDate ( _var )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Rewolfer, -
http://rewolfer.de
  return valid date as number of days since 0001-01-01 or nothing if invalid
   
762. IsDateInRange ( TestDate , LowerLimit , HigherLimit )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Ibrahim Bittar Torres, Eikonsys
http://www.eikonsys.com
  Determines if a given date falls between two reference dates.
   
763. IsDaylightSavings ( TS )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Yvonne Dutreaux, Cordblood Registry
http://www.cordblood.com
  Determines if a given timestamp is with Daylight Savings Time
   
764. isDaylightTime ( dt )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Howard Schlossberg, FM Professional Solutions
http://fmprosolutions.com
  Returns 1 or 0 to indicate whether the given date falls within U.S. daylight savings time (post-2007)
   
765. IsEmptyString ( Field )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Ryan Grgurich, CRS Manufacturing, Inc.
http://www.crsmfg.com
  Use to determine if field is an empty string value.
   
766. IsFilled ( field )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Josh Ormond, none
http://fmrift.wordpress.com
  The opposite of IsEmpty.
   
767. isFirstRecordWithValue ( sortedBy )
 
RatingRatingRatingRatingRating
  Average rating: 4.8
  Max Heller, fmax software
http://www.fmaxsoftware.com
  Used to hilite the first record of a given value in a sorted list of records.
   
768. isFrontMostTabPanel ( _objectName )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  Returns 1 if _objectName is or contains the frontmost tab panel, else 0
   
769. IsIP ( IP )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Hartger Visser, Teuker Small Business Solutions
http://www.teuker.nl
  Checks if string entered is an IP address, returns true or false
   
770. isLeapYear ( _year )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Watchara Yarnu,
http://www.giggogchang.wordpress.com
  Returns 1 if the year is a leap year, else 0.
   
771. isLeapYear ( _year )
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com
  leap year simple test
   
772. IsNthBinRoot ( Number ; Factor )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Tim Griffith, NA
NA
  Calculates whether a number is a binary positional number, i.e., 001 is the first binary position, 010 (2) is the second binary position, 100 (4) is the third binary position, etc..
   
773. IsNthBinRootNumToBin ( decNumber ; binary )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Tim Griffith, NA
NA
  This is a dependent function for 'IsNthBinRoot' but will function on its own to convert a decimal number to a binary number.
   
774. isNull( text )
 
RatingRatingRatingRatingRating
  Average rating: 1.0
  Derek Bastille, University of Alaska Fairbanks
http://www.uaf.edu
  Checks to see if the input is NULL
   
775. IsNumber ( _var )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  Rewolfer, -
http://rewolfer.de
  return a valid number according to regional setting
   
776. IsNumberInRange ( Number , LowerLimit , HigherLimit )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Ibrahim Bittar Torres, Eikonsys
http://www.eikonsys.com
  Determines if a given number falls between two reference numbers.
   
777. IsPlainText ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Returns True (1) if text has no text formatting applied to it; otherwise returns False (0).
   
778. IsPowerOfTwo ( number )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/
  Returns True(1) if number is a power of two; otherwise returns False(0).
   
779. IsRelationship (relatedConstant)
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com
  This functions result will be TRUE if there IS a relationship.
   
780. IsTime ( _var )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Rewolfer, -
http://rewolfer.de
  return valid time as number of seconds or nothing if invalid
   
781. IsTimeOfDay ( _var )
 
RatingRatingRatingRatingRating
  Average rating: 2.0
  Rewolfer, -
http://rewolfer.de
  return number of seconds since midnight if valid or nothing if invalid
   
782. IsTimestamp ( _var )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Rewolfer, -
http://rewolfer.de
  return timestamp in number of seconds if valid or nothing if invalid
   
783. IsUUID( Self )
 
RatingRatingRatingRatingRating
  Average rating: 0.0
  John Hanson, Pulp Studio
http://www.pulpstudio.com
  Checks if a text string is in UUID format, e.g. generated by Get(UUID).
   
784. IsValidABN ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Vaughan Bromfield, Vaughan Bromfield Design
mailto:vbromfield@optusnet.com.au
  Validates Australian ABN numbers.
   
785. IsValidBankNumber ( banknummer )
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Theo Ros, *
http://notapplicable.com
  Checks a Dutch banknumber for validity.
   
786. IsValidEmail ( text )
 
RatingRatingRatingRatingRating
  Average rating: 2.6
  Michael Rhodes, Allied Data Service
http://allieddataservice.com
  test if valid email for format and against current top level domains
   
787. IsValidEmail ( theEmail )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Paul Turnbull, One of Me
http://www.oneofme.ca
  Determines if a supplied email address is valid or not
   
788. IsValidEmailFormat( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.1
  Michael Rhodes, Allied Data Service
http://allieddataservice.com
  Validate email address
   
789. IsValidIP ( IPaddress )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Theo Ros, n/a
n/a
  Checks if 'IPaddress' contains a valid IP address.
   
790. IsValidSofiNumber ( sofinummer )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Theo Ros, *
http://notapplicable.com
  Checks a Dutch sofinumber for validity.
   
791. IsWebClient ()
 
RatingRatingRatingRatingRating
  Average rating: 4.1
  Ilya Shuvalov, SUI Solutions
http://filemaker.suisolutions.com
  Checks if the current user connected to the database file from a web browser
   
792. Is_FM_Go
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Mark DeNyse, Driftwood Interactive
http://www.driftwoodinteractive.com
  Return 1 if running FileMaker Go on an iPhone/iPod Touch
   
793. Is_FM_Go_iPad
 
RatingRatingRatingRatingRating
  Average rating: 2.9
  Mark DeNyse, Driftwood Interactive
http://www.driftwoodinteractive.com
  Returns 1 if running FileMaker Go on an iPad.
   
794. is_valid_number (some_text)
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  steve harley, none please
http://no.website.really.com
  returns true (1) if the input text represents a valid number
   
795. ITC_date__WorkingDayNext ( inputDate ; HolidaysList )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  SL, ITC
  The next weekday of a given date (giving a list of all your closed days!)
   
796. ITC_date__WorkingDayPrevious ( inputDate ; HolidaysList )
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  SL, ITC
  The preceding weekday of a given date (giving a list of all your closed days!)
   
797. ITC_list__DateToTextList ( valueList )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  SL, ITC
  Convert a list of dates in the format DD/MM/YYYY to a list of dates in the format YYYY/MM/DD
   
798. ITC_list__MatrixHoriz ( valueList ; columns )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  SL, ITC
  Put the value of a list into a matrix of given columns number
   
799. ITC_list__MatrixHoriz_loop (valueList;countOfValues;columns;sepArray)
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  SL, ITC
  Part of the CF
   
800. ITC_list__TextToDateList ( valueList )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  SL, ITC
  Convert a list of dates in the format YYYY/MM/DD to a list of dates in the format DD/MM/YYYY
   
801. Iyele ( metin ; ayrac )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  F. Osman Cabi, Cabitas
http://www.cabitas.com
  (Only for Turkish) Adds ownership suffix to the name
   
802. JDToDate ( JulianDayNumber ; gregorian )
 
RatingRatingRatingRatingRating
  Average rating: 2.7
  Theo Ros, *
http://notapplicable.com
  converts a Julian Day number into a Filemaker date
   
803. joinRepeatingVariable ( variableName ; delimiter ; startIndex ; endIndex )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Sam Barnum, 360Works
http://www.360works.com
  Join / concatenate a repeating variable / array using a delimiter character
   
804. joinRepeatingVariableFast ( variableName ; delimiter ; startIndex ; endIndex )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Sam Barnum, 360Works
http://www.360works.com
  Join / concatenate a large repeating variable / array using a delimiter character
   
805. JoinRepetitions ( repeatingField ; delimiter; start ; nRepeats )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Theo Ros, *
http://notapplicable.com
  Returns all repetitions in the repeating field as combined string
   
806. JSON_array( v )
 
RatingRatingRatingRatingRating
  Average rating: 4.2
  Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.gudthlandum.no
  Build a JSON key/value element
   
807. JSON_entity( k; v )
 
RatingRatingRatingRatingRating
  Average rating: 3.8
  Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.gudthlandum.no
  Build a JSON key/value element
   
808. Julian ( vDate )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Makah Encarnacao, Soliant Consulting
http://www.soliantconsulting.com/
  Calculate Julian Date
   
809. Julian( datetime )
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com
  Julian Date and Time for calculations
   
810. JulianDecoder( JulianDate )
 
RatingRatingRatingRatingRating
  Average rating: 5.0
  Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com
  This function takes a Julian date code and returns a timestamp
   
811. Jumble ( text )
 
RatingRatingRatingRatingRating
  Average rating: 3.6
  Rob Westergaard, DataStorm Solutions
http://www.datastorm-solutions.com/
  Randomly re-orders the words in a string.
   
812. JumbleLetters ( theText )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Ted Steel, OTF Solutions
http://www.otfsolutions.com
  Jumbles letters in a single word. Great for a word jumble puzzle.
   
813. kentekenFormat ( k )
 
RatingRatingRatingRatingRating
  Average rating: 3.7
  Quint Gijsbers, mafkaan
http://www.mafkaan.nl
  formats dutch licenceplates
   
814. KeysDown ( theModifierKeys ; ignoreCapsLock )
 
RatingRatingRatingRatingRating
  Average rating: 3.5
  Peter Wagemans, SHpartners
http://www.shpartners.com
  User friendly version of Get ( ActiveModifierKeys )
   
815. Keywords ( text ; separator )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Vaughan Bromfield, Vaughan Bromfield Design
mailto:vbromfield@optusnet.com.au
  Creates a delimited list of words, with plural words converted into singulars. (English only)
   
816. LastDayInstance ( theDate; NameOfDay )
 
RatingRatingRatingRatingRating
  Average rating: 4.0
  Andrew Sasaki, n/a
n/a
  Returns the last instance of a given day in the month of the date
   
817. LastDayOfMonth
 
RatingRatingRatingRatingRating
  Average rating: 3.3
  Michael Myett, FileMaker Apps
http://filemakerapps.biz
  Returns the last day of the current month. Does not require any parameters.
   
818. LastDayOfMonth ( theDate )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Darren Terry, Pacific Data Management, Inc.
http://www.pdm-inc.com
  Returns the date of the last day of the specified month
   
819. LastDayofMonth( theDate)
 
RatingRatingRatingRatingRating
  Average rating: 4.3
  Timothy Brown, Antidote Solutions
http://www.antidotesolutions.com
  Find the date of the last day of the month
   
820. LastMonday ( themonth ; theyear )
 
RatingRatingRatingRatingRating
  Average rating: 3.2
  Theo Ros, *
http://notapplicable.com
  Returns the date for the last Monday in a given month
   
821. LastMonthString_fn (theDate)
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Stephen Wonfor, Iceworm Consulting & Stuff, Inc.
www.idonthaveone.com
  creates a date search string for the previous month
   
822. LastMthSearchRange
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Lee Dolereit, Sharp ABT
http://www.sharpabt.com.au
  Search Range for the Previous Month
   
823. LastRepDefined ( theField; SetToZero )
 
RatingRatingRatingRatingRating
  Average rating: 4.4
  Larry Badten, TechMedic Computers
http://www.techmedic.net
  Gets the number of repetitions a field is defined to have
   
824. LastRepNumber ( repeatingField ; maxRepeat )
 
RatingRatingRatingRatingRating
  Average rating: 3.0
  Daniele Raybaudi, ACI
www.aci.it
  Returns the number of the last not empty repetition
   
825. Last_Saturday ( Date_1 )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  Michael Myett, FileMaker Apps
http://filemakerapps.biz
  Enter a date in the Date_1 field and the calculation will return the last Saturday of that month.
   
826. LatinUpperAlpha
 
RatingRatingRatingRatingRating
  Average rating: 3.9
  Raybaudi Daniele, ACI
www.aci.it
  Returns a string with all 133 latin upper chars
   
827. LatLongDist ( Lat1 ; Long1; Lat2; Long2 )
 
RatingRatingRatingRatingRating
  Average rating: 3.4
  George Nassar, Provident Data Services
http://www.providentdata.com
  Calculates the distance between two sets of latitude/longitude coordinates
   
828. LayoutCalcHTML ( text )