Filemaker Pro 12 filter a portal by a value list

Hello,

I have a portal I'd like to be able to filter based on a value list that can be edited to include or remove list items.

Example list

1st
2nd
3rd
-
Mobile
Fax
Toll Free
Pager
-
Home

Say if I add a 4th or remove the 3rd option from the list, I want it then to  refilter the portal by the new list.
nsalabsAsked:
Who is Participating?
 
IT OpsConnect With a Mentor Commented:
There are a couple of ways this can be accomplished off the top of my head:

Let ([ 

~list = ValueListItems ( Get ( FileName ); "YourValueListName" );

~text = yourRelatedTable::youRelatedFieldName

];

PatternCount ( ~list ; ~text )
)

OR

Let ([ 

~list = ValueListItems ( Get ( FileName ); "YourValueListName" );

~text = yourRelatedTable::youRelatedFieldName

];

ValueCount ( FilterValues ( ~list ; ~text ))

)

Open in new window

0
 
Robert JacksonSystem DeveloperCommented:
Could you clarify - Is this question about portal filters, dynamic value lists or perhaps both?

Portal filters
Portal filter example from Sarah Severson, Solient Consulting Attached file

Value lists
You could create a dynamic value list that is based on a field value.  The value list changes whenever the field has a new and unique value added.

Here is a great file on creating value lists on the fly - Magic Value lists by Andries Heylen of BH&A courtesy of Kevin Frank's site FileMakerhacks Magic Value Lists
0
 
nsalabsAuthor Commented:
Thanks for the examples but neither does what I am trying to do.

I have several portals I wish to filter each by the values in a value list.

The example is types/priority of phone numbers the value list is a popup menu for a type field in the portal.

So say if I remove the toll free type from the list I want the portal to no longer show toll free numbers. I don't want it to change the type on the record just filter it out of the portal.

I am trying this in the portal filter but it isn't working

Phone Type /*Field that holds the type from the value list = ValueListItems ( Get(FileName) ; "Phone Type Value List Name" )

It should show any portal record that has a type field which matches a value in the value list.

I don't see the value list being edited often but I am trying to use the same kind of portal filtered by a value list in multiple locations and only want to have to edit the value list to change the filter on the portal.
0
 
nsalabsAuthor Commented:
This is just what I was looking for Thanks!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.