Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

FirstPortalViewed ( PortalName ; FieldName ; n )

Determines the first fully visible portal row in a protal

  Average rating: 4.3 (3 votes) Log in to vote

David - Show more from this author

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

/* Inputs: PortalName = Name of the Portal - necessary for layoutinfo FieldName = Name of field used - necessary for layoutinfo n = which portal row to start with and counter for recursion. This allows any number of portal rows breaking the 50,000 limit iteration if we pass the active portal row with n and subtract the number of portal rows in the layout to be sure we get above the first row. If the top field/portal row is only half visible then the returned portal row will be the first portal row that is completely below the top of the portal */ /* Calculate the top of the portal passed in the PortalName */ Let (p = GetLayoutObjectAttribute(PortalName;"Top";"";""); /* Calculate the top of the specified portal row using the FieldName field */ Let (r = GetLayoutObjectAttribute(FieldName;"Top";"";n); /* Test to see if r (field top)is greater than p (portal top). If not call the function again with n+1 or return with n */ Case( r > p ; n ; FirstPortalViewed(PortalName; FieldName;n+1)))) Click to copy

With filemakers tendency to reset a portal when you display a different record it is important to be able to return to the same portal. Use this function and a knowledge of how many portals are being displayed you can use the GOTO Portal by calculation to go to the record needed.'

If the function returns 8 and visible rows are 15 and total rows are 50 then the bottom row will be 8+15 or 23. Goto portal row 23 and your selection is back where you were.

 

Comments

		19752, Japan Mar 6, 2017
You forgot to remove 3rd parameter in recursive call. Last line should be Case( r > p ; n ; FirstPortalViewed(PortalName; FieldName; n+1))))

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: