Counting contents of fields

[aaronsupremeworks.com]

I have a customer that is having a dinner. I was hoping to get some help with a rule that would count the different meal choices in the different columns (one column for each guest) and return a result something like: 1 Steak, 1 Halibut

 

Sample data attached.

 

thanks

 

Aaron

Oct 12th RSVP Meal Choices by Name.xlsx.zip

[step]

Maybe this would do the trick:

var result = [];
var meals = {};
var fields = ["Guest Entree", "2nd Guest", "3rd Guest", "4th Guest", "5th Guest", "6th Guest", "7th Guest"]
             .map(Field).filter(String).forEach(function(s){ meals[s] = meals[s] + 1 || 1 });

for (var mealChoice in meals)
 result.push((count = meals[mealChoice]) + ' ' + mealChoice + (count > 1 ? 's' : ''));

return result.join('<br/>\n');

[aaronsupremeworks.com]

Thanks Step!

 

That worked great!