Hello! I created this test app (https://datetest.glideapp.io/) to ask you for help.
When I create an event I only insert the date without the time. By adding details to the event (sub-events), the overall duration of the event is calculated, as the sum of the durations of the sub events. As a result, the end time of the event is calculated as the sum of the start date and the duration.
So far, so good. What I can’t do is make sure that the start time of a new event matches the end time of the last event already on the calendar for the selected date.
For example, if I have already entered an event that starts on May 19th at 0.00 and ends at 1.30, I would like if I insert a new event it starts at 1.30 and ends according to its duration.
I have tried numerous solutions but have not been able to find the right way!
I hope it is understandable!
Thank you so much