Portal Filter by Left text; 3

[Quito]

Hi,

I'd like to create a Portal with Categories for a single, rather large file with items. Each item is coded.  The first 3 characters in the code define the Category.

So, I'm thinking of filtering the items into Portal Categories like this:

IF Left ( CODE; 3) = "321"

Then show items in Category 1

IF Left ( CODE; 3) = "331"

Then show items in Category 2

IF Left ( CODE; 3) = "341"

Then show items in Category 3

...and so on

What should the real code be?

All the very best,
Daniel

[comment]

How do you want the users to select the category they want to show? Should they select from a list of codes, or a list of category names, or  .... ?

[Quito]

Thank you Comment,

I have a single table. The table contains records which are tagged with a Category field (321, 331, 341). 

Users have a portal with about a dozen tabs. Each tab is populated with records from the table according to Category (tab for Category 321, tab for Category 331, tab for Category 341, etc).

In the meantime, I've split the records into separate FileMaker files by Category (321.fmp12, 331.fmp12, 341.fmp12, etc) so I can populate the portal but this is really tedious and prone to error, as any change I make to one Category file must be added to all the other Category files. Can you suggest a better way of filtering the records within the Portal without splitting the file into smaller files?

Best,

Daniel

[Quito]

I found how to do it. In Layout mode, double click the portal layout. Select "Filter portal records" and click Specify:

If ( Table::Category = "331" ; Table::ID ; 0 )

Guess I'll have to change the Title of this Topic