Group Start date - End Date by day and send alert

AppSheet AppSheet Q&A
, ,
1

In my app I have for each record (event) 2 fields:

  • Start Date (with the time)
  • End Date (with the time)
  • Name of the event

and in my calendar view all works fine.
I have also created a virtual column that calculate the total of hours TOTALHOURS([HOURS])

Now I would create a view that group the hours for Each day/Event and so show how many hours for each day.

And so (for example):
Column Day | Event | Column Total Hours
06/11/2023 | Event 1 | 5 hours
06/11/2023 | Event 2 | 3 hours
06/11/2023 | Event 3 | 15 hours
06/11/2023 | Event 4 | 5 hours
06/11/2023 | Event 5 | 4 hours
07/11/2023 | Event 6 | 5 hours
07/11/2023 | Event 4 | 5 hours
08/11/2023 | Event 5 | 4 hours
08/11/2023 | Event 6 | 5 hours
etc…

2

What do you need help with ? Looks like you already have everything necessary.

3

Now I would create a view that group the hours for Each day/Event and so show how many hours for each day, and so not start date - end date, but single day.

And so (for example):
Column Day | Event | Column Total Hours
06/11/2023 | Event 1 | 5 hours
06/11/2023 | Event 2 | 3 hours
06/11/2023 | Event 3 | 15 hours
06/11/2023 | Event 4 | 5 hours
06/11/2023 | Event 5 | 4 hours
07/11/2023 | Event 6 | 5 hours
07/11/2023 | Event 4 | 5 hours
08/11/2023 | Event 5 | 4 hours
08/11/2023 | Event 6 | 5 hours

4

You can create a column [Column day], set the type as Date and use as a formula : [Start Date], which will convert it in date format.

For total hours (assuming you didn’t created it yet), formula can be : ([end date] - [start date]) and type should be Duration

5

Thanks, it works.

1 Like
6

Nice ! You can mark the thread as solved. Have a nice day !