Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

GetLayoutNumberFromID ( layoutID )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 3.7  (36 votes)
  Discuss this Custom Function

Ulf Carlsson, Studentlitteratur AB
http://www.studentlitteratur.se

Gets the Layout order number from the layout with ID

Sample Input:
GetLayoutNumberFromID ( 2 )
Sample Output:
4


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

Use: Gets the Layout order number from the layout with ID "layoutID"

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 the function GetLayoutNumberFromID ( layoutID ).

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

This is my Custom Function and I want to edit it

Discuss:

due to the nature of "PatternCount" there might be situations where the wrong layout is choosen.
if you have a layout with id "38" BEFORE the layout you look for (with id "8"), the "38" is choosen because of "8" is part of "38".

i informed the "owner" and he hopefully will change it. otherwise you can do this by yourself by simply add a return in front and at the end of the number like this:
---------
Let ( [
layoutID = ¶ & layoutID & ¶;
layoutIDs = LayoutIDs ( Get ( FileName )) ;
currentIDPosition = PatternCount (
Middle ( layoutIDs ; 1 ;
Position ( layoutIDs ; layoutID ; 1 ; 1 ) ) ;
"¶" ) + 1
];
GetAsNumber ( currentIDPosition )
)
-----------


this will make sure that you only have the value you're looking for.

pixi, berlin/germany
August 26, 2009 9:47am

I would also add a return before and after the LayoutID's, else it doesn't work with the first or last value of the list.

Let (
[
v_layout = "¶" & layout & "¶";
v_fileName = Get ( FileName );
v_layoutList = "¶" & LayoutNames ( v_fileName ) & "¶";
v_IDList = LayoutIDs ( v_fileName );
v_position = Position ( v_layoutList ; v_layout ; 1 ; 1 );
v_currentLayoutPosition = PatternCount ( Left ( v_layoutList ; v_position ) ; "¶" )
];
GetValue ( v_IDList ; v_currentLayoutPosition )
)

Thomas, Montreux, Switzerland
March 01, 2010 5:04am

Sorry copied the wrong one :-(

Let (
[
v_layoutID = "¶" & layoutID & "¶";
v_fileName = Get ( FileName );
v_listID = "¶" & LayoutIDs ( v_fileName ) & "¶";
v_Position = Position ( v_listID ; v_layoutID ; 1 ; 1 )
];
PatternCount ( Left ( v_listID ; v_Position ) ; "¶")
)

Thomas, Montreux, Switzerland
March 01, 2010 5:08am

ValueCount(

Left(
"¶" & LayoutIDs( Get( FileName ) ) & "¶" ;
Position ( "¶" & LayoutIDs( Get( FileName ) ) & "¶" ; "¶" & layID & "¶" ; 1 ; 1 )
)

)

Vaughan Bromfield, Sydney, Australia
November 06, 2010 5:03am

Sorry did the functions a long time ago, if you can fix them please do, if not, sorry /Ulf

Ulf Carlsson, Lund
November 08, 2010 6:42am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 2 + 2 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions