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

Forum Posts

Creating or using fuzzy or wildcard dates

I want to create a field or use a field that will allow me to create "fuzzy dates".  I'm in a business where I want to create records containing a date field.  But, the date field sometimes needs to be flexible.  Sometimes, I know an exact date, like...

Resolved! Help with creating a particular view

Hello! I currently am using Make to funnel in data from a webhook and then create a record in airtable. My goal currently is to be able to display Events per hour for each day of the week, I am essentially trying to recreate the table in the screensh...

Screenshot 2024-07-05 at 12.08.48 PM.png
LudusLart by 4 - Data Explorer
  • 5 replies
  • 1 kudos

Timezone problem

Time zones are difficult to handle within AirTable. Here is an example that gives me a headache. I have a table (let's call this table Calendar) in which there is, among other things, a Date Field associated with an event occurring at a Location. Str...

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
  • 1 replies
  • 0 kudos

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...