0 Replies Latest reply on Oct 3, 2015 3:09 PM by TimRogers_1

    GetSummary Field in Portal

    TimRogers_1

      I'm creating a product ordering system.

       

      Every Order database that is generated includes the date and the vendor name, and then a "Summary" Record is also created with the Date of the Order, the Vendor name, and a GetSummary Field with the total amount of the order:

      Order Database.png

       

      In the table for my vendors I want to have a portal showing just these summary fields and the date and totals of each order.

      When i create the Portal, and sort the records everything shows up nicely:

      portal unfiltered.png

       

      However I only want the Summary records to show, so when I filter the portal to only show the records with Type = "Filter" the Order Summary Field is blank:

      filtered.png

       

      I want to be able to see a list of the dates of each order and the total amount.

       

      Can someone please assist me as to the best way to accomplish this?

      Here is a link to the sample Database:

       

       

       

      Any help with this would be much appreciated!

       

      Thank you