Help
Other questions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Help with autopopulated dates and calender

I've figured out how to create a formula that outputs a date that Airtable understands as a date (rather than a string of data) and have it appear on a calendar BUT is there a way to be able to drag said  item across the calendar so the dates change ...

nasw95 by 4 - Data Explorer
  • 468 Views
  • 2 replies
  • 0 kudos

Resolved! Filter by a specific day of last month

I've set up a Table for recording my Staff working hours, moving from a paper system. Each day the staff member using a form, enters the date, name and number of hours worked, site location etc. When its time for payroll I want to create views that f...

sehenley by 5 - Automation Enthusiast
Solved
  • 761 Views
  • 3 replies
  • 2 kudos

Calendar sync - Timezones

In airtable, I've programmed a calendar with dates and times for specific events. The formula is as follows: IF({Override horaire cour 1}=0,IF(Ordre="1", DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Horaire c1h1}), DATETIME_PARSE(DATETIM...

abbi by 4 - Data Explorer
  • 868 Views
  • 0 replies
  • 0 kudos

Calendar view

Hi, I am a new Airtable user and I have a problem with the display of data in Calendar view: the date of today is wrong and tasks are scheduled one day before the defined date (see attachment). If I login on the phone the dates in Calendar view are c...

crdbasile by 5 - Automation Enthusiast
  • 1358 Views
  • 4 replies
  • 1 kudos

Grouping and sorting issue - by date

Hi - I’m running into a problem when I try to group a list of events. The dates are from Dec. 21 up to Dec. 22 and I’ve one column witha formula that extracts the month from the date column. I can sort my table by the date field and it’s all fine, bu...

rbrauns by 4 - Data Explorer
  • 2469 Views
  • 2 replies
  • 2 kudos

TODAY() reports wrong date

Sheet here: (can’t post due to new user) Column 1 is “Date” type with the time field disabled. Column 2 is “Formula” type: IF({Due Date} != "", {Due Date}, TODAY()) On row 2, if {Due Date} is empty, it automatically fills today’s date, ie, November 5...

Add multiple records into one field/entry?

Greetings! I am trying to figure out the best way to add dates/times of different candidates spoken to for interviews. Ideally, I would like to have one project line entered and then be able to click on the project to see which candidates were interv...

Amanda13 by 4 - Data Explorer
  • 584 Views
  • 3 replies
  • 1 kudos

Timezone not working correctly

I'm currently in Seoul, South Korea. I'm working with a partner based in NYC. I'm looking to set the timezone of specific fields to EDT as this team needs to automate workflows for the upcoming [tomorrow]'s day's work. I failed to post this last nigh...

cowboyjim by 4 - Data Explorer
  • 411 Views
  • 1 replies
  • 0 kudos

Resolved! Created date time field and imported data

I have built an Airtable structure that utilizes the Created date/time field type to track when a record is added. This Airtable solution will replace an Excel version of the same data. The Excel version contains 2 years worth of data with it’s own c...

Scott_Callery by 6 - Interface Innovator
Solved
  • 3828 Views
  • 4 replies
  • 6 kudos