2 Replies Latest reply on Jul 20, 2015 7:32 PM by JackWilliams

    Responsive/Synchronized Fields

    JackWilliams

      Title

      Responsive/Synchronized Fields

      Post

      Hi everyone,

      I'll give a lot of detail here because I believe what I am trying to do is a bit complex. I have a layout in my FileMaker solution that I call a "kit builder". What this "kit builder" does is compile products, which I have stored in a few other separate tables, into one "kit" of the aforementioned products stored in other tables. Visually, I am trying to make this easy for the end-user.  Following is a screenshot of what a sample element of the kit builder looks like alone (http://i.imgur.com/Ju4SHuT.png). I would like the elements to synchronize with each other, meaning that fields on that element should update according to which record is initially selected. For example, Product A is a record stored in the "PV Modules" table. This record, of course, contains fields, such as an image that is specific to the record/product. When I select product A from the drop down menu (which I know how to do already), I would like the image container box to update with the image container field used in Product A's record. Here is a visual example of what I am trying to accomplish (http://i.imgur.com/zKkMr3H.png). I apologize for asking such a detailed question, but I'm still relatively new to FileMaker and I'd rather not spend time devising a system that may or may not work only to discover that there was a much easier and more efficient option.

      Thanks! 

        • 1. Re: Responsive/Synchronized Fields
          SteveMartino

          It's always good to start with a plan and explore the available options.

          Some questions, because you have some contradictory statements in your post:

          First you say you want to 'sync' with items in separate tables.

          Then you say,

          Product A is a record stored in the "PV Modules" table. This record, of course, contains fields, such as an image that is specific to the record/product. When I select product A from the drop down menu (which I know how to do already), I would like the image container box to update with the image container field used in Product A's record.

          That's 2 different scenarios.  Do you have a master record (from which table/relationship?) on your layout, where you want to pick a different record from the dropdown, and go to that record with all the pertinent information

          OR

          Do you just want the dropdown to select an item, and add it to the main record (like an invoice with a portal to line items)?

          The first type scenario would be more of a master/detail module.  The second scenario is more of adding a picker list.  In this second scenario, you would use calculations or lookups, like you would in an standard invoicing solution where the dropdown selection triggers a script which depending on how you have your layout set up and which table/TO's are connected), adds what you selected to the main record on they layout, usually in a portal.

          Both of these are easily googled on all the FM sites & blogs with many examples

          Is the panel on the left (with the dropdown) a portal or a popover?

           

          • 2. Re: Responsive/Synchronized Fields
            JackWilliams

            The second option, apologies for not being clear. Fields on the kit builder interface should draw information from other tables, but add it to the "kits" table (separate).