Help

Welcome to the Airtable Community!

64523members
149669posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Automation passes test but doesn't work IRL

Hi there,I have this automation I have built and it looks right to me and passes the test. The test data populates in the destination table. But when I manually enter data into the source table nothing happens.Here is the automation: This is the dest...

Screenshot 2024-05-23 at 5.20.30 PM.png Screenshot 2024-05-23 at 5.12.13 PM.png Screenshot 2024-05-23 at 5.13.05 PM.png
  • 4 Views
  • 0 replies
  • 0 kudos

Linking tables using automation

I am simply trying to connect to the information from one table to another table automatically using automation. Every time I try it it comes up with errors. I have tried using the record id formula to connect them (they dont match between tables). I...

Screenshot 2024-05-23 164231.png
  • 20 Views
  • 0 replies
  • 0 kudos

Duration Data Not Importing Correctly

Hi,I'm trying to import duration data from a CSV (e.g., "2:52:32" meaning 2 hours, 52 min, 32 sec). The Airtable  Duration field is set up correctly (I think?) with the h:mm:ss time format selected. I want to keep it as a duration field so I can calc...

  • 24 Views
  • 0 replies
  • 0 kudos

How to convert formula from Excel to Airtable

I have an Excel formula I'd like to replicate in Airtable.This formula converts different currencies into GBP.Excel:=IF(M2+(N2/1.25)+(O2/1.2)+(P2/8.75)=0,"",M2+(N2/1.25)+(O2/1.2)+(P2/8.75))Key:£ GBP$ USD€ EUR¥ CNYM2N2O2P2How would I go about it? 

  • 37 Views
  • 1 replies
  • 0 kudos

Extra Blank Record Shows Up in Column of Synced Tab

Hello! I have a rollup column that looks fine in the original base, but when synced to another base some of the cells seems to add extra information.For example, in the original base, a cell in the column will say "Person A, Person B"In the synced ba...

  • 35 Views
  • 0 replies
  • 0 kudos

Resolved! How to calculate word count into TRT

I am trying to take the word count of a book (ex: 100,000 words)divide that by 9,300 (which is how many words an average narrator can read per hour)to come out with the actual time in HH:MM format. This is the formula I have currently and how it turn...

Screenshot 2024-05-23 at 12.43.29 PM.png Screenshot 2024-05-23 at 12.44.05 PM.png
  • 37 Views
  • 4 replies
  • 0 kudos

Send single Google Calendar entry to Airtable Calendar.

We have a single Airtable group calendar for 15 staff members.  When a staff member receives a calendar invite from a third party, when they accept, it adds it to a Googe Calendar. I know I could do a full integration but for several reasons, we do n...

  • 35 Views
  • 1 replies
  • 0 kudos

Linking Records in the same column

As you can see in the attached file, I want to Create a link between anchor campaigns and other campaigns from the same column. Anchor campaigns are the “major” campaigns happening throughout the year and all other campaign types are “subcampaigns”. ...

  • 36 Views
  • 0 replies
  • 0 kudos

Resolved! Limit the choices for Single Select field in Interface Form

Is it possible to limit the options for a single select field in an interface form? i can definitely do this in a regular airtable form. but i can't seem to figure out the way to do this in an interface form.example: single select fieldOption 1Option...

  • 40 Views
  • 2 replies
  • 0 kudos

Announcements

Expanded Support for Dynamic Filters

Hi there! I’m Rosalind – a product marketing manager at Airtable focused on helping teams build powerful, custom applications that make work more efficient. Today I’m happy to share more details on th...

Announcements

New Project Management Features Added

Hi there! I’m Rosalind – a product marketing manager at Airtable focused on helping teams build powerful, custom applications that make work more efficient. Building on our project management-focused ...

Announcements

Introducing Our AI Ambassadors User Group!

Hi Airtable Community,We're thrilled to introduce a new addition to our community: the AI Ambassadors User Group! This group is tailor-made for individuals who are passionate about Airtable AI and its...

Announcements