FileMaker Pro Custom Functions

Search  |  List  |  Show Random  |  Upload  |  Add This to Your Site

LayoutFields

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

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

Description:

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 )
)

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

This is my Custom Function and I want to edit it

digg this page | del.icio.us this page

Download the Custom Function Dashboard Widget for OS X Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions: 1. CustomList_BottomUp ( Start ; End ; Function )   (Mon, Jul 21, 5:44am) 2. ColumnsAcross ( listOfValues ; numberOfColumns ; columnDelimiter )   (Tue, Jul 15, 8:01am) 3. _cf_Country_Letter_Code ( _Country )   (Mon, Jul 14, 8:02pm)

Custom Function Authors:
Link to all of your own custom functions on this site with the following URL:
http://www.briandunning.com/filemaker-custom-functions/results.php?author=Your Name Here