AnsweredAssumed Answered

How sort records using script with several fields?

Question asked by egbaumier on Nov 25, 2016
Latest reply on Nov 25, 2016 by keywords

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

Outcomes