Development & APIs

Hello, I already posted in another part of the community, I’m wondering if this section would have been a better place? The core issue is that a date formatted formula column causes an error when creating new records with the error as below. ERROR j: Can't create records: invalid cell value for field 'Date'. Cell value has invalid format: <root>.0 must be a string, <root>.1 must be a string, <root>.2 must be an object at main on line 131 Thanks for your ideas!

Hello! I am brand new to Airtable scripting and trying to get a very simple script to work with no luck. What I am trying to accomplish is to have a use click a button then run a script to update 2 fields on that record. I have pieced this together and it doesn’t show any specific error but also doesn’t change the field (I am starting with only one first to see if I can get this working). Any ideas on what is going wrong? // Change these to match your base. let table = base.getTable('Master_Table'); let field = table.getField('Step'); // When run from a button field, the script skips the prompt // and automatically uses the button's record. let record = await input.recordAsync('Choose a record', table); let value = field.updateOptionsAsync.toString("QC Ready");

I have been successfully using this script for almost a year now and it stopped working last week. Did something on the backend change? Here is the error message I am getting: TypeError: record.getCellValue is not a function or its return value is not iterable at main on line 76 Here is line 75 and 76 of my script: if (unique && record.getCellValue(“Lock Content”) == true) { for (let rec of record.getCellValue(fieldToWriteTo)) { “Lock Content” is a checkbox field. Ultimately when it is checked the script doesn’t edit those records and when it is unchecked it is supposed to update, but I am getting the error message. I have never had this problem with this script and I like said earlier we have been using it for almost a year now. Here is my whole script. It’s a bit long and has some old iterations still in there. /* C O N F I G */ /* names: fill to match own table*/ let tableToPullFromName = 'Content Library'; let viewToPullFromName = 'Grid view'; let tableToWriteToName = 'Con

Hi, I have a problem with displaying the data from the API AirTable… it appears correctly on the console screen, but it does not appear in the exact location on the site

Can I have an OAuth2 authorization flow where the redirect_uri points to a custom app URL?

Hi all, Can I use Next.js to run a Custom App? Have any tried it before? Are there any incompatibilities? Thanks

The Airtable REST API allows one to create, update, and delete up to 10 records at a time. I need to know whether or not Airtable will prevent the modification of all record info provided in the request payload if any issues are to arise in the operation, whether that be due to partial bad input on my end or an issue on Airtable’s end. From doing some quick testing it seems that if operations are atomic but I’d love some confirmation from Airtable staff on this. Thank you!

I would like to know how to copy a column “Items” from one table to another table. Both table have the same naming “Items” Table Name: DB_Checklist Daily_Closing_Checklist View Name: DB_Checklist > Closing Field Name: DB_Checklist > Items Daily_Closing_Checklist > Items I want to copy one of the row of data from DB_Checklist/Closing/Items to Daily_Closing_Checklist/AllEntry. Can anyone show me how to code this? let checklist = base.getTable("DB_Checklist"); let checklistView = checklist.getView("Closing"); let dailyClosingChecklist = base.getTable("Daily_Closing_Checklist"); I only know this much, want to learn more on how to make my table more automate.

I have this script I made a month ago. It worked perfectly fine. Just tried it today and it doesn’t work. The fields that I’m updating with updateRecordAsync do not update. They are just blank. let newRecord = await main.createRecordAsync(obj) main.updateRecordAsync(newRecord, { "ID" : newID, "Discipline" : {name: record.getCellValueAsString("Discipline")}, "Experience" : {name: record.getCellValueAsString("Experience")}, "Duration" : {name: record.getCellValueAsString("Duration")}, "Activity Type" : {name: record.getCellValueAsString("Activity Type")}, "Content": newCombinedText }) Like I said, this script did exactly as I wanted to in the past. Did something change with updateRecordAsync?

Hello! I believe I discovered a new issue when working with Airtable’s automated testing feature. Here is my sample component: import React from 'react'; import { useBase, useRecords } from '@airtable/blocks/ui'; const Main = () => { const base = useBase(); // Table and view name will vary depending on your base const view = base.getTableByName('Component Table').getViewByName('Potluck Volunteer Sheet'); const records = useRecords(view); return ( <div> <h1>Testing useRecords</h1> <p>{records.length} records found for {view.name}</p> </div> ); }; export default Main; And here is the example unit test: import React from 'react'; import TestDriver from '@airtable/blocks-testing'; import { render, screen } from '@testing-library/react' import Main from './main'; import { fixtureData } from './fixture'; const testDriver = new TestDriver(fixtureData); describe('main', () => { it('renders correctly', () =>

I need to know how i ask to run script when new record is created and define if name in: var response = await fetch('https://api.agify.io/?name='+name); is equal to Prénom used from table else only change records only for this person. I give you a screen of my table // query for every record in "trombinoscope" let table = base.getTable("test"); let view = table.getView("Donnée brut"); let query = await view.selectRecordsAsync ( { sorts: [ // sort by "Prénom" in ascending order... {field: "Prénom"}, ] } ); let records = query.records; // print ID & "Prénom" from each record: for (let record of query.records) { let name = (record.getCellValueAsString('Prénom')) ; let response = await fetch('https://api.agify.io/?name='+name); /*fetch('https://api.agify.io/?name='+name) ;*/ /*console.log((await response.json()).age);*/ let agifyAge = (( await response.json()).age); let records = query.records; for

Hi, Is there a way to Programmatically(*) Hide / Show Field(s) - Add / Modify FILTER to an existing VIEW ? Same question came into my mind about: COLOR & SORT. Best, oLπ (*) = by SCRIPT Block.

Can I get a second pair of eyes on my script? Expected behavior is that a user can click a button on any record in the “People” table, and it will create a record in the “Payouts” table, linked to People by a lookup field called “Person” I don’t get any error messages when I run this script, but I also don’t get any new records in the “Payouts” table. And I’m the only user on the license, so I don’t think it would be a permissions error. Can you see anything I’m missing? Thanks in advance! const childTable = base.getTable('Payouts'); const parentTable = base.getTable('People'); const parentRecord = await input.recordAsync('Parent record', parentTable); const linkField = 'Person'; const newRecordValue = parentRecord.getCellValue("Account Balance")*(-1); console.log(newRecordValue); childTable.createRecordAsync({'Amount': newRecordValue, linkField: parentRecord});

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

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>

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

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

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 + `"), )`, });

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

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.

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.

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, {

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?

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?

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.