Development & APIs

I don’t see anything in the Developer docs for Apps or Scripts which has the option of setting a table’s or field’s permissions. There are methods to see if the table or user has permissions to make changes, but none to set them through the API as far as I can tell. Use case: I have created an archive of a large base with many tables for posterity prior to deleting a bunch of data. I’d feel better with the archive copy locked down to prevent any modifications. It would be great to be able to for-loop through the table’s and fields to lock them down in order to prevent record deletion, new record creation, and modification. Is there a way to do this programmatically or only through the GUI?

I’m trying to purge a KeyCDN url in a script and get the following error, “Request cannot be constructed from a URL that includes credentials”.

It’d be great if there was a required?: boolean field on the <Label>, <FormField> components in the apps sdk. When set to true, this would add a red asterisk like the one seen here:

Hi guys :slightly_smiling_face: Happy Friday! I was trying to adapt one of the available scripts. However, I failed badly. Opposite to the script I shared above, I’m using only two tables and in the main, I don’t want to create a template but I want to take a record (only a product name field) from the first table and incorporate it into the second table and assignee this record to a specific client (for that column, I’m using a single select feature). Those two tables are linked to each other by the product name column. In other words, the first table is containing all our products, while the second table contains multiply of these duplicated records but each of these records is assigned to a different client. Each client’s view is tailored and depending on their profile we share only products that are relevant to their profile. As our list of partners is growing, this task is becoming time-consuming as each time we need to perform it manually but with the sort of semi-automation, w

Currently my business is subscription based all through my company’s app with the database set up in Airtable (with payments in Stripe). I would like to add the ability to purchase a subscription from the website as well, and have it connected to the current Airtable database. Is this a doable task for a beginner or better suited for a developer? Thanks Brad

Airtable forms are not sufficient for my client’s need. There are several complex editable PDFs which they need populated from Airtable bases, but the scripting app questioningly denies access to the DOM (which is at least documented), but also the BOM (not documented). I can successfully populate the PDFs, but I can’t do anything with the stream. It would be great if I could open a browser window and dump it there, but without BOM access that is not doable. Any ideas to get around this report generation miss that Airtable has?

Hi all, I have built a simple email automation for our team that triggers upon entering a view. All good there. However, we have one text block in the email that is dependent on the value in a specific field. I have done some digging, and it seems like there should be a way to make this text block appear conditionally, but I am not sure where to begin. I am more familiar with formulas than scripts, but I am guessing an script with an if/then function could work, with something like "If (field X is empty then, " ", “text block”), where I would use the output of the script in the email. Can anyone point me in the right direction, and to where I might find the bones of such a script if this seems workable? Thanks

We have an airtable form that we are embedding into our website via an iframe. Our form is very long and after they submit it we run into weird behavior. Submit a very long form webpage remains the height of the form submission message is centered within that height screen appears to be blank (causing confusion wether the form has been properly submitted) Scroll up you will see the after submission message. Why does the height of the webpage stay the same after the form is submitted? It is causing the message to be “hidden” from view and causing confusion.

Hi! I’ve been wanting to use an map in my database, in a way that it plots every record within my database. However, airtable’s map app requires use to use google API which would be very costly, and I have other ways of getting geocode coordinates of each location. Is there any map solution within airtable that will be fed lat/long and plot it in a map?

Here’s an odd one random records go blank after being created 40 out of around 600 entries. Here’s the kicker it thinks the content is there. Can’t add the linked item because it thinks it is already linked. Add in the OS, the history shows no change just the original entry by the API. Also, could sort by the supposedly blank records

This is killing me. It’s literally the last speedbump in my first Airtable script: I have this command: await email.updateRecordAsync(dateArray[i][0],{‘ActualFieldName’ : linkID}); It works! But THIS… await email.updateRecordAsync(dateArray[i][0],{fieldVar : linkID}); DOESN’T WORK. Even with the single-quotes gone, the system is still parsing my defined and assigned fieldVar as the string “fieldVar”. It’s maddening. Any ideas?

I am new to the scripting platform and what im trying to create is a button that will trigger a script that does the following things. Look at Table - I got this working Look at View - Got this working Results of all Records - i think i have this working via await view.selectrecordsAsync(); Run Loop for ‘X’ number of times. Inside this loop i want to update a specific field (for instance Checking a checkbox) So basically i want to click the button, it goes to a certain view within a table and updates a field of about 100 records, then it will stop.

This hook works well when changing between tables and when deleting a table but not when creating a new table. Example: const cursor = useCursor(); When I create a new table cursor.activeTableId is null and the property is only set moments later. Any solution from the SDK to handle this specific case? Or should I implement some internal logic to wait for this property to be defined?

Hey everyone, been using integromat and trying to find records in Airtable. Is there an option to search for a record using 2 conditions? I want to find the record that has the following 2 conditions (see attached image)

Let’s say I have a table with few rows - each one has a uniq ID Can a button cell have a script that will identify the ID in which he was called? for example - this is my table: id. Button 1 Click 2 Click when I click on the button on the first row - I can see what is also the id of this row.

Hello! I asked here a couple of weeks ago whether my apps are really slow because of the number of records in my table. It turns out that is the case, but I have a couple of followup questions. Is the decrease in performance related to the number of records size of the base or of the individual tables? Is it possible to load a table or base into an app conditionally? And if that is possible, would it even improve the performance of my apps? My experiments so far result in the “too many hooks rendered” error. For ex: const base = useBase(); let records=null; let table=null if(something is true)){ table=base.getTableByNameIfExists('Line Items'); records= useRecords(table) } Any other suggestions for how to improve app performance on large bases/tables? I don’t think I really have the option of deleting records or archiving them in another base because my system of linked records makes it complicated. Thanks so much!

Hello everyone, I am creating a script that will ask the user for a project name and a hand-over date, and then the script will generate a number of records with subsequent dates (to create a Gantt chart, essentially). I want this done through the script because the intervals between the dates is always going to be the same. I am however struggling to find how to add say 5 days to the date I just collected from the user. I can’t seem to find an easy way to do it when creating a new record. Here is my current code… output.markdown('Welcome to the Add-New-Project routine'); let projectName = await input.textAsync('What is the name of the new project?'); let handOverDate = new Date(); if (await input.buttonsAsync("Hand-over date", ["Today", "Custom"]) === "Custom") {let newDate = await input.textAsync("Enter a date: M/D[/YYYY] (Current year implied if not included)") let year = newDate.slice(-5, -4) === "/" ? "" : "/" + handOverDate.getFullYear().toString() handOverDate = new Date(`${ne

Are there any ways to share a script to the public? Or a way to use coding to update Airtable forms? The airtable forms aren’t advanced enough to use for our application. Thanks in advance!

I’m struggling to find anything on the web to teach me how to builds outputs from the API from scratch. Is it a prerequisite that I am already accomplished with Javascript? [I know programming concepts and am a beginner] Youtube and Google have a few sparse videos but nothing like a course I can take that will bring me up to speed quickly.

Hi there - Does anyone have more specifics on how to use AIrtable as a backend? Mostly, I want to create a custom form where the questions and answers shown are based on previous answers and custom filtering that is too complex for views. This is a tutorial, but I am not sure if it’s only a matter of setting up an HTML with a javascript section(I’ve never had a javascript application on a webpage) or something else… DEV Community Using Airtable as backend service The hell of finding the right backend When it's time to write a Single Page Application in...

Hi, I am getting this error for all calls to remoteFetchAsync. j: Error: Non-200 Response Received: 500 Our request, looks like below. let response = await remoteFetchAsync(qbBaseURL+"/v3/company/"+qbRealmId+"/query?minorversion=62", { method: ‘POST’, body: “select * from Customer Where DisplayName LIKE '%”+customerName+"%’", headers: { ‘Content-Type’: “application/text”, “Authorization”: "Bearer " + qbAccessToken, “Accept”:“application/json” }}); let data = await response.json(); Can someone pls assist? Regards.

I created a “sandbox” base to develop this script to create a new hypertext field from a text field and a URL field: When I got it working in the test base, I copied the code into my live base. The field names were different there, so I edited the script accordingly. I ran it and it worked. This script doesn’t run automatically, so after I entered new records, I ran it again to populate the empty hypertext field in the new records. Now the script doesn’t work properly. It calls the text and the URL into the destination field, but it doesn’t format them as hypertext. Here’s the result: I checked that the destination field was long text with rich formatting enabled. The code still works in the sandbox base, so I tried copying it back into the live base (and changed the field names again in the script). Will not work, even if I create a brand new destination field for the hypertext. What could be wrong in my live base that’s keeping the URL from embedding when I’m using the same code

Fetch YouTube video metadata and insert it into each row in a given table. Source code /** * Copyright 2020 Bocoup * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to * deal in the Software without restriction, including without limitation the * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or * sell copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM

Ok, I have this script, but I need to check only for duplicates in the same table. Thoughts on what I need to add to ensure the record pulled is not self linking in linked records? //Define the table and query let jobTbl = base.getTable(“Caregiver Applicants”); let appQuery = await jobTbl.selectRecordsAsync(); //Loop through the records and find the Applicant for (let record of appQuery.records) { let appname = record.getCellValue("E-mail"); //Define linked table and query let applicantTbl = base.getTable("Caregiver Applicants"); let applicantQuery = await applicantTbl.selectRecordsAsync(); //Loop through linked table and match ID values for (let appRecord of applicantQuery.records) { if (appRecord.getCellValue("E-mail") === appname) { let inputid = appRecord.id; //Update field jobTbl.updateRecordAsync(record, { "Additional Records": [{id: inputid}] }); } } } This ends up linking the original record to itself.

Hi all! I’m working on a script that grabs two fields from a table as query parameters in a API GET request, gets the resulting JSON data, and updates the records in the same table for those corresponding queries. I have my for loop running fine when I limit it to 50 records (notice the IF statement) and aware of the 50 record limitation by Airtable. How do I go about refining my script so that it grabs the remaining records? I’ve been banging my head against a wall on how to do this since Friday. Here’s the script I have so far: //Set table for Stage Data let testTable = base.getTable("Test Table"); let stages = await testTable.selectRecordsAsync(); let recordsData = []; //Testing for loop for (let record of stages.records) { let url = `https://apiwebsite?filter[account][customId]=${record.getCellValue("Query Param")}&filter[stage][id]=${record.getCellValue("Query Param")}` if (recordsData.length < 50) { let data = await fetch(url, { method