Pre-order summary report including table numbers : Dish Cult

Start a new topic

Pre-order summary report including table numbers

Dominic Perry

started a topic almost 5 years ago

Create a pre-order report that shows the total number of each dish ordered for each table that can be displayed in one report.

I.e Table 1 - 4 of X dish, 5 of Y etc,

Table 2 - 3 of X, 6 of Y etc

This would save having to go into each individual booking and having to print or view the pre-order.

1 Comment

Ewan Farry

said almost 5 years ago

Hi Dominic,

We have the function within the 'Placecards' section to export pre-orders to CSV.

The exported data does include;

- Table numbers
- Dishes ordered

The missing part is the totals of the dishes ordered.

I have raised the improvement request on your behalf to include this.

What you could try if you are comfortable with formula in spreadsheets, is to export the CSV from placecards and apply the following;

Add =UNIQUE(F2:I2) anywhere and specify the cell range where all the items are
Enter =COUNTIF(F2:F5, E5) this adds the number of dishes shown in E5
Drag across all dishes to replicate

How can we help you today?