This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I built a base to track my medicine but need a time field type to improve it. Any chance that could be developed? You probably want to build in standard time where user can designate their time zone and what is known as military time.
Vernon, the current Duration field type doesnโt quite do it for me. My use case is a chain-of-custody style tracking of an item with a series of timestamps that donโt have start and end times for each record row, but that can be subtotaled with the first timestamp and the ending time essentially being the last time stamp. I did try creating this by making each timestamp a start and end time on itโs own and then summarizing the duration (in days) across records but I canโt figure out a way to do that with times.
Apparently I canโt embed a picture or URL link in my post reply to explain this in more detail.
You may need to โparticipateโ a little more before you gain the permission to include a picture or URL in your forum posts. Try adding an emoji or editing an earlier post to earn the badges.
Iโve found Duration field type is close but not exactly meet my use case โฆ That was a while ago now, so Iโll have to revisit.
+1 on this since duration and time arenโt the same thing. Something I didnโt see pointed out here was that grouping by date is thrown off when using the combo of date/time since it creates a different group for each time slot instead of a group by date, then time. (see example below)
Currently:
Date
10am
Date
11am
Date
12pm
When it should be:
Date
10am
11am
12pm
===
One idea may be to adjust the settings on the current date options so you can enable/disable the visibility of date just like you can do for time.
Itโs quite strange that Airtable is willing to spend time to create a duration field type but so reluctant to create time field type (my conclusion after reading several articles in the community).
As a user, I just think a time field is the simplest way to fit my demand as I would like to have a field for entering the date, the start time, and the end time separately.
Though I know it can be done by using the current date field and โinclude time fieldโ to allow the time entry. However, it will combine the date and time info into one field and I may need to create another column and use the โdatetime formatโ to get the time data without the date display. This is an indirect and inconvenient way for users.
For the end time, currently, Airtable allows users to get it by creating the formula that combining the current date field (with time include), the duration field and datetime format formula to get the result. But once again, this is an indirect and inconvenient way for users.
Another problem using the current date field type that included the time in one field is that when I change to other views from Grid to Kanban or Calendar, it does not allow me to display the time only.
I just want to voice out my need (maybe itโs also the need of other people) and hope Airtable can put it into consideration (to create a time field type or to modify the current date field that allows users to select date only, time only or date and time together) in the near future.
Iโm having the same issue. I have to export with separate time and date columns. Is this something that there is a formula where I can display only the time from a date-time column?
yes please - It is super hard to use the calendar properly for events, if these include events of different lengths - so some that are โall dayโ and others that have a specific time - as this basically means that we must include multiple fields which is time intensive and takes a lot of space