The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Sep 06, 2023 02:57 PM - edited Sep 06, 2023 02:58 PM
I run a podcast studio and I track the status of a podcast with names, dates, episode name, guest name, etc.
I have a column on recording date, but would like to add a specific time it will be recorded at.
so how do I add a specific time to a column?
I only see time created and timestamp but no option for specific time?
Sep 07, 2023 12:17 PM
Within your date field there is a toggle to turn on time as well.
Sep 14, 2023 08:52 PM
If you select include time under created time it should appear like this. Is this what you're wanting it to look like?
Sep 17, 2023 02:59 PM
yes!
but as far as i know, the only option is created time and last modified.
i dont see option to put in a specific time that you typically have with, say google calendar.
Sep 17, 2023 06:50 PM
Hmm, that's weird. Is your column just a normal date field? Also, do you have the free airtable or pay a little monthly? I notice sometimes the free version is unable to do certain things but I feel like it would be able to do this.
Sep 21, 2023 09:43 AM
I was using pro account for the first month and all the time options is created time and modified time.
im on the free plan atm.
Sep 29, 2023 01:13 PM
Like Zack mentioned, you'll want to use a Date field and toggle on "Include time" - this will also make it so that you can plot out your records in a Calendar. I wouldn't recommend using Created Time or Last Modified Time fields for what you're trying to do.
If you don't plan on plotting out the times in a calendar and just want to plug-in free-text for your own tracking, you could also use a Duration field (which will look like, for example, "8:30" but technically be read by Airtable as 8 minutes and 30 seconds, depending on how you format it, and not 8:30Am or 8:30PM) or even Single-line Text