Using formula field in time tracker

[Yuku_Kotani]

I’d like to calculate duration by due date and current time like DATETIME_DIFF(Date, NOW()) and refer it from time tracker. However, this field is not selectable in time tracker. Of cource i configured format type to duration.
Does anyone know how to use formula in time tracker?

[Elias_Gomez_Sai]

The Time Tracker block measures the duration and sets it in a Duration field, and optionally fill the Start Date (and Time).

You can’t use the block to calculate time from now to due date, the formula you typed already does that :thinking: . You can’t use that field in the Time Tracker because it is not a Duration type field, it’s a Formula type.

Airtable - Support

Duration field type

The duration field type is a numeric field type intended for use with time durations measured in hours, minutes, seconds, or milliseconds. (If you want to store a time duration measured in days, we...

[Yuku_Kotani]

Oh i see. I misunderstood that time tracker is something like reminder.
Thank you for answering!

[Elias_Gomez_Sai]

Check this for reminders:

How to Set up a Calendar Reminder Views

I use Airtable in a very basic way. The only integration I have is via Zapier and emails. No formulas at this time. Is there a way to incorporate a calendar that will send a reminder. In my real estate business I will have certain dates that require attention in keeping the transaction on track. I’d like those dates to ding, ring, clang as reminders across email, on airtable, etc. This seems so elementary so surely I’m missing something?