VariablesFromObjects ( )

passes the content of all named objects on the layout to named variables

Average rating: 4.4 (27 votes) Log in to vote

Fabrice Nordmann - Show more from this author
1-more-thing
https://www.1-more-thing.com

Sample input:

the layout contains :
field "A", named "field_A" that contains "1",
WebViewer named "wv_B" that contains "2",
text label named "lbl_C" that contains "3"

Sample output:

$$field_A will contain "1"
$$wv_B will contain "2"
$$lbl_C will contain "3"

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

/*
VariablesFromObjects ( )
by Fabrice Nordmann
with thanks to Agnès Barouh, Ugo di Luca and Daniele Raybaudi

v2.1: Sept 2007, fixed a bug with carriage returns
v2 : no more parameter is needed (was VariableFromObjects ( start ))

Loads all current named layout objects, since they are fields or webviewers, in named global variables

i.e. current layout has :
field "A", named "field_A" that contains "1",
WebViewer named "wv_B" that contains "2",
text label named "lbl_C" that contains "3"

Evaluating this function will result in 3 global variables :
$$field_A will contain "1"
$$wv_B will contain "2"
$$lbl_C will contain "3"

Among other ways of evaluating this calculation, you can use :
- a Set Variable script step [ $temp ; VariablesFromObjects ( ) ]
- an unstored calculation field on your layout and defined as = VariablesFromObjects ( )
   In this case, you will need to refresh window to load variables.
-----------------*/

Let([
_objects = LayoutObjectNames ( Get ( FileName ) ; Get ( LayoutName ) ) ;
_end = ValueCount ( _objects ) ;
$$cfVFO_counter = Case ( IsEmpty ( $$cfVFO_counter ) ; 1 ; $$cfVFO_counter > _end ; "" ; $$cfVFO_counter + 1 ) ;
_objectName = GetValue ( _objects ; $$cfVFO_counter ) ;
_value = Substitute ( GetLayoutObjectAttribute ( _objectName ; "content" ) ; ¶ ; "\¶" ) ;
_textEval = " let ( $$" & _objectname & "=" & Case ( IsEmpty ( _value ) ; "\"\"" ;  "\"" & _value & "\"" ) & "; \"\")"
];
Case (
$$cfVFO_counter <= _end ; If ( _objectName <> "VariablesFromObjects" ; Evaluate ( _textEval ) & VariablesFromObjects ( )
)
))

Load dynamically named global variables with the content of the named objects of the layout.

UPDATE : I would now recommend the use of CustomList, by Agnès Barouh : http://www.briandunning.com/cf/747
Calculation would be :
CustomList ( 1 ; ValueCount ( LayoutObjectNames ( Get ( FileName ) ; Get ( LayoutName ))) ; "let ([ $o = getvalue ( LayoutObjectNames ( get ( fileName ) ; get ( layoutName )) ; [n] ) ; $c = getLayoutObjectAttribute ( $o ; \"content\" ) ]; VariablesLog ( $o ; $c ))")

Comments

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

VariablesFromObjects ( )

Comments

Support this website.

Support this website.