GetLayoutID ( layout )

Gets the layout ID of current or named layout

Average rating: 4.1 (34 votes) Log in to vote

Ulf Carlsson - Show more from this author
Studentlitteratur AB
http://www.studentlitteratur.se

Sample input:

GetLayoutID ( "current" )

Sample output:

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

/*  copyright Ulf Carlsson, ulf.carlsson@studentlitteratur.se, free to use if this row is here

Use: Gets the Layout-ID of current layout if parameter layout="current" or of the layout which name is in parameter layout

Function name: GetLayoutID

Parameter: layout     If layout="current"  is current layout used, otherwise should "layout" contain the name of wich layout ID you want

*/

Let ( [
	// use "current" layout or the layoutname that is coming from the "layout"-parameter
	theLayout = If ( layout ="current" ; Get ( LayoutName ) ; layout );            

	// Get all the layout names (is a list)
	theLayoutNames = LayoutNames ( Get ( FileName ) );
	
	// Count all ¶ from the start to where the layout name are and add 1
	currentLayoutPosition =  PatternCount (                                                 
								Middle ( theLayoutNames ; 1 ;                  
								Position ( theLayoutNames ; theLayout ; 1 ; 1 ) ) ;
                                "¶" ) + 1 ;

	// Get all the layout IDs (is a list)
	layoutIDs = LayoutIDs ( Get ( FileName ) ) ;
	
	// Count how many layouts there is
	numberOfLayouts = Get ( LayoutCount ) ;                      
 
   
	// Get the the ID from the list
	layoutID = Case (                                                                                   
				// If first value in the list, do this
					currentLayoutPosition = 1 ; LeftWords ( layoutIDs ; 1 ) ;   

				// if not first or last item in the list, do this
					currentLayoutPosition < numberOfLayouts ; 
                                                             Middle ( layoutIDs ;
							              Position ( layoutIDs ; "¶" ; 1 ; currentLayoutPosition -1 ) ; 
								     Position ( layoutIDs ; "¶" ; 1 ; currentLayoutPosition ) - Position ( layoutIDs ; "¶" ; 1 ; currentLayoutPosition -1 ) ) ;
                                                                                                             
				// If last item in the list, do this
					Middle ( layoutIDs ;                                                               
						     Position ( layoutIDs ; "¶" ; 1 ; currentLayoutPosition -1 ) ; 
						     Length ( layoutIDs ) )
                      )
];
 
   GetAsNumber ( layoutID )
)

Use: Gets the Layout-ID of current layout if parameter layout="current" or of the layout which name is in parameter layout

Problem: You use some kind of navigation that want to switch to another layout when a button is pressed, but you want to be able to change both layout names and layout order without the solution breaks.

Solution: Use the function GetLayoutID in combination with the function GetLayoutNumberFromID to be able to do navigation between layouts without your application breaks if layouts change names or order.
In other words: Where you save which layout name or layout number to go to, save the layout id instead and then look up which number the layout has at the moment with function GetLayoutNumberFromID ( layoutID ).

Comments

		Robert, Luxembourg Europe Sep 30, 2010
Hello Thanks for your function, but it is a little buggy. Example: Layout="Complaint" LayoutNames="Complaints TestÂ¶BlablaÂ¶Complaint" Function will return the ID of the 1st value but should return the ID of the 3'd value. Solution: replace: theLayoutNames = LayoutNames ( Get ( FileName ) ); with:theLayoutNames = "Â¶" & LayoutNames ( Get ( FileName ) ) & "Â¶"; replace:theLayout = If ( layout ="current" ; Get ( LayoutName ) ; layout ); with=theLayout = "Â¶" & If ( layout ="current" ; Get ( LayoutName ) ; layout ) & "Â¶"; replace:Position ( theLayoutNames ; theLayout ; 1 ; 1 ) ) ; "Â¶" ) + 1 ; with:Position ( theLayoutNames ; theLayout ; 1 ; 1 ) ) ; "Â¶" ) ; Bye

		Roman Hofstetter, Zurich Aug 30, 2011
This function doesn't work, if you have a Layout named "Example1 Overview" and a Layout named "Example1". If you search for "Example1", the script step Position() will now the position of "Example1 Overview" and you get the wrong ID. Solution: Check if the Layoutname is on the beginning or the end. Otherways search for Â¶LayoutnameÂ¶. Like that you're sure the whole name is identical.

		Thomas Parker, Stone & Wood Dec 29, 2020
I've found a bug that this script doesn't work if it is the last layout in the list. If this happens, it returns no result - just blank. Can anyone verify this?

		Menno van Beek, Van Beek Zakelijke Software Dec 29, 2020
I would simplify the function a bit: Let ( [ name = Â¶ & If ( IsEmpty ( layout ) ; Get ( LayoutName ) ; layout ) & Â¶ ; names = Â¶ & LayoutNames ( "" ) & Â¶ ; line = PatternCount ( Left ( names ; Position ( names ; name ; 1 ; 1 ) ) ; Â¶ ) ] ; If ( line ; GetValue ( LayoutIDs ( "" ) ; line ) ) )

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

GetLayoutID ( layout )

Comments

Support this website.

Support this website.