I’m still testing Airtable and here’s a question for the gurus: I want to include (1) records with deadlines (due date only, e.g. 10/31/17), and (2) records with events (due date and time value, e.g. 10/31/17 8:00 AM) on the same calendar view, which in turn syncs to my Google calendar. But I can’t use the same date field for both, because if the date field includes a time value, it creates an irrelevant start time for the deadlines.
I thought I could use a formula field to adjudicate the preferred format per record (IF the record has a start time, use that date value, otherwise, use the date field with no time value). But the formula field requires the field to be formatted either with or without a time value, defeating the purpose.
Although the Pro plan permits multiple dates on the same calendar, which I assume could solve my problem, I’m wondering if there is a work around for the Free or Plus plans. Any suggestions?