Product List : option to tally total order quantity of each item

  • ccvegan
    Asked on November 6, 2021 at 3:07 PM

    Hello-


    People are using my order form but I cannot see a chart of how many of each item was ordered. Right now I have to click on each order to see the total but that will take a lot of time to transcribe it all.


    I need to see how many of each item was ordered so we know how much to make.


    I hope there is an easy way to do this.


    Thanks!

  • Basil JotForm Support
    Replied on November 6, 2021 at 3:54 PM

    Hi,

    You need to click on the submission to see the details, you may consider using one of our reports to see the data as well.

    https://www.jotform.com/help/187-how-to-create-a-visual-report-with-your-form-submissions/

    Please let us know if you require any further assistance.

  • ccvegan
    Replied on November 8, 2021 at 8:16 PM

    This is not what I need. When I run a report it shows me when people ordered and who ordered but not WHAT they ordered.

    I need a list of what was ordered so I know what to make.

    To click on each submission will take an hour- I would have to notate every order on paper and then add it up. I feel like this form should be able to do this.

    Please look at my form. I need to know-

    Total Meals

    Total Desserts

    Total Sides

    ETC.


    Thank you!

  • Basil JotForm Support
    Replied on November 9, 2021 at 12:56 AM

    Hi,

    You may consider downloading the submissions as an excel file as it seems to be the most suitable way to match what you are looking for.

    1636437314 618a0d42d2d82  Screenshot 10

    Relevant guide: https://www.jotform.com/help/44-how-to-export-form-data-to-excel/

    Please let us know if you have any further questions.

  • ccvegan
    Replied on November 10, 2021 at 12:33 PM
    Again, this gives me the times of everyone who ordered, and who they are
    but not what they ordered.
    I don't think this form is capable of giving me this information.
    ...
  • Basil JotForm Support
    Replied on November 10, 2021 at 2:59 PM

    Hi,

    These are the only ways to see the data, if none of them work for you, then, unfortunately, what you are asking for is not possible.

    Please let us know if you require any further assistance.

  • jonathan
    Replied on November 25, 2021 at 2:20 PM

    We apologize for the inconvenience. I submitted a feature request ticket for this feature.

    We cannot give you any time frame as to when this will be available, but we will notify you here and in your email for any news/updates related to this feature.