Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,657 Topics
  • 11,709 Replies
3657 Topics
J
Josef_WinstoneNew Participant
posted in Development & APIs
Google Sheets Script

Hi guys, Totally new here, moved from google sheets today. I’m looking to build a restaurant delivery app with an Airtable backend. I currently have a script I made on GS that pulls an address from one cell & calculates it’s distance in km to a predetermined address in the script (restaurant address). To what extent can I just copy this script over? Haven’t seem to make it work yet! Thanks in advance, Josef

53
B
G
GreysonParticipating Frequently
asked in Development & APIs
Connecting to the API from Codepen

I’m trying to connect to the API with a private code playground such as Codepen for quick experimentation. I’ve added the retrieve script to the JS editor: var Airtable = require("airtable"); var base = new Airtable({ apiKey: "key123" }).base( "app123" ); base("Base").find("rece123", function (err, record) { if (err) { console.error(err); return; } console.log("Retrieved", record.id); }); But I get this error: Uncaught ReferenceError: Airtable is not defined I’ve tried linking to the Airtable CDN but that hasn’t worked. What else am I missing to get this to work? Is there a simple way to get Airtable running in a JS editor in the browser? It’s private so the API key is protected. Here is a sample pen (not private with dummy key) https://codepen.io/meowpower/pen/eYJNoXK?editors=0011 Thanks in advance

112
G
H
Hunter_ParenteNew Participant
posted in Development & APIs
(Error) A: Cannot deserialize 15

Hello, I am working on writing a script for work, and as of about a week ago I ran into an error that I can’t seem to wrap my brain around. From what I can tell this doesn’t appear to be a standard JavaScript error, and I am concerned as to whether or not this correlates to some sort of change the Airtable development team may have made on the backend? Up until about a week ago a TypeError was causing some hangups, then this arose spontaneously without any changes to my code. Below is a screenshot of the error being thrown:

32
S
V
Viken_ToramaniaNew Participant
asked in Development & APIs
Get User ID from field - Block

Hello, I have a field where I have a list of collaborator. I’m developping a block and I would like to get all the users ID from my field of my table. Currently I can get the name of the collaborator with : const base = useBase(); cont table = base.getTableByNameIfExists(“name_of_the_table”); const value_user = my_record[0].getCellValueAsString(“Name_of_collaborator_field”); I got the name of all my users in the value_user But now, I would like to get the list of user ID. How can I got it ? Thank you :winking_face: . Viken

662
V
Kim_Trager1
Kim_Trager1Brainy
asked in Development & APIs
Take away time stamp from ISO date

I’m trying to format a bunch of date ranges to be used in WORKDAY(). I created a script that collects these dates from a base and have them converted to iso-dates. However all my dates has a trailing time stamp of T00:00:00.000Z. Wondering if there is a quick way to omit of the time stamp so it’s only YYYY-MM-DD?

522
Kim_Trager1
Kim_Trager1
Kim_Trager1Brainy
asked in Development & APIs
Shouldn't await only be able to be used inside async functions

I’m new to JS and been playing around with the scripting block, quite alot. I’ve been wondering about the use of the await keyword. I think i learned somewhere that await can only be used to consume promises inside async functions. Await is used in the main code. Is it me who is wrong or is the script block one big async function?

202
Kim_Trager1
K
Kawika_ButtelNew Participant
posted in Development & APIs
Can't get it to filter through the list in my linked records

I’m trying to submit a url query with a filterByFormula to return only dealerships that have the specific brand in them. The brand side is linked, so it’s in a list on the return response and it’s by record ID. How do I build a filterByFormula that will look into a list instead of just the 2nd level value within fields?

36
kuovonne
S
Srishti_JainNew Participant
posted in Development & APIs
Duplicate Entry Automation

Can we automate in a way where we can delate the duplicate entry in airtable on the basis of time stamp or the previous entry?

11
Justin_Barrett
M
MikeBrownNew Participant
posted in Development & APIs
Copy values from one table to another

When I add a new row in X table and click te button a script would copy all rows from /table into table. Is it possible with using script? I developed a script like below but it doesn’t work.

84
Justin_Barrett
O
Olpy_AcafloInspiring
posted in Development & APIs
How to get around of npm install (pip install) usual scripting practices in context of AT Script-BLOCK?

Back to Script-Block, I have recent memories of very regular python practices like: creating an environment (VENV); PIP install a library of my choice inside this VENV; importing that library into my python code; using it in my python code so I don’t have to rewrite it myself! My python is a bit in the fridge in favor of airtable Script-Block. Admitting that you can’t use DOM-Manipulation js code, I nevertheless wish to call one or the other available js Code Git by calling it from my own js code which must run in this block. Please read on to see what I imagine doing like this. Let’s suppose I would have got the RAW js code from a small library called dspmath.js or dspmath.min.js which would not call any dependencies. (this case is purely imaginary for the moment.) Let’s suppose that I didn’t steal this code and that I intend to use it under the conditions allowed by its rightful owner. Suppose that I plan to copy it within my code, preferably in a minified version so as not to be to

375
B
G
Gustavo_ZomerNew Participant
asked in Development & APIs
How to get linked field table id?

Is it possible to get the linked table id from a Field? I was looking at the Field docs and I couldn’t find anything. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. I tried using the options property, but there is nothing in there. Many thanks, Gustavo

90
R
S
Shane_TurnerNew Participant
posted in Development & APIs
Airtable.NET & Unity Android Build Not Paginating

Hi there, I’m having some trouble getting all of my records via a C# API (Airtable . net). I’ve posted this in their forum and gotten in touch with Airtable Support - but got advised to message here. I’m using Unity to build a mobile app that uses Airtable integration - and I’m building to Android. I wanted to find out if there’s perhaps something I’m doing wrong (or if there may be a limitation of my android build)? On my PC, I run my script to List the Records (173 in total), and it does so without issue. I can’t seem to upload a screen shot here - but on my device, despite logging out the right offset it doesn’t ever get the remaining records.On my PC, it works 100%… just not on android. I’ve tried splitting out the method, to call itself again with the offset parameter (instead of using a doWhile loop) - and I get the same results. And then I just recently tried running the method, getting the first 100 records, then waiting 2 seconds and attempting the remaining records (also wait

204
R
A
Alexia_LafitaUNew Participant
asked in Development & APIs
Import contact form from Wordpress to Airtable

Hi there :sunny: I would like to automatically import contact forms from my Wordpress site to Airtable (prospect view). Do I need a special plugin? If someone has already implemented this workflow, I would be happy to get your advice :slightly_smiling_face: Thank you so much in advance for your help. Have a very nice day. Alexia

70
A
Jen_Rudd
Jen_RuddInspiring
posted in Development & APIs
Link Record by Email

Hi There! I am just trying to jump in as we are working on data migration for a client. I need to be able to take a table (“Job Applications”) and search for a record in another table (“Applicants”) using a field (“Email Address”) as the lookup. Once the record is found, I would like to link the (“Applicants”) record to the (“Job Applications”) record. I have 10,000 records to scrub, so my current zap is laughable. Thanks for your help!

34
Jen_Rudd
M
Michelle_ValentInspiring
posted in Development & APIs
Looking for team members for the $100,000 Custom Blocks Contest? (Ending July 6th)

While you can participate as an individual, sometimes it is more rewarding to do things as a team. If you’d like to find a team member to participate in our $100,000 [Custom Blocks Contest] (Airtable Blocks SDK), chime in here! The contest platform makes it easy to submit entries as a team. To recap, the platform team is offering big prizes for the best blocks in three categories: Blocks for Business Teams (5 winners) Blocks for Education or Non-Profit (2 winners) Wildcard (2 winners) The contest runs until July 6, 2020, so head over to Devpost now to get all the details and register: https://airtable.devpost.com/

30
M
M
Mark_HamiltonNew Participant
asked in Development & APIs
Retrieve all data from table without any filters

I am trying to retrieve all records from a table. The master view has filters on it that have to stay there for other business users, but I would like to retrieve all records without the filters with the API. More specifically, the table is filtered to records added in the last week, but I need all of the records from the beginning of the table. Is there a way to use the API to get all records even if the table in the browser has filters on it?

152
M
A
Adrian_HeadKnown Participant
posted in Development & APIs
Expanding on Creating Multiple Linked Records Based on Mumeric Field

Hi @kuovonne, I found your script in the below thread incredibly helpful – Thank you so much this is a game changer for me! https://community.airtable.com/t/weekend-scripting-block-challenge-and-1-000-prize/28074/9?u=adrian_head I’m curious if you might be able to help me make an adjustment to the script for a specific use-case which I think it broadly applicable to people needing to use a script similar to the one your created above. I have translated my problem to match the verbiage in your Cake order example to make things more clear. You can find the link to my example base here for your reference. Context: Right now the number of New Linked Records I am creating in my Cakes for Creation table is dependent on a Count Field which is adding up the number of Items linked in the “Cake Types” Field (See examples below): Count Field Creation: Example as Field: In your example, rows created by the script in the “Cakes” Table are created based off the number of cakes in the “Orders” Tab

62
A
N
Nick_Bergthold1New Participant
posted in Development & APIs
Script to send selected record to Zapier/Webhook when ran?

I’d to send selected records in Airtable to Zapier in order to push the record’s data to another platform. Ideally, the user could select one or multiple records in a table view, click Run on the script block, and the process would occur. Can anybody point me in the right direction on where to get started?

135
B
A
Ashwin_PInspiring
posted in Development & APIs
Mobile friendly documentation site

To: Airtable folks: I see that the documentation site is not mobile friendly. I usually read it on my phone and find it very hard to navigate. Please consider making it responsive.

00
A
A
aMackdawgNew Participant
posted in Development & APIs
POST with alteryx & returning 'validation' and 'fields not found' errors

Preface: this is the most frustrating API to POST to I have ever worked with, it’s incredible. I am attempting to POST a new record using Alteryx (a workflow tool with cURL’ish functionality) and I keep getting 1 of two errors: {"error":{"type":"INVALID_REQUEST_MISSING_FIELDS","message":"Could not find field \\"fields\\" in the request body"}} Or, when I re-aliased the alteryx field from “data” to “fields” - {"error":{"type":"INVALID_REQUEST_UNKNOWN","message":"Invalid request: parameter validation failed. Check your request data."}} Here is the data I am POST’ing: '{ "fields": { "Program Name":"Education Test", "Category":"Education" "External Id":"a00ie00QA4" } }' This exactly conforms to Airtable’s spec and I am still getting errors. Do you have any suggested approaches for troubleshooting or resolving this? Edit: worth pointing out that I have been able to successfully POST using Postman, but I am blocked when I am trying to “Productionalize” this in alteryx

223
O
K
Kelvin_RamirezNew Participant
asked in Development & APIs
Create Record With Query Parameters

Hello! I have a program that can make API calls via HTTP Request but you can only input URL’s. Is it possible with the Airtable API to create records using just a URL with query parameters? Everything I’m finding says to use curl but that’s not possible with the software I’m using. If not is there a service that my software can send a URL with query parameters to and then it takes it and executes the proper curl to Airtable? Maybe Postman? Thank you.

254
A
O
OnurKnown Participant
posted in Development & APIs
Possibility to "run" scripting blocks via API &or time scheduled?

Hey Community, Is there the possibility to A. Let a script run via API? B. Give scripts a(n absolute) “time reference” in order to let them run in some kind of scheduled time frame? Feedback appreciated & Thanks in advance

35
B
D
Dan_James1New Participant
asked in Development & APIs
Check for existing value when creating new record

Hi all. Total AirTable newbie here, and I’m hoping someone can please point me in the right direction. I’ve started working with a charity that uses AirTable to track requests that members of the public file for COVID-related assistance. There are two tables involved specifically in what I’m trying to achieve: Requests and Requestors. The person making the request fills out a WordPress form with name, postcode, etc. which are fields in the Requestors table and details about what they’re requesting from the charity; these are fields in the Requests table. Within the Requests table, there is a field which is a link to the Requestors. We end up with a lot of duplicated rows in the Requestors table if people make multiple requests. What I’d like to be able to do is intercept the form when it’s submitted, check to see if there’s a criteria match in Requestors (say on name and postcode) and if so, assign it to the existing requestor. If there is no match, then it would create a new requestor

30
ScottWorld
K
Krishangi_GoswaInspiring
posted in Development & APIs
Get actual records instead of record_id using Python requests library

Hello Community, This is how I am getting the records using the Python requests library: How to get more than 100 rows using Airtable API in Python using offest? But some fields only show the “Record_id” instead of actual values. I hit a wall trying to find solutions to this. How do I resolve this? Any leads would be appreciated. Thank you in advance!

174
K
R
Rutvik_PatelNew Participant
asked in Development & APIs
To-do List example throws can not read primaryField on null

I just cloned the to-do list example to get familiar with blocks and it starts with a can not read primaryField of null when compiled. It’s a small fix with the code i found, this is just if anyone else finds it also for the airtable team to update their sample code. Since there is no table selected in the beginning of the list table is null therefore need to add in a check for table present before calling table.primaryField. const records = useRecords(doneField ? view : null, {fields: [table ? table.primaryField : null, doneField]}); {fields: [table ? table.primaryField : null, doneField]}); update this object! Thank you!

30
E

Badge winners

Show all badges
Terms & Conditions