I have created two events, as shown below. One from Google Calendar, and one from Appsheet. The Appsheet-created event appears as an All-Day event but actually, it’s not. I would like the event to be All-Day so that client can receive All-Day notifications from Google Calendar app. (Client is not interested in receiving notifications through Appsheet, since that isn’t an option with the free version.)
I’ve tried to create the dates for [Start] and [End] to be Date type instead of DateTime, but Appsheet automatically assigns 12:00am as default.
Currently, my work around is that I have to create 2 events. One to create the psuedo All-Day event on the calendar, then another as a timed event, so that the client can receive the notification at that time. It’s definitely not ideal. It looks clunky with all the extra timed events, and also just seems like bad practice to have double the events.
Since Google Calendar is essentially a giant spreadsheet, I would think there would be a column for “All day” with True or False values or something like that. If there is, is it possible to access it through Appsheet?