GetScrollPosition ( PortalName ; ObjectName ; PRN ; fountCount )

Get scroll position (top, bottom, and active no in it.

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

Ole Kristian Ek Hornnes - Show more from this author
ProgramDesign
https://programdesign.no

Sample input:

GetScrollPosition("aPortal";"anObjectInPortal¶"; count(PortalRelation::ID))

Sample output:

10¶20¶5 - Scrolled to top position 10, bottom 20, and active element is number 5 from scroll top

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


Let ( [
  ~portalTop = GetLayoutObjectAttribute(PortalName; "Top"); 
  ~portalBottom = GetLayoutObjectAttribute(PortalName; "Bottom"); 
  ~selectedRowTop = GetAsNumber(GetLayoutObjectAttribute(ObjectName; "Top"; 1; PRN)) ; 
  ~portalRowHeight2 = GetAsNumber(GetLayoutObjectAttribute(ObjectName; "Top"; 1; PRN+1)) - GetAsNumber(GetLayoutObjectAttribute(ObjectName; "Top"; 1; PRN)) ;
  ~portalRowHeight3 = GetAsNumber(GetLayoutObjectAttribute(ObjectName; "Top"; 1; PRN)) - GetAsNumber(GetLayoutObjectAttribute(ObjectName; "Top"; 1; PRN-1)) ;
  ~prh = If (~portalRowHeight2 < 1; If ( ~portalRowHeight3 < 1 ; 0; ~portalRowHeight3) ; ~portalRowHeight2); 
  ~FromTop = If (~prh < 1; 0; Floor ( ( ~selectedRowTop - ~portalTop) / ~prh ));
  ~TopPRN = PRN - ~FromTop; 
  ~Lines = If (~prh < 1 ; 1; Floor((~portalBottom - ~portalTop) / ~prh)); 
  ~BottomPRN = If ( (~TopPRN + ~Lines) > fountCount; fountCount; ~TopPRN + ~Lines-1)

]; 
  ~TopPRN & ¶ & ~BottomPRN & ¶ & ~FromTop+1 
)

/*

Parametere:
- Portalnavn - A object name for the portal
- Objektnavn - A object name found inside the portal.
- PRN - Portal row number for active ellement.
- foundCount - Number of records in selection.

Returns 3 values , one value on each line.
- Top Portal Row Number
- Bottom Portal Row Number
- Relative number for Active portal row number in portal dvs 1,2,3… independent of scroll posisjon.

*/

Comments

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

GetScrollPosition ( PortalName ; ObjectName ; PRN ; fountCount )

Comments

Support this website.

Support this website.