Base Design
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Why can't I convert text to date when importing excel sheet?

Hi,Every time I try to convert the multiple select field (automatic field from import) to Date (with time included), I get this message that some cell data may be cleared. And indeed, most of the cell data were cleared. I don't understand this as my ...

jaymees_2-1708335245151.png jaymees_0-1708335124579.png jaymees_1-1708335204122.png
jaymees by 4 - Data Explorer
  • 2 replies
  • 1 kudos

Timeline Summary Variable Values

Is there a way to make a timeline's summary bar display different values over a given object's duration? I'm trying to make a map of the effort levels for various projects to forecast my team's workload at a given time (not using utilization because ...

paul-morrill by 5 - Automation Enthusiast
  • 0 replies
  • 0 kudos

Datetime format for an upload

I'm working on creating a .csv to upload time shift data into another management system. (I don't have control over it.) The datetime format it requires is YYYY-MM-DD, HH:MMa. Airtable is setup without the comma. I'm struggling to create a formula to...

User friendly Calendar field

Does airtable support a user-friendly calendar field? The calendar that I currently see on an interface is not too great. I need to keep clicking the back arrow to go to previous month. So if I want to go from the year 2023 to 2018, I need to keep cl...

cshenoy86 by 7 - App Architect
  • 2 replies
  • 0 kudos

Last modified time field updated with no evidence of how

We have a "Last modified time" field that updates when either of two other fields are changed. We discovered a group of records all modified on the same date and time (05/11/2023 at 12:50 PM) but when we opened each record to see the revision history...

Showing a range of time

Hi all! I have a base in which we create and track educational programs that we put together. I have a date and time field that shows when the program starts, and a date field that shows when the program ends. Some of our programs are mutli session o...

Limi by 6 - Interface Innovator
  • 0 replies
  • 0 kudos

Time Duration

Is there a way to create a time slot, similar to when you add a calendar a pop up appears and you can choose a date. I've aded a screenshot of what I've created, which is a single select option, But would like it to be more flexible. So, if you choos...

Screenshot 2023-08-31 at 15.31.10.png
Allan by 4 - Data Explorer
  • 0 replies
  • 0 kudos

Sign-up sheet

Hello- I watched this video but it's not clear to me what happens between minute 1:00 and 1;07. am looking to create a sign-up sheet for one day in 5 minute increments between the hours of 12:00 pm - 5:00 pm, and have 4...

CPMSM by 4 - Data Explorer
  • 1 replies
  • 0 kudos

"Local date", to who?

How can I set local to the date that every country uses, and not the America only one?

plinio by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Date mismatch

Hi all,I've got a table of dates called "Possible event dates" that gets linked to other columns including "Dates table" as shown below.The problem is that the link seems to be setting the time back an hour, as though they were set to different time ...

Screenshot 2023-06-23 at 22.35.11.png
Matt_Guy by 5 - Automation Enthusiast
  • 1 replies
  • 0 kudos

Resolved! Adding a Date

So, I'm trying to add a day to the columns, but I need it to add exponentially... if you know what I mean.  It would be nice if we could click and drag like in sheets with this stuff. 


Create a database comparing multiple entities across time?

Hello,I'm trying to design a database that can accomplish the following:Aggregate data across several different entities (for example, cities).Aggregate data for each entity across different time periods (for example, years).Aggregate data for each e...

cmm2012 by 4 - Data Explorer
  • 0 replies
  • 0 kudos

Resolved! Capturing timezones

Hi,I have an airtable database that captures information from a tally form.One of the fields in the database is date created which is a formula and is the date when the form was filled in.Anyone can fill the form and I want to capture the time zone o...

jackline by 6 - Interface Innovator
  • 3 replies
  • 0 kudos

Timeline: 24-hour time format?

Hello,Is there a way to change the time format from a 12-hour to a 24-hour time format for the timeline view (as well as the interface element)?The calendar view seems to do it automatically, however, I can't find a setting or any info on the support...

DiscoBreak by 4 - Data Explorer
  • 2 replies
  • 1 kudos

Creating date range from Google calendar

Hi,I've built a team utilisation and created a timeline that allows me to see how I have committed my resources across different projects. As part of this utilisation, I have a table where I can log days off for each team member. Currently, I enter t...