ValueListForExport ( )
Function stats
Average user rating
Support
FileMaker 9.0 +
Date posted
22 August 2010
Version
1
Recursive function
Yes
Function overview
Prototype
ValueListForExport (
)
Parameters
No parameters for this function.
Description
Returns a string suitable for export of all the Value Lists of the DB.
FileMaker can create a new DB based on the generated .txt file that will have:
One record
As many fields as the number of the value lists ( with their names )
All the values into each field
Examples
Sample input
ValueListForExport
Sample output
The alphabet !! Flag ( one ) More and more ...
a b c d e f g h k j i l m n o p q r s t u v w x y z 1 One More Two X One Two-Edged Three Someone Xray Four
a b c d e f g h k j i l m n o p q r s t u v w x y z 1 One More Two X One Two-Edged Three Someone Xray Four
Function code
/*
ValueListForExport Custom Function
Author: Daniele Raybaudi
Parameter: none
Recursive: yes
Returns a string suitable for export of all the Value Lists of the DB.
FileMaker can create a new DB based on the generated .txt file that will have:
One record
As many fields as the number of the value lists ( with their names )
All the values into each field
*/
Let([
vlNames = ValueListNames ( Get ( FileName ) ) ;
$count = $count + 1 ;
vlName = GetValue ( vlNames ; $count ) ;
vlValues = If ( $count > 1 ; " " ) & Substitute ( ValueListItems ( Get ( FileName ) ; vlName ) ; [ " " ; " " ] ; [ ¶ ; " " ] )
];
Case(
$count = 1 ; Substitute ( vlNames ; ¶ ; " " ) & ¶ & vlValues & ValueListForExport ( ) ;
$count ≤ ValueCount ( vlNames ) ; vlValues & ValueListForExport ( ) ;
Let ( $count = "" ; "" )
)
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/263
Prototype: ValueListForExport( )
Function Author: Daniele Raybaudi (http://www.fmfunctions.com/mid/38)
Last updated: 22 August 2010
Version: 1
*/
// ===================================
ValueListForExport Custom Function
Author: Daniele Raybaudi
Parameter: none
Recursive: yes
Returns a string suitable for export of all the Value Lists of the DB.
FileMaker can create a new DB based on the generated .txt file that will have:
One record
As many fields as the number of the value lists ( with their names )
All the values into each field
*/
Let([
vlNames = ValueListNames ( Get ( FileName ) ) ;
$count = $count + 1 ;
vlName = GetValue ( vlNames ; $count ) ;
vlValues = If ( $count > 1 ; " " ) & Substitute ( ValueListItems ( Get ( FileName ) ; vlName ) ; [ " " ; " " ] ; [ ¶ ; " " ] )
];
Case(
$count = 1 ; Substitute ( vlNames ; ¶ ; " " ) & ¶ & vlValues & ValueListForExport ( ) ;
$count ≤ ValueCount ( vlNames ) ; vlValues & ValueListForExport ( ) ;
Let ( $count = "" ; "" )
)
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/263
Prototype: ValueListForExport( )
Function Author: Daniele Raybaudi (http://www.fmfunctions.com/mid/38)
Last updated: 22 August 2010
Version: 1
*/
// ===================================
