Ask the Community

Hello Airtable Community!I'm looking to enhance my tables and I believe using scripts could be a helpful solution.Here's the issue: I have a database where company managers provide monthly forecasts for income and costs on their respective projects. Currently, I've set up an Airtable automation that detects the start of a new project and adds a record to the managers' table.However, I have a gap: when a project is completed, I want Airtable to lock in all the data entered up to and including the project's end date, and then remove any predictions made after that date. Does anyone have a solution for achieving this? Your assistance would be greatly appreciated!

We have built an automation that syncs data from our CRM with Airtable. Each insert/update/delete in the CRM post a message to a webhook created from an Automation. This works perfectly fine for single transactions in the CRM but for a bulk update or an import in the CRM of e.g. 500 records it only processes a limited number of records (e.g. 168 out of 800). Is there a limitation in the number of instances of a script that can run in parallel? And if so, is there a way in Airtable to work around this as I have no idea to buffer the webhooks coming in.

I have two tables: one called companies and one called candidates.  I'm creating a form for candidates to fill out which will add them to the candidate table.  One of the questions on the form is "where do you live?".  I want to match them with companies that are in their same city, so I want the company locations I have in my companies table to be the options for the "where do you live" list in the candidate form.  Is there a way to sync these up?  I tried linking the record, but I get a message saying "this is read only and won't appear on the form".  Ideally I want new locations to be automatically added to the candidate form when I add a new company with a new location.  

"I am conducting research to monitor the depression status of patients. It's crucial that I track their status on a weekly basis. Consequently, I am looking to set up a reminder calendar to facilitate this. I've utilized the provided formula to determine follow-up dates, but Airtable suggests that the outcome isn't recognized as a date format. This has hindered my efforts to create a calendar using the results. I would greatly appreciate any advice on this matter. Thank you!"   IF(    {First visit},    DATETIME_FORMAT(        DATEADD({First visit},1, 'weeks'),

Hi all!So I've read quite a lot of articles in here and I can't find what I am looking for.  I created 4 tables in my base :Activités (Activities)Tâches (Tasks)Sous-tâches (Subtasks)To Do'sHere's how my base works : In Activités, all our shows are listed and gets one of the following statuses (Confirmé / Option / Supplémentaire)Tâches contains our main tasks and Sous-tâches contains the subtasks. Both are linked.To Do's, would be used to create the lists of tasks. There is a link to the table Activités.Base on these informations, here's what I would like to achieve by using an automation :In Activités, when an activity with the status Option or Supplémentaire gets the status Confirmé and therefore enters the view ''Représentations confirmées'', create a list of subtasks to complete in the ta

In our organization there is some of the user that can not log in. there was no problem for them the other week but suddenly they couldn´t  Can you give me a tip what to do

Say I have a table in which each record has a Single Line Text "Notes" field with content like this:MondayGood FridayTuesdayTaco TuesdayGood FridayTuesdayI want to find all records where the Notes have exact matches, in this case for Good Friday and Tuesday, and display them together.I figured I'd have to add a field to check for uniqueness somehow and then filter for non-unique records, but I'm not sure how to do this. 

Have you had any experience with Airtable Partner Portal? How long did you wait for a response to your application? 

I have a table of date ranges: school terms and holidays over three years.How do I determine which range a specific date occurs within?

Hi,Is anyone else experiencing views not currently loading within their database?We have multiple users reporting seeing a error message "Loading this view...This view may be loading slowly due to a large number of records or fields". Some users are experiencing load times of 20 minutes. Looking into the account the record and storage limits are no where near capacity.The offices internet speed is fast and all other web based platforms are working. Any insight here would be appreciated.

For the last 2 to 3 days, we have found Airtable almost unusable. Very slow and advanced functions won’t load at all. Any solutions appreciated

I want to start with the important fact that I do not know javascript so I need to be able to do this within the automations manager in Airtable. I have a simple base that has contacts with certain categories. I want Airtable to email me once a week with the names of any contacts still in that category.For example, John Smith and Wade Wilson might have "needs follow up" in the Status field. I would like Airtable to email me once a week to list out the people in "needs follow up" under Status. It can be an email that just lists their names. I have read the forums here and googled and I cant' figure out how to do that. 

Helo there, we have an online Online Language School, we use airtable as our database system.I have Student, Teachers and LessonPlan tables. LessonPlan has Student and Teacher pairs.We pay them for each lesson they taught monthly.  I would like to create a table called TeacherPayments to see Teacher-MonthYear pairs as below.How can I create this table so that I can see "HowManyLessons" calculated automatically each month?  

Very simple, but I couldn’t seem to find it anywhere. I have a “date contacted” date field, and a “follow up” date field. I want the “follow up” date field to automatically populate a date that is one week out. Any help would be greatly appreciated!

Hi, I'm working on a way to consolidate a base used for a diaper program. We're a nonprofit and need to track for many different reasons, but our current process is long and requires toggling from table to form to table. Here's what we're doing (all are in separate tables):Entering donation inventory via form (an individual count of diapers, wipes and formula)Receiving requests via formReviewing the requests and inventorying out the items via form (linked to step 1)Here's what I'd like to do:Inventory donations via form (needed because amount spent is required for tax purposes)Link the request and inventory out form to subtract from inventoried donationsIs it possible to deduct (2) items at once or do we have to inventory out each item to properly subtract?Essentially, all three tables would be linked together with the inventory out and request forms "combined" to avoid exiting the table w

I'd like to get a slack message whenever an automation run fails, but I don't see any native functionality for this. Has anyone found a workaround to get this done? Thanks!

I'm using the formula below to calculate the date difference between the day a position was opened to today (tracking number of days the position is open until filled). Is there a way to override that formula if the Position Status is listed as Filled or to make the formula only run on Positions with the status as Open. I don't want the running count of days once the job is filled, but don't want to lose the data point of the day it was opened.DATETIME_DIFF(TODAY(),({Open Date}), 'days')

Please could number formatting options be implemented? At minimum, I would expect to be able to set decimal places and use of thousands comma. Even better would be to add currency symbols.

Hello,I'm wanting to take the timesheets we built out in airtable and create a dashboard in the Interface Designer for each member of the team so they can see an overview of their time, over under etc.I can't for the life of me seem to find anyone having a template or having written about one - so basically if anyone has anything they can share - it would be much appreciated!

Hello! Looking for some help organizing a dataset that isn't importing from an Excel file as intended. As you can see in the picture below, the primary fields are spaced out, separated by extra rows made for each "Regulation" data point. For example, all the "Regulation" data points from "FDA Guidance 2001i" to "OECD GLP No. 13iii" should be merged into one multiple select field for the BAV 1.0 record. Similar for BAV 2.0, "21 CFR 320.29" and "FDA Guidance 2001" should not be split into two rows, but merged into the same "Regulation" multiple select field.Looking for a way to automate or at least quickly go through this data set merging these extra records. Thank you!! 

Hi there,I am trying to set up an OKR table in Airtable.  I have two tables in my workspace.  One for Key Results and one for Initiatives.  Under initiatives I have a column with tasks just check off as they occur.  Please see below.  How do I create a column with a formula that will calculate the % completed based on the check marks listed in the task column.  I have tried to create the formula with creating additional columns (total task count and total task count completed to calculate off of but that didn't work).  I used the "countall tasks" in the total task column and tried to create a formula in the total task count but it isn't working.  Any guidance would be greatly appreciated.     

Hi Airtable Community!I want to be able to send an email if 7 days has passed since they last received an email.I have set a date field in my database to be populated with today's date when an email is sent from my automations.I now want to create another field that includes a "1" if today's date is greater than 7 days, or "0" if not.I can then trigger future emails if a "1" is present in the field.I'm nearly there with this formula (see attached).IF(TODAY()-{Last Contact Date}>7,"1","0") Does anyone know what I'm missing please?Thanks,Gavin

I created a "lookup from another field" field, and set it up to pull 4 other fields from another table. It pulls the first field just fine, but then does NOT pull the other 3 for no apparent reason and it's driving me crazy haha. The field I'm using to test DOES have values in those 3 fields to pull, so that's not why. I don't get it. 

Hi Thanks for taking a look at this. This seems a simple question but I can’t work out the best approach. I want to be able to choose the country where a company is located. More specifically I want a user to be able to choose from a list of companies in a TypeForm and then connect the form to an AT table. Adding 200 countries to a single select field in AT seems not the right way to do it but putting them in a separate table means Typeform will not be able to send the data to AT. [Why do I say this: (1) because I can find no way to copy and paste a list of options into a AT Single Select field (2) the AT-Typeform integration is very pernickety in relation to exact match of options] Thanks

Hello! I am trying to figure out a way to link 1 column of records to multiple tables. For example, I have a master list of students on one table and have additional tables of info that I would like to link to the master list so that when I add or delete a student on the master list, it adds or deletes that record on all of the other tables. Is there a way to do this?