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

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.

Sheila

Hi Sheila, thank you for reaching us.

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

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

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.