I have a calendar with both all day events and timed events and I am trying to display them both in an intuitive way. The problem is…because some of my records have start times, my date fields need to have times enabled…so I have to arbitrarily assign a start time to the record aka event. But then that stat time shows up on my calendar. I don’t want a start time on the calendar because it’s an all day event.
Through a series of formulas, I can create calcualted fields which the calendar references so the events without a end date/time show up as date only and the ones with an end time show up with a time.
However, because the calendar view is referenced formula fields, I cannot edit the event directly by dragging or clicking; I have to go into the record to edit the orignal date/time fields.
Is there a way for airtable to correctly display all day events without a few complicated formula columns? So they can be editable?