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?
Not sure how you’re envisioning this calendar, but you could work with a formula field to return the date however you want to use it. You mention the irrelevant time but it’s relatively irrelevant, depending on what you want to see and do.
If what you want is to be able to see a grid layout that says “deadline date” without a time and “event date” with time, you just hide the formula that puts them together. In the calendar, you will see the deadline on top with 12 am and the events in the bottom with their corresponding times–and if you make it so that deadlines have something to distinguish them visually, you may not care so much about the time showing. It’s all about what you’re willing to compromise to use Airtable (and all it’s good things) for free.
For example, would this work for you? (formula)
PRO doesn’t make it much more different but does hide the 12 because it doesn’t exist (2 date fields):
or without the label:
if you’re not looking for the benefits of the time not being there for deadlines when expanding records on calendar view, and if formatting such as I’ve shown first works for you, you can totally make it work with a formula and the free plan.
Thanks so much for the suggestions and the time you spent thinking about my
request! That was very nice, and what you say makes a lot of sense –
especially the point about the irrelevant time being relatively irrelevant
The only other problem with this approach is when I sync the data to Google
Calendar (this is the “One Ring to Rule Them All” view of deadline, events,
meetings, other calendars’, etc). My deadlines from Airtable come across as
one-hour events at midnight, so they are basically hidden from view during
the day. I could fix this by separating events and deadlines in the base
and not worrying about the redundancy of the Airtable calendar.
In the end, you are right and I’m not complaining – I really enjoy
Airtable’s flexibility and options. I’m a little obsessive about getting
things just right, but I can do that later when I’m finishing testing and
on the paid plan.