Solved

This is kind of complicated and I’m not sure if it will be possible, but here goes. I’m trying to automate data entry for each record I create in my Project table. What I have set up now is a Long Text field called “Paste” where I paste the contents of an email, and several field agents that comb through the text of that email to fill out fields like Project Name, Project Type, Notes, etc. Each email contains the name of several people associated with the project’s production team: directors, writers, and producers. I have a separate table that is a Master Contact List of all the names that have ever been entered, and in my main Project table, I have a linked field called Production Team that links to the Master Contact List. Multiple linked records are allowed so that multiple people can be logged in that field in the Project table. Right now, I have to manually enter all the names. I would love for a field agent to be able to do this for me, but it would require several steps. First,

This one is a little convoluted and I can’t figure out where I’ve gone wrong. I have three tables - course list, participant list, and course completion status. I set up an automation so that when a participant is added to the linked field in course list, or a course is added to the linked field in the participants table, it creates a record in course completion with that information.What is happening is that the new record will do one of three things: it will link to the correct record in the course list, it will link to a different record in the course list, or it will create a new record in the course list. I actually need to make some changes to accommodate users who get future enrollments, but I want to get this working first.Here is the automation setup:When record enters a view in Participants table, create record in Course Completion Status table. The view is set to show only records in the Participants table where the Courses field is not empty.And the action settings:Course C

I’m trying to convert an Access database we use to track event and participant data to Airtable so that we can get away from Access and all of its downsides. What we have has always seemed pretty simple and straightforward, but I’m really struggling to create a similar situation in Airtable that isn’t so time consuming. What I have is two tables connected by a join table: Events is where I create records for each new event we host, with a unique number as the identifier, as it’s possible to have multiple events on the same day. Participants is where I create records for each new attendee who participates, and the unique identifier is their username. We have new events about every week, and new attendees is unpredictable. Participants may attend one event or many events, and the goal of the database is to track who comes to which events, to be able to pull data about the types of people who come to our events, and to offer transcripts of the events attended by attendees who may ask for

Hello! I’m trying to create an automation that allows me to add someone to a collaborator field without replacing any data that is already in the field. Is this possible? That is, if 3 people are already in the collaborator field and I want to add a fourth via an automation, can the fourth be added without removing the other 3 that are already in the field?

Hi everyone,I’m trying to create a line chart in Interface Designer that shows interest rates over time. My table structure is simple: Date (date field) Rate (percentage field) Type (single select) In the chart settings: I use Date for the X-axis, Rate for the Y-axis, And I apply a filter so that only records with a certain value in the Type field appear. However, I noticed that Airtable automatically applies an aggregation (e.g., average, sum, etc.) to the Y-axis values, and I can’t find a way to set it to “none.”Since each date in my table corresponds to exactly one record (no duplicates), I’d like the chart to simply plot the rate as-is, without aggregation.Is there a way to disable aggregation or make the chart use raw values for each record instead of aggregating them?Thanks in advance!

I understand there is an Admin panel available on the Business and Enterprise plans that looks like a one-stop-shop for organizing user settings/permissions, but that this is not available on the Teams plan. Isn’t there a way on the Teams plan to see all users in one place to see what they have permission to and at what level with the ability to edit the settings right there? Currently it seems like a disorganized mess as I have to go to each element to see who has what and frankly that’s not very clear. An Admin panel seems like database 101 and should be available to all paid plans. Am I missing the boat here? (I feel like I’m missing something obvious.) A specific question: In our workspace, under the Collaborators tab, it shows three users:Me - Workspace OwnerMy boss - Workspace EditorEmployee - Interface Editor Would this setting allow the employee to interact with the base itself, or do can they only see the interface (which is the goal)?

Hello Community,First post here. I am attempting to connect my Airtable to Power BI.I am receiving the following error message in Power BIExpression.Error: We cannot convert the value null to type Record.Details:Value=Type=[Type]I am following this guidance and using a Personal Access Token. I setup Power BI Parameters successfully but received the error code in the Query. I suspected that it may be the M Code so I followed a link to a GitHub resource for alternate code."If the above script seems to be causing an error, then please refer to this GitHub resource, as the code may have changed.I have tried both versions of the M code.I don't know enough about tracking down this error code. Any ideas of what it might be?All assistance is greatly appreciated.

So I’m looking to employ a formula to provide a word count for my SEO keyphrases, which range from 2 to 8 words. Below is the formula that I thought would work, but I’ve had no such luck…does anyone have any thoughts as to what’s going on here? Thank you in advance! IF(({Keyphrase}=BLANK()),0,(LEN({Keyphrase}) - LEN(SUBSTITUTE({Keyphrase},’ ', ‘ ’))+1))

Hi everybody,Our company has 3 x sized boxes - small medium large.We fit the following quantities of our product in each  box:Small - 95Medium - 200Large - 300What I want to do is tell a user how many boxes each order will use. I’ve achieved this with nested IFs:IF({quantity} <= {Small Box (from Link To Products)}, "1 x Small Box", IF({quantity} <= {Medium Box (from Link To Products)}, "1 x Medium Box", IF({quantity} <= {Large Box (from Link To Products)}, "1 x Large Box",ROUND({quantity}/{Large Box (from Link To Products)},2)&" x Large Boxes")))This works well. My only issue is with the last statement when orders exceed 1 x Large Box. With an order larger than the size of 1 x Large Box, it returns a decimal of large boxes e.g. “2.67 x Large Boxes”. My question relates to the deicmal  - I now want my formula to say whether that residual decimal would fir into a small box, medium box or round up to another full large box.I’m used to nested IFs going in one direction, but no

I am on the Free plan for now trying to make sure everything will work …. I’ve got a Find records and no matter what it only returns 10 records, even if I make the only condition where it should catch them all. For example the primary field of “Name” is not empty. Or switching to a View based and still the same result.Is the free account limited on the number of found records? or am I being a major bonehead on my action...

Hello! I’m having more difficulty than I’d like to replace text with a newline.In the Airtable Find & Replace extension script, I’ve modified it to support RegExp find and special character replace. However, when I replace the text with a special character like a newline, it always comes out in a literal text format.Here’s a real basic example of what I’m doing:let originalValue = record.getCellValue(field);let findText = "<br>";let replaceText = "\n";let newValue = originalValue.replace(findText, replaceText);Every time I view the replaced results, there is always a \n in the output: Is it possible to ensure that Airtable treats \n (I’m even doing \u{005C} to try to get around it and it doesn’t work) as an actual newline and not literally as “\n” ?

I’m building a self-referencing task dependency system in Airtable. Each task can list its Predecessors, the tasks that must be completed before it,  and I want Airtable to automatically display the corresponding Successors, the tasks that depend on it, without any code or automation.In short, I’m creating a two-way view of task relationships so that linking one side (Predecessors) automatically reveals the other side (Successors). So in the image attached, “Conduct internal briefing meeting” should show up as a successor in “Project set-up”. If anyone can help this would be amazing!

Hi. Thank you in advance, I am wondering if there is a way to show numbers with thousand/comma separator if you combine it with a text in a formula field using concatenate. My Amount field is in currency format. Current Formula: CONCATENATE(Amount, " ", {asking-currency})Much appreciated.   

Hi all, I have been struggling to figure out a way to solve this all day. I am wanting to track checked out laboratory media in an interface graph so that team members who create the media can see how much is being used per week. I’d like this to be automated for the previous week, but specifically Monday through Sunday of the previous week (so that you can check any day of the current week and the numbers would remain the same for the previous week). My plan for this was to set an automation trigger for early Monday morning, that then finds all records within the last 7 days (all checked out items have creation dates + times for the check-out record), and then marks them with a date for the previous week’s Monday, using the Update Record command (which would be found using a formula field consisting of DATEADD(NOW(), -7, 'days'), which will return the previous Monday (because the trigger to pull from this field is occurring Monday morning). The interface would then pull from values wi

I know this has been raised before as a feature request but is there a way to add a default value to a date field through automations or some other mechanism other than pleading airtable to implement or a third party add-on? Thanks in advance

Hi everyone, I’m currently testing the ai field agent’s capabilities for automatized tagging of records, but I’ve come across a limitation that I seek to overcome with your help: No centralized tag management. When using the field agent for direct ai tagging, I have not found any option to provide tags in a centralized way, similar to how you can do with linked fields for human tagging. There is the ai recommendation option integrated into the linked record field, but this does only add a recommendation for human usage. Is there a way to have it both? The centralized tagging table and ai field agent tagging? I’m considering injecting an accumulated list, of all entries in my tag table, into the prompt of a simple text ai field agent and have it output it’s selection as a list, which hopefully could be linked via automatization features.

Hi there,I'm facing this issue unfortunetly i checked on the community but none of the solutions work for me.This is the error: "type" Invalid_Offset_Value - The value of offset 100 is invalid.I'm trying to get 350 rows. I already did a first api call to get the first 100 rows, what i need is to continue with the second call.When i try this url https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome everything work fine, when i use the same URL adding the offset value, i get the error: https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome&offset=100What am i doing wrong? I can't work much on the code, i just can modify the URL. I've also tried to put the recordId instead of the "100" but i get the same reply. Hope you can help, thank you very much

Hi All, I’m trying to run this automation script that works perfectly on my test base of ~10 records but throws this error when I move it to my real base with ~1100 records. Error: Script exceeded execution time limit of 30 seconds The below code is based on this tutorial here, tweaked slightly with recommendations I found in another similar question. Any help or ideas would be appreciated! Learn Airtable scripting #1: basics & removing duplicates with Giovanni Briggs - YouTube (from Automate All the Things channel) var table = base.getTable(“Table 1”); var query = await table.selectRecordsAsync ({ fields: ["Name" ] }); console.log(query); let duplicates = query.records.filter((record)=>{ return query.records.find((potentialDuplicate)=>{ return record.getCellValue("Name") === potentialDuplicate.getCellValue("Name") && record.id !== potentialDuplicate.id; }) }); console.log(duplicates); let updates = duplicates.map(update => { return { "id":update.id,

Airtable is unable to load data.We are a company located in Korea. Currently, all accounts within the company are unable to load Airtable data.We need help from someone who knows about the current official maintenance schedule or the error.

I wanted to make a Siri Shortcut that lets me upload a screenshot to Airtable. In my Airtable I have these fields: Screenshot ID (autonumber) Screenshot attachment Descriptive text I got pretty far but either the webhook doesn’t allow images or I’m doing something wrong. I set up the shortcut to make the webhook request using the “Get contents of URL” command in shortcuts. Under “Request body” I selected “Form” and then told the shortcut to send the screenshot and some text to describe it. That seems to be the only way shortcuts allows files to be sent out, the other options are text only. When I test the integration in airtable, it works as long as I’m not trying to send an image. It fails when I test it because the test is sending text into an attachments field. When I run the shortcut with the image included, the api request fails & it says: Multipart upload was specified but is not supported When I run the shortcut as text only, it works and the descriptive text is insert

I’m currently on the Team Plan and building a survey using Interface Forms. However, I encountered an issue where I can no longer add more elements. The error message says:“Your change was reverted because your interface is too big. Try deleting some elements.”My form currently has 249 elements, and all of them are required for the survey — so deleting any of them isn’t an option.May I ask if there’s a way to increase the element limit or an alternative solution to accommodate more questions within the same Interface Form?Thank you in advance for your help!Best regards!

I cant load any of my Airtable pages other than the main Home page This error is showing too. Can anyone help on this?

I am using a Free account right now and have a fairly simple automation where every month, if a record as Due Date in the past, the Benefit Interval is 1 I want to update two fields. I want to update the Due Date to the next month, and change the Status to “Unused”. I have successfully tested and run this when there is a single record that meets the criteria however when there is more than one record it errors out. Here is the one that works.  However when two records meets the Find Records criteria and get the error “Received invalid inputs.” Works like a champ for a single record update, just not multiple 

Hi there ! 👋First of all english is not my mother langage, sorry if my english is not perfect.I'm working on a customer networking project.We have a multitude of tables, but there's no specific naming convention. they're table used by sales people, so not necessarily a tech culture. &#x1f605For example, in one table to determine which sales rep is the owner of a customer, the name is "owner", in another it's "Account Manager".To create a dashboard grouping together a multitude of information, I've decided to create join tables, as the information I group together will inevitably be useful elsewhere.Is it possible to add the "owner" and "Account Manager" information in the same column to this join table?In SQL, it's possible to do this with "virtual columns", but I haven't found anything about this on Airtable.If this doesn't work with Airtable, do any of you have any feedback on data aggregation using Airtable -> Zapier -> Google Sheets -> Airtable type automations?Tha

I feel like I’m missing something pretty easy. I’m having a hard time converting what I do in Excel into our Airtable base. Each year our clients' total sales (a rollup of their sales for a given year) converts to shares based on a sales/shares tier. The tier changes every year. Because of this, we want to track the data historically. For example:Client ABC’s 2024 Total Sales were $250,000 and they earned 4 shares based on the 2024 shares tier.Client ABC’s 2025 Total Sales were again $250,000, but this year they earned 2 shares because the tiers changed in 2025. We need to track the tier changes each year as to keep data integrity of the shares earned each year by our clients. (We don’t want ABC’s 2024 points to change from 4 to 2, which it would if we use a nested if formula - the change in criteria for 2025 would mean an edit to the formula which would have a cascade affect and change all previous year's data.) ANNUAL CLIENT TABLE - rolls up sales totals for each client for all their