AnsweredAssumed Answered

Comparing Records From the Same Field.

Question asked by yiningw on Jan 2, 2016
Latest reply on Jan 4, 2016 by mikebeargie

Say there is a "Company" field with 5 records: Apple, Orange, Banana, Kale, and Broccoli. I want a layout with two drop down lists, where the user gets to pick two of the 5 companies to compare data with. Eg, average spendings of Apple company vs. Banana company, who the distributors are, and average overages of Apple and Banana company, etc. All of these information come from their respective fields. Is there a type of script trigger that I can use so that the data within the layout is displayed based on the two separate companies that I am choosing from?