AllFields ( start )

Returns the content of all the fields of a layout

Average rating: 4.3 (33 votes) Log in to vote

Daniele Raybaudi - Show more from this author
ACI
http://www.aci.it

Sample input:

AllFields ( 1 )

Sample output:

a
aa
aaa

(if there are 3 fields, first holding "a"
second "aa", third "aaa")

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
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 ));
""
)
)

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 )

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

AllFields ( start )

Comments

Support this website.

Support this website.