Brian Dunning's FileMaker Custom Functions

LayoutFields

Non recursive, list all fields values on the current layout, in either Find or Browse Mode

  Average rating: 4.5 (34 votes) Log in to vote

Ugo DI LUCA   Ugo DI LUCA
DL Systems
http://www.dlsystems.fr

Share on Facebook Share on Twitter

  Sample input:
LayoutFields
  Sample output:
In Browse Mode

|Layout|ContactLayout
|RecordNumber|1"
<\COMPANY\> ABC
<\COUNTRY\> USA"

In Find Mode

|Layout|ContactLayout
|RequestNumber|1
|RequestOmitState|1
<\Company\> A
<\Country\> USA"

Real format is "<"&MyFieldName&">"&Value" , couldn't format tags here

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

This function may be used to store a search request ( or n search requests if used in a loop ), in order to perform it again through a script that would loop through all layout fields and set the values according to what the function returned.
It may also be used to temporarily store the content of all fields on layout

Doesn't work with repeating fields, which isn't a problem in find Mode.

This function returns all fields on the layout.
In order to only limit its content to the not empty fields, you may use it in combination with ZapValues ( from Ray Cologon ) , for example

Let ( [
fields = FieldNames ( Get ( FileName ) ; Get ( LayoutName ) ) ;
subst = Substitute ( "<" & fields & ">" ; ["¶" ; ">¶<" ] ) ] ;
ZapValues ( LayoutFields ; subst )
)

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.