I’m trying to setup a portal that filters records with a calculation field.

I have a set of Disk table records that have the fields Disks::Title and Disks::FirstLetter = Left(Title,1).

The user selects a letter from a value list attached to a global field gFirstLetter. A dropdown displays values A through Z.

The portal TO, FilterDisks, is a self join, using the “x” operator. It uses the filter criteria FilterDISKS::FirstLetter=FilterDISKS::gFirstLetter.
When a value (A to Z) is selected by the user I expect the portal to display only records beginning with that letter.
However, it does not display the records properly. Sometimes, but nor always, by clicking outside gets it to work.

I guess my question is: can portals be filtered with a calculation field?

 

Yes. I think you might need a commit and refresh.

Have a look at this technique for "filter as you type". http://filemakerinspirations.com/2010/10/dynamic-portal-filtering-while-you-type/

Via Layout View you can Set Script Trigger to the field where user types first letter, choose OnObjectKeystroke. And create a script with 2 steps: Commit Record and Refresh.

Also I would recommend in field properties on Inspector Window choose the right tab (Data) and click on a check-box that says "Select entire contents on entry"

Edited January 24, 20187 yr by Pavlk