Hi,
I have a sales team that inserts every sale into a DB on to Air Table
I would like 2 do an automation that sends me a daily report with
1 - Sales on current month (how much)
2 - Sales on current month (how many)
3 - Sales on current week (how much)
4 - Sales on current week (how many)
Maybe make it in 4 different emails and get those numers in the subjet like "Daily Report - Monthly Sales = R$ 1000 / 10 sales" and "Daily Report - Weekly Sales = R$ 500/ 5 sales"
Is there a way?
The field names are
"Pagamento 1" for date
"Valor Total Projeto" for amount of money of each sale
Thanks in advance =D
Juan