PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Amalgamate all product orders into one grand total for each product?

  1. Chalky
    Member

    Not sure my post title is all that explanatory, but we are using a gravity form to allow corporate clients to submit orders for food to a catering company's kitchen. Each menu item is a single product with an associated price. It's working really well for each client's submission, informing our catering client of quantities of each product that has been ordered. Which helps with their paperwork for each account. So far, so good. Well so far, so perfect actually :)

    I know that in an ideal world the client would also like a summary of all of their clients' forms, so that the kitchen knows the total number of item A, item B etc that they need to cook the next day. Is there an easy way to do this? (Other than my client typing each submission into a spreadsheet).

    Thanks for your help.

    Posted 12 years ago on Monday October 3, 2011 | Permalink
  2. How about exporting the entries and combining them in Excel? You should not have to type the data in. If the information comes from multiple forms, combine all the CSV and then open in Excel.

    Posted 12 years ago on Monday October 3, 2011 | Permalink
  3. Chalky
    Member

    Just tried that and yes it works! Thanks very much. The simple solutions are often the best.

    Posted 12 years ago on Monday October 3, 2011 | Permalink
  4. Glad that worked for you. Sounds like a neat use of Gravity Forms. Thanks.

    Posted 12 years ago on Monday October 3, 2011 | Permalink

This topic has been resolved and has been closed to new replies.