FILEMAKER: EXAMPLE: Get Field Function Sorting Portals With Color

From Dwayne Wright - www.dwaynewright.com

This example uses the GetField Function Sorting example and expands on it. What we have done has allowed the sorted field to be highlighted in yellow. This is a very simple technique. First we created a container global field and pasted a color rectangle in the field. Then for each field in the portal, we created a duplicate calculation field that has a container result.

For example, we have a First Name Highlight field with the following calculation ...

If(Portal Sort = "First Name", Highlight Color Global, "")

which is to say that if the radio button equals First Name, show the color.

Like we said earlier, we created a highlight field for each field in the portal. The we put these fields in the portal behind the regular fields. This can be done with the options in layout layering.

An example file can be downloaded at ...

http://www.dwaynewright.com/blogfiles/GetSortedColor.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.