AnsweredAssumed Answered

Button to trigger portal sort outside the portal

Question asked by jebber6685 on Nov 6, 2016
Latest reply on Dec 31, 2016 by shona1

Hello Fellow FM Users;


I have a relational setup between an Accounts file ( companies ) and Contacts file ( people ). Right now I have a portal in a layout of the Accounts file that displays all my contacts that work at ( relate to ) that company ( specific company record ). When viewed via that portal in the Accounts layout, they are sorted by last name. No problem here. I set the sort in Portal Setup... via the Last Name field ascending.


90% of the time this auto portal sort method is fine, but occasionally I want would like to sort the portal by not the last name but by a field I call Priority Contact. I have a drop down for this field to enter A, B, or C depending on the importance of that contact.

I would like to create a button that when pushed will sort the portal records by the Priority Contact ( A, B, or C ) thus overriding the Portal Setup sort by last name.  I would like the button to reside on the layout outside the portal in the Accounts layout.


Can this be done? I cannot seem to find a way to do this.


Any help here would be greatly appreciated.




Jeff -  Long time FM User


I have FMPro Advanced

OS - Windows 7