Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,658 Topics
  • 11,711 Replies
3658 Topics
M
mkay232New Participant
asked in Development & APIs
Record template from record picker

Hallo, i have a problem with the script. i would like a template with next actions for a project with record picker function. but the problem is with my script, i have two projects with the same name always after the script. one project is empty and one projects with the template actions. Problem is the projectid var. The script create always a new record. Can someone help me pls with the syntax? // pick tables from your base here let projects = base.getTable(‘Projekte’); let tasks = base.getTable(‘Next Action’); // prompt the user to pick a template for our project output.markdown(’# New project’); let record = await input.recordAsync(‘Select a record to use’, projects); if (record) { // Customize this section to handle the selected record // You can use record.getCellValue(“Field name”) to access // cell values from the record output.text(You selected this record: ${record.name}); let projectId = await projects.createRecordAsync({ ‘Projekte’: record.name, }); await tasks.createRecord

61
A
M
M_kInspiring
posted in Development & APIs
Airtable Image Limit?

Hi Airtable! I seem to have alot of questions lately, I hope to give back, too. I am trying to upload Google Drive images into an Airtable record (one image per record), using Integromat. I want to know what the image limit is, per day, since it stops uploading images, after a number of records. Thank you, Mary

70
M
F
Faculty_SchedulKnown Participant
posted in Development & APIs
SharePoint v2 REST API Calls

Has anyone been able to successfully integrate the SharePoint v2 Rest API into their scripts? I am looking into it and it uses Oath v2 to authenticate and generate an access token, but the token expires in 12 hours. The problem I think I will run into is that I can generate an access token the first time outside of Airtable, but it really is of no use if it expires in 12 hours. Does anyone know how I can have an access token that doesn’t expire in 12 hours or generate a new access token without needing user interaction which isn’t possible inside a scripting app or automation script?

20
F
S
Sticker_ninjaInspiring
posted in Development & APIs
Advice on creating a record search component

Hey there! I need to create a component for one of my apps that searches through my records by a couple of criteria corresponding to fields. Is there a better way to do it than just looping thru every record and checking? I have thousands of records. How does the Airtable search app do it for example? Or perhaps someone has already built something open source that I can use? Ideally I’d be able to use something built into Airtable like Interfaces, but they are not quite customizable enough yet. :slightly_smiling_face:

61
kuovonne
T
Tom_WatsonNew Participant
posted in Development & APIs
Filtered Array by another Array help

Hey there, Looking for a bit of help with something that is driving me round the bend! I’ve wrote a script that basically checks staff availability against a general schedule(i.e. days and times of the week they are generally available) , but also checks to see if they have already been assigned on an exact date. I want to then return only available staff. Currently I have two arrays with the names (strings) of the staff who are generally available and then names of those staff who are already booked that day. I’d now like to filter one array(avaliablestaff) by the other (unavailable) and be left with only staff who are definitely available. But when I try something like const filteredlist = availablestaff.filter(name => (!name.includes(unavailable)); Nothing is removed. I put a specific string in there instead (as you can see in the screenshot) and could filter it, but can’t get it to filter by the other array I’m CLEARLY missing something. I suspect it’s something to do with only

42
J
D
David_FiedelNew Participant
posted in Development & APIs
How to move a field of a record with newlines to another table with different lines

I am trying to automate a situation in which a field has multiple lines, each with a newline at the end. The data will be organized in this fashion: title project title title project title etc. Project titles are known key words whereas the titles are arbitrary. with each line, a separate table is updated with that data organized so that the title moves over to that new table and then classified by the project title until there is no more entries. It has been a long time since I programmed in js and just got stuck.

01
kuovonne
S
Suraj_KapoorNew Participant
posted in Development & APIs
Cannot Get Patch Request To Work

article_url = "https://api.airtable.com/v0/appxxxxxxxxxxx/articles/row_id?api_key=APIKEY" data = {"fields" : {"contacted" : "hello world"}, "typecast":True} patch_article_data = requests.patch(article_url, data=data) I don’t understand why the above doesn’t work doing a patch request. I’ve tried many variations, including without typecast. I get the following response. {u'error': {u'message': u'Invalid request: parameter validation failed. Check your request data.', u'type': u'INVALID_REQUEST_UNKNOWN'}}

248
JonathanBowen
S
Sticker_ninjaInspiring
asked in Development & APIs
Should I pass the whole record object into components

Is it better practice to pass only the values you need from the base into child components or is it okay (performance-wise) to pass down the whole record object? For example: function ParentComponent({record}){ const status = record.getCellValue("Status") const date = record.getCellValue("Date") const otherField = record.getCellValue("Other field") return ( <ChildComponent status = {status} date = {date} otherField={otherField} /> ) } vs. function ParentComponent({record}){ return ( <ChildComponent record = {record} /> ) } I’ve been doing the former but its gotten kind of disorganized when I’m using a lot of fields from a record. Does the record object actually contain all the data in its fields or just the method to retrieve them from airtable? Thanks!

110
kuovonne
J
Janene_PappasNew Participant
asked in Development & APIs
Why does this not run in an async function?

I have the following code that runs fine if I put it in the main body of my App but not if I put it in a function. I’m baffled, hoping folks here can enlighten me as to why. When in the main body, it runs through all of the records in the Teams table. When in a function, only the 1st record is updated. The portion I’d like to have in a function is the code inside of the if (allUsers) block. I have other functions that update in loops, what is so special about this one? let teamsTable = base.getTable("Teams"); let teamsRecords = await teamsTable.selectRecordsAsync({ sorts: [{field:"active members", direction: 'asc'}], fields: ["active members", "Included Players"] }); if (allUsers) { console.log("rebalancing"); let lowestActiveCount = teamsRecords.records[0].getCellValue("active members"); console.log("Lowest active count: " + lowestActiveCount); let included = lowestActiveCount - 5; for (let team of teamsRecords.records) { console.log("Changing I

82
J
S
Sticker_ninjaInspiring
asked in Development & APIs
App error screen + "Error: comment count out of sync"

Hello! One of my apps is crashing (showing the “Sorry, an error occurred”) screen intermittently and I don’t know why. What I know: It usually takes a minute or so of refreshing the app before it is able to load. The airtable record data the app references is changing a lot throughout the data so it might be related to that I have been unable to reproduce this error when I am ‘block run’ mode via the CLI. So far I have only seen it happened on the ‘release’ version of the app the browser console says Error: comment count out of sync a ton of times when I open it after the app crashes Does anyone have an idea what’s going on? Thanks so much for your help. Here is a screenshot:

50
S
J
Josh_HaywoodInspiring
asked in Development & APIs
Uploading Attachments with Integromat

I’m hoping to use JotForm to add some functionality for recruitment applications, and having some trouble with Airtable’s attachment field when mapping the fields using Integromat. Jotform is sending the attachment data as a URL, which I’m mapping to the attachment field in Integromat, as below: This successfully adds to Airtable: And creates a record with the attachment. However, it seems that the Airtable is then immediately deleting the attachment! I doesn’t do this when I manually enter the same attachment URL, only when it’s mapped from JotForm. Any ideas or prior experience would be appreciated!

3210
D
O
Oliver_NgowaNew Participant
posted in Development & APIs
How to create a new table through the API?

We send daily surveys and get feedback via sms which we push to airtable in realtime. We should have a table for every survey because they have different questions as the table fields. Currently for every survey we create in our platform, we have to manually create a table in airtable which could be automated. Is there a way through the api to create and update table schema? This would be very helpful.

10
O
J
Julia_Moreno_PeNew Participant
posted in Development & APIs
Does Airtable API and BadgeCert API work together?

Thanks in advance! I’m looking at solutions for creating a database for results from an LMS that integrates with BadgeCert API. Does Airtable work with BadgeCert? Julia

22
J
E
Espedito_Del_GaNew Participant
posted in Development & APIs
Connect to MYSQL database read-write

Hello, I would Connect airtable to MYSQL database in read-write mode. How could I proceed with the API? I don’t want use paid Connector like Zapier and similar, but with a custom connection with the API solution. Thanks in advance

81
E
K
kierstin_wesoloNew Participant
posted in Development & APIs
API to Connect Airtable and Qwilr

Hi Everyone! Does anyone have any guidance/experience on using an API to connect Airtable to another third-party application. In my case we’re trying to use it in conjunction with Qwilr. Does anyone have any guidance on how to accomplish this?

41
ScottWorld
D
David_Allen-Hu1Known Participant
posted in Development & APIs
Any highly experienced developers?

We currently use Airtable for many things, and we love how easy it is to use. We are in the midst of building a custom preschool application/registration system using Salesforce, and I’m wondering if it’s possible to build something like this in Airtable instead as I’m finding everything in SF to be overly complicated (e.g. just building a report with embed is a massive process). Are there any highly experienced developers that can weigh in here? Roughly what would it look like/cost to build something like what we have below? What limitations? We want parents to be able to give us their data/info (e.g. child info, parent info, family info), select available options (e.g. weeks of summer camp), pay a fee for the week(s) they purchased, get confirmation emails…and then also have a portal where they can update their child’s information as needed. Contact: team@therosspreschool.org What we want to build: docs.google.com TRP-SF: Student Application Process TRP-SF S

160
D
S
Sasi_CNew Participant
posted in Development & APIs
Using remove.bg with Airtable Scripting App

Hi I was wondering if someone could help me with removing background for image using remove.bg using the airtable scripting? The previous discussion on this topic did include the completed script to output the file from remove.bg to an Airtable field: Make api call to remove.bg Scripting app Yeah remove.bg is relatively straight forward in the end //get the url of the attachment field let angle1Url = angle1[0].url console.log(angle1Url) let response = await remoteFetchAsync('https://api.remove.bg/v1.0/removebg', { method: 'POST', body: JSON.stringify({ "image_url": angle1Url, "size": "full", "scale":"90%", "bg_color" : "white", "type": "tiff", "output": "angle1.tiff" }), head… Look forward to your feedback!

243
Justin_Barrett
F
FinAll_Core_TeaNew Participant
posted in Development & APIs
How do we make an API call to an external API in the script automation of airtable?

I am trying to call an external API endpoint using the script in the automation functionality of airtable but the following code gives me an error. var xhr = new XMLHttpRequest();

1121
F
R
Rohan_Mathews_MNew Participant
posted in Development & APIs
Automating merging duplicates

Hi, I am looking for a script which allows me to merger duplicates records. In essence to automate how duplicates are removed when using the Dedupe app. Any help on the same would be much appreciated. Thanks

112
A
M
my_mferNew Participant
posted in Development & APIs
Attachment uploaded via API doesn't work

Hello, After many messages from the community, it appears that the bug is still not fixed: sometimes, without clear reason, API calls to create or update attachment fields of records, passing them a publicly accessible URL… doesn’t work. Happy to elaborate and provide the support team with API calls etc. if needed. This problem is driving me crazy - please help! Thanks

503
B
A
Austin_AdamsParticipating Frequently
posted in Development & APIs
Push One Button to update 2 single select fields via scripting app

So I’m completely new and underqualified to be writing scripts at this point but I’d like to push a button to trigger a script and have 2 (or more once I get the concept) fields change to certain preset values. I’d like to use this in some interfaces I’m creating to streamline a key process. I’ve started off with the “update single select field” template that airtable provides but I’m having trouble figuring out how to make the output change more than One Field at a time.

82
A
H
Hillary11New Participant
posted in Development & APIs
"Create records from multiple select field choices" script

Hello! I am a first-time poster using the following template script which is part of the Airtable +Add an app section (script below). I am using Airtable for hiring. Within my Applicants table, I have people (field name: Applicant Name) who have applied for multiple positions (field name: Active Positions Applied For) of which some are under consideration (field name: Active Positions Under Consideration). I am looking to automate rejection and advancing to next stage emails but am running into difficulty with the following scenarios due to multiple selection: Candidate applies for 2+ positions, of which 0 are under consideration – want to send separate rejection emails to positions applied for (current automation sending as one combined email only) Candidate applies for 2+ positions, of which 1 is under consideration – want to send rejection email to position not under consideration only Candidate applies for 2+ positions, of which 1 is under consideration and then later no longer un

2916
Alexey_Gusev
matt_stewart1
matt_stewart1Inspiring
posted in Development & APIs
Button script to record todays date based on value of a single select field in corresponding date field

I have a status column for the stage a project is in. I tried using automation to record todays date when a stage is changed. However this is problematic as sometimes people select wrong stage for a split second and the system records that date. I explored having automation overwrite that date, but it still creates problems either route I go. So I would like to safeguard it by forcing user to click the button field next to the status field to confirm/submit. So the idea is they select status they are starting today, and click the button. The script should then check the status field, and based on that value record todays date in the corresponding “actual date” field. Is someone able to modify the below script to give a baseline of how/where I can enter the multiple status options it might find and the corresponding date fields to record to? const config = input.config({ title: "Timestamp with Button", description: "Use the associated Button field to fill Timestamp field with cu

173
kuovonne
M
M_kInspiring
posted in Development & APIs
Looking For Someone To Help With Airtable

Hi Airtable! I am looking for someone to help with my Airtable base (at lest 2,000 records) and Integromat. It’s a basic setup, but I need help with filters and I have 2 unique keys, in one base. Mary

00
M
G
GREG_Witkamp1New Participant
posted in Development & APIs
Duplicate record and specific linked records

I’ve seen a few posts about duplicating records and their linked records with scripting, but none showing an example. Does anyone have some example code that will duplicate a records and it’s linked records, and update the association of the linked records to the new record? Use case: I’ve build a quote with multiple line items (linked records). I want to create a variation of the quote by creating a duplicate of the data set, quote and line items linked to the quote.

234
G

Badge winners

Show all badges
Terms & Conditions