Ask the Community

I have a warning that my file is over the limit of 1,000 records per base, but it only has 531 records.The warning says it has 1145 records. There is no filter applied, it only has 531 records!Nothing else is over the limit.

Hey all, sorry this topic sort of covers not only bases, but also interfaces so forgive me.We have a few itemsCourses that have a field of "Who Can Teach", this field is populated from a linked fieldThat linked field is currently derived from a synced table, Staff.  Another base has scheduling of clients, that uses the Main Instructor field to schedule an instructor.The idea is:When someone schedules a specific course, the Main Instructor field will only show instructors that have been "assigned' or elected that they can teach said course.  We use emails as a keyid across the bases, so it can't be a lookup for per se as certain automations don't work well with lookups along with other reasons lookups aren't always useful.  They have to be able to be selected by someone, and not just a list.Then there is the idea of an interface for the instructors to add themselves to a list of courses.  We have

Hello! I'm slowly learning how to use date formulas, but I have hit a wall in my ability to troubleshoot.I have two date formulas causing me trouble.1) My Rush Due Date is displaying #ERROR! when "Rush" checkbox is not checked.DATETIME_FORMAT(IF(Rush, WORKDAY(Created, 4, '2023-11-11, 2023-12-25, 2024-01-01, 2024-02-19, 2024-03-29, 2024-05-20'), ""), 'LL')2) My "Time Since Ready for Pickup" formula is displaying NaN when a row is not yet "Ready for Pickup"IF(Completed, "Completed", DATETIME

Hi everyone, I searched through the community posts but could not find anything.Using a formula I created custom URL for every person in our company that will allow prefills in a form.CONCATENATE('https://airtable.com/appxxxx','?prefill_Your Name=',Name)for example 'https://airtable.com/appxxxx','?prefill_Your Name=',John Doe)Problem is that there are now blanks and therefore only the first part of link is recognised as such. I know that I can use %20 is used in the final URL. But this does not make the URL in my dataset clickableAnyone an idea what I would need to do?

On table A, I've added a linked record field to table B. On table A, I can add lookup fields from the linked record on table B.But on table B, I cannot add lookup fields:> No available sources to look up. Add a lookup source, then try to configure your lookup again.I created a new linked record field with the same configuration on table A and the lookup works both way. Is there a way to fix my original field to work both way too? 

Hello, I'm really enjoying building for the first time in Airtable but need some help creating a script (if that's the best approach).I have a form where users will put in 3 comma separated words to describe the Niche they work in.I want to turn this column into tags, so that I can group records by common Niche.My understanding is that I need to write a script to go inside an automation that fires when that field is not empty on a new record (when the form is filled in). And takes the text, parses it based on the commas and then adds it to my Tags column which is a multi-select field.I've tried using claude.ai and chatgpt to write the script portion but they're failing! I'm confident a real human can help me!cheersjonny

Hello, I published two templates on airtable universe some time ago but I’m now updating/improving these templates. I’ve published the changes I’ve made but I’m wondering, do users effectively subscribe to these changes or when they copy a base does this stay as it is? For example, if I add a table or a column to the template - then update the already published base - will those who have already copied the base into their own accounts see these changes? Thanks for your help!

I am using Airtable to track hours worked versus workable hours in a month to try and calculate how much overtime there was in a given month. The table below is correctly doing what I want where # Hours Worked is the number of hours a person logged in a given month for different tasks. Total Hours is work days including holidays, Total Work Hours is work days not including holidays. And Hours Worked - Holidays is self explanatory (we don't want to count holiday time towards comp time). Looking at the below screenshot, the comp time would be 1 hour (161-160). The problem is that I don't think you can make a formula that can do math with the summary types. I was trying to do rollups in a different tab but it wasn't working. In excel I would do a SUMIF function where the criteria is that Month = Sep 2023 and Resource = X and have it sum total work hours and another one summing hours worked - holiday so I can subtract them.I'm trying to do this by resource by month. D

Hi (newbie here),Can you do a rollup on a Lookup field in a different grid?I have a table of employees.  There is a table of Trips where we look up the employees from the employee table.  Then I have a Departures Table that pulls in the Employee information from the Trips table. Now I would like to do a count(rollup) of the number of departures each employee has.I am having problems figure out how do this.  Any help would be appreciated.

How can you publish specific Airtable info into a Google Slide? My team uses our base for project tracking and we want to publish specific information from Airtable to Google Slides or some other presentation format. What would be a visually appealling way to publish chosen Airtable info into a living presentation?

Hello,My sister operates a bakery from her home, and I want to make things easier for her by creating a system in Airtable where she can take orders for her products.As a bonus I'd like to be able to track repeat orders from customers as a way to determine customer preferences, habits, trends, etc.There are a few problems I'm finding with this. Airtable has no way for customers to "make an account" so to speak. I'm inclined to create a table for customers, but...Customers would need to complete a separate form if they're a new customer, then come back to the order form, which feels cumbersome.For each customer that already exists in the base, Airtable will reveal all of the names in the customer table whenever a returning customer begins to search for their name, which just doesn't sit right.We could simply request name and phone number each time, but I'm not sure if that will allow me to combine those records based on phone number

Hi All, I’m wondering what is the best way to calculate some basic counts on a table via the API. We need to calculate simple counts such as total records with a Status of “Fulfilled” and total records where Status is “Fulfilled” with where the Fulfilled Date is today (see excerpt below). I’ve written a Node Twilio function to retrieve the records and then loop through them and calculate which ones meet the criteria. We then use Zapier to retrieve this output from Twilio and put it into our Slack channel daily. However, as the table grows over 30,000 records, I’m running over the 10 second execution limit in Twilio. Is there a better way, or should I look for a different place to host my function not subject to the 10 second limit? let metrics = { matchedToday: 0, fulfilledToday: 0, fulfilledTotal: 0, }; base("Master Intake") .select({ fields: ["Status", "# to feed", "Created Date", "Fulfilled Date"], cellFormat: "string", timeZone: "Americ

Hello there,I'm not being able to create nor duplicate a record and I've try restarting, deleting cache, logout and login... simply I cannot do it.Thank you,Edson.

Having an issue where multiple paragraphs in AirTable are showing the same bullet point of 1. Rich text is enabled but it isn't working correctly (it shows up correctly in Make.com but doesn't transfer over from AirTable)Please help, thanks!

Hi All,I have an automation issue coming from a formula field.The lookup field is coming from Tasks table, and the regions are repetitive, so i created a formula to make it as a text and im hoping the automation will take the Regions Text to a normal editable field 'TASKS - Regions', but it updates it with a blank value in the end (the blue circle in the end). Im not sure why, but if someone can help me with this. the formula im using is:CONCATENATE(IF(FIND("KSA", {Regions (from Task Tracker)}), "KSA, "),IF(FIND("GCC", {Regions (from Task Tracker)}),

Hello everybody, I have a weird problem with a gmail automation. When testing the automation works perfectly. The automation looks for a field value that is greater than 4 and then the actions are run. When manually changing the a value in the record that is used for the automation to a value greater than 4 the automation also runs perfectly. But when the automation its run automatically I suddenly get the following error in the logs: It doesn’t make any sense that this automation suddenly throws errors when it is run automatically, but every other way of running it works fine. Also, when this same automation is run again manually it just works… Someone any idea what’s going on?

Hi community,I'd like to give two of the interface collaborators editor-level access.Will I be charged an additional subscription fee?

Hello,I have a formula field that is supposed to return a value ("updated") when a last-updated field is today.I live in another time zone, but all of my dates are set to Eastern time to reflect my working hours. Some of the posts I have read have said that a time zone error will produce this problem. To show that all time fields are set up for Eastern, I am including screenshots below. You can see that the last updated date/time is today (10/10), and the value of today is also 10/10.The formula field is not showing the value "updated." Here is the way the formula field is set up  Here is how the last

Hi,I have been using AirTable on a regular basis.  Yesterday I noticed that my chrome browser refused to go to the website (error was certificate not valid).  Upon inspection, I found that it is because, for some reasons, my browser has been redirected to a different website (web.remscripts.com) and it is this different website that has an invalid an invalid certificate. I tried a different browser (Firefox) and I did not have the same problem there.Do you know what happened? Is the website (or my computer) infected?Thanks!

Hi, I would like to know if there is a maximum number of automation that a base can have or if it can have infinite automations?  Thank you 😊

Hi! I've been trying for two weeks to create some automations with integromat but i can't find a solution, can someone explain me step-by-step the necessary integromato flow (i'm sorry but i haven't knowledge in the field).I have a two tables in Airtable, OR and RA. The two most important fields in OR are: Name and Surname, Machineries and Last Modified (Machineries is a multiple choice field). When i select one or more machineries in OR i would like that every single machine will be automatically saved in RA, each machine in a different row with the associated name and surname, so that i can save in each row the time the machine has started working and the time it stopped, in order to compound the utilization of the machine.Trying to do this process i incurred in many problems, when i deselect a machine from OR it does not delete the record from RA, but it duplicates the record of the remaining machines; when i select an extra machine the new machine is saved but the

Hi there, I’m a long term user of Trello and new to Airtable. Trello had a feature where you could forward emails to your board. I would have a to-do list board and whenever I got a request emailed to me I could just forward it to the board and it would create a to-do item for me. Does this function exist within Airtable? Thanks for your help.

I am trying to incorporate a formula column which looks for entries which may include swear words, but I cant seem to get this formula to work. Here is a snippet (I've taken out a lot of the middle which is just 3230 different swear words) but the beginning and end are there. Any ideas? IF((OR(SEARCH(“2 girls 1 cup”, ARRAYJOIN({Lower})) > 0, SEARCH(“2g1c”, ARRAYJOIN({Lower})) > 0, SEARCH(“4

Airtable sometimes mentions 5 requests per second per base rate limit and sometimes just 5 requests per second; see the links below.5 requests per second per base: https://airtable.com/developers/web/api/rate-limits5 requests per second: https://support.airtable.com/docs/de/managing-api-call-limits-in-airtable#understanding-rate-limitsCan someone from Airtable shed some light on what's going on and what's the reliable source?

Hello, I am starting with Airtable Scripting.I need to use the content of two cells as input text for a function that formats the text in a specific way.Using this way I only get the value of the first row [0], but this needs to work for every row. It is triggered once a row is added and/or modified.   if (record && record.records.length > 0) { const inputText1 = record.records[0].getCellValueAsString("Index"); // Replace with the actual field name const inputText2 = record.records[0].getCellValueAsString("Script"); // Replace with the actual field name // Combine the content of the two cells const inputText = inputText1 + "\n" + inputText2; const jsonOutput = convertToJSON(inputText, sentencesPerSection);​