Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,657 Topics
  • 11,709 Replies
3657 Topics
S
Smyth_CountyParticipating Frequently
posted in Development & APIs
Scripting to Input values/perform function on another cell

Is is possible to have a button perform a script to input values into other cells all in the same table?. For example, if a field is set to button and you click the button, then do the following: In the Columns “Sales” and “Orders” place data from Column “Estimates” Thanks

104
S
L
Luis_BritoNew Participant
posted in Development & APIs
Error: Invalid hook call when importing a Zendesk Garden React component

The code works fine without using Airtable SDK. Any ideas on what can be causing this? You can see it working here: vibrant-snow-m8sl6 - CodeSandbox Here’s my code using Airtable’s initializeBlock() : import React, { useState } from 'react'; import { initializeBlock } from '@airtable/blocks/ui'; import { Dropdown, Field, Menu, Item, Select, Label, } from '@zendeskgarden/react-dropdowns'; interface IItem { label: string; value: string; } const items = [ { label: 'Fern', value: 'item-1' }, { label: 'Snake plant', value: 'item-2' }, { label: 'Rubber tree', value: 'item-3' }, ]; const App = () => { const [selectedItem, setSelectedItem] = useState(items[0]); return ( <Dropdown selectedItem={selectedItem} onSelect={setSelectedItem} downshiftProps={{ itemToString: (item: IItem) => item && item.label, }} > <Field>

43
B
H
Hendrik_YangInspiring
posted in Development & APIs
Airtable API for Chart

Hi Airtable Team, Based on above screenshot, is it true Airtable doesn’t support API for chart?

20
H
Karlstens
KarlstensBrainy
posted in Development & APIs
Scripting a Rollup Substitute

Hey all, I’ve tested a simple script that takes two Rich Text fields and copies them into a third field, and excitingly the Markdown format keeps as I’d hoped. :partying_face: My next step is to now have two tables in a base, a primary table that has field lookups to the secondary table. And then any lookups added to the primary table record - to have their single Rich Text fields (in the Secondary Table) combined into the Primary table Rich Text Field. I’m basically substituting the Airtable RollUp formula due to it lacking support for Rich Text, as although the Rollup works unfortunately it drops all formatting (and I’ve since written a support request to address this). Here’s my work so far, keep in mind I’m still learning JS so this is all new to me. I understand some of the basics, but am struggling to understand the syntax of how to place the Lookup Name values into a For Loop, and then assign each of their Rich Text contents to a variable that I then combine into the Primary T

315
Alexey_Gusev
S
saumya_gargNew Participant
posted in Development & APIs
AND filterbyformula does not filter

AND filterbyformula does not filter bring up all records instead. Anyone have any ideas? let step_count_records = await log.selectRecordsAsync({ filterByFormula: `AND(( {Email} ="` + email + `"), ({Action} = "` + status + `"), )`, });

295
B
L
leggomyiNew Participant
posted in Development & APIs
Converting string to array for creating record with multiselect field

One of the inputs to my script is a string which needs to be reformatted such that it will be an acceptable value for a multiselect field when creating a new record. There are three possibilities for the string: “option 1” “” many options: “option 1, option 2, etc” I know the format below is what I need to convert it to, but I can’t figure out how. await table.createRecordAsync({ “Multiple Select Field”: [{name: option1}, {name: option2}, etc] }) I’m omitting all the things I’ve tried which haven’t worked. I’m going to use the create records action instead of a script action until I can figure this out. Below is the skeleton of the script action I was using with some ??? where I was stuck. Any help would be greatly appreciated! In the meantime, I’m leveling up my Javascript skills. let config = input.config(); let recordID = config.recordID; let table = base.getTable("Table_Name"); let view = table.getView("View_Name"); let query = await view.selectRecordsAsync({ fields: ["Strin

2177
D
A
Ahsan_TahseenNew Participant
asked in Development & APIs
How to use date and time for conditions in scripting app

Hi so i have a airtable table and it has date and time field. I wanted to use those value for time for calculation condition and date for comparison basically i want if else based on date and time values. How can i use that? i used JavaScript functions for that but still i cannot get my desired output. Please someone help me out here. IT IS VERY URGENT pls.

152
D
M
Marc_Justin_RaiKnown Participant
asked in Development & APIs
Response status was 303

I have a problem in fetching the github api using this code and the error show is Response status 301 ‘Moved Permanently’ but redirect mode was set to ‘error’. I’m new on the airtable scripting environment and I don’t quite sure how to make this successful. let response = await remoteFetchAsync('https://github.com/google/google-api-javascript-client.git'); let x = await response.json(); console.log(x); Thank you.

132
D
T
Tech_Support2New Participant
asked in Development & APIs
Scripting to delete a value in a single select

I have a button/script that I want to be a toggle the value in a single select field. If the value is blank, I want to e button to mark it “Absent”; if the value is “Absent”, I want the button/script to make the cell blank. In Airtable Scripting, I see how to delete choices, but I don’t think I want to delete the choice, just the value. (I am trying to avoid having a second option of “Present”, as I know my users will assume they have to mark all clear cells as “Present”.) Here’s my script: // Select the recordId that houses the button let tableClassReg = base.getTable("Class Reg"); let record = await input.recordAsync('',tableClassReg).catch() //console.log(record.id, record.name); // read in a specific field let entry = record.getCellValue("D1 Atnd"); // toggle that field if (entry.name=="Absent") { await tableClassReg.updateRecordAsync(record, { 'D1 Atnd':{"name":""} //<-- here's the problem }); } else { await tableClassReg.updateRecordAsync(record, {

332
T
N
Nicole_LopezParticipating Frequently
posted in Development & APIs
How to query a table on a separate base?

Is it possible to programmatically with Airtable scripting load a different base from the one in which the script is running? I’d like to automatically sync views from one base to another with the scripting block, but it’s looking like that might not be possible?

196
J
T
TFPInspiring
posted in Development & APIs
Airtable Script - "when a record matches conditions" -> How do I get the records that triggered the automation?

I configured an Airtable automation script to trigger when a record matches some conditions. I had expected to somehow get an “input” containing the said records, but it feels like there isn’t such thing. My goal is to perform processing for the said records only. I didn’t find anything in the API reference Airtable Scripting. Is it possible? If not, what’s the recommended way to about that? I’m thinking about iterating over all elements and check if some field is empty and if so then perform some processing for that record. Also, I read that only 15 records can be updated per second, how does this work? Is it handled by Airtable automatically or do I need to temporize the updates myself so that I don’t go over the limit?

13215
Alexey_Gusev
M
Mulgetta_FritzNew Participant
posted in Development & APIs
Lock URL in form view

Is there a way to lock the shared URL in form view? I would like to maintain a URL link so no collaborators can generate a new one accidentally. We use this URL as a QR code internally.

21
Justin_Barrett
L
Luis_BritoNew Participant
asked in Development & APIs
You can develop apps for free until September 2021

Getting this notice while developing an app. What does this mean?

210
J
D
Dominik_BosnjakInspiring
asked in Development & APIs
Mimicking the deprecated selectRecordsAsync() behavior

You’ve probably all seen the following warning by now: I’m guessing the deprecated behavior might still work well into 2022, but if you want to future-proof your scripts right now and/or depend on the old behavior, here’s the cleanest, functional way of mimicking it I’ve found so far: const table = base.getTable(yourTableName), fields = table.fields.map( f => f.name), query = await table.selectRecordsAsync({fields}) This particular destructuring syntax obviously depends on your scope being clean. But in practice, I’d usually just write this: const table = base.getTable(yourTableName), query = await table.selectRecordsAsync({ fields:table.fields.map(f=>f.name) }) Either way, I figured I’ll share this and ask if anyone has figured out a quicker method.

162
D
B
botcasterNew Participant
posted in Development & APIs
Embedding Airtable's iframe shows SameSite error/warning in Chrome

When embedding Airtable’s view iframe into my page, the chrome console prints A cookie associated with a cross-site resource at https://airtable.com/ was set without the SameSite attribute. It has been blocked, as Chrome now only delivers cookies with cross-site requests if they are set with SameSite=None and Secure. You can review cookies in developer tools under Application>Storage>Cookies and see more details at https://www.chromestatus.com/feature/5088147346030592 and https://www.chromestatus.com/feature/5633521622188032. I think this is expected due to the Chrome update in Feb: https://blog.chromium.org/2020/02/samesite-cookie-changes-in-february.html Any plan for Airtable to get the iframes updated?

163
M
A
AtesNew Participant
posted in Development & APIs
How to send webhook after status changes to active?

I have a status column and when i change it to active or passive, i want to send silent webhook to selected URL including another cell’s value. I couldn’t find how to do that. Can you please help? Thank you

41
kuovonne
T
Tim_WaxenfelterNew Participant
posted in Development & APIs
Use "Gantt auto set dates" for one project only

I’m using the “Gantt auto set dates” from the Marketplace. I’m trying to figure out how to update it to only act on a particular project. Right now, every time I run it, it will update every project whether I want it to or not.

00
T
N
Nishant_ShahNew Participant
posted in Development & APIs
Adding new fields to existing table using Webapp

Is it possible to add additional fields in existing table from a webapp that i create on top of Airtable?

11
kuovonne
T
TiberiusParticipating Frequently
posted in Development & APIs
Find All Errors in Table/Base

Hi, Is there a script that finds all errors in a specific table (or even better in the entire base) and then returns those error fields? That would help greatly with troubleshooting larger bases, so I don’t have to scroll through hundreds of fields looking for the red error sign when making larger changes.

92
kuovonne
E
Eddy_MaayaInspiring
posted in Development & APIs
Website Search Page

I tried to search for this topic and could not find any answers. I am trying to know if it’s possible to create a search page and when that record is available, I can manipulate the layout of the result? I am using the pro plan.

23
B
M
Mike_Williams2New Participant
posted in Development & APIs
For operational continuity in case of internet outage, can Airtable be configured to store its data in local servers?

We are using Airtable to support City activation of volunteer resources in the event of a disaster or other community-wide emergency. We have fiber optic loops around the city to critical locations. If the public internet goes down, we would like to have our Airtable data stored in our local servers, which have their own redundancy, security, and back-ups. Is this possible to arrange with Airtable?

21
kuovonne
H
Hemi_PhillipsParticipating Frequently
asked in Development & APIs
Where to start; using scripting block to POST to an api

Hello! this is my first time using the scripting block and first time trying to use an API with code (I’ve used lots of no-code tools in the past; Zapier, Integromat etc.) I want to use a text field in my base to create a ‘tag’ in Toggl using the Toggl api; The Toggl API documentation looks good, and I think I understand most of it, but I don’t know how to actually start - what is the first think I need to write? All the toggl examples start with ‘curl’ e.g. curl -v -u 1971800d4d82861d8f2c1651fea4d212:api_token \ -H "Content-Type: application/json" \ -d '{"time_entry":{"description":"New time entry","created_with":"API example code","start":"2012-02-12T15:35:47+02:00","duration":1200,"wid":31366}}' \ -X POST https://api.track.toggl.com/api/v8/time_entries Is this what I would paste into the script editor? I assume I need the toggle api url somewhere ( api.track.toggl.com) so the script knows where to get/post the data but I don’t know where or how to add this url. Can someone plea

586
kuovonne
A
Ava_NikaeinNew Participant
posted in Development & APIs
Automation: Exceeded quota of 15 mutations per second

Hello, I have a script that I’d like to run as an automation when a record is updated but have been running into a problem when trying to update the record (specifically one field - “Conflict”) since it exceeds the 15 mutations per second limit… The records are screenings of films in various venues, across 10 days. The script is checking whether there is enough turnover time between the screenings at a single venue. If there is less than 55 mins, both records will get their Conflict field checked to notify the humans working on the scheduling. SlotIDs are ascending numbers unique to each scheduling slot and this is how I’ve been able to determine the time difference. The script does what we need it to do when run manually, inside apps. But turning it into an automation gives the error. I’ve narrowed down that it’s the for loop used for updating the records that’s causing it but don’t know how else to achieve the same result. I’ve also tried using a while loop for updating the records b

111
kuovonne
S
Shashank_AmbekaNew Participant
asked in Development & APIs
Pull unique values and no of occurances for particular column into seperate columns

We have a requirement like below. e.g. Consider a table with column as Names. Names abc xyz abc pqr pqr We want two columns in another table as below. UniqueNames NamesCount abc 2 xyz 1 pqr 2 Is there any way to achieve this?

141
Alexey_Gusev
J
Jay_ShinNew Participant
posted in Development & APIs
Duplicate Linked values in a cell

Hi All, This might be completely impossible but I’m trying to get rid of duplicate linked field values. Is there any way I could force it to do this via scripts? The dedupe app doesn’t quite do what I need it do and although this can be acheived via a rollup column, the values are now not linked. I know this isn’t a native feature so I’m trying to find a work around because I can’t generate neat pivot tables at the moment. Some advice would be much appreciated.

153
Alexey_Gusev

Badge winners

Show all badges
Terms & Conditions