count number of items in products ordered

  • Profile Image
    Asked on June 09, 2020 at 11:00 PM

    I use jotform to place an ordering facility to my customers. I am a Baker.

    They may order several products. eg. 2 tinned sourdough loaves, 5 Teacakes, 1 pack of scones etc

    Is there a way I can some how consolidate all the order at the end of the day to give :

    Tinned Sordough Loaves = 7

    Teacakes = 9

    Scones 6 (packs)

    if I could get that I could then produce another Jotform to make a makeup list for the days production.

    I did try the CVS/Excel but all the items in Products are clumped together

  • Profile Image
    Answered on June 10, 2020 at 03:00 AM

    If I understood correctly, you want to know how many products you sold each day. Unfortunately, this cannot be automatically calculated. You can download a daily Excel report and manually calculate the sold products.

    How to Export Form Data to Excel