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

    How sort records using script with several fields?

    egbaumier

      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:

       

      State

      Vertical Market

      Supplier

      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?

       

      Tks

       

      Edison