FileMaker Pro Custom Functions

/* AllFields custom function Returns the content of all the fields of a layout, starting from field "start", with the exclusion of the field holding this calc that must be named:"functionAllFields"; you have to use the Evaluate function to see the changes. (something like: Evaluate (Quote ( AllFields ( 1 ) ) ; field1 ) Author: Daniele Raybaudi Format: AllFields ( start ) Parameter: start - number - the number of the field you want to start from 01/01/2006 */ Let([ fields =FieldNames ( Get(FileName) ; Get(LayoutName) ); fieldName = Substitute ( MiddleValues ( fields ; start ; 1 ) ; "¶" ; "" ); end = ValueCount ( fields ) ]; Case ( start = end ; If( fieldName ≠ "functionAllFields" ; GetField(fieldName);""); start < end ; If( fieldName ≠ "functionAllFields" ; GetField(fieldName)& ¶ & AllFields ( start+1 );AllFields ( start+1 )); "" ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.