Development & APIs

Hi, everyone. I have a question about Airtable API. As far as I know, Airtable API doesn’t allow direct image uploading and needs a public URL that images are stored. However, the images include very sensitive information in my case, so that they can’t be stored in public. In this case I guess I can use S3 presigned URL. My question is, can Airtable API retrieve images even if the URL is only temporarily available to public? Thanks, Ryo

The API is limited to 5 requests per second per base. If you exceed this rate, you will receive a 429 status code and will need to wait 30 seconds before subsequent requests will succeed. Anyone has experience with what is max request per second allowed by the AirTable Enterprise plan

I’m new to Airtable scripting but I have figured out quite a bit already. Using many different sources I have written a script that copies my task template into my task table bases on picking the name of the template you want to use. Now I’ve been asked to add some additional fields with different types and my script does not work anymore. Let’s start with the first field type with an issue: Multi-select Current error: P: Can’t create records: invalid cell value for field ‘Test Multi-Select Copy’. Could not find a choice with that ID or name at main on line 54 To me this error means that the lists aren’t the same but I there are only three and I checked that yesterday I’m a little confused on how to show everything that someone might need to assist me. I put a screen shot above of my task template and below is my script: //declares and then gets the project from the select list or from the row the button is on const projectsTable = base.getTable(“Projects”); let record = await input.r

Anyone has used a scripting app to run API calls to add/update webflow cms items?

Hi, team! We’ve noticed that “GET https://api.airtable.com/v0/meta/bases/BaseId/tables” is a part of Metadata API now. Are there any announcements about excluding this from regular API? The endpoint was listed in baseID specific API docs, so we were expecting to access tables and their structure with regular API key. Is there a way to get this data with regular API key now? Thanks

Hi! I’m trying to generate a csv file of a table similar to a file generated by web UI. Using Airtable API I get data only in JSON format, which supports only numbers and strings. Thus I have to guess the type by value shape. For example: Does a string contain a template DDDD-DD-DD? ​Is it a link to another table? Etc And it is a mess. So my question is - do we have a way to get the type of the field, the same as what we are able to see when reading API documentation (Currency, Lookup, URL, Link to another record, etc)?

Hi all, I noticed the Airtable has announced better integration with Elementor. I am new to Airtable but have been using Elementor since it launched. Is there any documentation regarding Elementor integration please? Thank you.

Is it possible to use the UI components from Airtable Blocks SDK outside the Airtable Apps environment? Are there any Airtable React components implementation that can be used outside the Apps environment? Thanks.

I have my .env file with my variables, its in my src folder, I have my YOUR_ID_HERE, YOUR_BASE_ID and that in it. BUT, when I use “process.env.MY_VAR_HERE”, it gives me a a error: “Airtable requires a api key” … I already generated one, I know its the dotenv file, because when I switch the vars in the field for the raw api code… it works. so its the dotenv file that’s not loading.

Hello, I would like to run the script every time the user enroll to my app. How can I access the current user in the script?

I am using integromat and airtable update record module. If my data coming in date fields are empty its failing to pass into Airtable. This used to work and it just would negate the date fields since there was no data but now getting invalid date field. I tried using ifempty formula but that does not work either. Any suggestions here? The rest of the fields if I have them mapped and no data is there , it just treats them as if they were not mapped. Not sure what is going on with the date fields.

I’m using Zapier with Airtable and a New Record in Airtable trigger. The new record has an email address like d12345@… Then I have a Find Record in Airtable action. There is a record with the email D12345@… - with a capital D. The Find Record action doesn’t find anything. Is there any way to make this work so that the Find Record action will match on similar strings like this?

Hi everyone, we are interested to use Airtable as a database for video classes that we produce. Is there an already built app or script that can generate unique filenames using fields in a table? Our reasoning is we want to fill out a form that once submitted will generate a file name, we will rename the file accordingly and keep it in our database. Then at a later time we can search with the appropriate criteria and get a list of filenames that we can easily search on our local drive. Please let me know if something like this exists. Thank you for your help

Hi I would like to be able to create multiple linked records in one “run”. I do a lot of videos for lectures and have a base has with a “productions” table and a “projects” table. I want to be able to add a button in the “projects” table that runs a script the script should ask me how many new records to create in the “productions” table. and then create the records linked to the project This would help me when 1 projects has 30 productions. And because a higher demand for remote learning I get many request for many videoes - so time saved on place it time used in another:) Thanks!

I didn’t see this discussed but it seems like something that would be extremely valuable. Is there a way to run a script upon leaving a field or when a field value changes?

Why my files on google drive come with an extension (jpg)? I don’t want to see these in my files. when they transferred to airtable using integromat they come with also. it’s a big issue in matching these names. how to avoid this issue guys?

I am trying to add decimals with 5 or more decimal places. i used the currency field but i cannot add the data via api. the value here is “gains”=>“0.00072333333333363115” i get error Airrecord::Error (HTTP 422: INVALID_VALUE_FOR_COLUMN: Field “gains” cannot accept the provided value)

Hi! I couldn’t find any informations about extending the existing Metadata API in a way, so there would be a possibility to update the structure of the bases, fields and so on through the metadata API. Let me describe myself better, what I mean by that. I had an occasion to work with Salesforce for some time. This is also a low-code platform, where instead of writing code whenever there is a repetetive task, you can do that by draging or clicking. Everyone knows the benefits of low-code platform, so I won’t be talking about that here. When using low-code tools like Airtable or Salesforce, everything is wonderful in developing stage, we can do that much faster, we have ready made API we can connect to other tools really fast, but when we finally go live with the MVP of the product and we have real users who uses the application we made, we would rather perform future developing and testing on some dev/test environments. Of course we can do that, but current way is just bad. When we fina

I want to create an API end point to delete records based on a user_id (or any field other than the records’ id). In other words, the equivalent of SQL DELETE FROM {table} WHERE user_id = {x}. Airtable’s built-in API only allows to delete records based on their ID, not on any other field. Is this possible?

I’m hoping to get the first 9 characters of a record into another field. Id normally just make the field into a formula and use Left({product},9) but the rest of the automation wont run on the formula field. Please help.

I have a code that looks like this: await createPackage(oderSummary); async function createPackage(oderSummary) { let pickPosition = true; let lineItemsArr = []; const r = Object.keys(oderSummary[0]).map((v) => ({ [v]: oderSummary.map((c) => c[v]), })); let tableItem = [...r[2]["Pozycja"]]; while (pickPosition == true) { let pickItem = await input.buttonsAsync( "Pick order to pass", tableItem.map(String) ); let filteredOrders = oderSummary.filter( (item) => item.Pozycja !== Number(pickItem) ); let difference = oderSummary.filter((x) => !filteredOrders.includes(x)); tableItem = tableItem.filter((v) => String(v) !== pickItem); lineItemsArr.push(difference[0]); oderSummary = filteredOrders; if (pozycjaTabeli.length) { let shouldContinue = await input.buttonsAsync("Dodac Nastepna?", [ { label: "Yes", value: "Yes" }, { label: "Cancel", value: "Cancel", variant: "danger" }, ]);

I use the following request to get list of records by view. In this view, records are sorted by id DESC. But the API returned list of records, which are sorted by id ASC https://api.airtable.com/v0/mybasekey/mytable?api_key=my_key&view=my_view This problem just happened in today. Please help me to resolve this problem.

Hello, I’m trying to do an automation for a project of mine where it takes two images, overlays one over the other, and then saves the result to a new field. I have tried to use OffscreenCanvas as well as a simple Image object. However, I get a cannot find name error for both. I am aware of the limitation on the DOM API, but both of the APIs are not a part of the DOM API. Any ideas why I get this error? Or maybe an idea for a different solution?

So let’s say I have two tables, (1) People and (2) Companies. I’ve created a form view in the People table, which has the following fields {First Name}, {Last Name}, and {Company}. What I’d like to have happen is that when a user fills out this form, the {Company} value is not only created in the People table, but also in the Companies table as linked record so that this person and the company in the Companies table are a linked record. I would use Zapier for this, but I don’t know how to configure the Zap to get them to be linked as opposed to just creating an isolated record in the Companies table. Any help would be much appreciated. Thanks a ton.

Hello! I am trying to sync prices and stocks for several products between Google Sheets (source) and Airtable (destination). Thanks to other posts’ answers in this community I could make a script that updates products one by one. But I would like to reduce the number of requests by adding 10 products at a time on a single request. I tried several things but I cannot make it work. I guess it’s related to the way the script parses the data. Here is a simplified version of the script covering only 10 products: function bulkSendData() { const url = "https://api.airtable.com/v0/XXX/"; const dataSheet = SpreadsheetApp.getActive().getSheetByName("XXXSheetName"); var productsData = []; //Step 1 get the data on Google Sheets for (r=2; r<11; r++) { var singleRecord = { "id": dataSheet.getRange(r,1).getValue(), "fields": { "Cost": parseInt(dataSheet.getRange(r,2).getValue()), "Stock": parseInt(dataSheet.getRange(r,3).getValue()) } } pro