I was browsing Briandunning.com for custom functions and found a few good ones to link: GetQueryStringValue ( keyName ; sourceUrl ): Given a full URL and name of a key, returns the given key’s value out of the entire URL. CurrentTime_Less_Hours_Minutes (Hours ; Minutes): Gets time less hours and minutes entered CurrentTime_Plus_Hours_Minutes (Hours ; Minutes): To […]
A HANDY little function for formatting mailing labels – and it removes empty lines by using the list function. No need to re-invent the wheel. FileMaker Custom Function:MailingLabel ( fname ; lname ; company ; addr1 ; addr2 ; city ; state ; pcode ).
SHOW AN OBJECT based upon the active field. Nice little function.
NIFTY LITTLE Execute SQL function that returns the highest set (n) of values from a field. FileMaker Custom Function:TopResults ( FieldName ; TableName ; Results).
YET ANOTHER handy custom function. Correctly format any UK telephone number Sample Input: UKPhoneMask ( 01234567890 )UKPhoneMask ( 01134960018 )UKPhoneMask ( 02079460018 ) Sample Output: 01234 567890113 496 0018020 7946 0018
This little function will come in handy from time to time. Description: Adapted from Daniele Raybaudi’s GetEmail function. It extracts all email addresses from text. Added a substitution filter for common characters found surrounding email addresses. Recursive function. Thanks, Daniele Raybaudi for GetEmail! FileMaker Custom Function:GetEmailAddr(Text). FileMaker Custom Function:GetEmailAddr(Text)
This could come in handy… Omit ( text ; string ) Rate this function: Average rating: 0.0 (0 votes) Discuss this Custom Function Daniele Raybaudi, ACI http://www.aci.it This custom function omits the chars of the string from the given text, without any practical limitation. Sample Input: Omit ( “abcdefg” ; “af” ) Omit ( “a12345” ; “1234567890” […]
Easy way to resolve names to values inside scripts. Can be used from any context without creating relationships. Description: Aditional details: There should be a “table” with fields ID,name,value. ID is of type number with auto enter serial enabled. Other fields are text type. valuelist.names is a value list based on field “names” from “table”. […]
I could have used this a few years back when I worked with an advertising research firm: Description: Converts film and tv timecode strings eg 01:05:20;02 @ 29.97 fps into a framecount in this case 117484 The calculation traps for the special case of drop frame 29.97 timecode and allows for all other interger fps […]
Developers are always busy adding new custom functions at Brian Dunning’s website. Here’s the latest: Sep 26 NextFirstFriday ( theDate ) Sean Sep 25 GetUniqueValues.cf ( TextList ; ExceptionsList ) Jonathan Jeffery Sep 25 CountWeekday.cf ( StartDate ; EndDate ; CustomIgnoreList_as_ddmmyyyy ) Jonathan Jeffery Sep 25 FilterListItems_Filtrate.cf( MyList ; FilterList ) Jonathan Jeffery Enjoy!
Business Minute 11 - FileMaker Pro Gurus: [...] New Custom Function List [...]
Interesting little email scheduling function… FileMaker Custom Function:BusinessHours.
IT Professional Consultants Inc. www.itprofessionalconsultants.netAuthor: Joseph Arzate (9.5.13) [ListValues] – Expecting a “¶” delimited list of values. List submitted should not begin with MORE than 1 ¶ or the function will be inaccurate.[SearchValue] – The value being searched upon in the List list provided. Any ¶ found in the SearchValue are removed.———————————–Function Result: Returns a number of […]
Cool new function – calculate great circle distances between 2 points on a sphere. FileMaker Custom Function:Distance ( lat1 ; lon1 ; lat2 ; lon2 ).
Replaces a designated value in a value list with another value More …FileMaker Custom Function:PutValue ( ValueList ; ValueNumber ; ReplaceString ).
Business Minute 23 - Destroying Your Comfort Zone - FileMaker Pro Gurus: [...] Great Video Custom Function [...]