GlobalVarsFromLayout ( )

returns a list of all merge variables in named objects on the layout

Average rating: 4.2 (25 votes) Log in to vote

Joris Aarts
ClickWorks
http://www.clickworks.be

Sample input:

the layout contains a named text object containing "<<$$A>> some text <<$$B>>" and another named text object containing "<<$$B>> some text <<$$C>>"

Sample output:

A
B
C

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

/*
GlobalVarsFromLayout ()
by Joris Aarts
with thanks to Jeroen Aarts, ClickWorks & David, Digital Fusion

v1: July 2012 

Returns a list of all merge variables in named objects on the layout

Sample Input:
the layout contains a named text object containing "<<$$A>> some text <<$$B>>" and another named text object containing "<<$$B>> some text <<$$C>>"

Sample Output:
A
B
C

This function requires two other custom functions from www.briandunning.com:
1) ParseAllBetween from David, Digital Fusion
2) UniqueValues from Jeroen Aarts, ClickWorks
-----------------*/

Let( [
	objectList =  LayoutObjectNames ( Get ( FileName ) ; Get ( LayoutName ) )  ; // get al named objects
	sourceFormula1 = Substitute ( objectList ; ¶ ; "\" ; \"source\" ) & \¶ & GetLayoutObjectAttribute ( \"" ) ;
	sourceFormula2 = "GetLayoutObjectAttribute ( \"" & sourceFormula1 &  "\" ; \"source\" )"  ;
	contentList = Evaluate ( sourceFormula2 ) ; // retrieve text content from named objects
	translateList = ParseAllBetween ( contentList  ;  "<<$$"  ;  ">>"  ;  1  ;  "" ) ; // get all vars to translate
	translateList = UniqueValues ( translateList )

];

translateList

) // End Let

This function is NOT recursive.
This function requires two other custom functions from www.briandunning.com:
1) ParseAllBetween from David, Digital Fusion
2) UniqueValues from Jeroen Aarts, ClickWorks

Comments

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

GlobalVarsFromLayout ( )

Comments

Support this website.

Support this website.