Development & APIs

Hello! Currently for a school project (Software Development and Design) I am making a game in unity complete with an online highscores leaderboard through Airtable. The leaderboard side of the project is now done but I wanted to add a replay system to the game. Much like demo files from the old doom games my replay solution is a JSON array that contains the positions and rotations of the key game objects over the lifetime of the game. The file that is generated is only about 1mb in size and such shouldnt take very long to upload if sent with the rest of my run information (such as the players username and their time) The issue I have run into is that im getting an INVALID_REQUEST_BODY error every time i try to put the entire JSON string into a Long Text feild on airtable. I beleive this may be due to the fact that it is a JSON string inside the rest of the JSON request that is sent to irtable. Is there a way to isolate the string so that airtable doesnt try and parse this data? Alterna

Our company is deeply integrated with the Airtable API. In fact, we help other companies build on Airtable - so we monitor the Airtable API closely. Up until a month ago, all our API requests to Airtable were GET requests. With the launch of our proxy, we’re now servicing PATCH/POST/DELETE requests as well. With these new requests, we began to notice some unusual API performance. Requests could intermittently take up to 10 seconds to complete. So we started an investigation to determine what caused this erratic API performance. Our first hypothesis was that base size was the culprit. We ran a benchmark across bases of different sizes, and oddly the 10K base was much slower. Granted, each base had different data in it - but the consistent performance on the other 1K base and 49K base indicated that size wasn’t the issue. So it must be something with the structure of the base that impacts API performance… Read the full post to learn what elements of your base cause the Airtable API to s

Continuing the discussion from Base64 conversion: Wanted to resurrect this 2020 topic for a second because it was locked without a definitive explanation, so maybe I can offer one and help some future coding prodigy keep their anxiousness in check instead of wasting 30 minutes of their life looking into random commits for an answer to what these mean red lines might want from their binary schemes as their own twisted way of procrastinating. So, it would seem that this is a visual bug specific to Monaco, an open-source text editor from Microsoft which powers Airtable’s Scripting app. On my end, these squiggly eyesores only appear if I write btoa instead of BtoA immediately after a DOM refresh. But if I reload the page and use BtoA first, I can btoa as much as I want all over the place. Sd linting quirks don’t affect functionality and the inconsistent accounts from the previous thread suggest the lines might actually originate from a third-party spellchecker (or a rare example of a secon

how can i show linked records for a selected table record that changes dynamicly when i select/deselect rows? i can get selected row ids from cursor, but i am struggling to to select and show linked recods

I am trying to write a script that will look at 4 fields from an older version, and copy the contents of those 4 fields to a newer version of the same data. When I run this, the script finishes super fast, and no records are updated. I know that some matches are being found due to the console.log statement. However, when I check my table that is supposed to be receiving the updates, there are no changes. What is going wrong when I try to update the records? let oldTable = base.getTable("Updated 4/15/21"); let newTable = base.getTable("Imported 4/29/21"); let oldRecordsQuery = await oldTable.selectRecordsAsync(); let newRecordsQuery = await newTable.selectRecordsAsync(); let oldRecords = oldRecordsQuery.records; let newRecords = newRecordsQuery.records; newRecords.forEach((record) => { let found = oldRecords.find((old) => old.name === record.name); console.log(found); if (found) { let newCalledBy = found.getCellValueAsString("Called By"); let newCalled = found.

I noticed three records missing from a table, which had been created via an API call. The API call response indicated success, including a response object containing the same number of records (and with recIDs) as had been POSTed in the call. However, these records do now not appear in Airtable. There is no record of manual deletion in the base trash, and the view is not filtered. I was wondering what could be going on and so decided to look at an automated Airtable snapshot taken on the same day. The records were not in the snapshot, but I did notice that the snapshot was taken at the exact same minute that the API record creation POST call was made for the missing three records. Is it possible that the snapshot process has interfered with the record creation call in some way (perhaps a DB transaction lock or similar), resulting in the Airtable API response to prematurely report successful creation?

Hi! I am learning to build my first Airtbale apps, I completed the basic tutorials, and now would like to be able to add the ability to read a remote JSON to my app. First question I have is: The API methods that work within the scripting app will work for custom apps? In that case is fetch the right way to go for reading remote data? Also, if anyone has a very basic example of an app reading remote data I will really appreciate that. Thanks a lot for your time!

i have set up nodejs and did block run. then i copy the url in App Url field and i get Can‘t connect to your local app, did you block run ? https://localhost:9000/ on local comp is working

Hi All, I’m wondering if there is a simple option to run a script when a checkbox is ticked. The Reason is i am going to take a timestamp and modified by when the check box is ticked. So if I was working: I Would Tick check record and that particular record would open in expanded card view: so it would need scripting, but I cannot work it out at all. any assistance would be appreciated. Rob

I’d like to pass in environment variables to my Airtable Block Code whenever I run and release so that I can configure things like endpoints dynamically based on the environment. Is there a way to do this?

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?