PortalScrollPosition ( portalName ; objectName ; totalPortalRows )

Returns the scroll position of a portal (number of the first and last fully visible row in a portal, separated by ¶)

Be the first to rate this function Log in to vote

Stefan MÃ¼nger - Show more from this author
University of Bern

Sample input:

PortalScrollPosition ( "portalName" ; "objectOrFieldNameWithinPortal" ; 123 )

Sample output:

3¶27 //first and last visible row of portal

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

/*
 * =============================================================================
 * PortalScrollPosition ( portalName ; objectName ; totalPortalRows )
 *
 * PARAMETERS:
 *		portalName (text): name of the portal
 *		objectName (text): object within the portal, typically a field
 *		totalPortalRows (number): total of visible and invisible portal
 *			rows; use: Count ( tableName::fieldName)
 *
 * RETURNS:
 *		(text) Number of first fully visible portal row and 
 *		number of last fully visible portal row, separated by 
 *		a return (¶ or char 13)
 *
 * REQUIREMENTS:
 *		FM 18+
 *
 * DEPENDENCIES:
 *		none
 *
 * PURPOSE:
 *		returns the scroll position of a portal (number of the first 
 *		and last fully visible row)
 *		
 * NOTES:
 *		none
 *
 * VERSION:
 *		1.0 - 2019-08-16; Stefan Münger
 * 
 * =============================================================================
 *
 */
 
While ( 

[ 

posPortalTop	= GetAsNumber ( GetLayoutObjectAttribute( portalName ; "Top" ) ) ;
posPortalBottom	= GetAsNumber ( GetLayoutObjectAttribute( portalName ; "Bottom" ) ) ;
$i		= 1 ;
$ii		= totalPortalRows ;
r 		= ""

] ; 

$i < $ii ; 

[ 

posTop		= GetAsNumber ( 
			GetLayoutObjectAttribute( objectName ; "Top"; 1 ; $i ) 
			) ;
posBottom	= GetAsNumber ( 
			GetLayoutObjectAttribute( objectName ; "Bottom" ; 1 ; $i ) 
			) ;
r		= List ( r ; 
			If ( posTop ≥ posPortalTop and posBottom ≤ posPortalBottom ; 
				$i ) 
			) ;
$i		= $i + 1

] ; 

LeftValues ( r ; 1 ) & RightValues ( r ; 1 )

)

Returns the scroll position of a portal (number of the first and last fully visible row in a portal, separated by ¶/char 13 (requires FM 18+).

Parameters:
portalName (text): name of the portal
objectName (text): object within the portal, typically a field
totalPortalRows (number): total of visible and invisible portal rows; use: Count ( tableName::fieldName )

Comments

		Josh Ormond, Iozax, LLC Aug 16, 2019
This line references a literal table:field. \| $ii = Count ( chapters_all::d_uuid ) ;

		Josh Ormond, Iozax, LLC Aug 16, 2019
This line references a literal table:field. \| $ii = Count ( chapters_all::d_uuid ) ;

		Stefan MÃ¼nger, University of Bern Aug 16, 2019
Thanks. I corrected this.

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

PortalScrollPosition ( portalName ; objectName ; totalPortalRows )

Comments

Support this website.

Support this website.