Solved

Filemaker Pro 12 filter a portal by a value list

Posted on 2013-11-01
4
1,384 Views
Last Modified: 2013-11-05
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.
0
Comment
Question by:nsalabs
  • 2
4 Comments
 
LVL 4

Expert Comment

by:rjplus
ID: 39618603
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
 

Author Comment

by:nsalabs
ID: 39621955
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
 
LVL 1

Accepted Solution

by:
IT Ops earned 500 total points
ID: 39624140
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
 

Author Closing Comment

by:nsalabs
ID: 39624713
This is just what I was looking for Thanks!!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now