2 Replies Latest reply on Apr 27, 2017 1:53 PM by mikewson

    Selecting Item in Value List Fails on Windows


      In our vertical market software we have numerous value list driven by records in tables. This allows each customer to customize the software. Take for example a list of products. In a routine operation they click into the drop down list of products, type the first letter of the product they want, and the first product that starts with that letter is highlighted. Or more accurately, the value list 'slides' down to show the values, and beyond, that start with their type letter.  Then, they merely click onto the one they want and they are done.


      Works great on Macintosh (any version of FMP).  But I just found out that it does not work on Windows, if they are on FMP 14.  (FMP 13 does work)  Any clues, anyone, on how to fix this for our Windows users on FMP 14? We have been moving all our customers to FMP 14 and have been shocked to find this problem in 14.


      By the way, in Windows with FMP 14, the observed behavior is that nothing happens when they type their desired letter.


      Each value list contains the ID and also displays the second field.  So, the drop down list, once closed, just shows the ID. A merge field beside it shows the second value on the layout.



        • 1. Re: Selecting Item in Value List Fails on Windows

          You could upgrade to 15 where I think that they fixed this. (Might test a free 15 day trial download to be sure.)


          Since that "Type one or two letters very quickly to scroll the list" trick never appealed to me as a good UI design, I've worked up alternatives that are better options, in my opinion.


          a) do it "backwards".


          Set up a relationship that matches by product name or description to products in addition to the one that matches by product ID. Format a text field to use a value list that just lists this name or description field, no ID. You can now format this value list to "auto-complete" on the value list--which in my opinion, works better than that "type quick" option. Then use this name based relationship to look up the ID and auto-enter it into the ID field that you originally set up with your value list. With additional scripting, this value list can be set up to add new products or handle cases where two products have the same name--neither are likely to be what you need here, but in other cases, this can be quite useful, such as when working with a value list of contacts in a contact manager.


          b) don't sue a value list at all. Set up a selection portal inside a popover where you enter some text into a search field above the portal and the portal updates to list matching entries. Clicking a product in the portal row then selects it for your record.


          Working examples and detailed documentation on each can be found in this teaching file:


          Adventures in FileMaking #2-enhanced value selection


          And please note the "Geek Busking" info on the introduction layout.

          1 of 1 people found this helpful
          • 2. Re: Selecting Item in Value List Fails on Windows

            Thank you! I have taken your advice and created a new single field value list, with a script that populates the ID behind the scene.


            Thank you again for taking the time to write such a carefully expressed suggestion!  Mike