Development & APIs

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.

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 consider

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 th

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!

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 (co

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