Development & APIs

I copied @Justin_Barrett’s script from the below post and modified it for my purpose: Automatically link record based on plain text or formula result Scripting app I would like to create a workaround for the issue that Linked Records are not available in Automations. I am collecting lots of URL inputs from colleagues via the web clipper. For a number of reasons I want to link the records to another table automatically, using a script. The idea would be to trigger the script using an Automation. In short: I want the title of the Calculated site to be copied into the linked record field Sites [how to link record] I feel like this should be fairly simpl… I’m inputting productName (formula field, text formatted) and recordID from the trigger. My tables are Departures with a linked field Product towards the table Products, where the primary field Product matches the productName input. let DepartureTable = base.getTable("Departures"); let ProductTable =

Just getting back into programming after a long pause. Is there an example script out there: Simple php loop and echo rows from table? Thank you!

I was wondering if it’s possible to add multiple filters in the Airtable API URL - I have figured out the way for one filter, but I am struggling to apply multiple filters. Here’s the URL I made, which has a single filter applied : api.airtable.com/v0/<BASE_ID>/<TABLE_NAME>?api_key=<API_KEY>&filterByFormula={City}="MUMBAI" The above URL works perfectly, but if I try to add another filter (using &), it shows errors. I am looking for a way to add these 3 filters : {City} = “MUMBAI” (field type = single line text) {Age} > 25 (field type = number) {Calculation} = “Ok” (field type = formula, result would be either “Ok” or “NA”) What is the recommended/correct way to add multiple filters? Your guidance would be very appreciated. Thanks!

Hey there community - I recently joined the Product team to lead Developer Relations! I get to work directly with the engineers building our developer tools, and advocate for things that this lovely community needs to succeed. Specifically, my role is to listen to, learn from, and contribute to this community on behalf of Airtable. I’m dedicated to making announcements about recent changes, popping into hot debates and discussions on this forum, and answering Airtable questions as they come along. From the outside looking in, this community has been thriving. I’m excited to get to know each of you. That being said, it wouldn’t be a valuable post without an announcement! We recently added the ability to write field descriptions and write description data when creating a field or table using the SDK. Field descriptions can now be edited and specified when creating a new field: Added field.updateDescriptionAsync (docs). Added optional description argument to table.createFieldAsync (docs)

$api_key = ‘[KEY GOES HERE]’; $base_id = ‘appPrp2UDQKyeozka’; // Base ID for entire scorecard machine $table_id = ‘tblhkGjHUAMbsLYDF’; // Table ID $view_id = ‘viwnABjCLiL9eAiip’; // View ID $scorecard_id = ‘recNQHVVwauXgaS3q’; $url = ‘https://api.airtable.com/v0/’ . $base_id . ‘/’. $table_id . ‘/?view=’.$view_id; //’&fields%5B%5D=Criteria&fields%5B%5D=Section%20Link’; $headers = array( 'Authorization: Bearer ’ . $api_key ); $ch = curl_init(); curl_setopt($ch, CURLOPT_HTTPGET, 1); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_TIMEOUT, 10); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); curl_setopt($ch, CURLOPT_URL, $url); $entries = curl_exec($ch); curl_close($ch); $airtable_response = json_decode($entries, TRUE); This gives me a response with the items in this view. But they aren’t ordered by the order in the view? How can i fix this?

Hey folks, Seems when we use images from Airtable to render they bring in 10+ cookies with them see attached. Can someone from Airtable team explain why this is the case as this is breaking EU laws… –Artur

I run a kids club and do my database through airtable and would love to automate some updates after club each week. Want to have the “pts this week” column be multiplied by 10 and added to the existing value in the “total points” column. Want to increment the attendance column value by 1 if the “pts this week” column is not blank. Not sure I can swing this with a formula or an automated script run weekly. Zero scripting experience. I know how to do this through third party apps (Wayscipt, Pabbly, etc) but would like to learn here. Thought I’d ask for help and see where I end up as this probably is a very simple script.

Hi I have a price field that I auto import prices from and it comes out as “7 99” because that’s how this specific website shows the price. I want to use the find and replace script to replace the spaces " " with a period “.” however that doesn’t work. Idk code but should this fix be done in my data scraping or can airtable fix it.

The attachments get into my airtable, but… a) they only show as grey paper clips b) clicking on them gives a black screen with an error e.g. “Previews for this filetype are not available screenshot_20211001-083956_google (3).jpg - 315.2 KB” - so airtable KNOWS this is a jpg c) clicking on the “Download” button from that black page, correctly downloads the file - so airtable HAS the file.

Hey all, I have an Airtable set up former employees returning hardware to the company. It’s based on a form where they select whether they will drop-off their hardware in person or ship it to the building. I set up an automation where if they select drop-off, they select a day and time and an event is created on a shared Google calendar. I am working on another automation that adds a member of the IT team as an attendee on each event when they are assigned in Airtable, and it works perfectly for the drop-off records. However, I assign IT team members to all records, not just drop-offs, and when I assign out a non-drop-off ticket I get a ‘failed automation’ notice. Is there a way to tell Airtable to only update records that have ‘Drop-off’ selected, and not update for records with ‘Ship to HQ’ selected?

Hey! First time here. Guys, I need the Airtable API to return an array on this format: But the only way I could make it return was in 2 separated arrays, like this: Is there anyway to return it like the first image? Thanks in advance!

Hey there, I would love a bit of help with an issue I have been struggling with: I have large data set containing keywords / descriptive tags to describe/classify the designs on our webshop juniqe.com, they are stored on a table called Image Keywords in my base, whereas the designs they are related to are on a table called DESIGNS I wrote the script below to merge the duplicate entries in the keyword table, since these records hold much information other than the linked record to DESIGNS. I’d like to believe that the script does the following cycle through all the records and compare the current records main field to the others, using the field Name (EN) as comparison value (the keywords english translation) If a duplicate has been found, combine the linked records of both the instances the script has found, and write them back to the first instance Clear the linked record field of the second instance (the comparison record) and mark that record with a checkbox field called DUPE to in

Hello, first of all, the Airtable API documentation is great. That said, closely following the example code, i’m trying to understand how I might do something functional with the retrieve method. Here is the example I am given from the API docs for my table ‘Users’ base('Users').select({ // Selecting the first 3 records in Grid view: maxRecords: 3, view: "Grid view" }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function(record) { console.log('Retrieved', record.get('ID')); }); // To fetch the next page of records, call `fetchNextPage`. // If there are more records, `page` will get called again. // If there are no more records, `done` will get called. fetchNextPage(); }, function done(err) { if (err) { console.error(err); return; } }); What i’d like to do is wrap this example up in a function and return an array of all records. But I don’t see

Hi, Is it possible to return the Linked table children of a table from List Rest call? At the moment a list call seems to return an array of Id’s - is it possible to expand that to include the data from the linked table? The only solution I can see is to iterate through the array of ids and make a Retrieve a Record call for each id of the Linked Field… e.g. in Ingredient below it returns the an array with Id:recEehttf17ZzJYwq… Could that expand to include the fields from the linked table Ingredient? { “id”: “recxTeOfNbAhcTPYS”, “fields”: { “Id”: 1, “Ingredient”: [ “recEehttf17ZzJYwq” ], “Price”: 14.5, “Date”: “2017-04-01T11:44:00.000Z” }, “createdTime”: “2017-04-01T10:40:34.932Z” } Thanks, Andrew

I have developed a Custom App locally, which I am able to run in development mode using block run in my base, however, after running block release, the custom app is not available in the Custom Apps modal, and rather than showing the custom apps menu item, the menu items says Build a custom app, indicating that there are no available custom apps for the base. Is there anything obvious that I might be missing? The block release process seems to run successfully: building copying package.json file copying package-lock.json file installing node modules [npm] [npm] > core-js@2.6.12 postinstall /tmp/airtableBlocks/build/1632423151219/transpiled/user/node_modules/babel-runtime/node_modules/core-js [npm] > node -e "try{require('./postinstall')}catch(e){}" [npm] [npm] [npm] > ejs@2.7.4 postinstall /tmp/airtableBlocks/build/1632423151219/transpiled/user/node_modules/ejs [npm] > node ./postinstall.js [npm] [npm] [npm] > fsevents@1.2.13 install /tmp/airtableBlocks/build/163242

Hey there, Apps should be able to offer a similar pricing model to airtable’s, which is a workspace based pricing model that charges per workspace user. To all app developers, if you’d like support for this too, please like this post :pray: . The following apparently simple features are missing from the current apps sdk in order for us app developers to offer that: Add base.workspaceId to the base model. Without that, a lot of code will need to be developed by apps to try and “guess” and/or ask users if another base belongs to the same workspace and should be added to the same subscription. Add CollaboratorData.isWorkspaceCollaborator or base.workspaceCollaborators so we can enable billing features only for workspace collaborators. Since airtable charges only for collaborators with owner, create, edit and comment permissions, add CollaboratorData.permissionLevel to the collaborator model. Without that, apps will be able to charge per user only after first time app use, after

Trying to add indicated number of days to date via scripting. But the system gives an error. Anyone has any clues about what is wrong? Maybe the DATEADD function is available to formulas only and is not available for scripting? ReferenceError: DATEADD is not defined Code: let current_date = new Date(); let date_added = DATEADD(current_date, 7, 'days')

Hey! I am trying to install Airtable block but I end up have these errors: npm ERR! code ENOENT npm ERR! syscall chmod npm ERR! path /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/loose-envify/cli.js npm ERR! errno -2 npm ERR! enoent ENOENT: no such file or directory, chmod '/opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/loose-envify/cli.js' npm ERR! enoent This is related to npm not being able to find a file. npm ERR! enoent I am using 14.7.6 node on a Macbook M1 with Big Sur. I have tried out the other solutions here but nothing worked for me! Can anyone help me out?

Hi, I have a few automations that do things like set default values for new records and one that randomly generates something. They work fine if I’m adding new records in manually but if I import a bulk CSV with 10,000 records then I get loads of emails complaining that the automation failed. But when i check after a few hours all the defaults are set and everything that needs generating has been. I think what happens is that it sees that there’s so many records and whilst its automating away its complaining that there’s too many to do. This isn’t too annoying as it still works I just get a load of emails I need to archive. But if it genuinely breaks I don’t realise for a while because I just thought the automation failure emails where from someone else doing a bulk upload. In short could Airtable make it so automation failure emails only fire when it actually fails not just when there’s a lot to do and if possible could the error emails contain a bit more debugging info on what went w

I’m having a little trouble with a script I’m using to update a date field in Airtable with data from an API. The API I’m using gives date/time info most of the time. Every once in a while it’ll output a string like “UNKNOWN,” which brings the whole thing to a grinding halt. I’d like my script to be able to skip trying to enter that in and move on to the next iteration in the loop. I’m feeding the data it gives me to a Date() function to save it as a new variable, then I pass that variable to table.updateRecordAsync(). But when the data is a string that can’t be parsed into a date, I get an error saying that the Airtable can’t store that string into a date field. Which is totally accurate and fine, but it halts the whole script. Is there a function/operator or something to check whether a variable/constant/piece of data is in a format that Airtable will accept for a specific kind of field? Thank you!

Hey Everyone, I am trying to understand why is TestDriver returning a “is not a constructor” error. Here is a snippet of the code. import React from 'react'; import TestDriver from '@airtable/blocks-testing'; import roninRecord from '../tableSample/RoninAccount'; import { getRoninAddress, } from '../frontend/Helper Functions/airtable/func'; describe("Get Ronin Address",()=>{ let testDriver = new TestDriver(roninRecord); it("Should return a list of all ronin addresses",async ()=>{ expect(0).toBe(0); }); }); I can confirm I have installed the packages. Unsure what could be the issue. I appreciate any advice :pray:

I am trying to update the Single Select value with an update query. I am tacking the value from another single select field. Values are exactly the same, but it doesn’t update for some reason. Has anyone got the answer to how to do it? But I get an error: Error: Field "fldax5f6gPgS23wMU" cannot accept the provided value. table.updateRecordAsync(${inputConfig.record_id}, { single_select_field: another_single_select.name})

Hey @Taylor_Savage and @Emma_Yeap, The block cli v2 docs state the following: Using code from other directories The new CLI allows this method of code-sharing by allowing “sibling directories” outside the source directory to be bundled. Those other directories can include npm imports based on link or file. What does this exactly mean? More specific setup / how-to instructions and an example repo demonstrating that would be very helpful. Thanks, Ronen Eazyapps

I’m noticing that I can’t use the Airtable API to create/edit columns of type Date. I’m using JS, and when I send in a date, I get the following error: {"error":"INVALID_VALUE_FOR_COLUMN","message":"Field timestamp can not accept value 2018-09-11T17:42:38.000Z","statusCode":422} However, it seems from your documentation that this is exactly how you’d like me to pass a Date string (ISO 8601 formatted date) UTC date, e.g. “2014-09-05”. Any help/ acknowledgment of a bug would be greatly appreciated! Seems like a pretty core piece of functioality to not be working correctly

I’m not too sure where I’m going wrong. The Javascript examples I’ve read indicate that this should work, but Airtable isn’t processing them as I’d hoped - and judging from the results I’ll need to modify my script somehow. Although the Automation triggers at the correct local time, it certainly doesn’t pass the local time as an input into the script - which isn’t a problem so long as we can easily process it to the correct time within the script, which is where I’m stuck. //Trigger executes 7am daily and provides the _input_date to the script, but it is using yesterdays date (even though Airtable trigger states it is using local time?), so attempting to align it with local time via JS below let rightNow = input.config()._input_date; var date = new Date(rightNow); let today = new Date() let string = today.toLocaleDateString() let correct = new Date(string) console.log(date.getTimezoneOffset()); console.log(date.toLocaleTimeString('en-AU')); console.log(correct) Appreciate any hel