2 Replies Latest reply on Mar 9, 2016 7:12 AM by scottworld

    Portals not auto-refreshing in 14.0.5

    scottworld

      We seem to have discovered a significant bug in FileMaker Pro 14.0.5, for a database file hosted with FileMaker Server 14.0.4.

       

      Aren't unfiltered portals ALWAYS supposed to automatically refresh to show any new line items that are added elsewhere? We've got a very simple invoicing solution with no tricks at all. Just the world’s simplest invoice table related to the world's simplest line items table. The relationship is just your basic generic relationship: the primary Invoice_ID field related to the foreign Invoice_ID field. Nothing unique going on here at all. (We also have the relationship checkbox set to allow creation of line items via the relationship, and the line items are sorted by date  — which is a date field on each line item.) This is all Basic FileMaker 101… nothing unusual nor advanced going on here.

       

      The invoice layout has a portal showing the related line items. Simple as pie. The whole setup would take about 30 seconds to setup… no trickery involved.

       

      If we open up 2 windows side-by-side in FileMaker Pro — one window is the Invoice table and the other window is line items table — and we start adding new records directly into the line items table, we get the expected behavior: Every time we add a brand new record into the line items table (with the proper Invoice_ID), that line item immediately & instantaneously shows up in the portal on the invoices table. Expected behavior.

       

      However, if we launch FileMaker Go 14.0.4 on the iPhone, and we go into the line items layout on the iPhone, and start adding new records directly into the line items table on the iPhone, the invoice layout on the desktop will NOT automatically refresh its portal with the newly-added line items. Those newly-added line items do actually exist in the line items table, but they do NOT appear within the portal on the invoice layout. We’ve tried adding dozens of line items via FileMaker Go, and yet FileMaker Pro's Invoice table on the desktop STILL doesn’t refresh its portal to show the newly-added line items. We are required to force a window refresh in order to force the portal to update itself.

       

      (If you aren’t seeing the same behavior on your end, then I can go into more detail about how we are adding the line items on the iPhone. We are actually adding each new line item via a very simple script that freezes the window, switches to the line items layout, adds the new line item, then comes back to the original layout. Again, very simple FileMaker 101 methodology, with no trickery involved.)

        • 1. Re: Portals not auto-refreshing in 14.0.5
          TSGal

          scottworld:

           

          Thank you for your post.

           

          This is by design.  If a client (FileMaker Pro, FileMaker Go, WebDirect) makes a change to a related table (not a portal on the current layout), the portal will not update until a Refresh Window occurs.  Your initial example with two windows will work for the current client, but other clients will not see the change in the portal until it is refreshed.  In essence, we do not want to update all information for all clients any time a new record is added to a table.

           

          If the relationship is set up to allow creation of records in the related table, then when you add a record directly to the portal, the data will then update to all clients.

           

          TSGal

          FileMaker, Inc.

          • 2. Re: Portals not auto-refreshing in 14.0.5
            scottworld

            TSGal:

             

            Thank you so much for this information! This is very interesting, and we didn't realize that this is how it was supposed to work.

             

            thanks,

            Scott