HidePortalScroll ( dph ; dprc ; dwch ; id_portalRecord )

Hide portal scroll bar unless extra data rows are hidden

Average rating: 4.5 (31 votes) Log in to vote

David Sparrow
Sparrow Design
http://sparrow-designs.com/

Sample input:

HidePortalScroll ( 250; 10; 800; Table_relatedTable::id_primary )

Also uses "input" from user-interaction - Get(WindowContentHeight)

Sample output:

1 or "" (null)

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

/* 
HidePortalScroll ( dph; dprc; dwch; id_portalRecord )

Use in Conditional formatting on "transperant object", so if Result is "1" make the object Fill = Opaque (hides portal scroll bar)

Assumes portal is set to enlarge vertically while maintaining orig. row height - i.e…display addtl. portal rows when it grows vertically. 

Copyright 2010, Sparrow Design
Feel free to use however you wish.

Dependencies: 
 Portal Layout Object Size
 Default # of Portal Rows Displayed
 Default WindowContentHeight

Legend:
 dph = default portal height as layout object
 dprc = default portal row count
 dwch = default window content height
 id_portalRecord = ID_Field in Related Portal Table

*/

Let ( [

hpr = dph/dprc ;  // height per portal row

tdr = Count ( id_portalRecord ) ;  // total portal rows with data

cwch = Get ( WindowContentHeight ) ;  // current window content height

diff = cwch - dwch ; // has window content height changed from default?

tvr = If ( diff  ≥  hpr ;  ( diff / hpr ) + dprc ; 0 ) ; // total visible portal rows, has content has grown > one portal row's hieght?

hr = tdr - tvr // if hidden rows exist, don't hide portal

] ;

If ( hr > 0 and tdr > dprc ; "" ; 1 )

)  // end let

Use in Conditional formatting on "transperant object", so if Result is "1" make the object Fill = White (hides portal scroll bar)

Assumes portal is set to enlarge vertically while maintaining orig. row height - i.e…display addtl. portal rows when it grows vertically.

// dph = default portal height as layout object
// dprc = default portal row count
// dwch = default window content height
// id_portalRecord = ID_Field in Related Portal Table

Comments

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

HidePortalScroll ( dph ; dprc ; dwch ; id_portalRecord )

Comments

Support this website.

Support this website.