Help

Welcome to the Airtable Community!

53567members
126754posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Conditional Formula (IF & AND)

I'm trying to set up a formula and could use some help. The first part is simple and is working: IF(Actuals <= {Approved/Expected Amount}," On Track"," Over Budget") However I would like it to provide a different result ("Profit") if the Type of reco...

  • 1 Views
  • 0 replies
  • 0 kudos

When a record is created create a record only is value is unique

Hi there,I have a form that captures emailHere is an example of what the data could look likeI'm trying to create an automation such that any time a unique email is entered, data is populated here. In the table above you see that ethan@abc.com is ent...

ethang_0-1685633493366.png ethang_1-1685633521792.png ethang_2-1685633557770.png
  • 10 Views
  • 1 replies
  • 0 kudos

rollup count values

I have 2 tables where I am trying to count the number of times project date changed. Table 1     ID Project Name Created DateChange Code  1Project 13/2/2022Project Date Change 2Project 23/2/2022Project Date Change 3Project 33/2/2022Project Date Chang...

  • 23 Views
  • 3 replies
  • 0 kudos

Formula to find the first instance of a meeting between two people

Hello!I have a table of clients, each of whom has been assigned a coach.I have a second table of appointments which is coming from Acuity. In that table, I have the clients linked so I can see all of the client's meetings with anyone in our company.W...

  • 14 Views
  • 1 replies
  • 0 kudos

Resolved! How to calculate a Date plus/minus X days

Hello, I am looking for a way to calculate a date minus x days based on a date field. I.e. the result should be 31.12.2023 (DD.MM.YYYY) minus 10 days = 21.12.2023. How can I do this? I tried to use this formula, but it returned an error:  DATETIME_FO...

  • 25 Views
  • 1 replies
  • 0 kudos

Updating an existing record through a form- a few issues

I have a table (Table #1) in which we keep upcoming events, along with their dates, topic, marketing content etc. I created a mirror table (Table #2) with the same fields. Table #2 has a form our staff uses when they need to update any of the events ...

  • 14 Views
  • 1 replies
  • 0 kudos
Limi by 5 - Automation Enthusiast

Parent date to another start date

I have a very simple example.Is there a way to make it so if I move A's start date, B will also follow along?B cannot be a formula, because I want the user to still be able to move it independently. Is there a native way to do this without automation...

jlabbe_0-1685617063299.png jlabbe_1-1685617102456.png jlabbe_2-1685617242044.png
  • 14 Views
  • 1 replies
  • 0 kudos

Display changes: Timeline

Hi, A few days ago, the display of the timeline records has changed. While previously the details of the records were limited to the strip of the entry, now they go beyond that (see screenshots). The timeline thus loses a lot of clarity, which is ess...

  • 41 Views
  • 3 replies
  • 0 kudos

When form is submitted, update record in another table?

I have a set of records that are connected for our market garden. One is a "Bed history" table that keeps track of all events that happen in a garden bed. One of these events is "transplanting.""Transplanting" is linked to another set of records call...

oreocereus_0-1685607746124.png oreocereus_1-1685607764852.png oreocereus_2-1685607805843.png
  • 16 Views
  • 1 replies
  • 0 kudos

Automate tick box and Your result type is not a number or a date.

Hello,So currently, we do have a tick box on this view and manually tick it once it is the latest valuation.Do you have any ideas on how can I automate this? without doing the manual ticking?Another issue, I created this formula : IF({latestVal Date}...

Screenshot 2023-06-01 at 12.45.00 PM.png Screenshot 2023-06-01 at 12.47.30 PM.png Screenshot 2023-06-01 at 12.49.51 PM.png
  • 67 Views
  • 4 replies
  • 0 kudos

Trigger to update all records in a table

I want to be able to send SMS and emails to a group of attendees of a workshop in bulk via Zapier. It seems that the best way to do it would be to use the "when a record in Airtable is updated" action but I don't want to have to update each record in...

  • 35 Views
  • 4 replies
  • 0 kudos

Boolean search inside attachments - 2023 update?

Hi Folks,We have one or more attachments (pdf, docx mostly) per record, and want to run a Boolean search on the content of these documents. This is similar to how you can search in Google Drive, Dropbox etc.@kuovonne I saw some of your suggested work...

  • 56 Views
  • 2 replies
  • 0 kudos

Creating Goals by Increasing a Number by a Set Percentage

I am trying to generate sales goals in a formula, I have a column with the previous years result (manually entered), I have a % column with my growth target but I cannot figure out how to create a column with a formula that takes the previous result ...

Screenshot 2023-05-31 at 9.20.14 PM.png
  • 35 Views
  • 1 replies
  • 0 kudos

Calculating Due Dates

Hello!I am creating a list of tasks that need due dates assigned using the following conditions:1. Each task is due one day after the previous task is due (note: dependencies would be nice to have but not necessary)2. The tasks are never due on Frida...

  • 142 Views
  • 1 replies
  • 0 kudos

Multiple forms on same page with single submit button?

I have a form for our market garden, which the user inputs information for direct seeding a bed. Each record is the date+crop, and keeps information on how much seed was used, how it was sown and such.There is a repeating automation, for if the user ...

oreocereus_1-1685567150878.png
  • 56 Views
  • 4 replies
  • 0 kudos

Announcements

New: Improvements to Timeline View

Hello everyone, I'm a product designer at Airtable. This quarter, our team is working on a number of improvements to Timeline view based on all the feedback we've heard (much of that from the communit...

Announcements

Community Change Maker: John Smith

This month we spoke with John Smith from Alamo Drafthouse Cinema. Alamo Drafthouse is a superior cinema and dining experience founded in Austin, Texas with ~40 locations throughout the U.S. John is cu...

Announcements

Airtable Top Contributors | April 2023

Welcome to April’s edition of our Top Contributors post! We’re excited to highlight the top contributors in the Airtable Community who have gone above and beyond to help others learn and grow their sk...

Announcements