VariablesFromFields ( )

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

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

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

Sample input:

on layout,
field "A" that contains "1" and
field "B" that contains "2

Sample output:

$$A = 1
and
$$B = 2

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

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

v2.1 : Sept 2007. Fixed a bug with carriage return
v2 : no more parameter is needed (was VariableFromFields ( start ))

Loads all current layout fields in named global variables

i.e. current layout has :
field "A" that contains "1",
field "B" that contains "2",
field "C" that contains "3"

Evaluating this function will result in 3 global variables :
$$A will contain "1"
$$B will contain "2"
$$C will contain "3"

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

This demo uses an unstored calculation : the field has to be named "VariablesFromFields, and must be put first on layout.
-----------------*/

Let([
_fields = FieldNames ( Get ( FileName ) ; Get ( LayoutName ) ) ;
_end = ValueCount ( _fields ) ;
$$cfVFF_counter = Case ( IsEmpty ( $$cfVFF_counter ) ; 1 ; $$cfVFF_counter > _end ; "" ; $$cfVFF_counter + 1 ) ;
_fieldName = GetValue ( _fields ; $$cfVFF_counter ) ;
_value = Substitute ( GetField ( _fieldname ) ; ¶ ; "\¶" ) ;
_textEval = "let ( $$" & _fieldname & " =" & Case ( IsEmpty ( _value ) ; "\"\"" ;  "\"" & _value & "\"" ) & "; \"\")"
];
Case (
$$cfVFF_counter <= _end ; If ( _fieldName ≠ "VariablesFromFields" ; Evaluate ( _textEval ) & VariablesFromFields ( )
)
))

Great to load settings into global variables in a snap, regardless of the type of the field, where a loop would not stop in a calculation field.
Just place your fields on the layout, and run a script such as

Set Variable [ $temp ; VariablesFromFields ( ) ]
You can even use an unstored calculation, just as the demo file does, and not even neeed to run a script.

Comments

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

VariablesFromFields ( )

Comments

Support this website.

Support this website.