1 Reply Latest reply on Jul 5, 2014 8:43 AM by philmodjunk

    Configuring menus



      Configuring menus


           I have several tables whose 'items' (eg. drugs) appear in pop-up fields within portals at the 'front end' of a solution. For ease of use I'd like to let users configure these pop-up menus to reduce the choices to those they regularly use.


           If I had a Drug_rx < Drugs relationship and the Drug_rx table is shown in a portal on the related Patient table layout how would it be best to configure the value list if:

           There are 3 levels to choose:

           - Country

           - Company

           - Individual drug.

           I'd like to list the above fields on a layout with each value a checkbox. So, for example, if:

           - Country = all

           - Company = companies A, B, E were 'checked', all the drugs in the world would be listed if they came from companies A, B, E. This also means that a drug from company A, B  or E listed as only in Country = USA would also be listed.


           The checkbox lists themselves must be automatically be updated from individual drugs listed, should those drug have a new country, company or drug name.


           Lastly, I'd like users to be able to save dated choice lists so that they can revert to earlier choice or 'reset'.

        • 1. Re: Configuring menus

               These are called conditional value lists--which can be used with check box formatted fields and also drop down lists/popup menus. Here are some links on the topic. Of particular interest to you may be the link on Hierarchical value lists where the choices made in one value list filter the next in a "chain" of multiple conditional value lists.

               There's a lot of overlap between the first two links so you can read one and skim the other. The demo file gives you several examples of different conditional value lists so you can examine them to see how they are set up. If you are using FileMaker 12 or later, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in your version of FileMaker.

               The next to last link discusses how to set up a chain of conditional value lists where the value selected in each conditional value list controls the values listed in the next value list and the very last link is a fairly new addition that describes how to use ExecuteSQL to produce conditional value lists that aren't easily possible with the other methods described here.

               Forum Tutorial: Custom Value List?

               Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list

               Demo File: https://www.dropbox.com/s/j6qf0z9fnem3uxd/ConditionalValueListDemo.fp7

               Hierarchical Conditional Value lists: Conditional Value List Question

               Using ExecuteSQL to produce a conditional value list: Using ExecuteSQL to Produce a Conditional Value List

               Feel free to post follow up questions here if those links aren't enough to get your value lists working correctly.