3 Replies Latest reply on Apr 12, 2011 3:58 PM by GregW_1

    Conditional value lists - ID# field displaying for users on different platform

    GregW_1

      Title

      Conditional value lists - ID# field displaying for users on different platform

      Post

      We have an app shared through FM Server that is accessed by clients using FM Pro and clients using FM Go for iPad.  There are two value lists populated by records in two respective tables - Area and Item (fk to Area pk).
      The Area value list has the following options:
      -Use values from first field, "pkArea"
      -Also display values from second field, "areaName"
      -Include all values
      -Show values only from second field

      The Item value list has the following options:
      -Use values from first field, "pkItem"
      -Also display values from second field "itemName"
      -Include only related values starting from Area table
      -Show values only from second field

      A layout in the app contains a portal with two pop-up lists.  The user selects the Area list and the values of "Area::areaName" are displayed in alphabetic order, selects an option, and the second Item list displays values of "Item::itemName" in alphabetic order.  The conditional value lists work as they should.  The problem is with how the value is displayed in the Item list in this layout, here are the symptoms I have noticed:
      -FM Go for iPad user enters new record in the portal, selecting an Area value in the first pop-up list and an Item value in the second.  After exiting the new record, it correctly displays the "second field" values for Area and Item.  However, when viewing the exact same layout using FM Pro for Mac, the conditional value list, Item, is displaying the first field (pkItem), instead of the second field itemName as it should.
      -Opposite symptoms occur if the new record is created from an FM Pro client.  The FM Pro client sees the value of the second field in both lists, but the FM Go iPad client sees the value of pkItem in the Item list, instead of itemName

        • 1. Re: Conditional value lists - ID# field displaying for users on different platform
          philmodjunk

          A workaround to avoid this problem you might use is to switch to a drop down list and place a copy of the related table directly on top of the drop down field. Haven't tested that in go, (don't have an iOS device), but it works well in FileMaker. If the related field is set do deny access while in browse and has a solid fill color, it will hide the drop down list, but clicking/tabbing into it will still deploy the value list.

          • 2. Re: Conditional value lists - ID# field displaying for users on different platform
            GregW_1

            Clever workaround, thanks for the tip, it's functioning well on both platforms.  It was not necessary to change the field to a drop-down list, I kept it as a pop-up (preferable because there is no way for the user to manually type a value).  I added the textbox to display the related "name" field, placed it directly over the pop-up list with the same dimensions, set the fill color to that of the text color of the pop-up, set the text color to something that would show up over the fill, and made the textbox uneditable in Browse mode.  Clicking anywhere in the area (using either platform) triggers the pop-up list, and the read-only textbox on top updates and displays cleanly after making the selection.

            • 3. Re: Conditional value lists - ID# field displaying for users on different platform
              GregW_1

              Actually I am seeing other issues with the conditional value list on FM Go for iPad, under the same conditions as above.

              1.  Create the first related record using the portal,
              -Select an option from the first pop-up list.
              -Select the second, conditional pop-up list - the options displayed are correct based on the first condition
              -Select one of the options in the conditional list, and here is where the issue occurs - Sometimes the selection is momentarily highlighted after selecting, but doesn't get checked and the pop-up list remains up.  Sometimes the option gets checked, the pop-up list goes away, but the selected value is not inserted in the record.
              -Click outside of the portal to refresh/update the records, select the second conditional pop-up list again and select a value, then the correct value is inserted in the record.

              2.  Create another related record in the same portal
              -Select an option from the first pop-up list that is different from that of the first record in the portal
              -Select the second, conditional pop-up list - the options displayed are correct based on the first condition
              -Select one of the options, and here we see another issue - The option gets checked, the pop-up list goes away, but the value that gets inserted is not the one that was clicked, the field fills in with a value from the conditional value list of the FIRST record, not the current record.
              -After testing further I noticed that the incorrect value correlates to the same number option in the value list.  E.g. The first related record, first value list, had option A selected, thus the second conditional value list had the related options, call them A1 through A15.  Now a subsequent related record had option B selected in the first value list, and selecting the conditional value list gives you the options say B1 through B12.  But when you select B10, the field fills in with the value of A10.
              -The user needs to exit the portal and select the conditional value list and option B10 again, in order for the correct value to be inserted.