Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Template or example of daily invoice by cashier

Solved
Jump to Solution
949 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Silenus
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Everybody.

I would love your help in pointing to a template or example on how to set up a table that takes orders from another table and gives a daily summary by cashier.

Table: Invoices
Invoice 1 - Jane - 3000 - 1/2/2021
Invoice 2 - Dave - 2000 - 1/2/2021
Invoice 3 - Jane - 2000 - 1/2/2021
Invoice 4 - Dave - 1000 - 1/2/2021
Invoice 5 - Dave - 1000 - 1/4/2021
Invoice 6 - Dave - 1000 - 1/4/2021

Desired Table
Each row by date and cashier
1-2-2021 Jane - Link Invoice 1 & Invoice 3 - Total = 5000
1-2-2021 Dave - Link Invoice 2 & Invoice 4 - Total = 3000
1-4-2021 Dave - Link Invoice 5 & Invoice 6 - Total = 2000

1 Solution

Accepted Solutions
Databaser
12 - Earth
12 - Earth

Hi @Silenus

Depending on your wish to add more information to the “desired table” or not, the quickest way is to just dubble group your “invoices” table.

Group by cashier + group by date.

image

See Solution in Thread

2 Replies 2
Databaser
12 - Earth
12 - Earth

Hi @Silenus

Depending on your wish to add more information to the “desired table” or not, the quickest way is to just dubble group your “invoices” table.

Group by cashier + group by date.

image

Silenus
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks a lot.
Yes that solves my issue.
I just flipped your example and used the date first, so it groups by day then by user.

Now I’ll just check if I can get that data grouped like that from the API.