3 Replies Latest reply on Nov 25, 2016 12:57 PM by keywords

    How sort records using script with several fields?


      In a regular layout form (not a portal) there are 5 subtotal levels.

      Every subtotal will be visible if I sort records according one field.

      Customer would like to combine some of these fields to see these report according these fields.


      Report contain these levels:



      Vertical Market


      Product Family

      Part Number


      How can I do a script to be able to include these fields to sort records and get a report just with fields and subtotals that I want?


      I know how to do script that contain one of these fields, but I need to combine several fields such as State, Supplier and PartNumber or Vertical Market, Supplier, Product Family and Part Number. All these subtotal levels should be reorder based a Summary Field.


      Is there any way to get just one script that get assigned fields to include in sort records or should I get several (25) scripts with every possible combination?