Development & APIs

One of our scripts started erroring out last friday. I wasn’t informed until this morning. Getting the error: P: Validate this value before parsing at main on line 5 Thought this was really odd so I added a new scripting block, added the record picker example and changed nothing, same error. Has something changed recently with the scripting block as a whole?

Hi All, I am wanting to add a button to a view so that when it is pressed, all the check boxes in the view are ticked. In an ideal world, pressing this button would also send all the records to be printed (I have designed the printable page in page designer) however this is less important for the time being. any assistance would be appreciated. Rob

If anyone is trying to buid Appsheet apps on top of AIrtable, here’s a few posts you might find useful. And if interested you could provide your own experience. I have found it much more complicated than I expected, and have found very few forum references to help (isn’t anyone else out there trying to do this?) Basic first step, setting up security filters to restrict data access by user profile – I raised this question in AIrtable forum and found this answer in Appsheet forum (my question was already closed before I got a chance to post the answer). How to handle links and table keys if you want to allow Airtable data to be edited and added natively as well as via the appsheet app. I came up with a complicated solution but am wondering if anyone has found an easier way.

I need help writing the following script: Tables: Classes Students Grades (junction table) Each time an Enrollment form creates a new record in the Classes table, the script creates a record for each Student in the Grades table. Grades table is a junction table linking Classes and Students tables. I know there are several community scripts regarding junction tables but I need one that works from just one Class record at a time.

Hi community, I’m working on the integration between ServiceNow and AirTable, the goal is to manage AirTable subscriptions through ServiceNow, so I need to get AirTable user subscriptions into ServiceNow. Looking at the AirTable API documentation, I don’t see anywhere how to do a simple “Get Users”. Using the Enterprise Account > Get Information, I’m only getting the userIds without the other parameters. https://api.airtable.com/v0/meta/enterpriseAccounts/EnterpriseAccountId How can I get the list of AirTable users including all the following basic information? "state": "provisioned", "email": "foo@bar.com", "name": "foo baz", "lastActivityTime": "2019-01-03T12:33:12.421Z" Thanks a lot for your support Regards Alberto

I am using Airtable to send data through to another platform (Formstack Docs aka Webmerge). My base has a main record with a number of linked records per main record. The use case is that each item from the linked records will be a new row on a document. In order to do that, I need to send the data through to the document in JSON. Is there a way that I can produce the JSON of the linked records with a script within Airtable? Ideally I could put that JSON into a long text field. Failing that, is using a code step in Zapier the only other option? Thanks Shaun

Hello! I just wrote a quick snippet to turn records and linked records into labels, but I ran into the nasty surprise that the scripting block doesn’t allow HTML formatting. I can’t really do this in markdown due to the flexibility constraints of the labels I print on. Is there any way to either a) make the Scripting block render HTML or b) easily convert a script to a custom app? Thank you!

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.