Brian Dunning's FileMaker Custom Functions

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   Bill Moseid
Model Masters
http://www.fmpsolutions.com

Share on Facebook Share on Twitter

  Sample input:
layout name
  Sample output:
layout number

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

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   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.
 

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.