I need a free script that can collect user info and send an end report that totals the input.
Specifically, I collect sales data from many users each month in the form of an email. The each send me an email that reads:
Week Ending Total Sales
11/16 2
11/23 1
11/30 5
I would like for them to enter this info into a form and then be able to get the total for each week. This is where I am having problems finding a script. I only need the total for each week. I do not care about each individual user's data.
So, I only need to be able to get a report that says:
Total sales of all users for week ending 11/16 = 25, 11/23=55, 11/30= 34
Can anyone suggest a script that can calculate the totals like that?
thanks in advance,
doug