Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Forum Posts

Incorrect data imported in date format

Hi, I'm facing an Issue with importing data into Airtable. I have date prepared in Google Sheets which I'm trying to import in 4 diffrent ways: just copying the range (data table) and pasting it, exporting the .csv file and trying to import it, expor...

Zrzut ekranu 2025-01-15 o 20.37.23.png

Default Time Zone

I have a form that is submitted daily by members of our team, and due to how the AirTable base was initially set up, it defaulted to GMT when our company is in EST, so when we default to 'todays' date, after 6pm EST it will jump to the next day. Is t...

mlandheer by 4 - Data Explorer
  • 236 Views
  • 1 replies
  • 0 kudos

Resolved! Date data mismatch error with link to another table

Im trying to use a field related to another table, the field is a date datatype which is in local format (DD/MM/YYYY) but the lookup tries to use another data forma (MM/DD/YYYY) so its not retrieving properly.Fecha de Facturación and Fecha (from anot...

rubenfarias_0-1736152882209.png rubenfarias_1-1736152926722.png rubenfarias_2-1736153016392.png
rubenfarias by 4 - Data Explorer
Solved
  • 287 Views
  • 2 replies
  • 1 kudos

how to consolidate linked dates to create a timeline view

Hi, I have a few tables for different marketing teams, and each team has their own campaigns and dates. Some campaigns have more than one date. I created a master integrated marketing plan where i pull in information from each marketing teams table. ...

Best practice for reports by Year, Month, Quarter

Hello,First of all, I apologize if I have duplicated this topic, but I couldn’t find the right answer.I’m trying to determine the best practice for organizing data and reporting for a workflow that I believe many others are dealing with.I have a tabl...

PeterJNCK by 6 - Interface Innovator
  • 525 Views
  • 3 replies
  • 0 kudos

Combining Monthly Prices Lists into Master Price List

I have monthly price lists that I'm looking to combine into a "master" combined price list.  The appended base provides 3 monthly price lists, along with a 4th table that exemplifies the desired output table.  In the "Combined Price List - Desired Ou...

Unute by 4 - Data Explorer
  • 440 Views
  • 1 replies
  • 0 kudos

Project Management and PTO Tracker

What does done look like? (The requirements I collected)My CEO is wanting me to build a base that ties project management and PTO together for better task/project orientation.1. This base should display all projects and tasks as well as the leads and...

JacobCH by 6 - Interface Innovator
  • 727 Views
  • 3 replies
  • 0 kudos

New records on mobile device close before completing

I am strongly considering moving to a more expensive plan, but here are two issues that are making me question whether or not it is worth it:1. Whenever we go to create a new record in our base on a mobile device it often closes the record automatica...

dukeh by 4 - Data Explorer
  • 314 Views
  • 0 replies
  • 0 kudos

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