Development & APIs

So I want more control over a CSV import…what if I don’t want to import all records? What if I want to “rollup” records. Like hypothetically, if I had a say a bunch of transactions on Wednesday but in the CSV each transaction was individual, with a date (Wednesday), amount and location…is there a way to program in javascript to essentially “rollup” all those transactions so I write to airtable a single record, with the date of that record, a total amount from all the records with that date and a field with the locations. Is that possible or should I just build a whole other table to do the rollup? Seems like a time consuming extra step that I could just program in and skip an extra table and time rolling it up. At very least is there a way to “limit” what gets imported?

I can’t seem to release a block that’s based on the unmodified Url Preview example block code. I literally just ran: block init [id] --template=https://github.com/Airtable/blocks-url-preview google_drive_preview “block run” works fine. But when I try to run “block release” here’s what I get: scotty:google_drive_preview scotty$ block release building copying package.json file copying package-lock.json file installing node modules [npm] [npm] > core-js@3.6.5 postinstall /private/var/folders/xb/yhygdpg55d734fcsckghy__m0000gn/T/airtableBlocks/build/1590085769112/transpiled/user/node_modules/core-js [npm] > node -e “try{require(’./postinstall’)}catch(e){}” [npm] [npm] added 78 packages in 1.701s Error: :x: added 78 packages in 1.701s Failed to build the block code!

Hi everyone! I have a particular situation where I’m trying to link several records from a view in one table to a specific view in another. I did some research from pre-existing articles–mainly this one–but I have a couple wrinkles for my script and don’t have the knowledge to make it happen: I work for a non-profit where volunteers go online to write encouraging notes to authors who have sent digital stories to us. In this example base, you’ll see that I have one table for the digital stories, one table for the volunteer events, and one for the companies we work with. Here are the complications: 1) I don’t want to “pack” any stories that were assigned to the same company from a previous event. 2) I want to assign a certain # of stories to the event based on number of attendees. So the script would count the number of attendees, multiply tha

We use Airtable as a back-end for many of our major systems. A big part of these systems is the use of scripting apps in order to streamline many of our processes. We have one system to track shipments. We get data in at the end of our day and someone will upload that data into one of our bases. From here, we run a series of scripts that scrubs and processes the shipping data since much of it can come in very raw. I was in the process of working on one of these script today when all the sudden I was thrown the error “You can only send 15 mutations every 1000ms”. Now, I haven’t made any changes to these scripts today and have never seen this error prior to today. The issue is that we process large amounts of data and while putting an ‘await’, which we don’t normally do, in front of an ‘updateRecordsAsync’ function will allow the script to work, it takes us from a process that used to take 5 minutes to one that takes ~30 and potentially ruins our entire decision to move

I’ve successfully applied both those conditions distinctly: filterByFormula: {customerOwnerRef} = '' filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}') But I don’t understand how to make a logical OR between both conditions, I tried the following but it fails with INVALID_FILTER_BY_FORMULA error: filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}' OR({customerOwnerRef} = '')

I know there has been lots of discussion about Airtable Apps regarding API keys and the best way to store them—I believe the current recommendation is still in globalConfig. My request is about Airtable’s own API keys in particular. It would be great if a Custom App was able to access the current user’s Airtable API key via a new readonly field in their CollaboratorData. When accessed via the App’s Session, this could really help with customizing the app per user and ensure any API calls they make are tied to their Airtable account. I don’t think this is currently possible, but I’d be curious to see if others would find this helpful as well?

Hi! I understand that the API has a rate limit of 5 requests/second per base, and I’m open to creating a database to cache the retrieved data to account for a potentially higher read volume, as recommended in the API documentation, but I just wanted to ask whether there are any other limits/caps on the number of total requests per, say, day. Thank you!

The following request works as expected: https://api.airtable.com/v0/appD1JKW7PlQhRMrF/Docentes?fields=Email&fields=Status But this one fails with status 422 Unprocessable Entity: https://api.airtable.com/v0/appD1JKW7PlQhRMrF/Docentes?fields=Email The response is: {"error":{"type":"INVALID_REQUEST_UNKNOWN","message":"Invalid request: parameter validation failed. Check your request data."}}

Hi Airtable, I would like to automatically retrieve historical exchange rate data from this website secure.mas.gov.sg Monetary Authority of Singapore Any kind folks can help me?

I have an app in G Suite that uses a trigger script from a spreadsheet to create a set of record-associated Google Docs, and retain their URLs within spreadsheet cells. This is done in the background, as a trigger. Can I access the Google Docs API to enable such a function, and how would I enable it as a trigger, similar to a trigger from a Google Sheet? Sorry if this sounds basic, I am just starting with Air Table. Much tighter and somewhat more intuitive than G Suite.

Hi all Is there a way to retrieve or update a record’s activity/comments using the API? I’d be keen to hear about any attempts at doing this. Thanks! Alex

Hi, I have a formula field that has long SWITCH statement and I want to modify this formula dynamically in backend. Is there a way to achieve this?

Hey AirTable Family, Is there a way to pivot columns to rows in AirTable? For example when I import an excel csv with contact name and 10 phone numbers on each row, is it possible to create a view / table from that table (in AirTable) which will pivot the 10 phone numbers to rows while repeating the contact name? I want my assistant to record dispositions for each phone call. Thanks!

Hello, I am using airtable.js javascript SDK to displaying records. I am trying to figure out, is there any way to duplicate a record in same table by just passing airtable record id to api SDK?? Thanks, Chirag

When I use the API to create, update, or delete multiple records in a single API request, is it possible for the request to partially succeed? Meaning, for example: the API successfully creates (or updates or deletes) some of the records but fails to create one or more other records. To ask this another way: if the API returns an error when I’ve sent multiple records, am I guaranteed that none of the records were successfully created/updated/deleted? Thanks.

I’m having trouble finding any info about how to retrieve the records contained in a linked record field. In the custom apps there’s a function called .selectLinkedRecordsFromCell, but I’m not seeing something similar in the scripting app documentation nor anything else about how one might do it. Thanks

Hi all, I have 5000 records and there is one deleted that I need to find. I loop over the the records IDs 100 at a time to see if I get all 100 returned. On this forum I found 2 approaches using filterByFormula to get multiple records for multiple IDs filterByFormula = 'SEARCH(RECORD_ID(), "'.implode($ids, ',').'") != ""' filterByFormula: "OR(RECORD_ID() = 'reca9IDlX0gvu32ml', RECORD_ID() = 'recgh3XeMcdmX8uPj', ...)" some questions is this the best way to find deleted records should I use filterByFormula, and if so, which formula is “lighter” for airtable to process should I use a different kind of filter (AFAIK the batch API is only meant for create / update / delete and not for reading) Greetings, PJ

I am trying to create an app that allows the user to edit/add data through input fields. I have the data binding and working fine. The issue happens when the user wants to edit anywhere in the text. It will allow a few characters input, then the app will refresh and the cursor will be at the end of the text. I simplified the code to just editing a record name for reproduction. Any ideas? Thanks in advance import { cursor } from “@airtable/blocks”; import { useLoadable, useWatchable, initializeBlock, useBase, useRecords, useGlobalConfig, TablePickerSynced, Box, Text, Input, } from “@airtable/blocks/ui”; import React from “react”; function UpdateBlock() { // YOUR CODE GOES HERE const base = useBase(); const globalConfig = useGlobalConfig(); const tableId = globalConfig.get(“selectedTabl

We are using Zapier to integrate an Airtable base onto our website. If we move the Airtable base to another workspace on a different Airtable account, will that affect the Zapier integration?

Is it possible to end a script early? It seems like the process.exit() function isn’t available. I’d like to show an error message and exit if the input meets certain criteria.

Hi, Does anyone know how to get to the REST API documentation? I found a link here https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API but it appears to be broken. Thanks!

Hi, Thank you for your participation in the Custom Blocks Beta! We have some big updates about Custom Blocks that we’re excited to share with you today. (Airtable has also launched several other new features today—you can check them out in our community announcement and in this blog post. Blocks are now Apps Firstly—Blocks are now called Apps! You can read our announcement here to find out more. This rename doesn’t change anything about how you manage your custom apps - no action is required on your end. The Blocks SDK and CLI are not being renamed and will continue to be published as @airtable/blocks and @airtable/blocks-cli.

Has there been any thought about enabling the creation of new spreadsheets by typing “airtable.new” or even “table.new” into the address bar? I use it extensively for google sheets, and wondering whether there were any plans to support having the same functionality?

Unfortunately another roadblock. Both Zapier and Integromat do not allow selecting the SINGLE SELECT Field as a Trigger to start workflows. Some other restrictions exist, e.g. Zapier allows Sing line text field to be a Trigger. Integromat does not allow even that, trigger can not be either text or Single Select. I may be mistaken but I tested both and both field types are unavailable as trigger. That’s a disappointment and I’ll reach out to Zapier and Integromat to comment on that. I’ll update here once I get some feedback.

Release: create tables, create fields, and update field options from the Blocks SDK