Solved

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

Table 1 is a database of completed projects, table 2 is a list of invoices. How do I have the linked field in table 1 link to the next available invoice # in table 2? The invoice #s cannot be duplicated and I’d like them to stay chronological. All of this is currently set up, but it’s done manually. First, by searching what invoice # is next then in table 1 under the invoices field, create a new record with the next invoice # in line. Is there a simpler way to do this? Table 1 Table 2

Hi, I am pretty new to this and not a developer. We are using Airtable for our product database for our Shopify store, and have Airpower as the sync between them. This works pretty good, but there is one major thing we need that Airpower does not support.We need the number of "committed" inventory of the products to sync from Shopify into Airtable in real-time. Right now, the Airpower Inventory sync only brings the "available" number through, but both are required for us, and we need the data to by syncing constantly so it's up to date.Is this something we could use a webhook for? Or is there a simpler process?

Is there a way to use Airtable sync to conditionally sync data from one base to another? I need to only sync specific records and not all of the records in table.If it is not possible using Airtable sync, is there any other way of accomplishing this?

Am I overcomplicating this?I have an automation to create a time stamp in a Date Completed field when a Status single-select field is changed to Done. The Date Completed field is populated with the full date and time, but I need to utilize this information in a Reporting interface for my management so I’d like to be able to have them select the month from a Dropdown Filter. To that end, I’ve created Month Completed field that uses a simple formula to just show the 3-letter code for the month, based on the Date Completed field.The issue I’m having now is that I’m not able to use that 3-letter code (because it’s a formula field?) as a filter on the Dashboard.I could create another automation that’ll convert the formula field into plain text or even a single-select field, but I feel like I’ve now created a whole bunch of steps to do something that might be accomplished in a simpler method. Note that the Month Completed info isn’t being used anywhere else. The Date Completed will likely al

Hi all! I have a problem that I feel should have an obvious solution: I’d like to set up an Automation that normalizes a string value after input by base collaborators. However, the Automation appears to run too early, catching only parts of the input string. (This behavior is not consistent, though: From time to time the Automation will catch the whole string.) I selected When record updated as trigger and configured it to watch only for changes in a specific field (in my case: Keyword). Example from the screenshot: The entered text is “Aldi Angebote”, but the Automations appears to run already after the first letters are typed in, so only “Ald” is used as Automation input. What’s the best way to solve this problem? Is there a better trigger for this use case that I am missing?

NEVERMIND - I filtered out the empty ratings. Thanks!

I have an Airtable that is populated from Jotform submissions. The Jotform has a configurable list that for someone to fill in their schedule for the week. The configurable list can’t be split in Jotform so I’m trying to split information in Airtable. I want all of the days of the week listed in the configurable list cell to be extracted in a Days Open column but can only figure out how to extract the first instance using regexextract.  For example the configurable list will come in as:Day Open: Monday, Opening Date: 2025-06-16, Closing Date: 2025-10-27, Start Time: 09:00 AM, End Time: 02:00 PMDay Open: Saturday, Opening Date: 2025-08-09, Closing Date: 2025-08-30, Start Time: 10:00 AM, End Time: 04:00 PM and I want Monday, Saturday to show up in the days they are open. 

Hello,I am creating a management system for tracking the required materials for projects. In each project, there will be predefined material quantities needed to complete the project. When the work on a project starts, the user will generate a Purchase Order (PO) (third table) and add multiple materials through the interface. I need some help in creating this interface.The base design is as follows:I have two base tables. The first one is called the Master Material Base, and the second base is called Jupiter Castle.The structure for the Master Material Base consists of one table called the Master Material Table, which contains four fields: code, description, type, and unit. I have granted permission to share and sync this table with other basesIn the second base, Jupiter Castle, I have the following design:(First table): I have synced the Master Material Table into this base.(Second table): I have created a new table called Material Tracker, which contains the following fields:Line ID

I have a base that I’ve published as a library, let’s call it Part Numbers. It only has two fields - a Part Number and a description. I have 2 or 3 other bases that are pulling in this library as a table, and they’re linking records to it.I now need to make some updates to the Part Numbers base - some individual #s may be deleted, or descriptions might be changed, etc. If I upload a new CSV to the main library base and overwrite everything that’s there, but many of the #s never change at all, will the linked records in other bases stay linked?

Hi everyone.As part of my job, I have to send a form to my customers, so that they can provide me with production data. iToday, this transfer is done via an Excel file.Tomorrow I'd like to digitize the method.I'm looking to create a form template, which will be sent to my customers, so that they can provide me with the information.The form filled in by the customer must be unique (unique url).The customer would also need to be able to consult and modify the form at any time.At certain times, he can't collect the information all at once.It would also be interesting if the unique form were password-protected.The data will be stored in a dedicated table.Do you have any ideas on how to go about this?Thank you very much!

Hello. Am developing an app using Flutter. Would like to find if I can use Airtable as my database. Is there an API that I can use to integrate Airtable with Flutter? Will need to be able to do all CRUD operations. If so, is there any documentation that I can refer to? Thank you!

I would like to send an email at 10am every week day to orders with the status ‘past due’. At the moment I have an automation with Trigger > at a scheduled time Action > find records (if status is ‘past due’) Action > send email however the test email fails due to “Cannot email more than 25 recipients at a time.” at the moment it is adding every recipient to one giant email, rather than separate emails. Is there a way to have it send out separate emails for each ‘past due’ record? I don’t want all of my clients to see each others email address :slightly_smiling_face: Thanks

I have a form for Licensure to get submitted, but I am wanting the person submitting to see the Description of the Code that is chosen.I can't seem to get this to show how I want because I need on my database to have a column with ONLY the code to be passed over on the file I generate.  Ultimately what I want is what you see below.  I want the "License Code - PS to be what is showing.  If we have someone in certain states I need it to change to a certain code.  Here is what it should look like (coming from step 3 below, but read why I don't seem to like this).  I tried a few items listed below:1. First, I wanted to use a formula in the Automations, but it won't allow this from what I could see.  I can chooseStatic or Dynamic to update the record, but can't use a Formula here.2. Second I then made the option on the form to be Code-Description and then tried to use the following formula which works great except I have some "Codes" that have a dash

Hello Airtable Community, I have experienced recently a misunderstanding with an automation of Airtable. I have a Plus Plan but the number automations free are 0, It says I have done 50.000 automatizations and now I cannot try my app anymore. I don’t need even 50.000 automatizations by now but It has been a misunderstanding of an automation of “When record updates” in the Collections base. This Collections Base is linked with the products (that are 1.000) and this products are sync with Shopify AirPower API that sync the changes every time. So the solution, i think, is to do not watch this records in the automatization… but I did not noticed earlier… Is there any solution on this type of situations? I am a developer and I need to keep working with the automatizations to develop an web for my client, even upgrading to Pro Plan will stop the work for this month as I have achieved 50.000 automatizations… What could I do? Sorry but I would need some type of solution. Thank you for your co

Hello Airtable Community,I’m receiving an array from a Fillout form via webhook into Make (see attached image)I would like to use this array in a Search Records module for Airtable to find all records where the primary field matches any of the values in the array.What’s the correct formula syntax in Make’s Airtable module to achieve this?Thanks in advance   

We are looking to enable users outside our domain (parents of our students) to submit a form with an attachment. If we turn on the setting "Allow unrestricted access to shared forms" at the org level what other impact might that have from a security perspective? We are using AirTable to manage very sensitive data about our students. Thanks!