GetLayout# ( layout name )

Data driven layout navigation. A button calls a script, passing a layout name as a script parameter. Navigation is to that layout.

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

Bill Moseid - Show more from this author
Model Masters
http://www.fmpsolutions.com

Sample input:

layout name

Sample output:

layout number

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

// Input: Layout name as a script parameter. 

GetAsNumber( PatternCount( Left( LayoutNames(Get(FileName) ); Position( LayoutNames(Get(FileName))  ; Get ( ScriptParameter ) & "¶"  ; 1 ; 1)); "¶" ) + 1 )

Purpose: Fetches The Layout Names Of This File, Then Gets The Script Parameter From The Calling Button And Calcs The Number Of The LayoutName Position (1 through n) In The Layoutname List. Last, The Goto Layout Script Step Navigates To That Layout Number.

The function returns a number which is the position of the layout name in the layoutname list. Typical use: Goto Layout[ ] i.e., Attach a button to a script such as: BTN: Goto Selected Layout, Script Step: Goto Layout[ GetLayout# // Custom Function ]

Comments

		marie, ottawa Apr 25, 2013
I need help. I want a script that will allow me to navigate to a specific layout in another table. I have a field on layout A in the Table A, that field has a company name, i want a button that will read that company name and will send me to that particular company (the Layout B) in the Table B. So i am thinking i need to choose my layout by calculation and initiate a search in the company field and then make it go to the right layout. But i cant find the right script. If you can help me please.

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

GetLayout# ( layout name )

Comments

Support this website.

Support this website.