Development & APIs

Hi, I’ve tried installing and launching a hello world app from the documentation for the first time today. I encountered a few issues initially trying to install the CLI, however I eventually seemed to get it working. The issue I’m having now is with the ‘block run’ command - after successfully using block init, the block run command leads to a large amount of errors which seem to stem from a few files not being found during the start of the process: /Users/craigronald/.nvm/versions/node/v13.14.0/lib/node_modules/@airtable/blocks-cli/transpiled/src/builder/node_modules/yaml/index.d.ts: Cannot read property 'get' of undefined /Users/craigronald/.nvm/versions/node/v13.14.0/lib/node_modules/@airtable/blocks-cli/transpiled/src/builder/node_modules/yaml/types.d.ts: Cannot read property 'get' of undefined /Users/craigronald/.nvm/versions/node/v13.14.0/lib/node_modules/@airtable/blocks-cli/transpiled/src/builder/node_modules/word-wrap/index.d.ts: `export =` is not supported by @babel/plugin

I’m trying to delete duplicate records from a table. I have table “Table1” that contains linked fields “Field1” and “Field2”. Where multiple records have the same values in “Field1” and the same values in “Field2”, I want to delete all duplicate records that are newest, leaving the original record that is oldest. In the below example (just for illustration purposes), “Record1” and “Record2” have the same values in “Field1” and “Field2”, and “Record3” and “Record4” have the same values in “Field1” and “Field2”. After running the script, “Record2” and “Record4” should be deleted (they’re the newest) and “Record1” and “Record3” should remain (they’re the oldest). [ {"Record": "Record1", {"Fields": [{"Field1": "Value1"}, {"Field2": "Value2"}], "Created": "2020-01-01"} {"Record": "Record2", {"Fields": [{"Field1": "Value1"}, {"Field2": "Value2"}], "Created": "2020-02-02"} {"Record": "Record3", {"Fields": [{"Field1": "Value3"}, {"Field2": "Value4"}], "Created": "2020-03-03"} {

Hi there! I´m developing a chatbot using Twilio and at some point, I need to collect the data inputs from the clients that talk to my bot, and then post it into an airtable base. I don´t have much coding skills, so my guide was this Dabble Lab tutorial: https://www.youtube.com/watch?v=xjt9YhNFrno However, the Twilio function proposed in the video isn´t working. Here is the code: exports.handler = function(context, event, callback) { let member = { name : event.name, email : event.email, date : Date.now() }; var Airtable = require('airtable'); var base = new Airtable({apiKey: context.AIRTABLE_API_KEY}).base('appISrkMnNdL65Lzj'); base('Members').create(member, function(err, record) { if (err) { console.error(err); return; } console.log(record.getId()); callback(null, member); }); }; When I try to make a POST request via Postman, this is what happens in my Twilio Console: And this is the capture of Postma

Hey there, expandRecord is really a great feature because it can eliminate the need for me to develop edit record forms in my apps, but for that to truly be used for that, it needs to accept the list of fields to display. @Taylor_Savage, is there an ETA for that? Related question - anybody knows what view is used to display the expanded record? If I’ll know how to control that, I’ll be able to edit the displayed and hidden fields in that specific view. Thanks, Ronen Babayoff Eazyapps

Hello I am trying to write a script that detects duplicates. Currently the if statement is triggered and it increase i(which tells me how many duplicates their are), even when the two fields do not match. let table = base.getTable(“Policy”); let view = table.getView(“All Fields”); let first = table.getField(“PolicyNumber”); //Lookup Field let sec = table.getField(“PolicyNumber”); let result = await view.selectRecordsAsync({ sorts: [{field: “PolicyNumber”, direction: “asc”}]}); let result2 = await view.selectRecordsAsync({ sorts: [{field: “PolicyNumber”, direction: “asc”}]}); for (let record1 of result.records) { let thedup = record1.getCellValue(first) let i = 0; output.text(thedup) for (let record2 of result2.records){ let cop = record2.getCellValue(sec); output.text(cop) if (thedup=cop){ i++ if(i>1){ output.text(“help”) } } } } This is the output i currently have 12 entires: B0750RNMFP1709519 - 001 B0750RNMFP1709519 - 001 B0750RNMFP1709519 - 003 help B0750RNMFP1709519 - 004 help B

How can we get the particular data to get searched and populated with Airtable formulas for search on the Website?

I have a table 1 “user” linked to a table 2 “event”. Via Post API, the users create any events where I collect de {user.email} like "email": "{user.email}" ]. This is to be able to link users informations in the Event table with lookup. Then, the goal is to display event with a GET request and add event information + users informations. But, the problem is, with the POST request, i can’t send a Text string (le user email so) from the API to the linked field… It necessary to give the row ID matching with the User record from the User Table. Do you have any idea to be able to directly send, via API call, the user email as text ? Thanks you for your help

Does anyone know if you can get babel plugins working with base run? I’d like to use Styled Components and the css prop so I can write quick inline css. Is this possible?

Hi, I’m stuck with one problem. I’d like to send Mailjet email with the Airtable Script automation. I succeed to send a Mailjet SMS with this code : let inputConfig = input.config(); // the input variables in Airtable let response = await fetch('https://api.mailjet.com/v4/sms-send', { method: 'POST', body: JSON.stringify(inputConfig), headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer Mykey' }, }); The problem is that, in Mailjet dev API, they said to use this code for sending Mailjet template : curl -s \ -X POST \ --user "$MJ_APIKEY_PUBLIC:$MJ_APIKEY_PRIVATE" \ https://api.mailjet.com/v3.1/send \ -H 'Content-Type: application/json' \ -d '{ "Messages":[ { "From": { "Email": "pilot@mailjet.com", "Name": "Mailjet Pilot" }, "To": [ { "Email": "passenger1@mailjet.com", "Name": "passenger 1" } ], "TemplateID":

Hi, I am experiencing errors in airtable’s ‘Find a Record’ in Zapier. Does anyone also has the same issues? Can you tell me what have you done to fix it? thank you very much in advance.

Has someone in the community created an Appsheet App sourcing Airtable data, where access is limited only to the data associated with the app registered user (surely a fundamental use case!)? I cannot get it to work. I have created an Appsheet app linked to a single Airtable table. All looks okay after making the initial connection. I have a single list view which displays my Airtable data, completely unfiltered. I then tried to set up the user access restriction. Go to Security section (in Appsheet) and create a security filter where email column in Airtable = USEREMAIL(). Save. And now my app is broken. Message is: Unable to fetch app definition. Error: Data table ‘’ is not accessible due to: Error executing AirTable operation. Status code: 422. When I remove the filter this error goes away. Help!

hey, is it possible to add my Airtable calendar to a Wix website? if so, how?

Hi all! Starting to dig in to the scripting block a bit more… is there a way to force the script to run automatically? Wrote a script to watch a table and make sure everything is linked to the same record on a junction table… but this is rendered useless if I have to train people to hit the button every time they login. :slightly_smiling_face:

I’m trying to make a Block that can detect changes (such as deletes) to the Airtable and notify another service. It doesn’t seem possible to efficiently detect deletes using the Airtable API with the 10’s of thousands of records we have in our Airtables. I have a basic prototype going, the only issue is that the block can’t capture any events from before it loads. So if the block takes a while to load and the user is fast and deletes a few records, the block will miss it. I noticed that there is another function “registerRecordActionDataCallback” that passes in button events that occurred before block is loaded Your block will not receive “perform record action” events until a callback is registered - they’re held until registration to ensure the block is ready to handle the event (e.g. has finished loading). Airtable Blocks SDK Is there anyway to do something similar with records or even cursor. Even if I could get a list of cursor events before the block loads, I’d be able to check

I have created an excel power query to retrieve data from airtable, I would need to expand this to be able to pull from multiple tables which is fine. My question is, has anyone encountered any issues with making multiple data pulls a day from airtable and getting IP address blocked, similar to what can happen with web scraping data?

I have about 4 tables all linked together (Activity, Resource, Activity + Resource junction called ResourceInstance and Calendar). First is an activity/Resource junction to create what I have called a ResourceInstance. This ResourceInstance record is given a quantity and then assigned to one or many dates. I have that ResourceInstance linked to a Calendar table that is what is shown above. This is effectively a junction between ResourceInstance and Date. There is obviously only one record for each date on the Calendar table, but can be multiple ResourceInstances (even with the same Resource) can exist on the same day creating these multiple values in each column. My end goal is to prepare this date for visualization in bar/line charts, grouped by Resource, not ResourceInstance. (i.e. LaborCrew 1 usage for each day, with many different activities using it, often on the same day.) With this in mind: –What integration would work best for charting over time (by day)? (AirTable charts seem

The strangest things happens when I execute the simple below script in Airtable. Does anyone know why it just stops after 15 created records and does not finish up to 50? let table = base.getTable(“Clients”); for (let i=0; i<50; i++) { table.createRecordAsync({“Number”: i}); }

Hi, I am definitely not a coder, so hoping I can find some help here. My goal is to search for specific text somewhere within a field, and if it’s found, then replace the entire field with a specific string. Specifically, if it finds “UPS” or “FedEx” anywhere within the field, replace the entire field with “Shipping & Delivery”. I started with the Find and Replace script that I installed from the Marketplace. This script replaces the text you are searching for with alternative text within the string, So, if my input field has “UPS Store #12345”, it will produce “Shipping & Delivery Store 12345”, rather than setting the field to “Shipping & Delivery”. I tried modifying this line: let newValue = originalValue.replace(findText, replaceText); to somehow replace the entire field but I just can’t get it to work. Any help would be appreciated!

Not sure if I’m missing something obvious, but was wondering why is Airscript.dev listed with the anchor of “airscript tutorials” in the scripting app (Documentation tab, item #4 of “Other Resources”). The site itself says it is neither endorsed nor owned by Airtable. A forum search yields two topics from the apparent owner of the domain, both of which are self-promotions and don’t explain the link. I understand the half a dozen or so marketplace scripts come from third parties but is the scripting app itself not owned by Airtable? Just to be clear, the site is a pretty decent resource but I’m amazed a company with a ten-figure valuation like Airtable would promote anyone for free. And that particular link has some pretty insane promotional value in terms of domain authority juice from Google.

:wave: Hey all, Stephen from the scripting block team here. Today we’re releasing a bunch of updates to the scripting block, based on all of your helpful feedback from the beta. To get access to the latest changes, you’ll need to reload your browser or Airtable desktop app. Note that some of these are breaking changes and you will need to update your existing scripts accordingly — sorry for the inconvenience; these should be the last breaking changes before we launch the block more broadly. Breaking: input.text() and input.buttons() have been renamed to input.textAsync() and input.buttonsAsync() . This means you need to prefix them with the await keyword. Breaking: output.text() is now plain-text only, but accepts values other than just strings. Use output.markdown() if you want to output Markdown. Breaking: all methods will validate their inputs — if you pass input to Airtable functions that don’t match the documented values, your script will now error. Custom script names have

I am looking to script automation that sends a task list to people when a new employee is hired. I am not finding anything on here that is similar. Any suggestions? More Details When an agent is added to the directory, they automatically filter over to my orientation list, once I put them in the “first engagement” stage I want an email sent to 4/5 different people with their specific task. That table is already built out, I will be adding a task list script to create a checklist, but I really want an email sent.

I have a script I want to run to speed up data entry but I can’t figure out how to run it from a mobile device. The button support is too limited on the mobile app. Has anyone been able to run scripts on a mobile device?

Hello, I’m trying to init a custom block for my database but i get this following error whenever I launch the command line block init from any github repo. Initializing block using https://github.com/xavdid/airtable-grouped-chart template ❌ Something failed! Cleaning up... ❌ Error: a.isDirectory is not a function Do you have any idea how i can fix it please ? Thanks in advance for your help BR

Hi everyone, I’m using the Airtable API to get some data and if I send in the same query parameter the options “offset” and “fields”, the “fields” will be ignored. Example: GET https://api.airtable.com/v0/app9T56uFsgbBnwd9/Table%201?fields[]=Name → result ok, only field “name” is in the response GET https://api.airtable.com/v0/app9T56uFsgbBnwd9/Table%201?offset=itrRTMLhF0a3iOmRS%2FrecWISmZwmjg0AeYR → result ok GET https://api.airtable.com/v0/app9T56uFsgbBnwd9/Table%201?offset=itr4KjTfwwdlSSBm4%2FrecWISmZwmjg0AeYR&fields[]=Name → failed! The filter “fields” was ignored Does someone know the reason for this behavior?

Title says the root of the problem. I’m thinking this is because CORS, but I’ve had no luck with fetch or the newly introduced remoteFetchAsync. Finding the same thing with two different APIs: Creating a customer in Stripe (this one works in automation) Creating clients in Toggl The more frustrating issue I’m running into is that there’s no error message or anything I can find in the stack using debugger; - the script exists and there’s simply no output. Could this be because Airtable scripts don’t support “redirect: follow”? If so, is the best workaround to dump all the logic into a cloud function like Google Apps Scripts, Netlify Functions, Code by Zapier, etc?