Help

Welcome to the Airtable Community!

51808members
122602posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Advanced Formula Help: Compare text from 2 lists

Goal: Create a list of email addresses that Accepted a Google Calendar Invite, a list of people that Declined, and a list of people that NeedAction.My Data: I have 2 text fields with my data, called "All Emails" and "Attendee Status" (grabbed via Zap...

  • 10 Views
  • 0 replies
  • 0 kudos

Navigate My Profile Page

Your public community profile is where Airtable community members can see the information that you have chosen to share, your community rank & stats, as well as your posts & replies. Keep your profile up to date so members of the community can get t...

ChrisShernaman_1-1680307994798.png
  • 13 Views
  • 0 replies
  • 0 kudos

Page Designer - Flow info through 2 columns

Hey all! Working on making Page Designer work hard to create the thing I need A couple of limitations I have run into that I haven't found a workaround for yet:1) Flowthrough to another column. Currently I have this list of information:But I want to...

Shannon_Bradley_0-1680301938530.png Shannon_Bradley_1-1680302214720.png Shannon_Bradley_2-1680302414056.png
  • 13 Views
  • 0 replies
  • 0 kudos

Nested IF with MAX formula, comparing dates

Hello!Pulled up a list of three dates from a linked table.  In this table, there is a separate date on each record.  Looking for a way to find the latest of the three dates, that is not later than the separate date in the record.  I can find the last...

  • 29 Views
  • 1 replies
  • 1 kudos

Struggling with AND vs OR in my formula

Hi All, I could use a little insight into what's wrong with my formula.It's scripted in my API, using Airtable.js with Next.js.The following works with only the second two fields, which are multi-select, but ignores (or seems to ignore) the text inpu...

  • 48 Views
  • 4 replies
  • 0 kudos

Skipping empty fields in a naming formula

I work in a digital archive and I'm using Concatenate to create a unique naming formula based on certain fields in a spreadsheet. However, some items have different naming requirements. What I would like to do is be able to tell this formula to skip ...

  • 20 Views
  • 1 replies
  • 0 kudos

Resolved! Pairing two records together before linking to another record

I am trying to set up a database of past video shoots, including who worked on them and what position they worked as. I have a table of people, a table of positions (director, cinematographer, producer, audio, makeup, etc), and a table of projects. T...

  • 51 Views
  • 5 replies
  • 0 kudos

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

  • 22 Views
  • 0 replies
  • 0 kudos

Script: Conditional Parent-child Record Creation

I've created a script that creates child records in a child table linked to parent records in a parent table through a linked field. It creates a set number of child records per parent record, if a set field in the parent record meets the conditions,...

  • 22 Views
  • 0 replies
  • 0 kudos

List View hierarchy feels backwards

I'm building a Project tracker with the following tables:Projects / Tasks  / Sub TasksI'd like to add a list view on the Projects table which would show the Projects > Tasks  > Sub Tasks in that order. But it looks like I have to put the List view on...

  • 52 Views
  • 2 replies
  • 0 kudos
BobH by 5 - Automation Enthusiast

Why does my DATE_FORMAT give an error?

I'm having a rollup field which is giving me the latest logged date from another linked table. The rollupfield is used in formular fields where it needs to show the date inserted into some text, but no matter what I do it gives me an error when I use...

Screenshot 2023-03-31 at 08.59.18.png
  • 25 Views
  • 1 replies
  • 0 kudos

Announcements

Question of the Week!

Hello Airtable Community! Time for question of the week  Be sure to share your ideas in the thread below. We will be sending swag to 3 lucky individuals. This week we want to know what are your tips ...

Announcements

New: Record templates

Hi everyone! I'm Helen, a Product Manager here at Airtable and I'm very excited to announce that we're launching the new Record Templates feature to all Pro and Enterprise users.This feature enables y...

Announcements

Question of the Week!

Hope everyone is having a great week! It was awesome to see the engagement from last week's post about replacing unnecessary tools with Airtable. Shout outs to @Jack_Manuel, @ramonscardua & @Tobias_LG...

Announcements

Question of the Week!

Hope everyone is having a great week! It was fun reading through best practices from last week's question. Special shout out to @Tobias_LGKR for sharing an innovative idea around a "change log functio...

Announcements