Development & APIs

I have a field that needs translating into a form that can be used by a second program, but there are some 50-60 options that need translating and the IF statement got huge. Essentially it goes: IF Cell A = “Manager”, “X”, IF Cell A = “Worker”, “Y” … It only needs to be done once, so would it be possible to use a script? The find and replace one looks almost perfect, but rather than replacing the value, I want the new value pasted into a separate cell

Hi Airtable team and community :)! First I want to thank the team for the awesome tool that is the Interface. I love using it (except for a few frustrations, namely the lack of a “duplicate” button or of the possibility to display fields instead of records as the x-axis in graphs). But my main concern today is the ability to share an interface. I just finished a Quarterly Reporting interface with KPIs of an incubator, and we want to share that with the executives of the school we depend on. For now, I understand there is no way to export the interface as a PDF or to share it with a link as a webpage instead of these busy important people having to create an Airtable account. I was wondering first if tricks exist to solve my problem overnight, and second if these features were planned? Many thanks in advance, and once again, congratulation for this amazing feature. Best, Tanguy

I’m looking for to connect Airtable to a PrimeTrust account to be able to do automatic ACH/Wires withdrawals, having a difficult time to connect to PrimeTrust API. What i need to do An Airtable automation that with just clicking on a button we can create and send the txn (withdraw funds to a third party) with our Primetrust account Create the script that performs this task -Primetrust has a sandbox option, that I believe it’s not necessary to have actual credentials Please guide to write script for this scenario as i am unable to so. I have less knowledge of how to write script for api calling and performing different actions.

Hi, I’m building a custom app for Airtable. The app interacts with my web service via REST API calls. I’d like those API calls to be authenticated. In other platforms, the integration layer has a function you can call to get a cryptographically signed document that contains the user’s account information. For example, as a Google Sheets addon, you can call ScriptApp.getIdentityToken to get an OpenID Connect token with the user’s information. Airtable almost has this – the useSession hook returns the current user’s ID and email address. However, they are returned just as plain strings. This is not sufficient for authenticating the user, because anyone could claim to be a user just by knowing their email address or

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

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

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?

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:

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 somethi

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.

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'}}

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!

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.record

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:

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!

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.

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

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

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?

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:

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

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();

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

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

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.