| 1. |
#AlAradan( #metin ; #aranan1 ; #aranan2) |
| |
Average rating: 3.1 |
| |
Kadir Kaleli, Yordam
http://www.yordam.com |
| |
cümleden parça alma ; getting piece from text |
| |
|
| 2. |
#ParcaEle ( #metin ; #aranan ) |
| |
Average rating: 4.3 |
| |
Kadir Kaleli, Yordam
http://www.yordam.com |
| |
Aranan jokerli parçayi yoket ; Replace string with wildcard |
| |
|
| 3. |
#TL ( #rakam ) |
| |
Average rating: 4.1 |
| |
Kadir Kaleli, Yordam
http://www.yordam.com |
| |
To translate a number into text. |
| |
|
| 4. |
ƒilter ( text ; AZazƒ09etc ) |
| |
Average rating: 3.7 |
| |
Thomas Seidler, The Good Book Company
http://www.harmlesswise.com/it |
| |
FilterC built to handle foreign characters (and a bit more) |
| |
|
| 5. |
Abscind ( text ; margin ) |
| |
Average rating: 4.4 |
| |
Ray Cologon, NightWing Enterprises
http://www.nightwing.com.au/FileMaker |
| |
Adds or repositions line breaks in supplied text so it wraps to specified margins. |
| |
|
| 6. |
AbsolutePaddingZeroes( number; digits ) |
| |
Average rating: 2.9 |
| |
Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.gudthlandum.no |
| |
Pads a number to have static length of digits |
| |
|
| 7. |
Academic ( theDate ) |
| |
Average rating: 4.2 |
| |
Matt Wills, Virtual Vermont
http://www.virtualvermont.com/FMP/ |
| |
Returns the academic season of a given date. |
| |
|
| 8. |
Accordion( NumberedList; selectedGroup; showNumbers ) |
| |
Average rating: 4.4 |
| |
Bruce Robertson, Concise Design
http://concise-design.com |
| |
Given a numbered list and a selected group number, collapse all items in unselected group. |
| |
|
| 9. |
Acos ( number ) |
| |
Average rating: 4.0 |
| |
Brian Dunning, BrianDunning.com
http://www.briandunning.com/ |
| |
Returns the arc cosine of a given number. |
| |
|
| 10. |
Acronym ( text ) |
| |
Average rating: 3.9 |
| |
Ray Cologon, NightWing Enterprises
http://www.nightwing.com.au/FileMaker |
| |
Returns the first letter of each word in phrase (in upper case). |
| |
|
| 11. |
ActualLineCount ( Text ; CharsPerLine ) |
| |
Average rating: 3.7 |
| |
Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/ |
| |
Determine if text is overflowing field bounds on layout. |
| |
|
| 12. |
AddConstantToListValues ( theList ; theConstant ) |
| |
Average rating: 3.4 |
| |
Simon Plint, Thanks For The Memories
http://www.thanks.com.au |
| |
Concatenate each value in a list with constant piece of text. |
| |
|
| 13. |
AddConstantToString( string; fillchar; posit ; direction; iter) |
| |
Average rating: 3.1 |
| |
Martti Tumanto, Martinova Oy
http://www,martinova.fi |
| |
Adds a constant string to very Nth position of a string |
| |
|
| 14. |
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. |
| |
|
| 15. |
AddDollarFormat ( Number ) |
| |
Average rating: 3.9 |
| |
Jeremiah Small, Soliant Consulting
http://jsmall.us |
| |
Turn unformatted number into dollars with commas rounded to nearest penny. |
| |
|
| 16. |
AddEllipsis ( theText ; theLength ) |
| |
Average rating: 3.2 |
| |
Simon Plint, Thanks For The Memories
http://thanks.com.au |
| |
Truncates theText if longer than theLength and adds ... |
| |
|
| 17. |
AddPrefixSuffixToList ( theList ; prefix ; suffix ) |
| |
Average rating: 4.2 |
| |
Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com |
| |
add a prefix or suffix to each line in a list |
| |
|
| 18. |
AddProperty ( propertyList ; propertyName ; propertyValue ) |
| |
Average rating: 3.7 |
| |
Shaun Flisakowski, spf-15
http://www.spf-15.com/ |
| |
Add a new name/value pair to an existing property list |
| |
|
| 19. |
AddRemove ( value ; content ) |
| |
Average rating: 3.4 |
| |
Matt Petrowsky, ISO Productions, Inc.
http://www.filemakermagazine.com |
| |
A custom function which allows simple addition or extraction of values from a list. |
| |
|
| 20. |
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 |
| |
|
| 21. |
AddressBlock ( com ; cont ; a1 ; a2 ; a3 ; a4 ; c %3 |
| |
Average rating: 3.4 |
| |
Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com |
| |
Calculated Address block from separate fields - handles missing elements |
| |
|
| 22. |
AddressLabel ( Name ; Address ; City ; State ; ZIP ; Country ) |
| |
Average rating: 3.5 |
| |
Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au |
| |
Address Labels - slide-up missing text in an address label |
| |
|
| 23. |
AddTextRight ( text ; number ; addedtext ) |
| |
Average rating: 3.3 |
| |
Drew Boone, Doulos Ministries, Inc.
http://www.douloscorp.com |
| |
Adds text to the right of a specified string the specified number of times |
| |
|
| 24. |
After ( text ; searchString ; occurrence ; include_1 ) |
| |
Average rating: 4.4 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
extracts text after search string |
| |
|
| 25. |
Age ( Birth; theDate; Format ) |
| |
Average rating: 3.5 |
| |
Geoff Wells, DataIsland Software LLC
http://www.dataisland.com |
| |
Calculates Age in three formats |
| |
|
| 26. |
age ( birthday ) |
| |
Average rating: 3.0 |
| |
Bailey Kessing, NCI-Frederick
http://kessing.com |
| |
calculates the correct age |
| |
|
| 27. |
age ( date1 ; date2 ) |
| |
Average rating: 2.8 |
| |
Winfried Huslik, Huslik Verlag GmbH
http://fmdiff.com |
| |
Calculates the number of years, months, and days between any two dates |
| |
|
| 28. |
Age ( DOB ) |
| |
Average rating: 2.3 |
| |
Chris Stasny, EducatorsInc
http://EducatorsInc.com |
| |
Converts date of birth to an age in years |
| |
|
| 29. |
All ( relatedField ; rFieldCount ; soughtValue ) |
| |
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 |
| |
|
| 30. |
AllFields ( start ) |
| |
Average rating: 4.2 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns the content of all the fields of a layout |
| |
|
| 31. |
AllMonthNames ( startMonthNumber ) |
| |
Average rating: 4.3 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns all the month's names from a given month number |
| |
|
| 32. |
AllTextCombinations ( theText ; stackDepth ) |
| |
Average rating: 3.1 |
| |
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 |
| |
|
| 33. |
AllTextCombinations(theText) |
| |
Average rating: 4.3 |
| |
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 |
| |
|
| 34. |
Alpha2Int ( Alpha ) |
| |
Average rating: 3.3 |
| |
JT Hughes, Queuedom
http://notapplicable.com |
| |
Converts Alpha string to its integral equivalent |
| |
|
| 35. |
AmtCompounded_cf ( principal ; rate ; iterations ) |
| |
Average rating: 3.9 |
| |
Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com |
| |
Calculates compounded amount from principal, interest and number of iterations. |
| |
|
| 36. |
AnnuallySerial ( AEfield ; digit ) |
| |
Average rating: 3.0 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Autoenter a serial number that increments annually |
| |
|
| 37. |
antiFilter (textToFilter ; filterAllow ; filterSubChar ; start ; stop ; textBuilt ) |
| |
Average rating: 3.9 |
| |
Michael Rauch, ShopWorks
http://www.shopworx.com |
| |
replace any character not specified in the allowed list with the substitute character |
| |
|
| 38. |
AntiFilterValues( ListA; ListB ) |
| |
Average rating: 3.8 |
| |
Bruce Robertson, Concise Design
http://concise-design.com |
| |
Return values only contained in ListA |
| |
|
| 39. |
Any ( relatedField ; rFieldCount ; soughtValue ) |
| |
Average rating: 2.7 |
| |
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 |
| |
|
| 40. |
AnyBaseToDec(number; base) |
| |
Average rating: 4.5 |
| |
Ferry, NCOI
http://www.ncoi.nl |
| |
Converts any base to decimal (max 32 base) |
| |
|
| 41. |
ApplescriptGetURL ( URLtoGet ; FieldtoSet ) |
| |
Average rating: 4.6 |
| |
Jim Main, Main Solutions
http://www.mainsolutions.org |
| |
Getting a web page via Applescript |
| |
|
| 42. |
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. |
| |
|
| 43. |
ApplyToList ( function ; listOfValues ; separator ) |
| |
Average rating: 3.2 |
| |
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. |
| |
|
| 44. |
ApplyToList( ListA; function, separator ) |
| |
Average rating: 3.8 |
| |
Bruce Robertson, Concise Design
http://concise-design.com |
| |
Apply FUNCTION to each item in list |
| |
|
| 45. |
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. |
| |
|
| 46. |
AreaConvert ( Width , Wunit , Height , Hunit , OutUnit ) |
| |
Average rating: 3.4 |
| |
Ibrahim Bittar, Eikonsys
http://www.eikonsys.com |
| |
Calculates areas based on multiple units |
| |
|
| 47. |
array.cellValueByColNum ( array ; rowName ; column ; delimiter ) |
| |
Average rating: 3.3 |
| |
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. |
| |
|
| 48. |
array.cellValueByColTitle (array ; rowName ; column ; delimiter ; useTitle ) |
| |
Average rating: 3.8 |
| |
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 |
| |
|
| 49. |
Asc ( char ) |
| |
Average rating: 4.0 |
| |
Theo Ros, n/a
n/a |
| |
Returns the Ascii code for the given character |
| |
|
| 50. |
AscAlphaNum ( str ) |
| |
Average rating: 3.5 |
| |
Tim Oehlke, Ecolab, Inc.
http://www.ecolab.com |
| |
returns an alphanumeric character's ASCII code value |
| |
|
| 51. |
AscIIToBase64 (string) |
| |
Average rating: 3.9 |
| |
Roberto Pellegrini, gestione datu
http://www.gestionedati.net |
| |
Convert text AscII To Base64 |
| |
|
| 52. |
AscIIToBase64 (string) |
| |
Average rating: 2.0 |
| |
Frank Seipel, Lilly's Media Logistics
http://www.lillysmedialogistics.com |
| |
Converts an arbitrary text string to BASE64. English functnion name version. |
| |
|
| 53. |
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 |
| |
|
| 54. |
ASFolderPath ( UnixFolderPath ) |
| |
Average rating: 2.8 |
| |
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 |
| |
|
| 55. |
ASFPCoreFx (UnixP2 ) |
| |
Average rating: 2.8 |
| |
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 |
| |
|
| 56. |
Asin ( number ) |
| |
Average rating: 3.0 |
| |
Brian Dunning, BrianDunning.com
http://www.briandunning.com/ |
| |
Returns the arc sine of a given number. |
| |
|
| 57. |
Astrological_Sign(date) |
| |
Average rating: 3.7 |
| |
John Pollard, Generic Human Studies
http://www.selfparenting.com |
| |
Determines a person's astrological sign based on their birthdate |
| |
|
| 58. |
atan2 ( y ; x ) |
| |
Average rating: 3.9 |
| |
Michael George, Michael George Consulting
mailto:mgeorge@coresupport.com |
| |
returns the base angle (arctan) of a triangle with the sides X and Y. |
| |
|
| 59. |
balance( theText; openbracket; closebracket ) |
| |
Average rating: 4.3 |
| |
Bruce Robertson, Concise Design
http://concise-design.com |
| |
Get text to length that balances open/close markers |
| |
|
| 60. |
base10_to_base64( integer ) |
| |
Average rating: 4.0 |
| |
Martin Sorich, FMBiotech
http://www.fmbiotech.com |
| |
Converts base 10 integer to base 64 alphanumeric character |
| |
|
| 61. |
Base64ToAscII ( string ) |
| |
Average rating: 2.8 |
| |
Frank Seipel, Lilly's Media Logistics
http://www.lillysmedialogistics.com |
| |
Convert text Base64 to AscII |
| |
|
| 62. |
Base64ToAscII (String) |
| |
Average rating: 3.0 |
| |
Roberto Pellegrini, gestione dati
http://www.gestionedati.net |
| |
Convert text Base64 to AscII |
| |
|
| 63. |
BaseConvert ( string; baseFrom; baseTo ) |
| |
Average rating: 4.6 |
| |
Debi Fuchs, Aptworks Consulting
http://www.aptworks.com |
| |
Convert a number (up to 10 billion) from one base to another. |
| |
|
| 64. |
BaseX ( Integer ; Base ) |
| |
Average rating: 3.3 |
| |
JT Hughes, Queuedom
http://notapplicable.com |
| |
Converts Integer to base Base, where Base is between 2 and 36, inclusively. |
| |
|
| 65. |
Before ( text ; searchString ; occurrence ; include_1 ) |
| |
Average rating: 4.0 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
extracts text before search string |
| |
|
| 66. |
BetragToESR ( Betrag ) |
| |
Average rating: 4.1 |
| |
Pavel Buncak, MacTech Buncak AG
http://www.mactech.ch |
| |
Num to ESR |
| |
|
| 67. |
Between (text; searchString1; occurrence1; include1_1 ; searchString2; occ |
| |
Average rating: 4.1 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
extracts text between two search strings |
| |
|
| 68. |
BetweenNext ( _text ; _searchString1 ; _occurrence1 ; _include1_boolean ; _searchString2 ; _occurrence2 ; _include2_boolean )_ |
| |
Average rating: 4.4 |
| |
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 |
| |
|
| 69. |
BillingDay ( DayOfMonth ) |
| |
Average rating: 3.5 |
| |
Brian Dunning, BrianDunning.com
http://www.briandunning.com |
| |
Makes sure the DayOfMonth given is actually a day in the current month. |
| |
|
| 70. |
Bin2Dec ( bin ; dmy ) |
| |
Average rating: 4.0 |
| |
F. Osman Cabi, Cabitas
http://www.cabitas.com |
| |
Converts binary number to decimal number |
| |
|
| 71. |
BinomDist ( successes ; trials ; probability ; cumulative ) |
| |
Average rating: 3.9 |
| |
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. |
| |
|
| 72. |
Bisiesto ( Anio, Tipo ) |
| |
Average rating: 4.0 |
| |
Miguel A. Aguerrea, Alquimia Digital
http://www.alquimia-digital.com |
| |
Calcula si un año es o no bisiesto. |
| |
|
| 73. |
BitAnd ( x ; y ) |
| |
Average rating: 3.4 |
| |
Shaun Flisakowski, spf-15
http://www.spf-15.com/ |
| |
Bitwise AND operation on two numbers |
| |
|
| 74. |
BitChange ( value ; bit ) |
| |
Average rating: 3.2 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Toggles a bit in a value |
| |
|
| 75. |
BitClear ( value ; bit ) |
| |
Average rating: 3.7 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Clears a bit in a value |
| |
|
| 76. |
BitOr ( x ; y ) |
| |
Average rating: 4.2 |
| |
Shaun Flisakowski, spf-15
http://www.spf-15.com/ |
| |
Bitwise OR operation on two numbers |
| |
|
| 77. |
BitSet ( value ; bit ) |
| |
Average rating: 3.6 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Sets a bit in a value |
| |
|
| 78. |
BitTest ( value ; bit ) |
| |
Average rating: 4.2 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Checks if bitnumber 'bit' in value 'value' is on or off |
| |
|
| 79. |
BitTest2 ( value ; bit ) |
| |
Average rating: 3.7 |
| |
Stephen Drake, Synergy
n/a |
| |
Checks whether bit 'bit' in value 'value' is on or off |
| |
|
| 80. |
BiweeklyFrom ( From Date ; After Date ) |
| |
Average rating: 3.3 |
| |
Kevin Hayes, KevTools
http://www.kevtools.com |
| |
Calculates the biweekly date based on From Date following After Date |
| |
|
| 81. |
BoldItalicEncode ( Text ) |
| |
Average rating: 4.1 |
| |
Tom Robinson, Kōwhai Computing
http://www.tomrobinson.co.nz/ |
| |
Encode any bold or italic text with tags |
| |
|
| 82. |
BubbleSort ( inputValues ; iterations ) |
| |
Average rating: 3.7 |
| |
Greg Lane, The Moyer Group
http://www.moyergroup.com |
| |
Sorts a list of return-separated values. |
| |
|
| 83. |
BubbleSort_SlideValue ( inputValues ; target ) |
| |
Average rating: 2.9 |
| |
Greg Lane, The Moyer Group
http://www.moyergroup.com |
| |
BubbleSort_SlideValue is used by the BubbleSort function. |
| |
|
| 84. |
ButtonValue ( Number ) |
| |
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. |
| |
|
| 85. |
CalcDaysBetween ( startDate ; endDate ; numDays ; $$HolidayList ; countWeekends ; returnNeg ) |
| |
Average rating: 3.3 |
| |
Shan Younker, Shan Younker
none |
| |
Calculates number of days between dates, accounts for holidays and weekends |
| |
|
| 86. |
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 |
| |
|
| 87. |
Calendar ( c_Date ) |
| |
Average rating: 3.2 |
| |
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. |
| |
|
| 88. |
CalendarDiff ( thedate ; gregorian ) |
| |
Average rating: 3.7 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Returns the number of days between a the Julian Calendar for a given date and the Gregorian Calendar |
| |
|
| 89. |
CardinalToText ( Amount ) |
| |
Average rating: 4.1 |
| |
Clement Hoffmann, none
none |
| |
Converts Numbers to Text in French (...from 999 billions to the tenth of unit...) |
| |
|
| 90. |
CardinalToText_Utility ( value ; quantifier ) |
| |
Average rating: 4.0 |
| |
Clement Hoffmann, none
none |
| |
called by http://www.briandunning.com/cf/573 |
| |
|
| 91. |
CaseStatus ( theText ) |
| |
Average rating: 4.5 |
| |
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) |
| |
|
| 92. |
CC_Expired ( ExpirationDate ; Checkdate ) |
| |
Average rating: 4.1 |
| |
Kevin Bache, None
www.none.com |
| |
Checks if credit card expiration date has past. |
| |
|
| 93. |
celciusFromFahrenheit |
| |
Average rating: 3.4 |
| |
Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.gudthlandum.no |
| |
Celcius From Fahrenheit |
| |
|
| 94. |
CelsToFahr ( degreesCelsius ) |
| |
Average rating: 3.5 |
| |
Brian Dunning, BrianDunning.com
http://www.briandunning.com/ |
| |
Converts degrees Celsius to degrees Fahrenheit. |
| |
|
| 95. |
cfActiveLayout |
| |
Average rating: 4.0 |
| |
Nicky Naessens, Aussiewords
|
| |
Shows the name of the active file, table and layout |
| |
|
| 96. |
cfCode128 ( pString; pCodeSet ) |
| |
Average rating: 4.9 |
| |
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. |
| |
|
| 97. |
cfColorByIndent (pText ; pIndentChar ; pRgbColorList) |
| |
Average rating: 4.8 |
| |
Tammo Fornalik / Felix Hausberner, dbyte solutions
http://www.dbyte-solutions.com |
| |
emphasizing thread-depths in a forum or indentations in text |
| |
|
| 98. |
cfGetData ( field ) |
| |
Average rating: 3.4 |
| |
Michele Olson, AppleSauce Productions, Inc.
http://www.applesaucepro.com |
| |
Returns the contents of a list of fields, recursive function. |
| |
|
| 99. |
cfGetEveryNthValue ( pList ; pStart ; pIncrement ; pInputSeparator ; pOutputSeparator ) |
| |
Average rating: 3.5 |
| |
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 |
| |
|
| 100. |
cfHiliteText( text; searchText; colorRGB ; textStyle ) |
| |
Average rating: 3.0 |
| |
Martin D. Brunner, -
http://- |
| |
a customFunction for hiliting text in a field with following advantages: |
| |
|
| 101. |
cfISRC (pMode ; pISRC_Code ; pRGB_OnError) |
| |
Average rating: 3.7 |
| |
Tammo Fornalik / Felix Hausberner, dbyte solutions
http://www.dbyte-solutions.com |
| |
ISRC formatting / validating |
| |
|
| 102. |
cfLayoutLister( whichFile; counter; fieldName; onlyLayouts; result) |
| |
Average rating: 4.4 |
| |
Bruce Robertson, Concise Design
http://www.concise-design.com |
| |
List layouts and fields for specified file. Option to limit to match by field name. |
| |
|
| 103. |
cfStackAppendSlide( pInput; pVariableName; pStackDepth ) |
| |
Average rating: 3.8 |
| |
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. |
| |
|
| 104. |
cfTab () |
| |
Average rating: 3.5 |
| |
Michele Olson, AppleSauce Productions, Inc.
http://www.applesaucepro.com |
| |
Provides a tab character for formula use |
| |
|
| 105. |
CF_blzcheck(BLZ;MAXIMUM) |
| |
Average rating: 3.2 |
| |
Frank F. Hautog, Datenbank & Design
http://www.wendland-design.de |
| |
Check Banknumber |
| |
|
| 106. |
cf_CenterWindowLeft ( width ) |
| |
Average rating: 4.2 |
| |
Stephen Dolenski, Ocean West Consulting, Inc
http://www.fmforums.com |
| |
Center window on creation using GTRR dialog box |
| |
|
| 107. |
cf_CenterWindowTop ( height ) |
| |
Average rating: 3.3 |
| |
Stephen Dolenski, Ocean West Consulting, Inc
http://www.fmforums.com |
| |
Center window on creation using GTRR dialgo box |
| |
|
| 108. |
cf_CH1903_WGS84 ( y ; x ) |
| |
Average rating: 3.2 |
| |
Ralph Nusser, Sogetes Computer-Services
http://www.sogetes.com |
| |
Convert Swiss coordinate data to normal WGS84 coordinates you find with GPS devices. |
| |
|
| 109. |
cf_CMYK2RGB ( Cyan; Magenta; Yellow; Black ) |
| |
Average rating: 4.3 |
| |
Andrew Mallison, Mallison
http://www.mallison.biz |
| |
Convert CMYK colour values to a similar RGB values. |
| |
|
| 110. |
cf_convertHexRGB( HexNumber; Separator ) |
| |
Average rating: 3.1 |
| |
Klemens Müller, Klemens Müller
http://www.klemenso.de |
| |
Convert hexadecimal RGB values |
| |
|
| 111. |
CF_FechaEspanol(Fecha) |
| |
Average rating: 3.4 |
| |
Rigoberto Carbonell And Luis González, AFS Group, Inc.
http://www.afsgroup.us/ |
| |
Translate the date into Spanish Completely, including day of the week. |
| |
|
| 112. |
cf_GetElement ( SearchString ; KeyList ; ElementList ) |
| |
Average rating: 3.5 |
| |
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. |
| |
|
| 113. |
cf_getElementNo( SearchString ; ElementList ) |
| |
Average rating: 4.5 |
| |
Klemens Müller, Klemens Müller
http://www.klemenso.de |
| |
Get the line number of sought-after element in a list |
| |
|
| 114. |
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. |
| |
|
| 115. |
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. |
| |
|
| 116. |
cf_ListR( Field ; Counter ; Maxi ) |
| |
Average rating: 4.2 |
| |
Klemens Müller, eichhorn. frankfurt
http://www.eichhorn-frankfurt.de |
| |
List-Function as counterpart to the new function in FileMaker 8.5 |
| |
|
| 117. |
CF_ListToCommas ( ListOfItems ) |
| |
Average rating: 3.6 |
| |
Nick Stockbridge, Transmedia Training
http://transmedia.co.uk |
| |
Converts a carriage-return delimited list to one separated by commas, with the word |
| |
|
| 118. |
cf_MacPath_AppleScriptPath(_path) |
| |
Average rating: 3.7 |
| |
Edward Souza, Duana A. S. Designs
http://none |
| |
Formatting from Mac path to AppleScript path |
| |
|
| 119. |
CF_ReplicaCar ( CadenaOriginal ; CantidadVeces ; CadenaResultante )) |
| |
Average rating: 4.0 |
| |
Luis Gonzáles and Rigoberto Carbonell, AFS Group, Inc.
http://www.afsgroup.us/ |
| |
Replicate CantidadVeces Times a Character or String, on resultan String |
| |
|
| 120. |
cf_WGS84_CH1903 ( Lat1 ; Lng1 ) |
| |
Average rating: 5.0 |
| |
Ralph Nusser, Sogetes Computer-Services
http://www.fmprofi.com |
| |
Converts GPS data from WGS84 to Swiss CH1903 coordinates |
| |
|
| 121. |
Check Zip ( Address ; City ; State ; Zip ) |
| |
Average rating: 4.0 |
| |
Mark P, SIP Corporation
www.sipgrinder.com |
| |
Creates the URL for the USPS Check Zip Code Web Page |
| |
|
| 122. |
CheckCF ( Codice Fiscale ) |
| |
Average rating: 3.7 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Only for Italian People |
| |
|
| 123. |
checkEffectiveBitSize ( value ) |
| |
Average rating: 4.3 |
| |
Jeff Hough, Pre1 Software LLC
http://www.pre1.com |
| |
Test the strength of a password entered by the user. |
| |
|
| 124. |
CheckIBAN ( IBAN ) |
| |
Average rating: 4.1 |
| |
Christoph Kaufmann, CLK
http://clk.ch |
| |
Checks whether the IBAN is correct or not |
| |
|
| 125. |
CheckSofi (Sofi) |
| |
Average rating: 3.2 |
| |
Hartger Visser, Teuker Beheer BV
http://www.teuker.nl |
| |
Validater for the Dutch Sofinumber against the '11-proef'. |
| |
|
| 126. |
ChecksumAdler32 ( text ; seed1 ; seed2 ) |
| |
Average rating: 0.0 |
| |
Vaughan Bromfied, Vaughan Bromfield design
http://google.com |
| |
Creates a checksum of the input text bases on the Adler-32 algorithm. |
| |
|
| 127. |
ChgWordOccWNums F1 ( _list ; F1StartNum ; ChgWord ) |
| |
Average rating: 4.2 |
| |
Pavle Ancevski, NYHTC PAN
http://NA.com |
| |
Change word occurrences in a list with consecutive numbers |
| |
|
| 128. |
ChooseFolder |
| |
Average rating: 2.0 |
| |
NicoWeb, NicoWeb
http://www.nicoweb.com |
| |
Choose Folder opens a folder selector windows and returns path folder |
| |
|
| 129. |
Chr ( ascii ) |
| |
Average rating: 3.7 |
| |
Theo Ros, n/a
n/a |
| |
Returns the character for the given ascii value |
| |
|
| 130. |
circleArea ( radius ) |
| |
Average rating: 3.6 |
| |
Scott Love, The Moyer Group
http://www.moyergroup.com/ |
| |
Calculates the area of a circle of specified radius. |
| |
|
| 131. |
CleanText ( Text ) |
| |
Average rating: 3.8 |
| |
Tim Cimbura, Cimbura.com Technology
http://www.cimbura.com |
| |
Strips out illegal text characters and simplifies. |
| |
|
| 132. |
Clock() |
| |
Average rating: 4.0 |
| |
Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com |
| |
CF for displaying a running time in a webviewer |
| |
|
| 133. |
ClosestDate( TestDate; ValueList) |
| |
Average rating: 3.0 |
| |
Ken Newell, Hamilton Glaucoma Center
|
| |
Find the closest date between a one to many relationship. |
| |
|
| 134. |
Codigos de Bancos |
| |
Average rating: 3.6 |
| |
Paco Caetano, TRAMANO SERIGRAFIA
http://www.notengoweb.com |
| |
Al insertar los 4 digitos del codigo del banco te dice el banco al que pertenece. |
| |
|
| 135. |
CollapseList ( listOfValues ) |
| |
Average rating: 3.9 |
| |
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net |
| |
Collapses a list of values by replacing serially incrementing sections with their range boundaries. |
| |
|
| 136. |
Color ( Text ) |
| |
Average rating: 3.8 |
| |
Geoff Coffey,
|
| |
Use a color name to specify a color in FileMaker rather than RGB values. |
| |
|
| 137. |
ColumnsAcross ( listOfValues ; numberOfColumns ; columnDelimiter ) |
| |
Average rating: 3.8 |
| |
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/ |
| |
Transforms a list of values into a tabular text array. |
| |
|
| 138. |
ColumnWrap ( Text ; StartRow ; NofRows ) |
| |
Average rating: 3.0 |
| |
Martin D. Brunner, Zurich Financial Services
http://www.mdb.bz |
| |
Non recursive custom function for colum break after a certain amount of linebreaks |
| |
|
| 139. |
CombineLists ( Start; End; ListFieldsObjects; Separator; Function ) |
| |
Average rating: 3.5 |
| |
Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html |
| |
concatenate n FieldsLists or ObjectsList |
| |
|
| 140. |
CombineValues ( list1 ; list2 ) |
| |
Average rating: 3.6 |
| |
Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/ |
| |
Combines two lists of values, sort of like php's array_combine function |
| |
|
| 141. |
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 |
| |
|
| 142. |
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 |
| |
|
| 143. |
ConditDateRange ( StartDate ; EndDate ; Weekend ) |
| |
Average rating: 3.0 |
| |
Miguel Angel, n/a
n/a |
| |
Date range that may include weekends or not. |
| |
|
| 144. |
ConsecCount ( ItemList ; StartingItem ) |
| |
Average rating: 3.7 |
| |
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. |
| |
|
| 145. |
ContainerSize ( Container ; Precision ) |
| |
Average rating: 4.3 |
| |
Robert Schaub, Starr Data
http://starrdata.com |
| |
Get the size of your container |
| |
|
| 146. |
ContrastText ( foregroundText ; bgRedPercent ; bgGreenPercent ; bgBluePercen |
| |
Average rating: 3.2 |
| |
Joe Rovang, none specified
N/A |
| |
Colors foregroundText black or white as appropriate for the specified background color. |
| |
|
| 147. |
Convert ( number ; from ; to ) |
| |
Average rating: 4.2 |
| |
Marco Terrile, ChefMaTe
http://www.chefmate.it |
| |
Units converter for kitchen use ;-) |
| |
|
| 148. |
ConvertFMPath(FMPath) |
| |
Average rating: 4.3 |
| |
Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com |
| |
Convert FileMaker Path to Windows Path |
| |
|
| 149. |
ConvertFractToNum ( number ) |
| |
Average rating: 4.0 |
| |
Colin Keefe, IT Solutions Consulting, Inc
http://itsolutions-inc.com |
| |
Converts a fraction to a real number. |
| |
|
| 150. |
ConvertMins_hh:mm( MinutesInput ) |
| |
Average rating: 3.4 |
| |
Sean Libin, Stride
http://www.stridemgmt.com |
| |
This converts number of minutes to hh:mm format |
| |
|
| 151. |
ConvertTextDate ( TextDate ) |
| |
Average rating: 3.4 |
| |
Darryl Oliver, N/A
N/A |
| |
Convert text date to a FileMaker date |
| |
|
| 152. |
ConvertTimeStamp ( unixTimeStamp ) |
| |
Average rating: 3.9 |
| |
Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com |
| |
Convert unix timestamp to FMP timestamp |
| |
|
| 153. |
CorrespondingValue ( indexValues ; searchValue ; listOfValues ) |
| |
Average rating: 4.8 |
| |
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/ |
| |
Finds the first occurrence of searchValue in indexValues and returns the corresponding value in listOfValues. |
| |
|
| 154. |
cosSeries ( angleInRadians ; series ; k ) |
| |
Average rating: 4.2 |
| |
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. |
| |
|
| 155. |
CountPermutations ( string ) |
| |
Average rating: 4.1 |
| |
maarten witberg, maarten witberg
http://none |
| |
To determine the number of permutations for a string of characters |
| |
|
| 156. |
CreateConstantMatrix ( |
| |
Average rating: 4.1 |
| |
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). |
| |
|
| 157. |
CreateVariables ( text ) |
| |
Average rating: 3.9 |
| |
Chris Bartlett, .
|
| |
Create variables from a text string like "Name=Jai;Age=1" |
| |
|
| 158. |
CreditCardName ( CreditCardNumber ) |
| |
Average rating: 3.8 |
| |
Geoff Wells, DataIsland Software LLC
http://www.dataisland.com |
| |
Returns the CC type from the number |
| |
|
| 159. |
CropYield ( Moisture ; Weight ; RowLength ; RowWidth ; RowCount ; CropAdjustment) |
| |
Average rating: 3.1 |
| |
Tim Griffith, Developer
Tim Griffith |
| |
Calculates Crop Yields |
| |
|
| 160. |
Crossfoot ( value ) |
| |
Average rating: 3.4 |
| |
Christoph Ivo Mattle, Christophs
http://www.christophmattle.ch |
| |
1-digit Crossfoot calculation |
| |
|
| 161. |
CSStoFMText (text) |
| |
Average rating: 4.6 |
| |
Christopher Gauntt, Cordega Solutions
http://www.cordega.com |
| |
Converts CSS inline styles to FileMaker Pro Text |
| |
|
| 162. |
CullNulls ( listOfValues ) |
| |
Average rating: 3.4 |
| |
Debi Fuchs, Aptworks Consulting
http://www.aptworks.com |
| |
Speedily (and with no recursion) remove empty items from a list. |
| |
|
| 163. |
Currency(Amount, Code, Lead, Trail, ShowDecimal, RedNegative) |
| |
Average rating: 3.8 |
| |
Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au |
| |
Format currency as text in many formats (inc. red negative) |
| |
|
| 164. |
CurrencyToText_SP (Monto , Currency , Sufijo) |
| |
Average rating: 4.8 |
| |
Ibrahim Bittar Torres, Eikonsys
http://www.eikonsys.com |
| |
Converts Numbers to Text in Spanish (up to 18 digits) |
| |
|
| 165. |
CustomList ( Start ; End ; Function ) |
| |
Average rating: 4.6 |
| |
Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html |
| |
Update, new version - customized lists - not recursive - Unlimited |
| |
|
| 166. |
CustomListOLDVersion ( Start; End; Function) |
| |
Average rating: 4.9 |
| |
Agnes Barouh, TicTac
http://www.tictac.fr/CoinFileMaker/Page.html |
| |
[old version] Custom Lists - For all native functions with a number |
| |
|
| 167. |
CustomList_BottomUp ( Start ; End ; Function ) |
| |
Average rating: 4.0 |
| |
Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html |
| |
customized lists - Reverse list - Not recursive |
| |
|
| 168. |
CV ( Principal ; Rate; Frequency; BegDate; EndDate ) |
| |
Average rating: 4.0 |
| |
Timothy Brown, Antidote Solutions
http://www.antidotesolutions.com |
| |
Current Value of an Investement based on compounded interest |
| |
|
| 169. |
DailySerial ( AEfield ; digit ; format ) |
| |
Average rating: 3.7 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Autoenter a serial number that increments daily |
| |
|
| 170. |
DashInsert ( text ) |
| |
Average rating: 3.6 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns the given text with dashes between numbers and chars |
| |
|
| 171. |
DataFormattata ( testo ) |
| |
Average rating: 3.7 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Restituisce il testo inserito nella formattazione data: gg/mm/aaaa |
| |
|
| 172. |
DataType ( Stuff ) |
| |
Average rating: 4.6 |
| |
Matt Navarre, MSN Media
http://www.msnmedia.com |
| |
Returns type of data, ie Integer, Date, Email, Phone, Text |
| |
|
| 173. |
date.format ( theDate ; format ) |
| |
Average rating: 4.1 |
| |
Tim Anderson, TAg
http://www.timanderson.co.uk/ |
| |
A function to return a date in a text format specified at the time. |
| |
|
| 174. |
DateAgeDisplay ( aTimeStamp ) |
| |
Average rating: 3.3 |
| |
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 |
| |
|
| 175. |
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. |
| |
|
| 176. |
DateByName ( dname ; curdate ) |
| |
Average rating: 4.8 |
| |
Gustav Hobel, Purple Phaze Productions
n/a |
| |
Returns the next date based on a day name. |
| |
|
| 177. |
DateDDlongMonthYYYY(xDate) |
| |
Average rating: 5.0 |
| |
Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au |
| |
Converts a date to DD longMonth YYYY format. i.e. 1 Jan 2006 |
| |
|
| 178. |
DateDDshortMonthYYYY(xDate) |
| |
Average rating: 4.0 |
| |
Tony Tanevski, Hi-Voltage
http://www.hi-voltage.com.au |
| |
Converts a date to DD shortMonth YYYY format. i.e. 1 Jan 2006 |
| |
|
| 179. |
DateDifference ( date1 ; date2 ; format ) |
| |
Average rating: 4.0 |
| |
Paul Jansen, APJ Ltd
http://www.apjuk.com |
| |
Calculate age ( years, months, weeks and days between 2 any two dates |
| |
|
| 180. |
DateDueHolidays ( StartDate ; TransitDays ; HolidayList ) |
| |
Average rating: 4.7 |
| |
Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com |
| |
Due date from Start Date plus intervening days, adding Holidays from user-entered table |
| |
|
| 181. |
DateFormat |
| |
Average rating: 3.0 |
| |
Eilert Sundt, Eilert Sundt Systemdesign
http://www.eilert.no |
| |
Returns a representation of a file's current date format |
| |
|
| 182. |
DateFormat( Entered_Date ) |
| |
Average rating: 4.0 |
| |
Veselko Pesut, PLANet Systems Group
http://www.planetsg.com |
| |
When you want to format date in non-date field. |
| |
|
| 183. |
DateFormatUSA (textDate) |
| |
Average rating: 4.1 |
| |
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 :) |
| |
|
| 184. |
DateHolidayFlag ( datefield ) |
| |
Average rating: 3.7 |
| |
Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com |
| |
Holiday Weekend conditional formatting calc for date field |
| |
|
| 185. |
DateNameFormat ( theDate ) |
| |
Average rating: 3.7 |
| |
David Goetzka, Untoil Software Group
http://untoil.com |
| |
change date format to day name and ordinal date |
| |
|
| 186. |
DateOffset ( startdate ; monthoffset ; dayoffset ; yearoffset) |
| |
Average rating: 4.2 |
| |
Erik Wegweiser, Intelligent Database
http://intelligentdb.com |
| |
Returns a start date, plus or minus a specified number of months, days or years. |
| |
|
| 187. |
DateOfWeek ( week ; yearOfWeek ; type ) |
| |
Average rating: 3.0 |
| |
Reinder Wolting, ABECON
http://www.abecon.nl |
| |
Calculate the first date of a given week and year |
| |
|
| 188. |
DatePlusMinus ( datefield ; internal param ) |
| |
Average rating: 4.9 |
| |
Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com |
| |
Enters current date, subtracts a day or adds a day |
| |
|
| 189. |
DateRange ( StartDate ; EndDate ; RangeLimit ) |
| |
Average rating: 4.0 |
| |
Andrew Persons, Excelisys
http://www.excelisys.com/ |
| |
Creates a multi-key field containing a range of dates. |
| |
|
| 190. |
DateRange ( startDate ; finishDate ; returnType ) |
| |
Average rating: 3.5 |
| |
Michael Richards, itraining
http://www.itraining.com.au |
| |
Calculate the number of days "d", months "m" or years "y" between two dates |
| |
|
| 191. |
DateRangeVal( LowDate ; HighDate ) |
| |
Average rating: 3.8 |
| |
Alex Babkov, Real Evolution
http://www.realevolution.com.au |
| |
Date Range Validation |
| |
|
| 192. |
DateRangewoWe ( ID ; StartDate ; EndDate ) |
| |
Average rating: 3.0 |
| |
Holger Bolecke, fmworks.de
http://www.fmworks.de |
| |
Creates date ranges without weekend days |
| |
|
| 193. |
DateRSSPubDate ( theDate ) |
| |
Average rating: 4.8 |
| |
Hal Gumbert, CampSoftware
http://www.campsoftware.com |
| |
Formats the Date as 'Fri, 29 Aug 2008'. |
| |
|
| 194. |
DateShipByHolidays ( DueDate ; TransitDays ; HolidayList ) |
| |
Average rating: 3.5 |
| |
Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com |
| |
Similar to ShipByDate but includes user-entered holidays from a table. |
| |
|
| 195. |
DatesToMonths ( Date1 ; Date2 ) |
| |
Average rating: 3.6 |
| |
Timothy Brown, Antidote Solutions
http://www.antidotesolutions.com |
| |
Find the date of the last day of the month |
| |
|
| 196. |
DateTimeAsSerial ( DateTime; ElemSep ; SectSep ) |
| |
Average rating: 3.3 |
| |
Doug Larsen, August Technology
http://www.AugustTech.com |
| |
Returns the date and time in a TEXT string that can be ordered properly. |
| |
|
| 197. |
DateTimeString(theDate, theTime) |
| |
Average rating: 4.8 |
| |
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 |
| |
|
| 198. |
DateToJD ( thedate ; gregorian ) |
| |
Average rating: 3.7 |
| |
Theo Ros, *
http://notapplicable.com |
| |
converts a date into a Julian Day number |
| |
|
| 199. |
DateToSortableText ( thedate ) |
| |
Average rating: 2.9 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Returns a sortable textual representation of a date value |
| |
|
| 200. |
DateTranslate ( d ; lang ; format ) |
| |
Average rating: 3.4 |
| |
LingoJango, AIB
http://www.aibcnet.com |
| |
Date output in different languages and formats |
| |
|
| 201. |
DateValues( date1 ; date2 ) |
| |
Average rating: 4.8 |
| |
Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/ |
| |
Generates a return delimited list of date for the given range. |
| |
|
| 202. |
DateValuesStrict ( dateBegin ; dateEnd ) |
| |
Average rating: 4.0 |
| |
Jonathan Stark, Jonathan Stark Consulting
http://jonathanstark.com/ |
| |
Generate a return delimited list of date for the specified range. |
| |
|
| 203. |
DateWrittenOut ( datefield ) |
| |
Average rating: 4.1 |
| |
Jonathan Ray, Richard Carlton Consulting
http://www.rcconsulting.com |
| |
Converts a date field to written text |
| |
|
| 204. |
DayLightSavings ( TargetDate ; TargetTime; Hours ) |
| |
Average rating: 3.4 |
| |
Tim Brown, Antidote Solutions
http://www.antidotesolutions.com |
| |
Day Light Saving Times |
| |
|
| 205. |
DaylightSavingsBegins |
| |
Average rating: 2.6 |
| |
Yvonne Dutreaux, Cordblood Registry
http://www.cordblood.com |
| |
Returns the timestamp of beginning of Daylight Savings Time |
| |
|
| 206. |
DaylightSavingsEnds |
| |
Average rating: 3.2 |
| |
Yvonne Dutreaux, Cordblood Registry
http://www.cordblood.com |
| |
Returns the timestamp of end of Daylight Savings Time |
| |
|
| 207. |
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 |
| |
|
| 208. |
DayNameList ( LocaleID ) |
| |
Average rating: 3.3 |
| |
Theo Ros, n/a
n/a |
| |
Returns a list of Day names according to the given LocaleID |
| |
|
| 209. |
DayNameToDayOfWeek ( theDayName ) |
| |
Average rating: 3.8 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
returns the day of week of a given day name |
| |
|
| 210. |
DayOccur ( selDate ) |
| |
Average rating: 3.7 |
| |
Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com |
| |
Calculates what Week Occurence and DayName in a month. |
| |
|
| 211. |
DayofFiscalYear ( TheDate ; StartingDay ; StartMonth ; StartDay ) |
| |
Average rating: 4.2 |
| |
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. |
| |
|
| 212. |
DayofMonthbyWeek ( DayofWeekWanted_Sunday_1 ; WeekWantedasNum ; MonthasNum ; YearasNum ) |
| |
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 |
| |
|
| 213. |
DaysDifference ( Date1 ; Date2 ) |
| |
Average rating: 3.7 |
| |
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. |
| |
|
| 214. |
DaysDifferenceAbs ( Date1; Date2 ) |
| |
Average rating: 3.5 |
| |
Andrew Sasaki, n/a
n/a |
| |
Returns the number of days difference in two dates. |
| |
|
| 215. |
DaysOfFebruary( myDate ) |
| |
Average rating: 1.8 |
| |
Gjermund Gusland Thorsen, Gudthlandum Consulting
http://www.developer.no |
| |
Gives you then number of days in February the year of myDate |
| |
|
| 216. |
DaysToNextBirthday ( birthdate ) |
| |
Average rating: 3.6 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Returns the number of days to the next birthday |
| |
|
| 217. |
Days_Diff ( date1 ; date2 ) |
| |
Average rating: 4.5 |
| |
Ron Smith, PaperCutPro
http://www.papercutpro.com |
| |
Days difference part between two dates. |
| |
|
| 218. |
DCount (inputValues; value) |
| |
Average rating: 3.2 |
| |
Rolf Clausen, Mallverkstan AB
http://www.mallverkstan.com |
| |
Counts the number of values. |
| |
|
| 219. |
Debug ( ) |
| |
Average rating: 3.6 |
| |
Matt Petrowsky, ISO FileMaker Magazine
http://www.filemakermagazine.com |
| |
Used to output environment data within a Show Dialog script step. |
| |
|
| 220. |
Dec2Bin ( decimalNumber ; binaryNumber ) |
| |
Average rating: 3.4 |
| |
Ronald W. Satz, Transpower Corporation
http://www.transpowercorp.com |
| |
Converts decimal number (positive integer) to binary number |
| |
|
| 221. |
Dec2Hex ( theNumber ; num0s ) |
| |
Average rating: 3.3 |
| |
Samuel Herschbein, Comsultant
http://www.oz.net/~samh |
| |
Convert Decimal # to Hex Text |
| |
|
| 222. |
Dec2HexNoLeading0s ( theNumber ) |
| |
Average rating: 3.1 |
| |
Samuel Herschbein, Consultant
http://www.oz.net/~samh |
| |
Convert Decimal # to Hex Text with no leading zeros |
| |
|
| 223. |
DecimalToFraction ( number ) |
| |
Average rating: 4.2 |
| |
Michael Myett, Home Computer Doctor
www.thehomecomputerdoctor.com |
| |
convert decimal numbers to fractions |
| |
|
| 224. |
DecToAlpha ( decimal ) |
| |
Average rating: 4.0 |
| |
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net |
| |
Returns the representation of a decimal number as a variable-length alphabetic text string. |
| |
|
| 225. |
DecToAnyBase ( decimal ; base ) |
| |
Average rating: 3.8 |
| |
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. |
| |
|
| 226. |
DeDupe ( startstring ; valuelist ) |
| |
Average rating: 4.0 |
| |
Rob Westergaard, DataStorm Solutions
http://www.datastorm-solutions.com/ |
| |
This function removes duplicate values from an alphabetical value list. |
| |
|
| 227. |
DeduplicateList ( input ; output ) |
| |
Average rating: 5.0 |
| |
Peter Roots, N/A
N/A |
| |
Removes duplicates from a return-delimited list of values |
| |
|
| 228. |
DeleteValue ( list ; index ) |
| |
Average rating: 4.3 |
| |
Theo Ros, n/a
n/a |
| |
Returns a list with value at position 'index' removed |
| |
|
| 229. |
DeleteVariableText ( Value ; StringStart ; StringEnd ; Pos ; Start ; End ) ) |
| |
Average rating: 3.5 |
| |
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 |
| |
|
| 230. |
DepreciationReducingBalanceRate ( Cost ; ResidualValue ; NoYrsDepreciation) |
| |
Average rating: 4.0 |
| |
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 |
| |
|
| 231. |
DepreciationStraightLineAmount ( Cost ; ResidualValue ; NoYrsDepreciation ) |
| |
Average rating: 5.0 |
| |
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 |
| |
|
| 232. |
dfAlphaNumericFilter(Text;ReplaceText) |
| |
Average rating: 3.4 |
| |
Caspar Harmer, Digital Fusion Ltd
http://www.digitalfusion.co.nz |
| |
Replace non alphanumeric characters with anything (or nothing) |
| |
|
| 233. |
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) |
| |
|
| 234. |
Dialog OK Cancel ( Position 1; Position 2; Title; Width; Dialog Text |
| |
Average rating: 3.6 |
| |
Brian Hightower, J Hightower, Inc
http://www.homesolution.ws |
| |
24u Dialog with a default OK and Cancel Button |
| |
|
| 235. |
Dice ( N ; S ) |
| |
Average rating: 3.5 |
| |
Barbecue, Le Kastelo de Barbakoa
http://www.milleniumhandandshrimp.com |
| |
Generates random integers simulating dice-rolling or coin-flipping |
| |
|
| 236. |
DifferenceValues(ListA; ListB) |
| |
Average rating: 3.0 |
| |
Koen Van Hulle, SHpartners
http://www.shpartners.com |
| |
Returns a single instance of all lines that are in ListA but not in ListB |
| |
|
| 237. |
DistanceBetweenPoints ( Lat1; Lon1; Lat2; Lon2; Units ) |
| |
Average rating: 4.2 |
| |
Vaughan Bromfield, Vaughan Bromfield Design
http://www.google.com.au/ |
| |
Calculates the distance between any two points on Earth. |
| |
|
| 238. |
DistanceGeoCoord ( Lat1deg ; Lat1mm ; Lat1ss ; Lon1deg ; Lon1mm ; Lon1ss ; Lat2deg ; Lat2mm ; Lat2ss ; Lon2deg ; Lon2mm ; Lon2ss ; U ; Version ) |
| |
Average rating: 5.0 |
| |
Edward_Souza, n/a
n/a |
| |
Measure the distance between two geographic coordinates |
| |
|
| 239. |
Distribution( uniqueList; dataList) |
| |
Average rating: 4.4 |
| |
Bruce Robertson, Concise Design
http://concise-design.com |
| |
For each item in list 1, counts occurrences in list 2 |
| |
|
| 240. |
EANofISBN ( pool ; ISBNnr ) |
| |
Average rating: 3.7 |
| |
Reinder Wolting, ABECON
http://www.abecon.nl |
| |
Generate the EAN barcode for the given ISBN# |
| |
|
| 241. |
Easter ( myDate ) |
| |
Average rating: 3.5 |
| |
Mike Duncan, Duncan Creations
http://www.duncancreations.com |
| |
Show when Easter falls in the calendar year for any given date. |
| |
|
| 242. |
Easter ( theYear ) |
| |
Average rating: 3.2 |
| |
Reinder Wolting, ABECON
http://www.abecon.nl |
| |
Calculates the date of Easter sunday of a given year |
| |
|
| 243. |
Edate ( thedate ; months ) |
| |
Average rating: 3.9 |
| |
Barry Maskell, Real Estate Navigator
http://www.realestatenavigator.com.au |
| |
Excel style EDATE function |
| |
|
| 244. |
EightBall ( Question ) |
| |
Average rating: 5.0 |
| |
Chris Kubica, Application Architects, LLC
http://www.applicationarch.com |
| |
Ask the Eightball a Question and Get An Answer |
| |
|
| 245. |
Elapsed ( StartDate ; EndDate ) |
| |
Average rating: 3.4 |
| |
Lee Smith, Smith and Associates
none |
| |
Elapsed Date to Text |
| |
|
| 246. |
ElapsedbyIno ( StartDate ; EndDate ; Type ) |
| |
Average rating: 3.3 |
| |
Aleksandar Rubeša, Q.com doo
http://q-com.hr |
| |
For rest of us ISO: D M Y or ANSI: Y M D |
| |
|
| 247. |
ElapsedTime ( TStampBegin; TStampEnd; Format ) |
| |
Average rating: 3.8 |
| |
Geoff Wells, DataIsland Software LLC
http://www.dataisland.com |
| |
Calculates elapsed time from Timestamps |
| |
|
| 248. |
ElapsedTime_CFpub( tsStart ; tsEnd) |
| |
Average rating: 3.4 |
| |
James Hea, None
None |
| |
Elapsed Time in Years, Months, Days, Hours, Minutes and Seconds |
| |
|
| 249. |
EliminatePrefix ( value; prefix ) |
| |
Average rating: 2.8 |
| |
Martin Brunner, Zurich Financial Services
http://www.zurichconnect.ch |
| |
Recursively eliminate any prefixes |
| |
|
| 250. |
EmailAddressProper ( text ) |
| |
Average rating: 2.8 |
| |
Esa Niiniranta, Bittihiisi
http://bittihiisi.net |
| |
Returns the proper form of an email address |
| |
|
| 251. |
EmailName ( account ) |
| |
Average rating: 2.7 |
| |
Dwayne Wright, dwaynewright.com
http://www.dwaynewright.com |
| |
Returns the name associated with the email (sans domain) |
| |
|
| 252. |
Employ (StartDate, EndDate) |
| |
Average rating: 3.6 |
| |
Pascal Dimopoulos, Primary School Education
http://uesrs.otenet.gr/~dnapas |
| |
Estimates the employment time between two dates. |
| |
|
| 253. |
EnclosingObjects (_objectName ) |
| |
Average rating: 3.7 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
not recursive. A list of all enclosing objects of a layout object. |
| |
|
| 254. |
Encode ( text ; code ; startValue ) |
| |
Average rating: 3.6 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
A simple encoder |
| |
|
| 255. |
encodeEmail ( email ; rName ) |
| |
Average rating: 2.7 |
| |
Hunter Chisholm, Protean Solutions
http://proteansolutions.com/ |
| |
Encode HTML mailto link as hexadecimal string |
| |
|
| 256. |
EncodeURL_CF ( textToCode ) |
| |
Average rating: 5.0 |
| |
Paul Spafford, Spafford Data Solutions
http://www.paulspafford.com |
| |
Encodes all urls enclosed in square brackets for html. |
| |
|
| 257. |
EncryptDate (TheDate) |
| |
Average rating: 3.7 |
| |
Ibrahim Bittar Torres, Eikonsys
http://www.eikonsys.com |
| |
Converts a date in a pseudo activation code format |
| |
|
| 258. |
EnDeCoder( Text ; Code2 ) |
| |
Average rating: 3.8 |
| |
Charles Garr, cgarr software
http://havenone.com |
| |
Simple decoder and encoder in one |
| |
|
| 259. |
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 |
| |
|
| 260. |
ErrorCode( ErrorNum ) |
| |
Average rating: 3.0 |
| |
Roger Biel, 2Geckos Consulting, LLC
www.2geckos.com |
| |
Updated Filemaker Error codes to english |
| |
|
| 261. |
ErrorToEnglish ( ErrorNum ) |
| |
Average rating: 3.7 |
| |
Jeremiah Small, Soliant Consulting
http://jsmall.us |
| |
Translate FileMaker error codes to the English language description. |
| |
|
| 262. |
Even Odd Week Today |
| |
Average rating: 4.2 |
| |
Steve Lelle, Steve Lelle Enterprises, Inc.
http://lelle.com |
| |
Returns "Odd" or "Even" for Currant Date |
| |
|
| 263. |
EvenCharacters ( text ) |
| |
Average rating: 4.2 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns even-numbered characters of text. |
| |
|
| 264. |
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. |
| |
|
| 265. |
ExcelNumberToTime ( ExcelNumber) |
| |
Average rating: 3.6 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns the time in correct format for FM |
| |
|
| 266. |
Exclude ( TextToFilter; FilterText ) |
| |
Average rating: 4.8 |
| |
Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html |
| |
Exclude the characters to be filtered |
| |
|
| 267. |
ExplodedKey ( ID ; StartDate; EndDate ) |
| |
Average rating: 2.2 |
| |
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 |
| |
|
| 268. |
ExplodedString ( Field ) |
| |
Average rating: 3.8 |
| |
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. |
| |
|
| 269. |
ExplodedString_Work( field ) |
| |
Average rating: 4.2 |
| |
Michael Alexander, none
no website |
| |
Exploded String Variant |
| |
|
| 270. |
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. |
| |
|
| 271. |
ExtractEmails ( Text ) |
| |
Average rating: 4.3 |
| |
Ilya Shuvalov, SUI Solutions
http://filemaker.suisolutions.com |
| |
Extracts list of e-mails found in Text |
| |
|
| 272. |
ExtractFromText( TextBody ; keyText ) |
| |
Average rating: 3.6 |
| |
Tim Anderson, TAg
http://www.timanderson.co.uk/ |
| |
Returns strings/values from text |
| |
|
| 273. |
ExtractLine ( TextField ; LineNumber ) |
| |
Average rating: 4.4 |
| |
Michael Haymore, N/A
http://www.my-xanadu.net |
| |
Return a specific line out of a text field. |
| |
|
| 274. |
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. |
| |
|
| 275. |
FadeGreentoRed ( text ; score ; lowest ; highest ) |
| |
Average rating: 5.0 |
| |
Ryan Brandys, Branmuffin Industries
http://www.branmuffinindustries.com |
| |
Adjusts the color of 'text' between greeen->yellow->orange-red based upon the 'score' value. |
| |
|
| 276. |
FahrToCels ( degreesFahrenheit ) |
| |
Average rating: 3.5 |
| |
Brian Dunning, BrianDunning.com
http://www.briandunning.com/ |
| |
Converts degrees Fahrenheit to degrees Celsius. |
| |
|
| 277. |
FastDateInput ( input ; format ) |
| |
Average rating: 3.0 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
Allows user to input a date faster |
| |
|
| 278. |
FastTimeInput ( _Time ) |
| |
Average rating: 3.8 |
| |
Paul Sazonov, APS
http://www.briandunning.com/ |
| |
Fast time input |
| |
|
| 279. |
Fibonacci ( n ) |
| |
Average rating: 3.4 |
| |
Steve Allen, Richard Carlton Consulting, Inc.
http://www.rcconsulting.com |
| |
Formula calculation of the number at n in the Fibonacci sequence. No recursion. |
| |
|
| 280. |
Fibonacci ( N ) |
| |
Average rating: 3.9 |
| |
Rob Poelking, N/a
http://printstar.biz |
| |
Nth result of the Fibonocci series |
| |
|
| 281. |
Fibonacci ( Seed1; Seed2; Iterations ) |
| |
Average rating: 4.8 |
| |
Geoff Wells, DataIsland Software LLC
http://www.dataisland.com |
| |
Returns a Fibonacci series |
| |
|
| 282. |
FieldBeginsWith ( Text ) |
| |
Average rating: 3.8 |
| |
Andrew Persons, Excelisys
http://www.excelisys.com/ |
| |
Creates a multikey field containing all the increments of the beginning of the supplied text. |
| |
|
| 283. |
FieldNames2FieldValues ( Text ) |
| |
Average rating: 3.5 |
| |
Ilya Shuvalov, SUI Solutions
http://filemaker.suisolutions.com |
| |
Replaces field names with field values in Text |
| |
|
| 284. |
FieldRepeats ( repeatingField ; 1 ) |
| |
Average rating: 3.8 |
| |
Theo Ros, n/a
n/a |
| |
Returns the true number of repetitions for a repeating field |
| |
|
| 285. |
FieldRepeatsByName ( "fieldName" ) |
| |
Average rating: 3.3 |
| |
Theo Ros, n/a
n/a |
| |
Returns the true number of repetitions for a repeating field |
| |
|
| 286. |
FilePathToHFS ( FMFilePath ) |
| |
Average rating: 3.8 |
| |
Tom Robinson, Kōwhai Computing
http://www.tomrobinson.co.nz/ |
| |
Convert from FileMaker filepath to HFS filepath (superseded by FilePathToOS) |
| |
|
| 287. |
FilePathToOS ( FMFilePath ) |
| |
Average rating: 4.3 |
| |
Tom Robinson, Kōwhai Computing
http://www.tomrobinson.co.nz/ |
| |
Convert from FileMaker filepath to OS filepath (HFS or NTFS) |
| |
|
| 288. |
FilePathToURL ( FMFilePath ) |
| |
Average rating: 3.7 |
| |
Tom Robinson, Kōwhai Computing
http://www.tomrobinson.co.nz/ |
| |
Convert from FileMaker filepath to URL |
| |
|
| 289. |
FillProperties (PropertyList ; PropertyValues ; Separator ; Blanks) |
| |
Average rating: 5.0 |
| |
Peter Vinogradov, Peter Vinogradov Consulting
http://www.petervinogradov.com |
| |
Populates a full property list from a potentially incomplete list of values |
| |
|
| 290. |
FilterC ( text ; AZaz09etc ) |
| |
Average rating: 4.0 |
| |
Thomas Seidler, The Good Book Company
http://www.harmlesswise.com |
| |
not quite a regex filter, but easier than |
| |
|
| 291. |
FilterList ( ListA ; Attribute ; ListB ; CaseSensitive ) |
| |
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 |
| |
|
| 292. |
FilterValuesByTest ( text ; varName ; test ; include_1 ) |
| |
Average rating: 3.4 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
Returns a text filtered by a test |
| |
|
| 293. |
FilterWordsByTest ( text ; varName ; test ; include_1 ; mode ) |
| |
Average rating: 3.2 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
Returns a text filtered by a test |
| |
|
| 294. |
Filter_Stopwords ( Text ) |
| |
Average rating: 3.9 |
| |
Thomas Seidler, The Good Book Company
http://www.harmlesswise.com/it |
| |
simple one function stopwords remover |
| |
|
| 295. |
FindInArray( array; value ) |
| |
Average rating: 3.5 |
| |
Michael Rhodes, Allied Data Service
http://allieddataservice.com |
| |
Find a value in an array |
| |
|
| 296. |
FindRepetition ( searchString; repeatingField; start; occurrence; end; partialMatch ; matchCase ) |
| |
Average rating: 3.3 |
| |
Peter Wagemans, SHpartners
http://www.shpartners.com |
| |
Calculates the repetition number where a search string can be found in a repeating field |
| |
|
| 297. |
FindValues ( list ; searchString ; matchcase ) |
| |
Average rating: 3.3 |
| |
Theo Ros, n/a
n/a |
| |
Returns a list of all values from the original list that contain the given search string. |
| |
|
| 298. |
FirstBlankRepetition ( RepeatingField ; StartingRepetition ) |
| |
Average rating: 3.2 |
| |
Brian Dunning, BrianDunning.com
http://www.briandunning.com |
| |
Finds the first blank repetition in a repeating field. |
| |
|
| 299. |
FirstDayThisWeek ( StartDay ) |
| |
Average rating: 3.7 |
| |
Matt Wills, Virtual Vermont
http://www.virtualvermont.com/FMP/ |
| |
Date of first day of current week |
| |
|
| 300. |
FirstMonday ( themonth ; theyear ) |
| |
Average rating: 3.3 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Returns the date for the first Monday in a given month |
| |
|
| 301. |
FirstQuartile ( valueList ) |
| |
Average rating: 3.0 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
returns 1st quartile of a value list |
| |
|
| 302. |
FiscalYear ( TheDate ; FYStartMonth ) |
| |
Average rating: 4.0 |
| |
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. |
| |
|
| 303. |
FiveCharsPermutations(text;number) |
| |
Average rating: 5.0 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns all 120 simple permutations of the five characters of the field |
| |
|
| 304. |
FiveFieldsPermutations (field1;field2;field3;field4;field5;number) |
| |
Average rating: 3.3 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns all 120 simple permutations of the contents of five fields |
| |
|
| 305. |
FixedLength ( text ; char ; charsNumber ; align ) |
| |
Average rating: 3.2 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns a fixed length string. |
| |
|
| 306. |
Fixed_DecimalDigits ( Num ; DecCount ) |
| |
Average rating: 2.4 |
| |
AnKe, N/A
N/A |
| |
format a number to a predefined number of decimal digits - recursive |
| |
|
| 307. |
FlagGender ( text ) |
| |
Average rating: 3.2 |
| |
Peter Vinogradov, Peter Vinogradov Consulting
http://www.petervinogradov.com |
| |
Flags gender pronouns in text with caps and brackets. |
| |
|
| 308. |
FlexCeiling ( number ; precision ) |
| |
Average rating: 4.0 |
| |
Kevin Frank, Kevin Frank & Associates
http://www.kevinfrank.com |
| |
An expanded "Ceiling" that accepts a precision argument |
| |
|
| 309. |
FlexFloor ( number ; precision ) |
| |
Average rating: 3.7 |
| |
Kevin Frank, Kevin Frank & Associates
http://www.kevinfrank.com |
| |
An expanded "Floor" that accepts a precision argument |
| |
|
| 310. |
FlipACoin |
| |
Average rating: 3.8 |
| |
Chris Kubica, Application Architects, LLC
http://www.applicationarch.com |
| |
Auto Enter The Result of a Coin Flip Into a Text Field |
| |
|
| 311. |
FlipDigits ( value ) |
| |
Average rating: 3.0 |
| |
Theo Ros, *
http://notapplicable.com |
| |
flips decimal digits for textual sort purposes |
| |
|
| 312. |
FMGrowl(title, description, sticky, message) |
| |
Average rating: 3.8 |
| |
Douglas Alder, HomeBase Software Publishing Ltd.
http://hbase.net |
| |
Add Growl notification to your FileMaker solutions. |
| |
|
| 313. |
FMP7ProtocolRegFix |
| |
Average rating: 4.5 |
| |
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. |
| |
|
| 314. |
FMPToTRIO( FMP_GetPath ) |
| |
Average rating: 4.2 |
| |
Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com |
| |
Converts FMP GetPaths to TROI File Plug-in Paths |
| |
|
| 315. |
FM_Name_ID ( _Name_ID ; _TLFSV ; _fileName ; _layoutName ) |
| |
Average rating: 4.3 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
Returns FileMaker item Name or ID, given the other |
| |
|
| 316. |
fnAddressParser ( address ; type ) |
| |
Average rating: 2.8 |
| |
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. |
| |
|
| 317. |
FNameLNameOrg ( FName ; LName ; Org ) |
| |
Average rating: 4.8 |
| |
Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com |
| |
Helps to parse different combinations of entries for a Name Display. |
| |
|
| 318. |
fnCalendar ( date_field ; parameter ; iteration ; highlight_weekends ; holiday_list ) |
| |
Average rating: 4.0 |
| |
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. |
| |
|
| 319. |
fnCalendarLite ( date_field ; parameter ; iteration ; highlight_weekends ; holiday_list ) |
| |
Average rating: 5.0 |
| |
Andrew Butt, Drewsol
http://www.drewsol.com |
| |
fnCalendar minus documentation and integrated holiday list. |
| |
|
| 320. |
fnGoogleLineChart ( chtitle ; xtitle ; ytitle ; xfield ; yfield ; color ) |
| |
Average rating: 4.0 |
| |
Jeremy Upton, DME Supply Group
http://www.dmesupplygroup.com |
| |
Extremely simple line chart solution using a web viewer and Google API |
| |
|
| 321. |
fnGoogleMap (Address; City; State; Zip; Zoom) |
| |
Average rating: 4.0 |
| |
Jeremy Upton, DME Supply Group
http://www.dmesupplygroup.com |
| |
Shows embedded (map only portion) Google Map within a web viewer object. No API required! |
| |
|
| 322. |
fnLatLon.bearing ( lat1 ; lon1 ; lat2 ; lon2 ) |
| |
Average rating: 4.0 |
| |
Michael George, Michael George Consulting
mailto:mgeorge@coresupport.com |
| |
Calculates initial bearing between two points on Earth's surface. |
| |
|
| 323. |
fnNameParser ( name ; type ) |
| |
Average rating: 2.6 |
| |
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. |
| |
|
| 324. |
fnNumberFormat ( number ; decimals ; dec_point ; thousands_sep ) |
| |
Average rating: 3.1 |
| |
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). |
| |
|
| 325. |
fnPhone(text) |
| |
Average rating: 4.3 |
| |
Timothy Trimble, Data Design Labs
http://www.DataDesignLabs.com |
| |
Phone Number Formatting |
| |
|
| 326. |
fnSetGlobalVar ( Name; Value ) |
| |
Average rating: 3.7 |
| |
Rob Poelking, n/a
n/a |
| |
Dynamically sets a global variable with a single script line. |
| |
|
| 327. |
fnVertexAngle ( sides ; base ) |
| |
Average rating: 4.5 |
| |
Michael George, Michael George Consulting
mailto:mgeorge@coresupport.com |
| |
Calculate the angle the vertex of an isosceles triangle. |
| |
|
| 328. |
ForceZero ( NumExpression ) |
| |
Average rating: 4.0 |
| |
Steve Gerow, Abrazos Data Consulting, Inc.
http://www.abrazosdata.com |
| |
Forces a number calc field to display zero if is empty |
| |
|
| 329. |
format.UkTelNumber ( telNo ) |
| |
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 |
| |
|
| 330. |
FormatAsDate ( text ) |
| |
Average rating: 4.0 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns the given text as the valid complete formatted date: gg/mm/aaaa |
| |
|
| 331. |
FormatAsFileName ( text ; extension ; lengthLimit ) |
| |
Average rating: 3.7 |
| |
Jonathan Mickelson, Thought Development Corp.
http://thought-dev.com |
| |
Simplifies concatenation of a data into a suitable length OS filename. |
| |
|
| 332. |
FormatAsPrice ( input ; separator ; currency ; Leading_1 ) |
| |
Average rating: 3.2 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
text formatting |
| |
|
| 333. |
FormatDate( DatetoFormat ) |
| |
Average rating: 3.4 |
| |
Catherine Dillimore, Digital Fusion Ltd
http://www.digitalfusion.co.nz |
| |
//Returns Mon, Dec 8 |
| |
|
| 334. |
FormatDateAsText ( baseDate ; Format ) |
| |
Average rating: 2.6 |
| |
Eilert Sundt, Eilert Sundt Systemdesign
http://www.eilert.no |
| |
Formats a date with a specifiable format |
| |
|
| 335. |
FormatDateLocale ( thedate ; formatstring ; LocaleID ) |
| |
Average rating: 3.0 |
| |
Theo Ros, n/a
n/a |
| |
Formats a date according to a Format string and a given language ID |
| |
|
| 336. |
FormatLike ( text ; template ) |
| |
Average rating: 4.2 |
| |
Peter Vinogradov, Peter Vinogradov Consulting
http://www.petervinogradov.com |
| |
Applies the formatting of 'template' to 'text' |
| |
|
| 337. |
FormatNumber ( Number ; ThousandSep ; DecSep ) |
| |
Average rating: 3.5 |
| |
Stefano Lesandrini, ITC-DiDAG Information Technologies Consultants
http://web.ticino.com/itc-didag/ |
| |
The passed valueNumber is formatted with the passed Thousand & Decimal separators |
| |
|
| 338. |
FormatNumberAsText ( number ; currency ; separator ; decimal ; precision ) |
| |
Average rating: 3.7 |
| |
Geoffrey Gerhard, Creative Solutions Incorporated
http://www.creativesltns.com |
| |
Number to text, padded/rounded to a specified number of decimal places |
| |
|
| 339. |
FormatNumbers ( Number ) |
| |
Average rating: 3.8 |
| |
Emily Parks, Bulldog Marketing
http://www.bdogm.com |
| |
Formats Numbers by rounding them and placing thousand separators where they should be. |
| |
|
| 340. |
FormatNumber_Sub ( Number ; Counter ; ThousandSep ) |
| |
Average rating: 3.5 |
| |
Stefano Lesandrini, ITC-DiDAG Information Technologies Consultants
http://web.ticino.com/itc-didag/ |
| |
Needs |
| |
|
| 341. |
FormatPercent ( Number ; Decimals ) |
| |
Average rating: 4.5 |
| |
Will Loving, Dedication Technologies, Inc.
http://dedicationtechnologies.com |
| |
Formats a number as a percentage text string with specified number of decimal places |
| |
|
| 342. |
FormatPhone ( phone ) |
| |
Average rating: 4.1 |
| |
Sravan Puttagunta, Mann Consulting
http://www.mann.com |
| |
Auto formats all US based phone numbers, along with extensions. |
| |
|
| 343. |
FormatPhone ( PhoneIn; AreaCode ) |
| |
Average rating: 3.2 |
| |
Chris Harvey, Bank of Bermuda
http://www.bankofbermuda.bm |
| |
Masks or refomats North American phone numbers |
| |
|
| 344. |
FormatPostcodeNL ( TheCode ) |
| |
Average rating: 4.2 |
| |
Henk Brendel, Data 33
http://www.data33.nl |
| |
Function for formatting dutch postcodes |
| |
|
| 345. |
FormatSWEPhone ( phone ) |
| |
Average rating: 3.3 |
| |
Rolf Clausen, Mallverkstan AB
http://www.mallverkstan.com |
| |
Format a phone number according to Swedish standards. |
| |
|
| 346. |
FormattaPhone( num ) |
| |
Average rating: 3.7 |
| |
Massimo, Risca
http://www.gescom.it |
| |
Format phone for Italian Standards |
| |
|
| 347. |
FormattedBytes ( Bytes ; Rounding ; bitsOrBytes ; DecimalOrBinaryIEC ) |
| |
Average rating: 3.5 |
| |
Stefano Monti, Plan Art
http://www.planart.it |
| |
Convert bit and byte to a formatted output |
| |
|
| 348. |
FormattedNumber ( number ; thousandSep ; red ) |
| |
Average rating: 3.2 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
Returns any gived number as a number formatted with thousand and decimal separators. |
| |
|
| 349. |
FormatTelNL ( TelNr ; Divider ) |
| |
Average rating: 4.4 |
| |
Henk Brendel, Data 33
http://www.data33.nl |
| |
Format telephone nrs from the perspective of dutch users |
| |
|
| 350. |
FormatThousands ( Number ; Precision ; Separator ) |
| |
Average rating: 3.2 |
| |
Rob Poelking, n/a
http://www.ohiokajukenbo.com |
| |
Formats a number separating the thousands by a user specified character. |
| |
|
| 351. |
FormatTime ( formatString ; timestampToFormat ) |
| |
Average rating: 4.0 |
| |
Tim Mansour, Neologica Print & Promotions
na |
| |
Formats a time/date any way you like using a format string |
| |
|
| 352. |
FormatTimestamp ( _ts ; _f ) |
| |
Average rating: 2.7 |
| |
Thomas Seidler, The Good Book Company
http://harmlesswise.com/it |
| |
PHP standards 4 timestamp, date and time formatting |
| |
|
| 353. |
Formatting ( text ; styles ) |
| |
Average rating: 3.8 |
| |
Rob Westergaard, DataStorm Solutions
http://www.datastorm-solutions.com/ |
| |
This function applies text formatting using a variable input field. |
| |
|
| 354. |
Format_Expr ( ExpirationDate ) |
| |
Average rating: 3.7 |
| |
Kevin Bache, None
www.none.com |
| |
Formats a credit card expiration date, returning it in the form "MM/YY" |
| |
|
| 355. |
Format_Text_LikeTemplate__CFpub ( aString ; aTemplate ) |
| |
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 |
| |
|
| 356. |
FormulaCall(formula; param) |
| |
Average rating: 3.4 |
| |
Bruce Robertson, Concise Design
http://concise-design.com |
| |
Universal custom function - write your function outside the CF editor |
| |
|
| 357. |
FoundList ( field ; start ) |
| |
Average rating: 3.3 |
| |
Eilert Sundt, Eilert Sundt Systemdesign
http://www.eilert.no |
| |
List the values of a field across a found set |
| |
|
| 358. |
Fraction ( number ) |
| |
Average rating: 4.0 |
| |
Theo Ros, *
http://notapplicable.com |
| |
Returns a number as fraction text. |
| |
|
| 359. |
Fraction ( _a_b ; _operator ; _c_d ) |
| |
Average rating: 3.0 |
| |
Thomas Seidler, The Good Book Company
http://www.harmlesswise.com/it |
| |
Enables common fraction operations, keeping results in fractions. |
| |
|
| 360. |
FriendlyPasswords |
| |
Average rating: 3.9 |
| |
Douglas Alder, HomeBase Software
http://www.hbase.net |
| |
Generate more memorable passwords from user selected phrase |
| |
|
| 361. |
FrontTabs( layoutObjects; parent ) |
| |
Average rating: 3.8 |
| |
Bruce Robertson, Concise Design
http://www.concise-design.com |
| |
Provides a list of frontmost tab(s) and any enclosed selected tabs |
| |
|
| 362. |
FrontTabsPanelsList ( Layout ) |
| |
Average rating: 4.0 |
| |
Agnes Barouh, Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html |
| |
Returns a list of front and visible Tabs panels on a layout. |
| |
|
| 363. |
FTPCopy ( URL ; user ; password ; directory ; file ; localdirect |
| |
Average rating: 3.6 |
| |
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. |
| |
|
| 364. |
FTPdelete(remotePath, host, user, password) |
| |
Average rating: 2.9 |
| |
Nico, NicoWeb
http://www.nicoweb.com |
| |
delete remote file via FTP |
| |
|
| 365. |
FTPDownload ( remotePath ; localPath ; host ; user ; password ) |
| |
Average rating: 3.6 |
| |
Mark DeNyse,
|
| |
Downloads a file from the specified FTP directory. |
| |
|
| 366. |
FTPList ( URL; user; password; directory) |
| |
Average rating: 3.5 |
| |
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. |
| |
|
| 367. |
FTPMove ( URL ; user ; password ; directory ; file ; localdirect |
| |
Average rating: 3.3 |
| |
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. |
| |
|
| 368. |
FTPUpload ( URL ; user ; password ; directory ; file ; localdirectory ; localfile ) |
| |
Average rating: 3.6 |
| |
Alan Deffenderfer, ABD Booksellers
http://www.abdbooksellers.com |
| |
Function to Upload file using curl and applescript |
| |
|
| 369. |
func_ActiveTab |
| |
Average rating: 3.2 |
| |
Michael Kupietz, Michael Kupietz, FileMaker Pro Consultant
http://www.kupietz.com |
| |
Return the number of the currently active tab in a tab object |
| |
|
| 370. |
FutureDate ( text) |
| |
Average rating: 3.6 |
| |
Jeff Yurka, Real Mac Solutions
http://yurka.net |
| |
Allow user to speedily enter dates using codes. Field must be text. |
| |
|
| 371. |
FYQ ( Start ; theDate ) |
| |
Average rating: 4.8 |
| |
Matt Wills, Virtual Vermont
http://www.VirtualVermont.com/FMP |
| |
Fiscal year and quarter of a given date |
| |
|
| 372. |
Gaussian ( _x ; _height ; _center ; _sigma ) |
| |
Average rating: 3.8 |
| |
Thomas Seidler, The Good Book Company
http://harmlesswise.com/it |
| |
Gaussian function to enable a controllable bell shaped graph. |
| |
|
| 373. |
GCF ( A ; B ) |
| |
Average rating: 3.3 |
| |
Scott Morrison, InDev
http://www.indev.ca |
| |
Greatest Common Factor of two numbers |
| |
|
| 374. |
GestationalAge(date) |
| |
Average rating: 3.8 |
| |
Rafael Burgos, USAF
http://www.af.mil |
| |
Calculate number of weeks and days from a given last menstrual period |
| |
|
| 375. |
GestationalAgeEDD(date) |
| |
Average rating: 3.8 |
| |
Rafael Burgos, USAF
http://www.af.mil |
| |
Calculate number of weeks and days from a given last menstrual period |
| |
|
| 376. |
Get3PixColumnState |
| |
Average rating: 3.8 |
| |
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 |
| |
|
| 377. |
getActiveSelection |
| |
Average rating: 3.3 |
| |
Bob Majors, na
na |
| |
Returns selection in a text field. |
| |
|
| 378. |
GetAge ( birthdate ) |
| |
Average rating: 3.0 |
| |
Danny Leung, Bloomington Public Schools
http://www.bloomington.k12.mn.us |
| |
Calculates the number of years, months, & days based on your birthdate |
| |
|
| 379. |
GetAsArabic( romanNumber ) |
| |
Average rating: 3.2 |
| |
Jeremy Bante, OshVay Systems, Inc.
http://www.oshvay.com |
| |
GetAsArabic( romanNumber ) returns the arabic number equivalent for a roman number. |
| |
|
| 380. |
GetAsKilometerMile( Distance ; Km_M ) |
| |
Average rating: 4.2 |
| |
Ursus, LeoSoft
http://www.don't_have_a_Web_site.com |
| |
Convert Miles to Kilometer or Kilometer to Miles |
| |
|
| 381. |
getbetween(text, starttext, stoptext,occurrence) |
| |
Average rating: 4.3 |
| |
Bailey Kessing, NCI-Frederick
http://kessing.com |
| |
gets the text between two search values |
| |
|
| 382. |
getchar(text, start, stop) |
| |
Average rating: 4.0 |
| |
Bailey Kessing, NCI-Frederick
http://kessing.com |
| |
gets the text between specified range of text positions |
| |
|
| 383. |
GetColumn ( text ; columnNumber ; columnDelimiter ) |
| |
Average rating: 4.8 |
| |
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net/ |
| |
Returns a list of values from the requested column in text. |
| |
|
| 384. |
GetContainerSize ( Container ; Precision ) |
| |
Average rating: 4.2 |
| |
Dennis Sirotkine, SUI Solutions
http://filemaker.suisolutions.com |
| |
Returns container size in bytes, kilobytes or megabytes with the corresponding abbreviation. |
| |
|
| 385. |
GetCountryCodeFromCountry ( Country ) |
| |
Average rating: 2.2 |
| |
Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com |
| |
Get Country Code from Full Country Name |
| |
|
| 386. |
GetCountryFromCountryCode ( CountryCode ) |
| |
Average rating: 4.0 |
| |
Andy Knasinski, nrg Software, LLC.
http://www.nrgsoft.com |
| |
Get full country name from country code |
| |
|
| 387. |
GetDates ( text ) |
| |
Average rating: 3.7 |
| |
Fabrice Nordmann, 1-more-thing
http://www.1-more-thing.com |
| |
extracts all dates from a text field |
| |
|
| 388. |
GetDayOccurrence ( TheDate; Weekday; Reps ) |
| |
Average rating: 3.8 |
| |
Ken Newell,
|
| |
Returns a date from a selected date for a specific day of the week that is N away. |
| |
|
| 389. |
getDomain ( theAddress ) |
| |
Average rating: 3.7 |
| |
Andrew Sasaki, n/a
n/a |
| |
parses the domain name from an email address or URL |
| |
|
| 390. |
GetDynamicStat ( Function ; TableOccurrenceName ; Field ) |
| |
Average rating: 3.6 |
| |
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 |
| |
|
| 391. |
GetEmail ( text ) |
| |
Average rating: 4.8 |
| |
Daniele Raybaudi, ACI
www.aci.it |
| |
It grabs all the emails of a given generic text |
| |
|
| 392. |
GetExtensionsPath |
| |
Average rating: 2.5 |
| |
Jens Rasmussen, Fimano
http://fimano.dk/filemaker/toolbox.html |
| |
Calculates the path in which to put plug-ins |
| |
|
| 393. |
GetFieldList ( fieldName ; recordNumStart ; recordNumEnd ) |
| |
Average rating: 3.3 |
| |
Don Wieland, DW Data Concepts
http://www.dwdataconcepts.com |
| |
Gets a Range of field values for local or related field |
| |
|
| 394. |
GetFieldsAsXML ( theFields ) |
| |
Average rating: 3.7 |
| |
Andy Knasinski, NRG Software, LLC.
http://www.nrgsoft.com |
| |
Convert a list of fields to XML data |
| |
|
| 395. |
GetFieldStat ( Function ; Field ) |
| |
Average rating: 3.0 |
| |
Ugo DI LUCA, DLSYSTEMS
http://www.dlsystems.fr |
| |
Do stats from values in a field or a value list |
| |
|
| 396. |
GetFieldType ( TableOccurrenceName ; Field ) |
| |
Average rating: 4.2 |
| |
Ugo Di Luca, DLSYSTEMS
http://www.dlsystems.fr |
| |
Determine the targetted field type |
| |
|
| 397. |
GetFileName ( FullName ) |
| |
Average rating: 2.6 |
| |
William Donelson, Mine
http://www.none.com |
| |
Extracts Filename from the Full Path Name |
| |
|
| 398. |
GetFirstName(FullName) |
| |
Average rating: 3.8 |
| |
Steve Bush, Intellisoft Development Inc.
http://www.intellisoftdevelopment.com |
| |
Returns A Contact's First Name from a Full Name |
| |
|
| 399. |
GetFMVersionNumber |
| |
Average rating: 4.4 |
| |
Dennis Sirotkine, SUI Solutions
http://filemaker.suisolutions.com |
| |
Returns the FileMaker version number. |
| |
|
| 400. |
GetFOI ( y ; m ) |
| |
Average rating: 3.7 |
| |
Roberto Degano, DLV
http://www.deleveste.it |
| |
A simple function to get the FOI Index (from Italian ISTAT) |
| |
|
| 401. |
GetFontFamily( text ) |
| |
Average rating: 3.3 |
| |
Joe Gold, Angel City Data
http://www.angelcitydata.com |
| |
Returns the font of a text |
| |
|
| 402. |
GetFontSize(text) |
| |
|
