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

    GetSummary Field in Portal


      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:



      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