Need a help to creat 7 day summary for luggage store rental

This should be fairly simple with filter groups on the data layer, which you can replicate into an interface if desired. 

For the filter the logic should be basically 

In this view, show bookings where..

• Condition Group 1: 
  • Where Booking Status is Confirmed 
  • and Start Date is within the next number of days 7

or

• Condition Group 2:
  • ​​​​​​​Where Booking Status is Renting
  • and End Date is within the next number of days 7

Hey @hello161, 

As mentioned by ​@DisraeliGears01 above, one way would be to set that up on your filter using groups. More on that matter here.

The other way would be to create a helper formula field. 

Step 1: Add a helper formula field in your Bookings table, call it “In next 7 days?” with something like: 
 

IF(
  OR(
    AND(
      {Booking Status} = "Confirmed",
      IS_AFTER({Start Date}, TODAY()),
      DATETIME_DIFF({Start Date}, TODAY(), 'days') <= 7
    ),
    AND(
      {Booking Status} = "Renting",
      IS_AFTER({End Date}, TODAY()),
      DATETIME_DIFF({End Date}, TODAY(), 'days') <= 7
    )
  ),
  "Yes",
  "No"
)

Step 2: Create a new grid (or calendar) view called “Next 7 days summary” and add a filter: 
“In next 7 days? is Yes” 


Feel free to grab a slot using thisi link if you need any help setting this up. Happy to help :D 

Mike, Consultant @ Automatic Nation 
YouTube Channel

Thanks to both ​@DisraeliGears01  and ​@Mike_AutomaticN   I really appreciate the time and effort you put into helping me. 🙏

I’ve tried both methods you suggested, and technically they work.. However, they don’t achieve what I’m actually trying to see in the Next 7 Days summary.

Let me clarify my goal again with a clearer explanation (I’ll attach screenshots/images below).

When I use the suggested methods, the filtered views show mixed start and end dates together. While the data is correct, it becomes visually confusing during daily work. My eyes aren’t trained to constantly scan each row and distinguish between start dates and end dates every single time.

What I’m trying to achieve instead is a separated and more intuitive summary, similar to how one of our competitors displays it.

For example:

1 Feb 2026 (or Today)
Start

• Booking 01

• Booking 02

• Booking 03

• Booking 04

• Booking 05

• …

Today
End

• Booking 02

• Booking 03

• Booking 04

• Booking 05

• …

2 Feb 2026

• …
  
   

  

   

​@hello161 interesting, seems like you want to group/view by the calendar date itself rather than by the start/end date on the actual record as shown in your screenshot.

In that case, I would suggest using a calendar or timeline (as a view or interface) and that shows the multiple date types

for example, here is a content calendar that has different dates for when I’m shooting each video vs shipping it. That would be a parallel to how you have a start and end date for each booking. 

This would give you a view of all bookings starting and ending on a given day. 

 

Yeah, you’re probably going to want to build out an interface to get things just right, and timeline or calendar views are helpful for that. Aside from the basic filter conditions, this is when adding group, sorts, and colors on top becomes handy. You could add to ​@alexmcdonnell’s suggestion by coloring the records by Booking status.

The other thing you’re probably running into issues with in the screenshot is your grouping on a date that includes time, so it will usually create single groups instead of grouping records by the date (1/28/26 10:00 is different from 1/28/26 10:05). If you added a formula field with DATETIMEFORMAT({Date Start}, ‘l’) it’ll get rid of the time and let you more cleanly group.  

That said an interface is probably a better solution at this point, as you can customize field names and positions much more granularly to help draw the eye to relevant information, which is useful in a summary view.