EXAMPLE - Portal Sort Via Calculation

From Dwayne Wright - www.dwaynewright.com

A very simple example of sorting a portal by using a calculation field. The calculation is simply...

Case(
Global Filter Field = "Sort Name", Name,
Global Filter Field = "Sort Zip", Zip,
Global Filter Field = "Sort Phone", Phone,
Global Filter Field = "Do Not Sort", "",
"")

with a text result. We put the Global Filter Field on the layout and made it a radio button value list. When you make a selection and exit the record, the portal sort for you. We added a button on the layout with the name of sort. This button doesn't do anything such as running a script. However by clicking the button, you exit the record and you will trigger the screen refresh.

An example file can be downloaded at ...

http://www.dwaynewright.com/blogfiles/SortCalc.zip
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.