1 Reply Latest reply on Aug 17, 2015 10:04 AM by philmodjunk

    Drop Down Relation / Portal Filtering

    MartinBishop

      Title

      Drop Down Relation / Portal Filtering

      Post

      I have two portal, one is a list of child records related to its parent. The other is a list of all child products.  I am trying to filter these two portals with a global drop down menu and is partially working. The problem I am encountering is the implementation of adding items into the drop down that don't mean anything to the records, such as "Show All" and "Complete ##". I think viewing of my file might make more sense.

      https://app.box.com/s/p8totym3kduiur84mquh6tfqp4wcfvvf

      Screen_Shot_2015-08-17_at_9.05.03_AM.png

        • 1. Re: Drop Down Relation / Portal Filtering
          philmodjunk

          Take a look at:

          "Adventures in Filemaking #2 - enhanced value selection"

          There's a section there on adding "action items" to a "use values from field" value list with a script that detects and responds to the selection of an "action item" such as "show all".

          If you are having trouble with getting that script to make the needed changes to what is shown in your portal, you'll need to describe your tables/relationships and explain how you want this filtering to work. (And yes we can then look at your file, but if you provide a few bread crumbs such as the name of the layout where you have set this up, we'll know that we won't need to spend a lot of time looking at your database and trying to figure out which one shows the issue that's the subject of your post.)