Development & APIs

Hi I am creating an extended project planning tool. So i create an graph for the project in which the workload per week in presented. For this I use data from a couple of tables (team, standaard uren (standard hours), Init en activiteiten (activities)) In order to create the graphical load per week I need to create subfases per main fase (hoofdfase) What i am trying to do is retrieve the fase + number of weeks in order to write these in the table activiteiten and also teammember from teamleden. I managed to get to work through test2 … But now stuck. Anybody willing to help? or maybe if you need more info, please let me know. //let let fases = [{ fase: "Voorbereiding", startDate: startdatumV, endDate: endDateV, weeken: duurV, id: records[0] }, { fase: "Campagne", startDate: startDateC, endDate: endDateC, weeken: duurC, id: records[1] }, { fase: "Nazorg", startDate: startDateN, endDate: endDateN, weeken: duurN, id: records[2] }]; // await fases.forEach(async (f) => {

Hey everyone, im kinda new in google sheets and google apps script. First i got a code where a sheet is hidden, if the checkbox in a specific cell is checked. function onEdit(a) { var range = a.range; if (range.getA1Notation() == "B13") { var Agenda = a.source.getSheetByName("Agenda"); if (range.isChecked()) { Agenda.showSheet(); } else { Agenda.hideSheet(); } } } Now i got the problem that i have multiple sheets. But this code shall only work in one of the sheets. So i tried two different things: if (activeSheet.getName() !== "Allgemeine Informationen") return; and if (activeSheet.getName() == "Allgemeine Informationen") { ... } Both doesn’t work properly. I also tried to get the value of the function by writing the value of “activeSheet.getName()” in a cell but the cell kept empty. So Long Text Short Question: How can i put an if function that makes the code only executing when the active sheet has the name “Allgemeine Informationen”? Friendly Rega

Hi All, Looking for some guidance as I’m well outside my basic scripting depth. Use case: I have a table of applicants each linked to a group. The groups are listed out in another table and then all the group’s applicants linked in the “group members” field. Each applicant has a field that I would like to compile into a list and email or display with markdown formatting. The goal is that I have a button on the Groups table that allows a user to “generate list” which outputs or emails them the formatted list of the 5-6 group members that can then be copied into an email. Where I’m stuck is I am able to get as far as building an array of the ids for the linked applicants, but don’t know how to then use that array to retrieve the individual field values for each applicant from the applicants table. Script so far is below. Also thanks to those whose scripts I already borrowed/mutilated to get this far. This script is born because the field I’m trying to pull out is a custom hyperlink and w

Hello everyone! I don’t know if I’m missing something, but I would like to know how to get the information of the record that spawned a “When record created/updated” so far for the created I have to retrieve the information by quering the table and getting the latest input(Sorting the table). However it seems to me like inside if the script of the trigger there should be somewhere with out having to do this. Im starting to use this tool so any help would be appreciated! Thanks in advance and sorry if i made a duplicate or if i miss this in the docs!

Hi, I’ve a simple code to move checked record from table to other table: let foraccept = base.getTable(“For Accept”); let plugins = base.getTable(“Plugins”); let result = await foraccept.selectRecordsAsync(); for (let record of result.records) { if (record.getCellValue(“Accepted”)) { await plugins.createRecordsAsync([ { fields: { ‘Name’: record.getCellValue(“Name”), ‘Website’: record.getCellValue(“Website”), ‘Type’: record.getCellValue(“Type”), }, } ]); await foraccept.deleteRecordAsync(record.id); } } My problem is: How i get values from single or multiple select? (Field “Type”) → ‘Type’: record.getCellValue(“Type”). It is possible?

Hi, sorry for the long post. I’m new to Airtable, but think I’m getting the hang of Airtable’s assumptions: hide the database keys and use the first column of the table as a psuedo-primary key for the UI. We are contemplating using airtable as a readonly front-end to our existing database, which is not very UX friendly and is increasingly perceived as a barrier. I’m using a script that pulls my data into an airtable base with two tables. I can setup a Link field that creates the links as the records are pulled in. Now, lets say I’m pulling in 2 tables from an sql database, Contacts and Homework. If I’m creating records in airtable by hand, its ok if I have two different contacts with the same name, because airtable is using its internal UUID, but if I pull contacts with the same name via script, the linking breaks. If I import the primary and foreign keys into Airtable then I can use those to link the tables, but it seems like I lose some Airtabley goodness. For example, if I make th

Hopefully someone can help. I’m using the airtable API to build a custom app. I want to have a record picker which displays a selection of records, upon selecting the record the resulting report (data based on selection) is rendered. I’ve been playing around and I’m fairly certain “SelectSynced” is going to be my friend. However I’m struggling with a lack of worked code examples (they mostly show table or view selections). Namely; I would like to a) render a < select> populated with data from a record query b) once user has made a selection use the select value to render data from the chosen record Link to api ref for react component: Airtable Blocks SDK //WIP - hard -coded values for testing import { useRecords, useBase, useGlobalConfig, initializeBlock, Select, SelectSynced, } from '@airtable/blocks/ui'; import React, {useState} from 'react'; const GlobalConfigKeys = { selectedOption: "Joseph Lee" }; //coachnames const options = [ { value: "Pear", label: "Pear" }, {

We have the limit of 50 000 automation runs in our plan. Does this limit includes API calls?

So I’m looking to create a simple chart of crypto projects I’m interested in tracking. I’m using a variation of @Nikolay_Tsenkov elegant stock price updater he posted on the Example Script Showcase. I can get it to work with a few securities sites, it pulls stocks in beautifully but when using CoinGecko’s API I keep getting an “Undefined” error. Upon inspection I can see that I’m getting the payload back correctly but no matter how I try to load it, it doesn’t seem to want to go into the table. Is it because the payload is nested within the id? I’m totally stumped on this at this point and could really use some fresh eyes to get me sorted. Here’s an example of the URL string. the `${coin}’ is obvously for pulling the id in from Airtable, in this example I’m using “cardano”: GET: https://api.coingecko.com/api/v3/simple/price?ids=${coin}&vs_currencies=usd RETURNS: { "cardano": { "usd": 1.15 } } All I want is the “1.15” to come into my price field, but NOOOO… A

Not sure what to request about this one, but likely the community has ideas. Recent outages of the Airtable API caused errors in live zapier.com “zaps”. Airtable Status - Incident 3/10/21 Airtable Status - Incident Here in Australia these outages happened in in the midde of the night, but generated zapier error alerts as the zaps are contantly pinging Airtable. This caused a lot of concern for our clients, and then time for us (featurepower.com) to investigate. Hence this post. I couldn’t find any other reference here to this happening. Though I presume many others were affected. So, for info, the errors reported from zapier were: the app returned “Service Unavailable” the app returned “503” Trigger partner failure: the app returned “503” Trigger partner failure: the app returned “502” Trigger partner failure: (9001, ‘Max connect timeout reached while reaching hostgroup 20 after 10000ms’) And also FWIW, zapier turned off some (but not all) impacted zaps because of repeated errors.

Hello! I help run https://vacfind.org, a COVID vaccine information site that stores links to helpful websites in Airtable. Given the recent Airtable downtime, I was wondering if it would be possible to have a simple /ping endpoint (or similar) added to the API so that I can configure our caching server to use this endpoint to check whether Airtable is up and if not, configure itself to serve requests from the cache. Does something like this already exist in the Airtable API that I’m not already seeing? ideally id like to not have to configure auth to make a request just to figure out if the Airtable API is up (200 OK) or not (503 Service Unavailable). Thanks, Adrian

I am looking for any documentation on integrating ClickFunnels with Airtable. I have a very simple 2 column Table - Email and a String of Data I can make Get, Post, Purge to work in Postman, but I was told all I need to do is grab the JS out of the API docs and paste it into a CF HTML element. This throws a ‘require not defined error’ My research has lead me to believe I need to use NodeJS or NPM or both, but to be honest I have never worked with either… Is there any documentation on how to get this running?

Hi there, I work for a prison education nonprofit that works with people facing federal crimes. We want to be able to send legal updates and resources to graduates of our classes, and use Airtable to track those graduates. We want to keep our records updated as to when graduates of our classes are transferred to a new federal prison, had their release date changed, or been released. Anyone incarcerated in federal prison is given a register number. You can use that number to get release date and location data from this API. We’ve been using a combination of Python scripts to do this but it’s been clunky and buggy because I’m not that great at Python (frankly I’m not that great at coding, period, but I’m learning). I think we can do this more efficiently with a script in Airtable. Here’s the one catch: every once in a while, someone puts in the wrong register number for our graduates. Is there a way to show values returned from an API side by side with the current values in the Airtable

Hello, We requested access to the Metadata API last month, but haven’t heard back yet. Is Airtable still giving access to the metadata API? We run formcrafts.com and would like to build an integration with Airtable :slightly_smiling_face:

Hi All, we use Airtable to manage our social media and one cell has a list of hashtags (one on each line) and we’d like to figure out a formula to shuffle the lines so the hashtags don’t post in the same order every time. Any ideas?

I am working on importing and managing data of device details on the cloud with API. I am a beginner and don’t have experience with coding. I was wondering if you can help me because my team is struggling with the data management of our clients while waiting on developing new tools (released in 5 weeks). The old tool is broken at the moment… We have airtable that can download (to airtable) and upload (to the server) info for the devices (about 4 fields) on airtable sheet. Using a script for that. I also saw script here in community that can delete all data from airtable sheet, but is it possible to use this script with the modification that deletes corresponding data on the server using api? For example: I download a list of devices with info on 4 fields. (name, code, mac address, NFC number) Copy selected devices or rows in airtable (not all, just ones that I want to delete) to the new airtable sheet. Click the button in the new sheet to use scripts to delete all corresponding device

Hello! I am looking for a way to import data using a URL that connects to a CSV and merge existing records on a recurring basis. This can be through a click of a button or the script running in the background. The CSV could also come from google sheets. Which of the following would be easiest to automate the importing of the CSV? Using the Scripting block and creating a button that will trigger the CSV import app? The automation with run a script every hour to trigger the CSV import app? Google scripts on the Google sheets with the Airtable API to import the CSV? If anyone has a built a similar script and is willing to share the script please do! The ideal would then be to have additional columns in the base that only sit in Airtable. Due to data privacy concerns, we cannot use a third-party extension. Thanks in advance!

I have grouped some fields in my Airtable. How can I get a specific “count” or a “sum” with API? How can I access this data through API? I am interested in getting the different counts and sums for each group. I.e: Score_act: sum 41 Task: “Jeg har koblet av med noe underholdende”: count 4 (times this task had been completed). Is this possible? Regards, Tor M

Hi all! I’m trying to remix the Wikipedia Enrichment app from Github. I’ve got everything installed and it’s working great, but I can’t get the app to release to Airtable’s servers. I’m getting zero feedback from Terminal when I put in $ block release. Right after it gives me the address to plug in a line shows up “Switched to a new block installation.” I’m not really sure why it keeps doing that. I’m on Big Sur 11.2.2 with Xcode command line extra tools installed, with a lower version of Node (14.15.0) installed because I noticed people with Big Sir are having problems. Any suggestions or what other information would you need to diagnose? Thanks everyone!

I’ve installed the Scripting app, but the input area in the upper left corner keeps loading and I can’t input any script. This happened after I ran the “Sync Airtable Base Structure” script provided by “miniExtensions”. I’m a beginner, so I don’t know how to solve this problem. If anyone knows how to solve this problem, please let me know. Thank you very much for your help.

I’m trying to use @Kamille_Parks Script No-Conflict Appointment Scheduler but I’m having a slight issue trying to set it up to allow Same day Scheduling currently it only allows appointments as soon as the next day. Any ideas? I found the line 266 //loopdates.push(loopCurrent); //NOTE: uncomment this to allow same-day scheduling but i wasn’t able to get it to work. Following is the script I am using with changes i made. /* Script: No-Conflict Appointment Scheduler Author: Kamille Parks This is the sister-script to my "No-Conflict Asset Reservations" script. This script performs a similar function, however this one is built for appointment/reservations which start and end on the same day. It allows users to select a service, pick a qualified agent/employee to perform that service, and then select upcoming dates and times which work for that agent. The script opts to use buttons as opposed to text box inputs to reduce human error in typing in correctly formatted date/time strings

Hi all, I’m at my wits end. I’ve written code for Airtable locally, which largely works. Now I’d like to place the code on a cloud functions tool so I can run my code on the browser and have it communicate with other APIs. Here’s the code I have on the serverless tool, just the basics first just trying to call the airtable library. /** * main() will be run when you invoke this action * * @param Cloud Functions actions accept a single parameter, which must be a JSON object. * * @return The output of this action, which must be a JSON object. * */ var Airtable = new require('airtable'); var base = new Airtable({apiKey: 'XXXXXXXXXXXXX'}).base('appumWMhUzhgN8fFe'); function main(params) { return { message: 'Hello World' }; } When I try to run this code, I get Error: Cannot find module ‘airtable’\n In this case I’m using IBM Cloud Functions, but the process as I also read Google Cloud Functions and others seems to be the same. I just am doing something wrong. Here’s the

Uncaught (in promise) Error: Can't create table: invalid field config for field 'games_id'. Creating or updating options for multipleRecordLinks fields is not supported at this time. Is there any other mechanism or workaround for this? When creating a table, or updating a table?

I wonder if anyone can point me to the right direction. I’m tasked to create a base for simple school administration for a small NPO. The use-case is quite simple: a Program contains multiple classes a Class contains multiple students a Student may attend more than one programs Based on the above processes, I’ve created a base with four tables: Student, Program, Class, and Attendance. the Student Table lists all of the students, and each student record would also link to multiple Program records, multiple Class records, and multiple Attendance records the Program Table lists all of the programs, and each program record would also link to multiple Class records and the students records the Class Table lists all of the classes, and each class record would also link to its parent program record and students and the Attendance Table is a junction table between Class Table and the Student Table With the above set-up, I’m able to create all of the views needed for my colleagues, such as

Hi, new to Airtable, so this may be a dumb question; apologies in advance if so. Is there a way to dynamically update single select field options from an API? For example, looking to have a list of item types to select for a record, ex: Server, Workstation, Switch This master list is contained in another system but accessible via rest API. Is there a way so that in the far end system, if “Router” is added as an item option, the Airtable option list for that field will now contain “Server, Workstation, Switch, Router”?