Brian Dunning's FileMaker Custom Functions

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   Fabrice Nordmann
1-more-thing
https://www.1-more-thing.com

Share on Facebook Share on Twitter

  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)

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

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.