How to make a report that will show us order of the day?

  • PAlunch
    Asked on January 13, 2021 at 8:51 AM

    Hi -

    We are using the school lunch order form. We need to compile information for the products ordered on each day. Example: We need to know what students ordered Chicken Fingers on Wednesday. We need a report that will show us Student Name, Grade, and Order for the day.

    I can't separate the products by day as they are given on the template.

    Please help me set up a table with this information broken down by day.

    Thank you.


  • Jessica JotForm Support
    Replied on January 13, 2021 at 9:39 AM

    Hi Sheila, thank you for reaching us.

    You may try to create your form using the Dropdown field.

    1610548622 5fff058e8c52c  Screenshot 10

    After that, you may try our Group By feature in Tables.

    1610548648 5fff05a89badf  Screenshot 21

    However, this is under the premise that the meal choices are not complex. Could you kindly elaborate future if you have a complex meal choice?

    We await your response.