Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Forum Posts

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
  • 3 replies
  • 4 kudos

Filtering by Look up field

Hey all!So I am having a small issue with a report system I am trying to create. I have created everything but I am just not able to filter by dates. Let me give you some context below:The report layout looks like this, I am dragging information from...

Diego34 by 4 - Data Explorer
  • 6 replies
  • 3 kudos

Resolved! Converting string to duration field (text to seconds)

From a look-up field array, I’m extracting a duration h:mm, which I’m trying to convert to a duration field. The time comes out alright in a human readable format, e.g. 2:59, 4:24, 6:00, but I’m struggling to convert the string into a duration format...

Ricardo by 7 - App Architect
  • 14 replies
  • 5 kudos

Select timezone for each record

Hello, I’ve got a table set up which is to hold flight data. So I have airport from, to and date/time fields. I would like to have the timezone listed in the time field as it is always local to the origin or destination. Is this possible? When I sele...

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

Date Picker Mobile App iPhone - No (Year Picker)

Hello All, I am using a iPhone mini 12 on the latest iOS 16.1.1 When using {Date Field} on a mobile device and clicking in that field the date picker shows up in Rolodex form. Weekday,Month,Date,Time. However when rolling forward passed the new year ...

Formatting opening and closing times

Hi again! im trying to add opening and closing times to each record - so they sync with softr… i figured the best way is to create a field for each day of the week and have a drop menu for every hour and assign to each record. However this info doesn...

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

Allocating different events for different days of the week

Hi, im trying to build a website with the help of Airbase (using I have a list of companies in my table. How would i format the data so that: i can display opening daysi can display specific events that business have on… for example - a bu...

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

Resolved! Creating a visible deadline on records

Hello! I was wondering is there a way to do what this screenshot shows with a formula? I want to use the output of that formula to update an automation to change a single select field to show when the project is due. We can’t use the color feature a...

Nathan_Ramey by 6 - Interface Innovator
  • 2 replies
  • 0 kudos

Nested conditions

i have a table called MetonicAppFileK which a number of fields including today’s date, which ive called GregDate. One of the fields in the table shows the Metonic Year for each day called MetNo. i would like to select records based on the value of ...

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

Resolved! Date off by one day when using pre-filled app

Hello - I am using the amazing pre-filled form extension by @kuovonne to pull form data entered into one table that is then updated with a pre-filled form. The only issue I am having is the date field from the original entry is moved back by one day ...

SaS_AT by 5 - Automation Enthusiast
  • 5 replies
  • 2 kudos

Upcoming Birthday Notification

I’m creating an employee directory and I’d like to have a record (cell) display an emoji or change colors one week before that person’s birthday. Has anyone figured out how to do that?

Evan_Pitchie by 5 - Automation Enthusiast
  • 36 replies
  • 18 kudos

DateTime add is not working correctly

Here’s all the info: The formula is subtracting time when it should be adding time. Here’s the beginning time settings Here’s the formula settings It should be adding one hour to the time, but instead it’s subtracting 7 hours. Any help would be gr...

Upcoming Birthday Email

To preface, I am completely new to Airtable, and get lost quickly in the formulas. I’ve been searching threads for over an hour, copying any formula I can find that relates, and not a single one has worked (“Sorry, there was a problem saving this fie...

Resolved! Future event form for specific datetimes

We host events that volunteers help to run. We have forms to let volunteers 1) create events and 2) choose events to help with on specific, future date-times (i.e. the only event times are Weds and Thurs 7-8pm). Form 1) needs an event date picker wit...

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

Resolved! Changes to date handling in scripts

A few months ago I received an email from descibing changes to handling of dates and timezones in scripting. Do I recall correctly? Can someone point me to the info it described? I’m still doing manual timezone adjustments i...

Peter_Borg by 6 - Interface Innovator
  • 5 replies
  • 2 kudos