Development & APIs

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

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!

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.

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

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

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

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.

Hi everyone! May be a confusing title but here’s my issue: I am using Airtable API to build in Appgyver. I am trying to use the filterByFormula to pull records with a specific linked ID. However, it was suggested to me in another forum that the reason it’s not working is that the ID is being returned as a list rather than an object (see below): I thought the reason it was showing as a list was because I initially had it to be able to link to multiple records, but then I changed that to single record and it still show up as a list with the brackets. IS the advice I’ve been given correct? And if so, how do I change it to show as an “object” so the filterByFormula can find it?

Long story short, I’m caching hundreds of images before showing users the home screen. This way I’m not calling the records with each click and there’s no delay… The app loads every record, every time on a highspeed connection but on slow WIFI, I’m getting errors or time-outs which causes the content not to fully load. Do I need to add 1 second delays after every 5 records because of the limit per-base? Or is there something else that could cause this? Here’s a screen recording of the app loading successfully. You can see the “image loaded” print strings in white, then I’m logging what has completed in green. Maybe it will help illustrate something I’m doing wrong. Thanks! https://dl.dropboxusercontent.com/s/iwzvocmu42mdzqf/fast_loading_question.mp4?dl=0

Hello community! I’m very new to Airtable and colleagues of mine - who are using Airtable very intensively - are using one of the communities’s script automations to create a child table linked to a parent table with a number of entries that is controlled by a “on-run” string-input from the user that originally has triggered the automation by clicking on a button at a given row in the parent table. The script is “Multiple records w/prompt”: What I’m trying to achieve is that, instead of waiting for the manual input from the user during execution to determine how many entries the script should create at the child table, as per line const newRecordCount = hardCoded.newRecordCount ? parseInt(hardCoded.newRecordCount, 10) : parseInt(await input.textAsync(‘Number of records to create’), 10); I would like to use the value of a field (column) that actually contains the number of entires to be created in the child table. More precisely, in the first row of this example: after pressing the bu

Hi, I’m looking for an app to build an Airtable Web App/Website, where the user can order directly from the application, with an add to cart button and thus a global cart payment. I’m currently using Soft and I’m new to it. There is the ability to add a payment button but the user has to pay for each product separately. Maybe I should create an Automattic table for the orders so that I can calculate the global amount, instead of ordering each product, and thus create a payment button for the global amount. Is there a simpler way to do that? I’m stuck

I have a table that in addition to other fields has an identification id. This table is automatically populated by a Make scenario (Integromat). Is there any way to configure in Airtable that if the field already exists when Make makes the call it is not created and duplicate the record? Thanks

I am running into an issue where the records that I’m updating with the app on the iPad are not getting updated in the actual base. Let me explain. I use Airtable to inspect products. I have fields for photos, multi select fields, note fields etc. the record already exists in Airtable and I search for it and update it. Sometimes when I update it, the iPad will act like it’s updating everything as I’m doing it but not actually update in the base. I am typically running 4-6 mobile devices in different tables at the same time all working on different records. Does the Airtable app make a api call and is it possible I’m hitting the 5 per second limit? Is there something anyone can recommend trying? Thanks.

Is it possible to pass a variable to a base in the URL? I’m looking to send a URL to a client, embed their Account ID in the URL, and then have them be able to click a URL or button that also includes that Account ID, so it would need to be accessible in formulas and buttons.

I have most of my app built in AT and I’m loving it but I have hit a snag. I was using Zapier Dev console to authenticate with Oauth2 with the intention of posting XML but it only allows JSON for some bonkers reason. So that solution has hit the breaks. My feeling is that I no longer want to use a third party connector and will instead use the scripting app to authenticate and then output the XML direct from inside AT itself. If that isn’t possible then I was looking to use Google Sheets/App Script as a go between. I did look at the API solution, Datafetcher but haven’t had a response back by email so not sure it’s there thing. Any advice or devs who can solve this and I’m all ears/yours.

Hi all, I’ve been using Airtable for a few years and have finally decided to try my hand at writing a few scripts to streamline our workflow. I’ve coded a fair amount before but am new to JavaScript, so please excuse my ignorance. My current project is writing a script that will be called from a button field. This script will make a request to a taxonomic database, retrieve classification data for a single creature, and populate a series of self-linked columns within the table. I have a working script that gathers the data and reformats, but I’m stumbling across the last step of assigning data to the linked fields. Throws this error after the last line: Can’t set cell values: invalid cell value for field ‘kingdom’. Cell value has invalid format: must be an array. Linked records field value must be an array of objects with property ‘id’ corresponding to linked record id. I understand that the issue has to do with needing the data to be formatted as an array for linked fields, but I’m

Hi everyone, I want to use metadata API to get details of all the bases used in my project. I hit the following API with my auth token- https://api.airtable.com/v0/meta/bases Reponse- {“error”:{“type”:“NOT_FOUND”}} Kindly help and do let me know if something is missing from my end. Thanks in advance!

Hi community! I’m setting up a script so I can mark order line items as “Delivered” by ticking a checkbox on the order tab. I’ve find a really useful post where a boiler template of code was provided (can’t seem to find it back). // Setup const config = input.config() const ordersQuery = await base.getTable("ORDERS").selectRecordsAsync() const orderLinesTable = base.getTable("ORDER LINE ITEMS") const orderLinesRecords = await orderLinesTable.selectRecordsAsync() const checkedOrder = ordersQuery.getRecord(config.recordID) // Collect linked tasks and find those that aren't checked let orderLines = checkedOrder.getCellValue("ORDER LINE ITEMS") let uncheckedTasks = orderLines.filter(linkObj => !orderLinesRecords.getRecord(linkObj.id).getCellValue("Mark As Delivered")) // Build array of updates let updates = uncheckedTasks.map(linkObj => { return { id: linkObj.id, fields: { "production_status": DELIVERED (PARTYSPACE) ✅ } } }) // Update t

Hi, I’m looking for an app to build an Airtable Web App/Website, where the user can order directly from the application, with an add to cart button and thus a global cart payment. I’m currently using Softr and I’m new to it. There is the ability to add payment button but the user has to pay for each product separately. Maybe I should create an automattic table for the orders, so that I can calculate the global amount, instead of ordering each product, and thus create an paymetn button for the global amount. Is there a simpler way to do that ? I’m stucked

I would like to use a scripting automation to check if a record exists. i.e. Does John Doe exist already in the Name column? The results should be simply yes or no. I’m not great at scripting and am looking for some fast track help!

Is there a way to duplicate a base with the API?

Hello, Given: var Airtable = require('airtable'); var base = new Airtable({apiKey: 'YOUR_API_KEY'}).base('app6wt6DBFn40vPRg'); base('Project List').select({ // Selecting the first 3 records in Master List: maxRecords: 3, view: "Master List" }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function(record) { //do stuff }); fetchNextPage(); }, function done(err) { if (err) { console.error(err); return; } }); How can maxRecords be determined dynamically via an API call? Is this the only way? Get the number of records in a table via API API Yes, a webhook with a script action. Even with a very full table, this will run in about 5s, whereas, an API process might require 15 seconds or more and will slow even more at scale. I tested the following on 37,000 records with 58 fields. I believe that by selecting fields: you are essentially ens