Thanks for the efforts, @BiancaT.
When the date column changes it triggers an event. This event should be triggered only once when I set the date and time for an appointment. And it should send the right date and time. Currently, this is impossible to achieve, because each time you choose the time, it triggers without the right date, and each time you choose the date it triggers and closes, so you cannot choose the time. I think the solution would be to only trigger once the user has chosen both date and time, with an “accept” or “OK” button. If you want to avoid the extra click, you could let the user configure this for the date column.
I am not using the calendar integration. I am sending the triggered event to my own webhook backend and then to the calendar, because the Google Calendar Integration is currently unusable for me, as I explain in this post: