Shopping Cart

Free Newsletter
Signup

Contact

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

1289 Custom Functions Found...

Can't find what you're looking for? Let me make it for you.

1.	#AlAradan( #metin ; #aranan1 ; #aranan2)
	Average rating: 3.6
	Kadir Kaleli, Yordam http://www.yordam.com
	cümleden parça alma ; getting piece from text

2.	#NthDayOfWeek ( MyDate )
	Average rating: 3.9
	Mehmet KAYA, Beyaz Bilgisayar http://www.filemakerturk.com
	NthDayOfWeek returns the occurence of the weekday of AValue in the month. // Ceiling ( Day ( date ) / 7 )

3.	#ParcaEle ( #metin ; #aranan )
	Average rating: 3.6
	Kadir Kaleli, Yordam http://www.yordam.com
	Aranan jokerli parçayi yoket ; Replace string with wildcard

4.	#TL ( #rakam )
	Average rating: 3.3
	Kadir Kaleli, Yordam http://www.yordam.com
	To translate a number into text.

5.	ƒilter ( text ; AZazƒ09etc )
	Average rating: 3.2
	Thomas Seidler, The Good Book Company http://www.harmlesswise.com/it
	FilterC built to handle foreign characters (and a bit more)

6.	Abscind ( text ; margin )
	Average rating: 4.5
	Ray Cologon, NightWing Enterprises http://www.nightwing.com.au/FileMaker
	Adds or repositions line breaks in supplied text so it wraps to specified margins.

7.	AbsolutePaddingZeroes( number; digits )
	Average rating: 3.6
	Gjermund Gusland Thorsen, Gudthlandum Consulting http://www.gudthlandum.no
	Pads a number to have static length of digits

8.	Academic ( theDate )
	Average rating: 3.7
	Matt Wills, Virtual Vermont http://www.virtualvermont.com/FMP/
	Returns the academic season of a given date.

9.	Accordion( NumberedList; selectedGroup; showNumbers )
	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.

10.	Acos ( number )
	Average rating: 3.8
	Brian Dunning, BrianDunning.com http://www.briandunning.com/
	Returns the arc cosine of a given number.

11.	Acronym ( text )
	Average rating: 4.0
	Ray Cologon, NightWing Enterprises http://www.nightwing.com.au/FileMaker
	Returns the first letter of each word in phrase (in upper case).

12.	ActualLineCount ( Text ; CharsPerLine )
	Average rating: 4.2
	Jonathan Stark, Jonathan Stark Consulting http://jonathanstark.com/
	Determine if text is overflowing field bounds on layout.

13.	AddConstantToListValues ( theList ; theConstant )
	Average rating: 3.0
	Simon Plint, Thanks For The Memories http://www.thanks.com.au
	Concatenate each value in a list with constant piece of text.

14.	AddConstantToString( string; fillchar; posit ; direction; iter)
	Average rating: 3.7
	Martti Tumanto, Martinova Oy http://www,martinova.fi
	Adds a constant string to very Nth position of a string

15.	AddDays ( theDate; DaysToAdd )
	Average rating: 3.3
	Andrew Sasaki, n/a n/a
	Given a date and a number of days, returns the date that many days later.

16.	AddDollarFormat ( Number )
	Average rating: 3.1
	Jeremiah Small, Soliant Consulting http://jsmall.us
	Turn unformatted number into dollars with commas rounded to nearest penny.

17.	AddEllipsis ( theText ; theLength )
	Average rating: 3.4
	Simon Plint, Thanks For The Memories http://thanks.com.au
	Truncates theText if longer than theLength and adds ...

18.	AddPrefixSuffixToList ( theList ; prefix ; suffix )
	Average rating: 3.6
	Andy Knasinski, NRG Software, LLC. http://www.nrgsoft.com
	add a prefix or suffix to each line in a list

19.	AddProperty ( propertyList ; propertyName ; propertyValue )
	Average rating: 3.5
	Shaun Flisakowski, spf-15 http://www.spf-15.com/
	Add a new name/value pair to an existing property list

20.	AddRemove ( value ; content )
	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.

21.	AddRemoveListItem ( theList ; value )
	Average rating: 3.8
	David Head, uLearnIT http://www.ulearnit.com.au/
	Add a value to or remove an values from a list of values

22.	AddRemoveListItems( theList; thevalues )
	Average rating: 3.9
	Bruce Robertson, Concise Design http://concise-design.com
	Add or remove item from list, also remove empty lines

23.	AddressBlock ( com ; cont ; a1 ; a2 ; a3 ; a4 ; c %3
	Average rating: 3.5
	Steve Gerow, Abrazos Data Consulting, Inc. http://www.abrazosdata.com
	Calculated Address block from separate fields - handles missing elements

24.	AddressLabel ( Name ; Address ; City ; State ; ZIP ; Country )
	Average rating: 3.3
	Tony Tanevski, Hi-Voltage http://www.hi-voltage.com.au
	Address Labels - slide-up missing text in an address label

25.	AddTextRight ( text ; number ; addedtext )
	Average rating: 3.7
	Drew Boone, Doulos Ministries, Inc. http://www.douloscorp.com
	Adds text to the right of a specified string the specified number of times

26.	After ( text ; searchString ; occurrence ; include_1 )
	Average rating: 4.6
	Fabrice Nordmann, 1-more-thing http://www.1-more-thing.com
	extracts text after search string

27.	Age ( Birth; theDate; Format )
	Average rating: 3.4
	Geoff Wells, DataIsland Software LLC http://www.dataisland.com
	Calculates Age in three formats

28.	AGE ( BirthDate )
	Average rating: 4.1
	meddved, meddved www.meddved.bg
	Calculate the correct Age :)

29.	age ( birthday )
	Average rating: 2.7
	Bailey Kessing, NCI-Frederick http://kessing.com
	calculates the correct age

30.	Age ( birthday; today; Format )
	Average rating: 3.5
	Kevin Kurpe, Proponent www.YourProponent.com
	This calculation determines a person's age based upon their birthday and a given date.

31.	age ( date1 ; date2 )
	Average rating: 4.2
	Winfried Huslik, Huslik Verlag GmbH http://fmdiff.com
	Calculates the number of years, months, and days between any two dates

32.	Age ( DOB )
	Average rating: 2.9
	Chris Stasny, EducatorsInc http://EducatorsInc.com
	Converts date of birth to an age in years

33.	All ( relatedField ; rFieldCount ; soughtValue )
	Average rating: 3.3
	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

34.	AllFields ( start )
	Average rating: 3.8
	Daniele Raybaudi, ACI www.aci.it
	Returns the content of all the fields of a layout

35.	AllMonthNames ( startMonthNumber )
	Average rating: 3.4
	Daniele Raybaudi, ACI www.aci.it
	Returns all the month's names from a given month number

36.	AllTextCombinations ( theText ; stackDepth )
	Average rating: 3.2
	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

37.	AllTextCombinations(theText)
	Average rating: 3.8
	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

38.	Alpha2Int ( Alpha )
	Average rating: 3.7
	JT Hughes, Queuedom http://notapplicable.com
	Converts Alpha string to its integral equivalent

39.	AmbiguousDate( Text )
	Average rating: 2.8
	Lewis Buckingham, None none
	Returns an approximate date for unspecific date input

40.	Amortization_CFpub ( principal ; interest ; periods ; payment; term ; currency)
	Average rating: 4.3
	James Hea, James Hea http://www.jameshea.com
	Produces the principal remaining at the end of a fixed rate amortization period.

41.	AmtCompounded_cf ( principal ; rate ; iterations )
	Average rating: 3.5
	Steve Gerow, Abrazos Data Consulting, Inc. http://www.abrazosdata.com
	Calculates compounded amount from principal, interest and number of iterations.

42.	AnnuallySerial ( AEfield ; digit )
	Average rating: 3.3
	Daniele Raybaudi, ACI www.aci.it
	Autoenter a serial number that increments annually

43.	antiFilter (textToFilter ; filterAllow ; filterSubChar ; start ; stop ; textBuilt )
	Average rating: 3.7
	Michael Rauch, ShopWorks http://www.shopworx.com
	replace any character not specified in the allowed list with the substitute character

44.	AntiFilterValues( ListA; ListB )
	Average rating: 3.3
	Bruce Robertson, Concise Design http://concise-design.com
	Return values only contained in ListA

45.	Any ( relatedField ; rFieldCount ; soughtValue )
	Average rating: 3.8
	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

46.	AnyBaseToDec(number; base)
	Average rating: 4.5
	Ferry, NCOI http://www.ncoi.nl
	Converts any base to decimal (max 32 base)

47.	ApplescriptGetURL ( URLtoGet ; FieldtoSet )
	Average rating: 4.0
	Jim Main, Main Solutions http://www.mainsolutions.org
	Getting a web page via Applescript

48.	AppleScript_Choose_Color ( result_field ; format )
	Average rating: 3.1
	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

49.	AppleScript_Choose_from_List ( myList ; window_title ; message ; allow_multiple ; allow_empty ; default_items ; OK_button_name ; result_field )
	Average rating: 3.3
	Thomas Siebert, Seabird http://www.t-seabird.de
	creates a dialog with a chooser list to choose one or multiple items

50.	AppleScript_Dialog ( Text; Button1; Button2; Button3 ; window_title ; giving_up_after; default_answer; hidden_answer; default_button; cancel_button; caution; result_field )
	Average rating: 3.7
	Thomas Siebert, Thomas Siebert http://www.t-seabird.de
	Generates an dialog box with a number of options

51.	AppleScript_Fontlist ( result_field )
	Average rating: 4.3
	Thomas Siebert, Thomas Siebert http://www.t-seabird.de
	Returns a list of fontnames compatible to FileMaker Pro using the "FontBook" application.

52.	AppleScript_set_clipboard ( text )
	Average rating: 2.9
	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.

53.	Apply ( function ; value )
	Average rating: 3.7
	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.

54.	ApplyToList ( function ; listOfValues ; separator )
	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.

55.	ApplyToList( ListA; function, separator )
	Average rating: 3.7
	Bruce Robertson, Concise Design http://concise-design.com
	Apply FUNCTION to each item in list

56.	ApplyToRange ( function ; start ; end ; step ; separator )
	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.

57.	ApproxDateRange ( date1 ; date2 )
	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.

58.	APV ( payment ; rate ; type ; nper ; futureval )
	Average rating: 4.5
	Lee Dolereit, Sharp ABT http://www.sharpabt.com.au
	Advanced Present Value

59.	areaCalcsByCoords ( xlist ; ylist )
	Average rating: 2.8
	Bill Holt, Notesoft http://www.notesoft.com
	Calculates the area within any shape defined by a series of coordinates.

60.	AreaConvert ( Width , Wunit , Height , Hunit , OutUnit )
	Average rating: 3.7
	Ibrahim Bittar, Eikonsys http://www.eikonsys.com
	Calculates areas based on multiple units

61.	Arithmetic_Mean ( Field ; MaxLoopCount ; StartIndex ; MeanValue )
	Average rating: 3.3
	Kevin Woods, KWoods http://www.RivieraCouches.co.uk
	Calculate the arithmetic mean of a set of numbers.

62.	array.cellValueByColNum ( array ; rowName ; column ; delimiter )
	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.

63.	array.cellValueByColTitle (array ; rowName ; column ; delimiter ; useTitle )
	Average rating: 4.0
	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

64.	ArraySetValue ( array ; index ; data )
	Average rating: 3.9
	Jeremy Bante, Gaia Herbs, Inc. http://www.gaiaherbs.com/
	Set a cell value in an arbitrary-dimensional array

65.	ArrayValue ( array ; index )
	Average rating: 4.2
	Jeremy Bante, Gaia Herbs, Inc. http://www.gaiaherbs.com/
	Retrieves a cell from an arbitrary-dimensional array

66.	Asc ( char )
	Average rating: 3.2
	Theo Ros, n/a n/a
	Returns the Ascii code for the given character

67.	AscAlphaNum ( str )
	Average rating: 3.6
	Tim Oehlke, Ecolab, Inc. http://www.ecolab.com
	returns an alphanumeric character's ASCII code value

68.	AscIIToBase64 (string)
	Average rating: 3.7
	Roberto Pellegrini, gestione datu http://www.gestionedati.net
	Convert text AscII To Base64

69.	AscIIToBase64 (string)
	Average rating: 2.7
	Frank Seipel, Lilly's Media Logistics http://www.lillysmedialogistics.com
	Converts an arbitrary text string to BASE64. English functnion name version.

70.	ASCII_Code ( char )
	Average rating: 3.4
	Tony Tanevski, Hi-Voltage http://www.hi-voltage.com.au
	Returns the ASCII Code value for any character

71.	ASFolderPath ( UnixFolderPath )
	Average rating: 2.9
	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

72.	ASFPCoreFx (UnixP2 )
	Average rating: 3.7
	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

73.	Asin ( number )
	Average rating: 3.4
	Brian Dunning, BrianDunning.com http://www.briandunning.com/
	Returns the arc sine of a given number.

74.	assembleBarGraph ( theList )
	Average rating: 3.2
	Edward Souza, Nossoestudio Som & Imagem, ltd n/a
	assembleBarGraph is a recursive Custom Function based on a clever Web Viewer's example

75.	AssignWindowName ( Text )
	Average rating: 5.0
	Koji Takeuchi, Splash, Inc. http://www.splash.jp/
	Add " - num" to Text when the Text is not unique in WindowNames.

76.	Astrological_Sign(date)
	Average rating: 3.4
	John Pollard, Generic Human Studies http://www.selfparenting.com
	Determines a person's astrological sign based on their birthdate

77.	AS_ChooseFile ( _resultTOGlobalCellName ; _prompt ; _defaultLocation ; _extensionVL )
	Average rating: 5.0
	Thomas Seidler, The Good Book Company http://www.thegoodbook.co.uk
	MAC ONLY. Generates applescript to choose file & returns result

78.	AS_ChooseFolder ( _resultTOGlobalCellName ; _prompt ; _defaultLocation )
	Average rating: 4.3
	Thomas Seidler, Harmlesswise.com http://www.harmlesswise.com/it
	MAC ONLY. Generates applescript to choose folder & returns result

79.	AS_FolderPathListing ( _resultTOGlobalCellName ; _folderPath ; _extensionVL )
	Average rating: 5.0
	Thomas Seidler, Harmlesswise.com http://www.harmlesswise.com/it
	MAC ONLY. Generates Applescript to obtain folder listing & returns result as ValueList.

80.	atan2 ( y ; x )
	Average rating: 3.5
	Michael George, Michael George Consulting mailto:mgeorge@coresupport.com
	returns the base angle (arctan) of a triangle with the sides X and Y.

81.	AutoUpdateErrorToEnglish (ErrorNum)
	Average rating: 3.8
	Andrew Duncan, Databuzz http://www.databuzz.com.au
	Returns the English description for the AutoUpdate Error Number for the FMSAUC_UpdatePlugIn function

82.	balance( theText; openbracket; closebracket )
	Average rating: 3.2
	Bruce Robertson, Concise Design http://concise-design.com
	Get text to length that balances open/close markers

83.	base10_to_base64( integer )
	Average rating: 3.2
	Martin Sorich, FMBiotech http://www.fmbiotech.com
	Converts base 10 integer to base 64 alphanumeric character

84.	Base64ToAscII ( string )
	Average rating: 2.8
	Frank Seipel, Lilly's Media Logistics http://www.lillysmedialogistics.com
	Convert text Base64 to AscII

85.	Base64ToAscII (String)
	Average rating: 3.4
	Roberto Pellegrini, gestione dati http://www.gestionedati.net
	Convert text Base64 to AscII

86.	BaseConvert ( string; baseFrom; baseTo )
	Average rating: 3.9
	Debi Fuchs, Aptworks Consulting http://www.aptworks.com
	Convert a number (up to 10 billion) from one base to another.

87.	BaseEncode ( inputInt ; base )
	Average rating: 4.4
	Cory Alder, Davander Mobile Corporation http://mobile.davander.com
	Base64, or base62 encode any integer

88.	BaseX ( Integer ; Base )
	Average rating: 3.4
	JT Hughes, Queuedom http://notapplicable.com
	Converts Integer to base Base, where Base is between 2 and 36, inclusively.

89.	Before ( text ; searchString ; occurrence ; include_1 )
	Average rating: 4.7
	Fabrice Nordmann, 1-more-thing http://www.1-more-thing.com
	extracts text before search string

90.	BetragToESR ( Betrag )
	Average rating: 4.1
	Pavel Buncak, MacTech Buncak AG http://www.mactech.ch
	Num to ESR

91.	Between (text; searchString1; occurrence1; include1_1 ; searchString2; occ
	Average rating: 3.4
	Fabrice Nordmann, 1-more-thing http://www.1-more-thing.com
	extracts text between two search strings

92.	BetweenNext ( _text ; _searchString1 ; _occurrence1 ; _include1_boolean ; _searchString2 ; _occurrence2 ; _include2_boolean )_
	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

93.	Bezier ( t ; controlPoints )
	Average rating: 3.3
	Jeremy Bante, Gaia Herbs, Inc. http://www.gaiaherbs.com/
	Calculates points on Bezier curves

94.	BillingDay ( DayOfMonth )
	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.

95.	Bin2Dec ( bin ; dmy )
	Average rating: 3.4
	F. Osman Cabi, Cabitas http://www.cabitas.com
	Converts binary number to decimal number

96.	Bin2Hex ( binary )
	Average rating: 3.2
	Vaughan Bromfield, Vaughan Bromfield Design mailto:vbromfield@optusnet.com.au
	A function to convert a binary number to a hex string.

97.	BinomDist ( successes ; trials ; probability ; cumulative )
	Average rating: 2.8
	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.

98.	Bisiesto ( Anio, Tipo )
	Average rating: 3.7
	Miguel A. Aguerrea, Alquimia Digital http://www.alquimia-digital.com
	Calcula si un año es o no bisiesto.

99.	BitAnd ( x ; y )
	Average rating: 4.0
	Shaun Flisakowski, spf-15 http://www.spf-15.com/
	Bitwise AND operation on two numbers

100.	BitChange ( value ; bit )
	Average rating: 3.9
	Theo Ros, * http://notapplicable.com
	Toggles a bit in a value

101.	BitClear ( value ; bit )
	Average rating: 3.8
	Theo Ros, * http://notapplicable.com
	Clears a bit in a value

102.	BitOr ( x ; y )
	Average rating: 4.4
	Shaun Flisakowski, spf-15 http://www.spf-15.com/
	Bitwise OR operation on two numbers

103.	BitSet ( value ; bit )
	Average rating: 3.6
	Theo Ros, * http://notapplicable.com
	Sets a bit in a value

104.	BitTest ( value ; bit )
	Average rating: 4.0
	Theo Ros, * http://notapplicable.com
	Checks if bitnumber 'bit' in value 'value' is on or off

105.	BitTest2 ( value ; bit )
	Average rating: 3.6
	Stephen Drake, Synergy n/a
	Checks whether bit 'bit' in value 'value' is on or off

106.	BiweeklyFrom ( From Date ; After Date )
	Average rating: 3.7
	Kevin Hayes, KevTools http://www.kevtools.com
	Calculates the biweekly date based on From Date following After Date

107.	BoldItalicEncode ( Text )
	Average rating: 3.7
	Tom Robinson, Kōwhai Computing http://www.tomrobinson.co.nz/
	Encode any bold or italic text with tags

108.	BoldRed ( input )
	Average rating: 3.7
	Dwayne Wright, dwaynewright.com http://www.dwaynewright.com
	Simple use of combining two text formatting functions into one streamlined custom function

109.	BubbleSort ( inputValues ; iterations )
	Average rating: 3.3
	Greg Lane, The Moyer Group http://www.moyergroup.com
	Sorts a list of return-separated values.

110.	BubbleSort_SlideValue ( inputValues ; target )
	Average rating: 2.8
	Greg Lane, The Moyer Group http://www.moyergroup.com
	BubbleSort_SlideValue is used by the BubbleSort function.

111.	BusinessDays ( startDate ; endDate )
	Average rating: 4.8
	Jeremy Bante, Gaia Herbs, Inc. http://www.gaiaherbs.com/
	Returns the number of business days between two dates (inclusive)

112.	BusinessHolidays ( calendarYear )
	Average rating: 5.0
	Jeremy Bante, Gaia Herbs, Inc. http://www.gaiaherbs.com/
	Returns a list of observed holidays in calendarYear

113.	ButtonValue ( Number )
	Average rating: 2.1
	Matt Petrowsky, ISO Productions, Inc. http://www.filemakermagazine.com
	Useful to make it easier for passing multiple parameters to a script from a button.

114.	CalcDaysBetween ( startDate ; endDate ; numDays ; $$HolidayList ; countWeekends ; returnNeg )
	Average rating: 3.1
	Shan Younker, Shan Younker none
	Calculates number of days between dates, accounts for holidays and weekends

115.	calcEndDate ( startDate; numDays; loopCount; holidayList; allowWeekends; direction )
	Average rating: 3.1
	Shan Younker, Shan Younker -none
	Calculate date by adding or subtracting days, option for skipping weekends

116.	CalculateEndDate ( startDate ; days ; wkEnds )
	Average rating: 3.1
	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.

117.	Calendar ( c_Date )
	Average rating: 2.9
	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.

118.	CalendarDiff ( thedate ; gregorian )
	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

119.	CamelCasePrefix ( name )
	Average rating: 3.9
	Marc Wood, studentpress.org http://studentpress.org
	isolate first word of camelCase-formatted names

120.	CardinalToText ( Amount )
	Average rating: 3.9
	Clement Hoffmann, none none
	Converts Numbers to Text in French (...from 999 billions to the tenth of unit...)

121.	CardinalToText_Utility ( value ; quantifier )
	Average rating: 3.9
	Clement Hoffmann, none none
	called by http://www.briandunning.com/cf/573

122.	CaseStatus ( theText )
	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)

123.	CC_Expired ( ExpirationDate ; Checkdate )
	Average rating: 4.6
	Kevin Bache, None www.none.com
	Checks if credit card expiration date has past.

124.	celciusFromFahrenheit
	Average rating: 3.5
	Gjermund Gusland Thorsen, Gudthlandum Consulting http://www.gudthlandum.no
	Celcius From Fahrenheit

125.	CelsToFahr ( degreesCelsius )
	Average rating: 3.9
	Brian Dunning, BrianDunning.com http://www.briandunning.com/
	Converts degrees Celsius to degrees Fahrenheit.

126.	CenterWindow in Window vert horiz (demension)
	Average rating: 4.5
	Todd Dignan, Dignan Consulting Inc http://www.dignanconsulting.com
	Center Window in Window

127.	cfActiveLayout
	Average rating: 3.8
	Nicky Naessens, Aussiewords
	Shows the name of the active file, table and layout

128.	cfCode128 ( pString; pCodeSet )
	Average rating: 4.2
	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.

129.	cfColorByIndent (pText ; pIndentChar ; pRgbColorList)
	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

130.	cfGetData ( field )
	Average rating: 3.9
	Michele Olson, AppleSauce Productions, Inc. http://www.applesaucepro.com
	Returns the contents of a list of fields, recursive function.

131.	cfGetEveryNthValue ( pList ; pStart ; pIncrement ; pInputSeparator ; pOutputSeparator )
	Average rating: 3.3
	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

132.	cfHiliteText( text; searchText; colorRGB ; textStyle )
	Average rating: 2.8
	Martin D. Brunner, - http://-
	a customFunction for hiliting text in a field with following advantages:

133.	cfISRC (pMode ; pISRC_Code ; pRGB_OnError)
	Average rating: 3.5
	Tammo Fornalik / Felix Hausberner, dbyte solutions http://www.dbyte-solutions.com
	ISRC formatting / validating

134.	cfLayoutLister( whichFile; counter; fieldName; onlyLayouts; result)
	Average rating: 5.0
	Bruce Robertson, Concise Design http://www.concise-design.com
	List layouts and fields for specified file. Option to limit to match by field name.

135.	cfMatch ( value_to_test; match_Value; match_operator )
	Average rating: 4.0
	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

136.	cfStackAppendSlide( pInput; pVariableName; pStackDepth )
	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.

137.	cfTab ()
	Average rating: 3.4
	Michele Olson, AppleSauce Productions, Inc. http://www.applesaucepro.com
	Provides a tab character for formula use

138.	CF_blzcheck(BLZ;MAXIMUM)
	Average rating: 3.5
	Frank F. Hautog, Datenbank & Design http://www.wendland-design.de
	Check Banknumber

139.	cf_CenterWindowLeft ( width )
	Average rating: 3.4
	Stephen Dolenski, Ocean West Consulting, Inc http://www.fmforums.com
	Center window on creation using GTRR dialog box

140.	cf_CenterWindowTop ( height )
	Average rating: 3.0
	Stephen Dolenski, Ocean West Consulting, Inc http://www.fmforums.com
	Center window on creation using GTRR dialgo box

141.	cf_CMYK2RGB ( Cyan; Magenta; Yellow; Black )
	Average rating: 3.4
	Andrew Mallison, Mallison http://www.mallison.biz
	Convert CMYK colour values to a similar RGB values.

142.	cf_convertHexRGB( HexNumber; Separator )
	Average rating: 3.2
	Klemens Müller, Klemens Müller http://www.klemenso.de
	Convert hexadecimal RGB values

143.	CF_FechaEspanol(Fecha)
	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.

144.	cf_GetElement ( SearchString ; KeyList ; ElementList )
	Average rating: 3.6
	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.

145.	cf_getElementNo( SearchString ; ElementList )
	Average rating: 3.8
	Klemens Müller, Klemens Müller http://www.klemenso.de
	Get the line number of sought-after element in a list

146.	CF_HTMLtoFMP_styledText ( text ; num )
	Average rating: 3.3
	Chaim Bacon, Productive IT (UK) Ltd 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.

147.	CF_HTMLtoFMP_styledText_sub ( text ; openTag ; closeTag ; replaceWith )
	Average rating: 3.8
	Chaim Bacon, Productive IT (UK) Ltd 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.

148.	cf_ListR( Field ; Counter ; Maxi )
	Average rating: 2.9
	Klemens Müller, eichhorn. frankfurt http://www.eichhorn-frankfurt.de
	List-Function as counterpart to the new function in FileMaker 8.5

149.	CF_ListToCommas ( ListOfItems; And_Or_Parameter; MaxNumber )
	Average rating: 4.1
	Nick Stockbridge, Transmedia Training http://transmedia.co.uk
	Converts a carriage-return delimited list to one separated by commas, with the word

150.	cf_MacPath_AppleScriptPath(_path)
	Average rating: 3.8
	Edward Souza, Duana A. S. Designs http://none
	Formatting from Mac path to AppleScript path

151.	CF_ReplicaCar ( CadenaOriginal ; CantidadVeces ; CadenaResultante ))
	Average rating: 3.5
	Luis Gonzáles and Rigoberto Carbonell, AFS Group, Inc. http://www.afsgroup.us/
	Replicate CantidadVeces Times a Character or String, on resultan String

152.	cf_RomanNumeral ( _number ; _digit ; _Kmarker )
	Average rating: 3.8
	Christopher Gauntt, Cordega Solutions http://cordega.com
	Swaps out arabic numbers for roman numerals

153.	ChaosDecrypt ( cipherText ; key )
	Average rating: 3.2
	Jeremy Bante, Gaia Herbs, Inc. http://www.gaiaherbs.com/
	Decrypt text enciphered by the ChaosEncrypt() function

154.	ChaosEncrypt ( text ; key )
	Average rating: 4.1
	Jeremy Bante, Gaia Herbs, Inc. http://www.gaiaherbs.com/
	Encrypt text with a chaos-based stream cipher

155.	ChaosHash ( text ; hashLength )
	Average rating: 3.9
	Jeremy Bante, Gaia Herbs, Inc. http://www.gaiaherbs.com/
	Uses a chaotic process to create a hash of the specified length.

156.	Check Zip ( Address ; City ; State ; Zip )
	Average rating: 2.9
	Mark P, SIP Corporation www.sipgrinder.com
	Creates the URL for the USPS Check Zip Code Web Page

157.	CheckCF ( Codice Fiscale )
	Average rating: 3.6
	Daniele Raybaudi, ACI www.aci.it
	Only for Italian People

158.	checkEffectiveBitSize ( value )
	Average rating: 3.8
	Jeff Hough, Pre1 Software LLC http://www.pre1.com
	Test the strength of a password entered by the user.

159.	CheckIBAN ( IBAN )
	Average rating: 3.2
	Christoph Kaufmann, CLK http://clk.ch
	Checks whether the IBAN is correct or not

160.	CheckSofi (Sofi)
	Average rating: 2.9
	Hartger Visser, Teuker Beheer BV http://www.teuker.nl
	Validater for the Dutch Sofinumber against the '11-proef'.

161.	ChecksumAdler32 ( text ; seed1 ; seed2 )
	Average rating: 3.8
	Vaughan Bromfied, Vaughan Bromfield design http://google.com
	Creates a checksum of the input text bases on the Adler-32 algorithm.

162.	ChgWordOccWNums F1 ( _list ; F1StartNum ; ChgWord )
	Average rating: 4.6
	Pavle Ancevski, NYHTC PAN http://NA.com
	Change word occurrences in a list with consecutive numbers

163.	ChooseFolder
	Average rating: 3.3
	NicoWeb, NicoWeb http://www.nicoweb.com
	Choose Folder opens a folder selector windows and returns path folder

164.	Chr ( ascii )
	Average rating: 3.2
	Theo Ros, n/a n/a
	Returns the character for the given ascii value

165.	circleArea ( radius )
	Average rating: 3.5
	Scott Love, The Moyer Group http://www.moyergroup.com/
	Calculates the area of a circle of specified radius.

166.	CleanText ( Text )
	Average rating: 3.3
	Tim Cimbura, Cimbura.com Technology http://www.cimbura.com
	Strips out illegal text characters and simplifies.

167.	ClearRepeatingVariable ( variableName ; startIndex ; endIndex )
	Average rating: 5.0
	Kevin Frank, Kevin Frank & Associates http://www.kevinfrank.com
	Clears a range of repetitions for a specified variable

168.	Clock()
	Average rating: 3.4
	Don Wieland, DW Data Concepts http://www.dwdataconcepts.com
	CF for displaying a running time in a webviewer

169.	ClosestDate( TestDate; ValueList)
	Average rating: 3.8
	Ken Newell, Hamilton Glaucoma Center
	Find the closest date between a one to many relationship.

170.	Codify( theText; code_option )
	Average rating: 3.0
	Bruce Robertson, Concise Design http://concise-design.com
	Encode/decode any input text using native code() & char() functions

171.	Codigos de Bancos
	Average rating: 3.5
	Paco Caetano, TRAMANO SERIGRAFIA http://www.notengoweb.com
	Al insertar los 4 digitos del codigo del banco te dice el banco al que pertenece.

172.	CollapseList ( listOfValues )
	Average rating: 3.3
	Michael Horak, *COMMENT Visual Realisation http://comment.cjb.net
	Collapses a list of values by replacing serially incrementing sections with their range boundaries.

173.	Color ( Text )
	Average rating: 3.2
	Geoff Coffey,
	Use a color name to specify a color in FileMaker rather than RGB values.

174.	Color_HEX_Random
	Average rating: 5.0
	Thomas Siebert, Thomas Siebert http://www.t-seabird.de
	generating a random color in HEX format

175.	ColumnsAcross ( listOfValues ; numberOfColumns ; columnDelimiter )
	Average rating: 3.1
	Michael Horak, *COMMENT Visual Realisation http://comment.cjb.net/
	Transforms a list of values into a tabular text array.

176.	ColumnWrap ( Text ; StartRow ; NofRows )
	Average rating: 3.1
	Martin D. Brunner, Zurich Financial Services http://www.mdb.bz
	Non recursive custom function for colum break after a certain amount of linebreaks

177.	CombineLists ( Start; End; ListFieldsObjects; Separator; Function )
	Average rating: 3.9
	Agnes Barouh, Tic Tac http://www.tictac.fr/CoinFileMaker/Page.html
	concatenate n FieldsLists or ObjectsList

178.	CombineValues ( list1 ; list2 )
	Average rating: 4.4
	Jonathan Stark, Jonathan Stark Consulting http://jonathanstark.com/
	Combines two lists of values, sort of like php's array_combine function

179.	CombineValues( list1, list2, divider )
	Average rating: 4.2
	Jeff Drake, Excelisys, Inc. http://www.excelisys.com
	returns a grid of all values in two lists

180.	ConcatListAndConstant ( theList ; Constant ; Place ; Separator)
	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

181.	ConditDateRange ( StartDate ; EndDate ; Weekend )
	Average rating: 3.7
	Miguel Angel, n/a n/a
	Date range that may include weekends or not.

182.	ConditionalSummary ( TypeField ; Type ; SumField )
	Average rating: 4.3
	Koji Takeuchi, Splash, Inc. http://www.splash.jp/
	Sum a SumField for records where TypeField matches "Type" param.

183.	ConsecCount ( ItemList ; StartingItem )
	Average rating: 3.8
	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.

184.	ContainerSize ( Container ; Precision )
	Average rating: 3.4
	Robert Schaub, Starr Data http://starrdata.com
	Get the size of your container

185.	ContrastText ( foregroundText ; bgRedPercent ; bgGreenPercent ; bgBluePercen
	Average rating: 3.5
	Joe Rovang, none specified N/A
	Colors foregroundText black or white as appropriate for the specified background color.

186.	Convert ( number ; from ; to )
	Average rating: 3.3
	Marco Terrile, ChefMaTe http://www.chefmate.it
	Units converter for kitchen use ;-)

187.	ConvertFMPath(FMPath)
	Average rating: 3.7
	Andy Knasinski, NRG Software, LLC. http://www.nrgsoft.com
	Convert FileMaker Path to Windows Path

188.	ConvertFractToNum ( number )
	Average rating: 3.9
	Colin Keefe, IT Solutions Consulting, Inc http://itsolutions-inc.com
	Converts a fraction to a real number.

189.	ConvertMins_hh:mm( MinutesInput )
	Average rating: 4.0
	Sean Libin, Stride http://www.stridemgmt.com
	This converts number of minutes to hh:mm format

190.	ConvertTextDate ( TextDate )
	Average rating: 3.9
	Darryl Oliver, N/A N/A
	Convert text date to a FileMaker date

191.	ConvertTimeStamp ( unixTimeStamp )
	Average rating: 3.5
	Andy Knasinski, NRG Software, LLC. http://www.nrgsoft.com
	Convert unix timestamp to FMP timestamp

192.	convert_gps_gausskrueger2wgs84( coordinate ; error)
	Average rating: 3.3
	TS Wolf,
	Converts an Gauß-Krüger-coordinate (as used by O2) to an comma-seperated WGS84-coordinate

193.	convert_gps_gausskrueger2wgs84_sub (Latitude ; CartOutputXMeters ; CartOutputYMeters ; CartOutputZMeters)
	Average rating: 4.0
	TS Wolf,
	Recursive subclass to convert_gps_gausskrueger2wgs84 and cannot be used on ist own

194.	CorrespondingValue ( indexValues ; searchValue ; listOfValues )
	Average rating: 3.2
	Michael Horak, *COMMENT Visual Realisation http://comment.cjb.net/
	Finds the first occurrence of searchValue in indexValues and returns the corresponding value in listOfValues.

195.	cosSeries ( angleInRadians ; series ; k )
	Average rating: 3.6
	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.

196.	CountPermutations ( string )
	Average rating: 4.2
	maarten witberg, maarten witberg http://none
	To determine the number of permutations for a string of characters

197.	CountWordOccurrences ( text ; searchWord )
	Average rating: 0.0
	Michael Horak, *COMMENT Visual Realisation http://comment.cjb.net/
	Returns the number of occurrences of searchWord as word in text.

198.	CreateConstantMatrix (
	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).

199.	CreateVariables ( text )
	Average rating: 3.9
	Chris Bartlett, .
	Create variables from a text string like "Name=Jai;Age=1"

200.	CreditCardName ( CreditCardNumber )
	Average rating: 4.0
	Geoff Wells, DataIsland Software LLC http://www.dataisland.com
	Returns the CC type from the number

201.	CropYield ( Moisture ; Weight ; RowLength ; RowWidth ; RowCount ; CropAdjustment)
	Average rating: 3.5
	Tim Griffith, Developer Tim Griffith
	Calculates Crop Yields

202.	Crossfoot ( value )
	Average rating: 3.4
	Christoph Ivo Mattle, Christophs http://www.christophmattle.ch
	1-digit Crossfoot calculation

203.	CSStoFMText (text)
	Average rating: 3.8
	Christopher Gauntt, Cordega Solutions http://www.cordega.com
	Converts CSS inline styles to FileMaker Pro Text

204.	csv.getColumn( array; returnColumn; delimiter)
	Average rating: 5.0
	Bruce Robertson, Concise Design http://concise-design.com
	Get designated column from delimited array

205.	csv.getColumn.if( array; matchColumn; matchValue; returnColumn; delimiter)
	Average rating: 3.5
	Bruce Robertson, Concise Design http://concise-design.com
	Get column from array for match in another column

206.	csv.getrows.if( array; matchColumn; matchValue; delmiter)
	Average rating: 4.1
	Bruce Robertson, Concise Design http://concise-design.com
	Return entire rows where value of matchColumn = matchValue

207.	csv.getValue
	Average rating: 3.1
	Nicolas Bourré, Me, Myself and I http://nbourre.ep.profweb.qc.ca/blogue
	Returns a specific cell or row in a CSV table

208.	CullNulls ( listOfValues )
	Average rating: 3.6
	Debi Fuchs, Aptworks Consulting http://www.aptworks.com
	Speedily (and with no recursion) remove empty items from a list.

209.	Currency(Amount, Code, Lead, Trail, ShowDecimal, RedNegative)
	Average rating: 3.0
	Tony Tanevski, Hi-Voltage http://www.hi-voltage.com.au
	Format currency as text in many formats (inc. red negative)

210.	CurrencyToText_SP (Monto , Currency , Sufijo)
	Average rating: 3.8
	Ibrahim Bittar Torres, Eikonsys http://www.eikonsys.com
	Converts Numbers to Text in Spanish (up to 18 digits)

211.	CustomList ( Start ; End ; Function )
	Average rating: 4.3
	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

212.	CustomListOLDVersion ( Start; End; Function)
	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

213.	CustomList_BottomUp ( Start ; End ; Function )
	Average rating: 3.6
	Agnes Barouh, Tic Tac http://www.tictac.fr/CoinFileMaker/Page.html
	customized lists - Reverse list - Not recursive

214.	CV ( Principal ; Rate; Frequency; BegDate; EndDate )
	Average rating: 3.3
	Timothy Brown, Antidote Solutions http://www.antidotesolutions.com
	Current Value of an Investement based on compounded interest

215.	DailySerial ( AEfield ; digit ; format )
	Average rating: 3.6
	Daniele Raybaudi, ACI www.aci.it
	Autoenter a serial number that increments daily

216.	DashInsert ( text )
	Average rating: 3.9
	Daniele Raybaudi, ACI www.aci.it
	Returns the given text with dashes between numbers and chars

217.	DataFormattata ( testo )
	Average rating: 3.1
	Daniele Raybaudi, ACI www.aci.it
	Restituisce il testo inserito nella formattazione data: gg/mm/aaaa

218.	DataType ( Stuff )
	Average rating: 4.2
	Matt Navarre, MSN Media http://www.msnmedia.com
	Returns type of data, ie Integer, Date, Email, Phone, Text

219.	date.format ( theDate ; format )
	Average rating: 3.6
	Tim Anderson, TAg http://www.timanderson.co.uk/
	A function to return a date in a text format specified at the time.

220.	DateAgeDisplay ( aTimeStamp )
	Average rating: 4.2
	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

221.	DateByDayOccur ( yearNum ; monthNum ; dayOfWeekNum ; dayOccurance )
	Average rating: 3.6
	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.

222.	DateByName ( dname ; curdate )
	Average rating: 4.1
	Gustav Hobel, Purple Phaze Productions n/a
	Returns the next date based on a day name.

223.	DateByNthDOW ( tYear ; tMonth ; tDayOfWeek ; tNum )
	Average rating: 3.6
	Koji Takeuchi, Splash, Inc. http://www.splash.jp/
	Pick Nth day of week in specified year and month.

224.	DateDDlongMonthYYYY(xDate)
	Average rating: 4.0
	Tony Tanevski, Hi-Voltage http://www.hi-voltage.com.au
	Converts a date to DD longMonth YYYY format. i.e. 1 Jan 2006

225.	DateDDshortMonthYYYY(xDate)
	Average rating: 4.6
	Tony Tanevski, Hi-Voltage http://www.hi-voltage.com.au
	Converts a date to DD shortMonth YYYY format. i.e. 1 Jan 2006

226.	DateDif( date1 ; date 2 ; flag )
	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.

227.	DateDifference ( date1 ; date2 ; format )
	Average rating: 3.3
	Paul Jansen, APJ Ltd http://www.apjuk.com
	Calculate age ( years, months, weeks and days between 2 any two dates

228.	DateDueHolidays ( StartDate ; TransitDays ; HolidayList )
	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

229.	DateFormat
	Average rating: 3.4
	Eilert Sundt, Eilert Sundt Systemdesign http://www.eilert.no
	Returns a representation of a file's current date format

230.	DateFormat( Entered_Date )
	Average rating: 4.4
	Veselko Pesut, PLANet Systems Group http://www.planetsg.com
	When you want to format date in non-date field.

231.	DateFormatUSA (textDate)
	Average rating: 3.4
	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 :)

232.	DateHolidayFlag ( datefield )
	Average rating: 3.8
	Steve Gerow, Abrazos Data Consulting, Inc. http://www.abrazosdata.com
	Holiday Weekend conditional formatting calc for date field

233.	DateNameFormat ( theDate )
	Average rating: 3.7
	David Goetzka, Untoil Software Group http://untoil.com
	change date format to day name and ordinal date

234.	DateOffset ( startdate ; monthoffset ; dayoffset ; yearoffset)
	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.

235.	DateOfWeek ( week ; yearOfWeek ; type )
	Average rating: 3.3
	Reinder Wolting, ABECON http://www.abecon.nl
	Calculate the first date of a given week and year

236.	DatePlusMinus ( datefield ; internal param )
	Average rating: 4.6
	Steve Gerow, Abrazos Data Consulting, Inc. http://www.abrazosdata.com
	Enters current date, subtracts a day or adds a day

237.	DateQuarterAsRange ( theDate )
	Average rating: 3.1
	Chiyoko Yoshida, chiyofm http://www.chiyofm.com/
	Pass any date and get the quarter END date based on input date.

238.	DateQuarterBegin ( theDate )
	Average rating: 4.4
	Chiyoko Yoshida, chiyofm http://www.chiyofm.com/
	Pass any date and get the quarter start date based on input date.

239.	DateQuarterEnd ( theDate )
	Average rating: 3.4
	Chiyoko Yoshida, chiyofm http://www.chiyofm.com/
	Pass any date and get the quarter END date based on input date.

240.	DateRange ( StartDate ; EndDate ; RangeLimit )
	Average rating: 3.3
	Andrew Persons, Excelisys http://www.excelisys.com/
	Creates a multi-key field containing a range of dates.

241.	DateRange ( startDate ; finishDate ; returnType )
	Average rating: 3.3
	Michael Richards, itraining http://www.itraining.com.au
	Calculate the number of days "d", months "m" or years "y" between two dates

242.	DateRangePast ( refdate; mos )
	Average rating: 4.8
	Atalanta, Imagination Design http://www.goldapples.com
	Starting with your reference date calculate a range backward x months

243.	DateRangeVal( LowDate ; HighDate )
	Average rating: 3.8
	Alex Babkov, Real Evolution http://www.realevolution.com.au
	Date Range Validation

244.	DateRangewoWe ( ID ; StartDate ; EndDate )
	Average rating: 3.5
	Holger Bolecke, fmworks.de http://www.fmworks.de
	Creates date ranges without weekend days

245.	DateRSSPubDate ( theDate )
	Average rating: 4.0
	Hal Gumbert, CampSoftware http://www.campsoftware.com
	Formats the Date as 'Fri, 29 Aug 2008'.

246.	DateShipByHolidays ( DueDate ; TransitDays ; HolidayList )
	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.

247.	DatesToMonths ( Date1 ; Date2 )
	Average rating: 3.8
	Timothy Brown, Antidote Solutions http://www.antidotesolutions.com
	This show the number of months between 2 dates

248.	DateTimeAsSerial ( DateTime; ElemSep ; SectSep )
	Average rating: 3.8
	Doug Larsen, August Technology http://www.AugustTech.com
	Returns the date and time in a TEXT string that can be ordered properly.

249.	DateTimeString(theDate, theTime)
	Average rating: 4.0
	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

250.	DateTime_From_TimeStamp ( FM_TimeStamp )
	Average rating: 4.1
	Gary Czychi, GC Consulting http://www.Czychi.com/
	Takes a FileMaker Timestamp value and returns a MySQL DATETIME string

251.	DateToJD ( thedate ; gregorian )
	Average rating: 3.8
	Theo Ros, * http://notapplicable.com
	converts a date into a Julian Day number

252.	DateToSortableText ( thedate )
	Average rating: 3.3
	Theo Ros, * http://notapplicable.com
	Returns a sortable textual representation of a date value

253.	DateTranslate ( d ; lang ; format )
	Average rating: 3.8
	LingoJango, AIB http://www.aibcnet.com
	Date output in different languages and formats

254.	DateValues( date1 ; date2 )
	Average rating: 3.5
	Jonathan Stark, Jonathan Stark Consulting http://jonathanstark.com/
	Generates a return delimited list of date for the given range.

255.	DateValuesStrict ( dateBegin ; dateEnd )
	Average rating: 3.8
	Jonathan Stark, Jonathan Stark Consulting http://jonathanstark.com/
	Generate a return delimited list of date for the specified range.

256.	DateWrittenOut ( datefield )
	Average rating: 4.2
	Jonathan Ray, Richard Carlton Consulting http://www.rcconsulting.com
	Converts a date field to written text

257.	DayCounter ( Date_Start ; Date_End; Days_of_Week )
	Average rating: 3.2
	Joshua Morton, JEM Consulting http://jemconsulting.net
	Counts number of times a day or days occurs over a date range

258.	DayCounterHolidays ( Date_Start ; Date_End ; Days_of_Week ; Holidays )
	Average rating: 5.0
	Joshua Morton, JEM Consulting http://jemconsulting.net
	Counts number of types of days between 2 dates excluding holidays

259.	DayLightSavings ( TargetDate ; TargetTime; Hours )
	Average rating: 3.0
	Tim Brown, Antidote Solutions http://www.antidotesolutions.com
	Day Light Saving Time

260.	DaylightSavingsBegins
	Average rating: 3.6
	Yvonne Dutreaux, Cordblood Registry http://www.cordblood.com
	Returns the timestamp of beginning of Daylight Savings Time

261.	DaylightSavingsEnds
	Average rating: 2.9
	Yvonne Dutreaux, Cordblood Registry http://www.cordblood.com
	Returns the timestamp of end of Daylight Savings Time

262.	DayNameDates ( theDayName ; StartDate ; EndDate )
	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

263.	DayNameList ( LocaleID )
	Average rating: 3.5
	Theo Ros, n/a n/a
	Returns a list of Day names according to the given LocaleID

264.	DayNameToDayOfWeek ( theDayName )
	Average rating: 3.9
	Daniele Raybaudi, ACI www.aci.it
	returns the day of week of a given day name

265.	DayOccur ( selDate )
	Average rating: 3.5
	Don Wieland, DW Data Concepts http://www.dwdataconcepts.com
	Calculates what Week Occurence and DayName in a month.

266.	DayofFiscalYear ( TheDate ; StartingDay ; StartMonth ; StartDay )
	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.

267.	DayofMonthbyWeek ( DayofWeekWanted_Sunday_1 ; WeekWantedasNum ; MonthasNum ; YearasNum )
	Average rating: 3.4
	Yvonne Dutreaux, Cordblood Registry http://www.cordblood.com
	Find the weekday of a given month by week, ie: the 3rd Wednesday of the Month

268.	DaysDifference ( Date1 ; Date2 )
	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.

269.	DaysDifferenceAbs ( Date1; Date2 )
	Average rating: 3.8
	Andrew Sasaki, n/a n/a
	Returns the number of days difference in two dates.

270.	DaysOfFebruary( myDate )
	Average rating: 2.6
	Gjermund Gusland Thorsen, Gudthlandum Consulting http://www.developer.no
	Gives you then number of days in February the year of myDate

271.	DaysToNextBirthday ( birthdate )
	Average rating: 3.8
	Theo Ros, * http://notapplicable.com
	Returns the number of days to the next birthday

272.	Days_Diff ( date1 ; date2 )
	Average rating: 3.6
	Ron Smith, PaperCutPro http://www.papercutpro.com
	Days difference part between two dates.

273.	DayWeekYear2Date ( dayNR ; weekNR ; yearNR )
	Average rating: 5.0
	Arjen van der Ree, Maxperts http://www.maxperts.nl
	Turns DayNr. WeekNr. & Year into a Date

274.	DCount (inputValues; value)
	Average rating: 3.3
	Rolf Clausen, Mallverkstan AB http://www.mallverkstan.com
	Counts the number of values.

275.	Debug ( )
	Average rating: 3.8
	Matt Petrowsky, ISO FileMaker Magazine http://www.filemakermagazine.com
	Used to output environment data within a Show Dialog script step.

276.	Dec2Bin ( decimalNumber ; binaryNumber )
	Average rating: 3.7
	Ronald W. Satz, Transpower Corporation http://www.transpowercorp.com
	Converts decimal number (positive integer) to binary number

277.	Dec2Bin9 ( decnum )
	Average rating: 3.8
	M S Pease,
	Converts a decimal number to its binary equivalent.

278.	Dec2Hex ( theNumber ; num0s )
	Average rating: 3.3
	Samuel Herschbein, Comsultant http://www.oz.net/~samh
	Convert Decimal # to Hex Text

279.	Dec2HexNoLeading0s ( theNumber )
	Average rating: 3.2
	Samuel Herschbein, Consultant http://www.oz.net/~samh
	Convert Decimal # to Hex Text with no leading zeros

280.	DecimalToFraction ( number )
	Average rating: 4.0
	Michael Myett, FileMaker Apps http://filemakerapps.biz
	convert decimal numbers to fractions

281.	DecimalToHrMin ( aNumber )
	Average rating: 3.5
	Andy Knasinski, NRG Software, LLC. http://www.nrgsoft.com
	This CF will return a decimal value in a format of hour and minutes

282.	DecodeAccents ( text )
	Average rating: 2.9
	Sean Dellis, Designer/Programmer http://seandellis.com
	Converts most upper and lower case latin accented characters into standard alphabetical characters.

283.	DecToAlpha ( decimal )
	Average rating: 3.4
	Michael Horak, *COMMENT Visual Realisation http://comment.cjb.net
	Returns the representation of a decimal number as a variable-length alphabetic text string.

284.	DecToAnyBase ( decimal ; base )
	Average rating: 3.3
	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.

285.	DeDupe ( startstring ; valuelist )
	Average rating: 3.5
	Rob Westergaard, DataStorm Solutions http://www.datastorm-solutions.com/
	This function removes duplicate values from an alphabetical value list.

286.	DeduplicateList ( input ; output )
	Average rating: 4.6
	Peter Roots, N/A N/A
	Removes duplicates from a return-delimited list of values

287.	DeleteDuplicatesList ( listOfValues )
	Average rating: 4.2
	HAZI, none http://hazisarashi.com/
	Delete all duplicate values from a list.

288.	DeleteMiddleText ( Value ; StringStart ; StringEnd )
	Average rating: 5.0
	Ruben van den Boogaard, Infomatics Software http://infomatics.nl
	Delete text between markers

289.	DeleteValue ( list ; index )
	Average rating: 3.4
	Theo Ros, n/a n/a
	Returns a list with value at position 'index' removed

290.	DeleteVariableText ( Value ; StringStart ; StringEnd ; Pos ; Start ; End ) )
	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

291.	DepreciationReducingBalanceRate ( Cost ; ResidualValue ; NoYrsDepreciation)
	Average rating: 4.9
	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

292.	DepreciationStraightLineAmount ( Cost ; ResidualValue ; NoYrsDepreciation )
	Average rating: 3.6
	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

293.	dfAlphaNumericFilter(Text;ReplaceText)
	Average rating: 4.1
	Caspar Harmer, Digital Fusion Ltd http://www.digitalfusion.co.nz
	Replace non alphanumeric characters with anything (or nothing)

294.	DialByWord ( phoneNumberString )
	Average rating: 4.1
	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)

295.	Dialog OK Cancel ( Position 1; Position 2; Title; Width; Dialog Text
	Average rating: 3.3
	Brian Hightower, J Hightower, Inc http://www.homesolution.ws
	24u Dialog with a default OK and Cancel Button

296.	Dice ( N ; S )
	Average rating: 3.9
	Barbecue, Le Kastelo de Barbakoa http://www.milleniumhandandshrimp.com
	Generates random integers simulating dice-rolling or coin-flipping

297.	DifferenceValues(ListA; ListB)
	Average rating: 3.8
	Koen Van Hulle, SHpartners http://www.shpartners.com
	Returns a single instance of all lines that are in ListA but not in ListB

298.	Digitise ( text )
	Average rating: 3.7
	John Bochan, private private
	Returns same psuedo-random number for same text input

299.	DirectionFrom ( Lat1 ; Lon1 ; Lat2 ; Lon2 )
	Average rating: 4.2
	Chris Pye, Mactec http://mactec.com.au
	Calculates the approximate direction in cardinal (compass) points from one location on earth to another.

300.	DistanceBetweenPoints ( Lat1; Lon1; Lat2; Lon2; Units )
	Average rating: 3.2
	Vaughan Bromfield, Vaughan Bromfield Design http://www.google.com.au/
	Calculates the distance between any two points on Earth.

301.	DistanceGeoCoord ( Lat1deg ; Lat1mm ; Lat1ss ; Lon1deg ; Lon1mm ; Lon1ss ; Lat2deg ; Lat2mm ; Lat2ss ; Lon2deg ; Lon2mm ; Lon2ss ; U ; Version )
	Average rating: 3.7
	Edward_Souza, n/a n/a
	Measure the distance between two geographic coordinates

302.	DistanceList ( BaseLat ; BaseLong ; ListOfLatLongIdentifiers ; Delimiter ; Units ; SortableDistance )
	Average rating: 4.2
	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

303.	Distribution( uniqueList; dataList)
	Average rating: 4.3
	Bruce Robertson, Concise Design http://concise-design.com
	For each item in list 1, counts occurrences in list 2

304.	DistributionTR ( uniqueList; dataList)
	Average rating: 4.0
	Bruce Robertson, Concise Design http://concise-design.com
	For each item in list 1, counts occurrences in list 2

305.	DuoTrigesimalToNum ( DTGString )
	Average rating: 3.8
	Tim Griffith, None None
	Converts Duotrigesimal strings into numbers

306.	EANofISBN ( pool ; ISBNnr )
	Average rating: 3.2
	Reinder Wolting, ABECON http://www.abecon.nl
	Generate the EAN barcode for the given ISBN#

307.	Easter ( myDate )
	Average rating: 4.0
	Mike Duncan, Duncan Creations http://www.duncancreations.com
	Show when Easter falls in the calendar year for any given date.

308.	Easter ( theYear )
	Average rating: 3.6
	Reinder Wolting, ABECON http://www.abecon.nl
	Calculates the date of Easter sunday of a given year

309.	Easterday ( Date )
	Average rating: 5.0
	Johan Söderberg, Distingo http://www.distingo.nu
	Calculates the date for any easterday according to Gauss formula.

310.	EDATE ( evalDate ; months )
	Average rating: 4.3
	Jorge Kluchnik,
	Replicates the EDATE function from Excel

311.	Edate ( thedate ; months )
	Average rating: 3.6
	Barry Maskell, Real Estate Navigator http://www.realestatenavigator.com.au
	Excel style EDATE function

312.	EightBall ( Question )
	Average rating: 4.0
	Chris Kubica, Application Architects, LLC http://www.applicationarch.com
	Ask the Eightball a Question and Get An Answer

313.	Elapsed ( StartDate ; EndDate )
	Average rating: 3.6
	Lee Smith, Smith and Associates none
	Elapsed Date to Text

314.	ElapsedbyIno ( StartDate ; EndDate ; Type )
	Average rating: 3.7
	Aleksandar Rubeša, Q.com doo http://q-com.hr
	For rest of us ISO: D M Y or ANSI: Y M D

315.	ElapsedTime ( TStampBegin; TStampEnd; Format )
	Average rating: 3.3
	Geoff Wells, DataIsland Software LLC http://www.dataisland.com
	Calculates elapsed time from Timestamps

316.	ElapsedTime_CFpub( tsStart ; tsEnd)
	Average rating: 3.6
	James Hea, None None
	Elapsed Time in Years, Months, Days, Hours, Minutes and Seconds

317.	EliminatePrefix ( value; prefix )
	Average rating: 3.4
	Martin Brunner, Zurich Financial Services http://www.zurichconnect.ch
	Recursively eliminate any prefixes

318.	EmailAddressProper ( text )
	Average rating: 3.1
	Esa Niiniranta, Bittihiisi http://bittihiisi.net
	Returns the proper form of an email address

319.	EmailName ( account )
	Average rating: 3.0
	Dwayne Wright, dwaynewright.com http://www.dwaynewright.com
	Returns the name associated with the email (sans domain)

320.	Employ (StartDate, EndDate)
	Average rating: 3.8
	Pascal Dimopoulos, Primary School Education http://uesrs.otenet.gr/~dnapas
	Estimates the employment time between two dates.

321.	EnclosingObjects (_objectName )
	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.

322.	Encode ( text ; code ; startValue )
	Average rating: 3.5
	Daniele Raybaudi, ACI www.aci.it
	A simple encoder

323.	encodeEmail ( email ; rName )
	Average rating: 3.4
	Hunter Chisholm, Protean Solutions http://proteansolutions.com/
	Encode HTML mailto link as hexadecimal string

324.	EncodeURL_CF ( textToCode )
	Average rating: 4.3
	Paul Spafford, Spafford Data Solutions http://www.paulspafford.com
	Encodes all urls enclosed in square brackets for html.

325.	EncryptDate (TheDate)
	Average rating: 4.0
	Ibrahim Bittar Torres, Eikonsys http://www.eikonsys.com
	Converts a date in a pseudo activation code format

326.	endDate(theDate; months)
	Average rating: 5.0
	Tim Brown, Antidote Solutions http://www.antidotesolutions.com
	Calc the end date based on number of months to preserve the day of month.

327.	EnDeCoder( Text ; Code2 )
	Average rating: 3.5
	Charles Garr, cgarr software http://havenone.com
	Simple decoder and encoder in one

328.	eParse ( text )
	Average rating: 2.2
	d.schellenberg, rivet design communications http://www.rivetcom.ca
	parse an e-mail addres from a string of text

329.	ErrorCode( ErrorNum )
	Average rating: 2.9
	Roger Biel, 2Geckos Consulting, LLC www.2geckos.com
	Updated Filemaker Error codes to english

330.	ErrorJP_11 ( ErrorCode )
	Average rating: 4.5
	Koji Takeuchi, Splash, Inc. http://www.splash.jp/
	Return Description of specified Error Code of FMP11 in Japanese.

331.	ErrorToEnglish ( ErrorNum )
	Average rating: 3.2
	Jeremiah Small, Soliant Consulting http://jsmall.us
	Translate FileMaker error codes to the English language description.

332.	EscapeForOsascriptShell ( escapeThis )
	Average rating: 4.2
	Daniel A. Shockley, NYHTC http://www.nyhtc.org
	Escapes a value so that it can be used in a nested AppleScript/shell/AppleScript command

333.	EscapeXML ( Text )
	Average rating: 4.8
	Ibrahim Bittar, Eikonsys, S.A. de C.V. http://www.eikonsys.com
	Simple function to escape characters for XML

334.	EvalCalcInserts ( Text )
	Average rating: 5.0
	Koji Takeuchi, Splash, Inc. http://www.splash.jp/
	Replace "Calc" to value of Calc Evaluated.

335.	Even Odd Week Today
	Average rating: 3.2
	Steve Lelle, Steve Lelle Enterprises, Inc. http://lelle.com
	Returns "Odd" or "Even" for Currant Date

336.	EvenCharacters ( text )
	Average rating: 3.3
	Daniele Raybaudi, ACI www.aci.it
	Returns even-numbered characters of text.

337.	EventCount ( DateBegin ; DateEnd ; Frequency ; When )
	Average rating: 3.4
	Jonathan Stark, Jonathan Stark Consulting http://jonathanstark.com/
	Counts the number of times a repeating event will occur between two dates.

338.	ExcelNumberToTime ( ExcelNumber)
	Average rating: 3.7
	Daniele Raybaudi, ACI www.aci.it
	Returns the time in correct format for FM

339.	Exclude ( TextToFilter; FilterText )
	Average rating: 4.2
	Agnes Barouh, Tic Tac http://www.tictac.fr/CoinFileMaker/Page.html
	Exclude the characters to be filtered

340.	ExplodedKey ( ID ; StartDate; EndDate )
	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

341.	ExplodedString ( Field )
	Average rating: 3.9
	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.

342.	ExplodedString_Work( field )
	Average rating: 3.7
	Michael Alexander, none no website
	Exploded String Variant

343.	ExtractData ( XML ; Attribute ; Instance )
	Average rating: 3.9
	Andy Knasinski, NRG Software http://www.nrgsoft.com/
	Extract specific data out of XML formatted text without using FileMaker's built-in XML functionality.

344.	ExtractEmailAddresses ( text ; placeholder )
	Average rating: 3.5
	Bart Bartholomay, HAB Marketing http://habmarketing.com
	Extract Email Addresses

345.	ExtractEmails ( Text )
	Average rating: 3.8
	Ilya Shuvalov, SUI Solutions http://filemaker.suisolutions.com
	Extracts list of e-mails found in Text

346.	ExtractFromText( TextBody ; keyText )
	Average rating: 4.1
	Tim Anderson, TAg http://www.timanderson.co.uk/
	Returns strings/values from text

347.	ExtractLine ( TextField ; LineNumber )
	Average rating: 3.8
	Michael Haymore, N/A http://www.my-xanadu.net
	Return a specific line out of a text field.

348.	ExtractPhoneNumbers ( text ; placeholder )
	Average rating: 4.2
	Bart Bartholomay, HAB Marketing http://habmarketing.com
	Extract Phone numbers

349.	ExtractPortion ( textField ; prePortion ; postPortion )
	Average rating: 2.9
	Doug Elam, US Home Systems, Inc. http://www.ushomesystems.com/
	Extract a portion of a text field

350.	ExtractTableCell ( HTML ; cellNumber )
	Average rating: 3.4
	Michael Horak, *COMMENT Visual Realisation http://comment.cjb.net/
	Returns the contents of the specified cell in HTML table.

351.	ExtractXMLAttributeList__cf ( _xml ; _attribute ; _instance )
	Average rating: 4.1
	Steve Hearn, CoreSolutions Software Inc http://coresolutions.ca
	Extracts a list of values that are contained within the XML attribute tag

352.	FadeGreentoRed ( text ; score ; lowest ; highest )
	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.

353.	FahrToCels ( degreesFahrenheit )
	Average rating: 3.7
	Brian Dunning, BrianDunning.com http://www.briandunning.com/
	Converts degrees Fahrenheit to degrees Celsius.

354.	FastDateInput ( input ; format )
	Average rating: 3.9
	Fabrice Nordmann, 1-more-thing http://www.1-more-thing.com
	Allows user to input a date faster

355.	FastTimeInput ( _Time )
	Average rating: 3.8
	Paul Sazonov, APS http://www.briandunning.com/
	Fast time input

356.	Fedex_Country ( Country )
	Average rating: 3.2
	Yvonne Dutreaux, CBR None
	Converts country name into the two character country code used by FedEx

357.	Fibonacci ( n )
	Average rating: 3.8
	Steve Allen, Richard Carlton Consulting, Inc. http://www.rcconsulting.com
	Formula calculation of the number at n in the Fibonacci sequence. No recursion.

358.	Fibonacci ( N )
	Average rating: 3.6
	Rob Poelking, N/a http://printstar.biz
	Nth result of the Fibonocci series

359.	Fibonacci ( Seed1; Seed2; Iterations )
	Average rating: 4.3
	Geoff Wells, DataIsland Software LLC http://www.dataisland.com
	Returns a Fibonacci series

360.	FieldBeginsWith ( Text )
	Average rating: 2.9
	Andrew Persons, Excelisys http://www.excelisys.com/
	Creates a multikey field containing all the increments of the beginning of the supplied text.

361.	FieldNames2FieldValues ( Text )
	Average rating: 3.9
	Ilya Shuvalov, SUI Solutions http://filemaker.suisolutions.com
	Replaces field names with field values in Text

362.	FieldRepeats ( repeatingField ; 1 )
	Average rating: 3.7
	Theo Ros, n/a n/a
	Returns the true number of repetitions for a repeating field

363.	FieldRepeatsByName ( "fieldName" )
	Average rating: 3.1
	Theo Ros, n/a n/a
	Returns the true number of repetitions for a repeating field

364.	FilePathToHFS ( FMFilePath )
	Average rating: 3.7
	Tom Robinson, Kōwhai Computing http://www.tomrobinson.co.nz/
	Convert from FileMaker filepath to HFS filepath (superseded by FilePathToOS)

365.	FilePathToOS ( FMFilePath )
	Average rating: 3.3
	Tom Robinson, Kōwhai Computing http://www.tomrobinson.co.nz/
	Convert from FileMaker filepath to OS filepath (HFS or NTFS)

366.	FilePathToURL ( FMFilePath )
	Average rating: 3.2
	Tom Robinson, Kōwhai Computing http://www.tomrobinson.co.nz/
	Convert from FileMaker filepath to URL

367.	FillProperties (PropertyList ; PropertyValues ; Separator ; Blanks)
	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

368.	FilterASCII ( text ; extended )
	Average rating: 3.3
	Michael Horak, *COMMENT Visual Realisation http://comment.cjb.net/
	Removes characters from text, retaining only printable ASCII characters.

369.	FilterC ( text ; AZaz09etc )
	Average rating: 3.3
	Thomas Seidler, The Good Book Company http://www.harmlesswise.com
	not quite a regex filter, but easier than

370.	FilterFileName ( text ; filetype )
	Average rating: 4.7
	Michael Myett, FileMaker Apps http://filemakerapps.biz
	filtering field contents as a file name when exporting record set to Excel or Acrobat file

371.	filterLines(filterField;filterValue;Result)
	Average rating: 4.5
	Rob Atkinson, Webwyz Systems http://www.webwyzsystems.com
	Examines a list of values, removing lines that do not contain a given filter value.

372.	FilterList ( ListA ; Attribute ; ListB ; CaseSensitive )
	Average rating: 4.0
	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

373.	FilterValuesByTest ( text ; varName ; test ; include_1 )
	Average rating: 3.3
	Fabrice Nordmann, 1-more-thing http://www.1-more-thing.com
	Returns a text filtered by a test

374.	FilterWordsByTest ( text ; varName ; test ; include_1 ; mode )
	Average rating: 2.8
	Fabrice Nordmann, 1-more-thing http://www.1-more-thing.com
	Returns a text filtered by a test

375.	Filter_Stopwords ( Text )
	Average rating: 3.8
	Thomas Seidler, The Good Book Company http://www.harmlesswise.com/it
	simple one function stopwords remover

376.	FindInList( array; value )
	Average rating: 2.9
	Michael Rhodes, Allied Data Service http://allieddataservice.com
	Get the valuenumber of a value in a list

377.	FindRepetition ( searchString; repeatingField; start; occurrence; end; partialMatch ; matchCase )
	Average rating: 3.5
	Peter Wagemans, SHpartners http://www.shpartners.com
	Calculates the repetition number where a search string can be found in a repeating field

378.	FindValues ( list ; searchString ; matchcase )
	Average rating: 3.7
	Theo Ros, n/a n/a
	Returns a list of all values from the original list that contain the given search string.

379.	FirstBlankRepetition ( RepeatingField ; StartingRepetition )
	Average rating: 3.2
	Brian Dunning, BrianDunning.com http://www.briandunning.com
	Finds the first blank repetition in a repeating field.

380.	FirstCapitalPosition ( text ; textLength )
	Average rating: 4.1
	Marc Wood, studentpress.org http://studentpress.org
	finds first capital letter position in text

381.	FirstDayThisWeek ( StartDay )
	Average rating: 3.3
	Matt Wills, Virtual Vermont http://www.virtualvermont.com/FMP/
	Date of first day of current week

382.	FirstMonday ( themonth ; theyear )
	Average rating: 3.2
	Theo Ros, * http://notapplicable.com
	Returns the date for the first Monday in a given month

383.	FirstQuartile ( valueList )
	Average rating: 4.1
	Daniele Raybaudi, ACI www.aci.it
	returns 1st quartile of a value list

384.	FiscalYear ( TheDate ; FYStartMonth )
	Average rating: 3.3
	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.

385.	FiveCharsPermutations(text;number)
	Average rating: 4.1
	Daniele Raybaudi, ACI www.aci.it
	Returns all 120 simple permutations of the five characters of the field

386.	FiveFieldsPermutations (field1;field2;field3;field4;field5;number)
	Average rating: 3.5
	Daniele Raybaudi, ACI www.aci.it
	Returns all 120 simple permutations of the contents of five fields

387.	FixedLength ( text ; char ; charsNumber ; align )
	Average rating: 3.2
	Daniele Raybaudi, ACI www.aci.it
	Returns a fixed length string.

388.	Fixed_DecimalDigits ( Num ; DecCount )
	Average rating: 3.4
	AnKe, N/A N/A
	format a number to a predefined number of decimal digits - recursive

389.	FlagGender ( text )
	Average rating: 3.2
	Peter Vinogradov, Peter Vinogradov Consulting http://www.petervinogradov.com
	Flags gender pronouns in text with caps and brackets.

390.	FlexCeiling ( number ; precision )
	Average rating: 2.9
	Kevin Frank, Kevin Frank & Associates http://www.kevinfrank.com
	An expanded "Ceiling" that accepts a precision argument

391.	FlexFloor ( number ; precision )
	Average rating: 3.7
	Kevin Frank, Kevin Frank & Associates http://www.kevinfrank.com
	An expanded "Floor" that accepts a precision argument

392.	FlipACoin
	Average rating: 3.9
	Chris Kubica, Application Architects, LLC http://www.applicationarch.com
	Auto Enter The Result of a Coin Flip Into a Text Field

393.	FlipDigits ( value )
	Average rating: 2.8
	Theo Ros, * http://notapplicable.com
	flips decimal digits for textual sort purposes

394.	FMGrowl(title, description, sticky, message)
	Average rating: 3.3
	Douglas Alder, HomeBase Software Publishing Ltd. http://hbase.net
	Add Growl notification to your FileMaker solutions.

395.	FMP7ProtocolRegFix
	Average rating: 2.8
	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

396.	FMPToTRIO( FMP_GetPath )
	Average rating: 4.4
	Don Wieland, DW Data Concepts http://www.dwdataconcepts.com
	Converts FMP GetPaths to TROI File Plug-in Paths

397.	FM_Name_ID ( _Name_ID ; _TLFSV ; _fileName ; _layoutName )
	Average rating: 3.8
	Fabrice Nordmann, 1-more-thing http://www.1-more-thing.com
	Returns FileMaker item Name or ID, given the other

398.	fnAddressParser ( address ; type )
	Average rating: 3.5
	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.

399.	fnALSourceParse ( source ; attribute )
	Average rating: 3.3
	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

400.	FNameLNameOrg ( FName ; LName ; Org )
	Average rating: 3.7
	Don Wieland, DW Data Concepts http://www.dwdataconcepts.com
	Helps to parse different combinations of entries for a Name Display.

401.	fnCalendar ( date_field ; parameter ; iteration ; highlight_weekends ; holiday_list )
	Average rating: 2.9
	Andrew Butt, Drewsol http://www.drewsol.com
	c. 2009 Drewsol. This CF consolidates a simple calendar display and selection tool complete with limitless iterations, highlights, holidays, and tooltips.

402.	fnCalendarLite ( date_field ; parameter ; iteration ; highlight_weekends ; holiday_list )
	Average rating: 3.4
	Andrew Butt, Drewsol http://www.drewsol.com
	fnCalendar minus documentation and integrated holiday list.

403.	fnGoogleLineChart ( chtitle ; xtitle ; ytitle ; xfield ; yfield ; color )
	Average rating: 3.7
	Jeremy Upton, DME Supply Group http://www.dmesupplygroup.com
	Extremely simple line chart solution using a web viewer and Google API

404.	fnGoogleMap (Address; City; State; Zip; Zoom)
	Average rating: 3.6
	Jeremy Upton, DME Supply Group http://www.dmesupplygroup.com
	NEW VERSION!!! Shows embedded (map only portion) Google Map within a web viewer object. No API required!

405.	fnHTMLAttributeList ( object ; attribute )
	Average rating: 3.9
	Jeremy Upton, DME Supply Group http://www.dmesupplygroup.com
	To be used with the custom function - fnALSourceParse

406.	fnLatLon.bearing ( lat1 ; lon1 ; lat2 ; lon2 )
	Average rating: 3.4
	Michael George, Michael George Consulting mailto:mgeorge@coresupport.com
	Calculates initial bearing between two points on Earth's surface.

407.	fnNameParser ( name ; type )
	Average rating: 3.0
	Andrew Butt, Drewsol http://www.drewsol.com
	c. 2009 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.

408.	fnNumberFormat ( number ; decimals ; dec_point ; thousands_sep )
	Average rating: 3.1