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...
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...
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...
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...
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...
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 ...
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...
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...
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...
Context: I'm working on an Animated TV Show and have made a Base for tracking the Production. The main function so far has been tracking all of the various Meetings/Milestones/Working Periods that happen within a certain Department. I also have a ...
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}...
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...
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...
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 ...
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...
Hello, Recently I have got an excel with information about customers and their ordered products and quantities.I have added all the tables and fields in order to turn this information into airtable orders with line items.Is there a way to automate th...
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 ...
Hi I have user information in 2 different tables but in both I have a field with the user email that could be used as a linking field. I would like to set an automation to update a specific field from table B into table A using the email as a matchin...
Hi all,I have a problem that feels like it should be simple but is giving me a huge headache, lol. Here are some past questions I found that seem to intersect, but I couldn't seem to find my answer in the replies: 1, 2 I replicated my problem in a sa...
Hello AirTable Community,Im somewhat new to Airtable and I am currently facing a challenge in building an effective inventory base in Airtable, specifically when it comes to linking multiple promo products into one product and properly managing the i...
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
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
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
Hi all! I’m Stephanie, product marketer at Airtable and I'm so excited to introduce some powerful new features to help teams build AI-powered apps on top of shared data—all within a single, scalable ...
Announcements
