Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Data manipulation when grouping records on a date range

Topic Labels: Dates & Timezones
Solved
Jump to Solution
450 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,
I have a problem with data manipulation when grouping records on a date range.
Each record has a date and a time, (they are cash receipts linked to a cash register). Of course I have multiple records per day.
I want to group these records by day and verify the data via another table (the cash register verification table).
To group my records on a date range I have no problem (I used formulas of type DATETIME_FORMAT(Date, "DD/MM/YYYY ")).
On the other hand I want to use the sum of each day and link this sum in another table of my database and I can’t do it with the rollup because it considers the records unique and not grouped.
In short, on the one hand I have customers who buy, and on the other hand I want to do a data validation on the totals of several columns per day and this without having to link via a rollup each record of each customer.
Thanks for your help.

Capture d’écran 2022-08-15 à 17.21.10

1 Solution

Accepted Solutions

Hi Martin, I’m not sure if I fully understand your problem here

Could we link up the records with the DATETIME_FORMAT(Date, "DD/MM/YYYY ") value instead? That way they’ll be linked together by day and you’ll be able to do a rollup to get the sum like you want

Screenshot 2022-08-16 at 8.12.15 AM

Screenshot 2022-08-16 at 8.12.19 AM

See Solution in Thread

2 Replies 2

Hi Martin, I’m not sure if I fully understand your problem here

Could we link up the records with the DATETIME_FORMAT(Date, "DD/MM/YYYY ") value instead? That way they’ll be linked together by day and you’ll be able to do a rollup to get the sum like you want

Screenshot 2022-08-16 at 8.12.15 AM

Screenshot 2022-08-16 at 8.12.19 AM

Hi Adam, yes that is perfect. I made an automation to automatically complete the linked record from the date. And with the rollups it works perfectly.
Thank a lot