Development & APIs

Hello, I’m looking to remove double line breaks in a rich text field (empty lines in the text). The substitute formula will make me lose the formatting. I tried the find and replace script to no avail. Could someone please help me ? Thanks a lot

Hello everybody,I have a table that's thousands of lines long, with a column called "Formula" which contains small string expressions like:amount = salary * 0.11;What I'm trying to do is run this string in my code, so that it updates the `amount` variable based on which line I select. However, I am running into an error when I try to run the string as code.This is my code, which is able to compile with the correct answer in other online compilers. However, when I run this in my automation script (specifically the line where I call `func()`) I receive TypeError: func is not a function.let code = "amount = salary * 0.11;";// Define the function with the desired argumentslet func = new Function('salary', code);// Call the function with the desired argument valuesfunc(50000);console.log(amount);I've tried using `eval()` to run this (I know it is not best practice) but similarly received the error ReferenceError: eval is not defined. There has to be some way to get this code

Hello,I have 4 columns setup. Date Opened - is a created time field, logs when an entry is createdTime Opened - is a formula field with the following:  TONOW({Date Opened}) - Simply logs in minutes (will likely change to hours) how long an entry has been opened for.Done - Simple checkmark boxDate Closed - Is a formula Field with the following: IF(Done = 1, LAST_MODIFIED_TIME(Done)) - simply logs the time an entry is marked as Done with a checkmark.My current issue is, I'd like Time Opened to stop counting as soon as Done is checked and I cant quite figure out how to do this. Does anyone have any pointers?Thanks!

Hi,I'm working with the API, and when trying to create or update a SingleSelect field with a new select option, which was not exist, I get the following error:{"error":{"type":"INVALID_MULTIPLE_CHOICE_OPTIONS","message":"Insufficient permissions to create new select option \\"\\"v0.65.1\\"\\""}}%I set my personal API key with all of the available permission, i tried editing the field's permissions and set it with:* Allow this field to be set in records created through forms* Allow this field to be modified by automationsbut it didn't work.I didn't find anything useful in the API docs. Can anyone help? 

Hello, I´m new using airtable.I´m developing a Labview-based software for reading information from airtable and writing information to airtable. I have no problem with reading from airtable. I´m using the functions in labview for inserting the headers with Authorization, then I encode the URL for retrieving the information I want, and use the Get function. This point has no problem.The problem is that I´m not being able to create a new record in the table. Basically, I´m following the same flow as before. I´m inserting the header with the Authorization, then I´m generating the URL with the Base ID  and the Table name, then I´m using the function POST which has as inputs the URL and the data to send to the airtable.The data I´m sending is this one:{"fields":{"Test Number":67,"CH - Pass / Fail":"Pass"}} As answer I receive the following header:HTTP/1.1 422 Unprocessable EntityDate: Sat, 24 Dec 2022 10:32:17 GMTContent-Type: application/json; charset=utf-8Content-Length: 12

I'm working on an extension that will use iframes to load parts of the app. While iframes aren't forbidden by the extension guidelines, I'd like to get confirmation from a senior Airtable engineer before starting to work on this architecture -- it's going to be a considerable time and effort to build! I have a design doc I can share to give a full sense of how it will work. Does anyone know how I can reach someone at Airtable to review my design? Thanks.

I have no experience creating scripts and am looking for some assistance to create one for my base. I thought that I could just utilize automations to update records but I have had no luck getting those to work properly and after searching through this forum I believe a script is necessary to do what I need. I have a Daily Fieldwork form that our employees fill out each time they go to install, remove, or service some equipment. If they are installing something new they fill out the form for an "install" and it triggers an automation that successfully creates a new record in another table called "Seismographs/Instrumentation".If they fill out the Daily Fieldwork form for anything other than a new install, they select the equipment number or "JID" that is associated with the equipment that has already been entered into the "Seismographs/Instrumentation" table and they update the information associated with that JID. I cannot figure out how to have multiple fields updated from the D

Hello I am looking to create a custom Airtable Block that can track a list of tracking numbers in a column and return all of the shipments status in other mapped columns (Location, Destination, Last event, arrival date etc) I think the best way would be to create a custom block connected to the Shippo API, but I am open to suggestions. I am OK to host if needed. Please let me know how you would do this, your best price, and when can this be completed by. About Me: Hello! I am Sal, a big Airtable x Zoho fan. I am looking to develop a relationship with a developer to help me with automation set up in Airtable and Zoho — I often come up with ideas, and looking for someone to execute.

Based on the advise here, I’m going to ask the user to enter an license/API key in order to prove they have subscription. My block might also need to store sensitive keys for other APIs. Where should I store these sensitive keys? This guide says it shouldn’t go in GlobalConfig. This answer says it should be an environment variable, but I want to enable non techincal users to install my block, so that doesnt feel like an option.

and failing, to be honest. Please take note that I have no idea what I’m doing and this script is pieced together from snippets and posts I found on the forum. This is what i have until now. I’ve tried multiple variations but I haven’t been able to write to a new attachment field correctly. //script settings let settings = input.config({ title: 'Create individual records from multiple attachments in a single attachment field', description: 'Creates 1 individual record in another table for each attachment in a multiple attachment field in the source table, and links the new records back to the source record.', items: [ // Source table select input.config.table('tableSource', { label: 'Table with existing attachments' }), // Source table: Attachment field input.config.field('attachField', { parentTable: 'tableSource', label: 'Attachment field with multiple attachments to split', }), //

Is there an endpoint to list all the bases for an api key, zapier is able to do it in their app, but i couldn’t find anything related to this in the standard api documentation ?

i'm trying with Postman, i don't understand how to find the email in a table of users and get the user data?it can be done?

Hi. I,m trying to filter records using filter formula based on record_id. The field is not exists in the table, and we don't want to create formula field to have record ids explicitly. Is there a way to compose query formula to filter data by their record_Ids like this:AND(OR(SEARCH(",recctaxd2aq9fvtfj,", "," & SUBSTITUTE(LOWER(ARRAYJOIN({record_id}) & ","), ", ", ","))))Thanks in advance.

I am working on a custom extension with Js/React. I would like to update the field of a specific record when someone clicks a button. function updateField() { let table = base.getTableByNameIfExists("Dart Applicant Tracker"); let record = useRecordById(table, "rec8XV8zW0GuGPBDX"); table.updateRecordAsync(record, { "Scheduled Staff": base._baseData["collaboratorsById"][base._baseData["currentUserId"]][ "email" ], }); }However, when I call my function I get the following error:Error: Invalid hook call. Hooks can only be called inside of the body of a function component. This could happen for one of the following reasons: 1. You might have mismatching versions of React and the renderer (such as React DOM) 2. You might be breaking the Rules of Hooks 3. You might have more than one copy of React in the same app It seems like I can't use these methods in a function. What is a workaround?

Currently, my account cannot be accessed because Airtbale does not send a text message to my phone with a 2-layer security login code. What should I do now? thanks so much!!!

Good morning everyone, I can’t seem to figure out the correct syntax for updating a Linked Field within a record. My test base is simple, two tables, a name field in each, and a linked record between the two. Table First Table Second Example of my simple script below. It’s odd that in the Airtable GUI users may paste text straight into the “Second” link and it creates the items in the Second table. But scripting requires the object/array to be formatted - which I’d appreciate a hand on. :pray:t2: let table = base.getTable("First"); let query = await table.selectRecordsAsync({fields: []}); let recordId = query.records[0].id; //Updating the Name works as expected await table.updateRecordAsync(recordId, { "Name": "Example Record", }) const data = ["Item 1", "Item 2"]; //Needing a hand to stamp "Name" items into the Linked Record. await table.updateRecordAsync(recordId, { "Second" : data }) output.text("Updated a record!");

Hello, I’m reading documentation here on the rate limits for the Blocks API and I’d like some clarity around these two statements: Batch methods ( updateRecordsAsync , createRecordsAsync , deleteRecordsAsync ) may only update/create/delete up to 50 records in one call. Additionally, writes are rate-limited (maximum of 15 writes per second). Your app will crash if this limit is exceeded. Two questions: What is a “write”? Does calling a batch method count as 1 write? Assuming that a batch method counts as a single write, does this mean that it’s possible to update 750 records a second (15 batch methods a second * 50 records per full batch) via the Blocks API Many thanks

Airtable is already a great way to give folks in our business the ability to edit a wide variety of datasets. With Interface Designer, we expect to move even more of our data into Airtable. But Airtable is just one piece within a large ecosystem of business systems. We need to connect with a wide variety of custom internal systems and off-the-shelf systems. Event buses like Kafka make it easy to add new connections. Instead of connecting each system to each other system, you just connect everything to the event bus. It would be great to have a Kafka Connector for Airtable so we can stream out every single update to other systems that care about them. Other databases like Snowflake and Redshift have connectors. There are two ways to build this on the current system: the Script app and the API. Both approaches work, but they involve a lot of custom coding. It would be great to have an officially-supported option.

Hi all,Hoping someone can help me with this,I have a table with a list of brands and a score for each brand. The brands are labelled by category, some brands have multiple categories. I want to be able to automatically rank these brands by their score, and have that rank update if I filter.E.g if I filtered to just 'makeup' the rank would update to only rank the brands categorised as makeup.Included an example table that's simplified,Hoping this is possible!Thanks in advance,Charlie

Hello dear members of the community, I hope you’re doing well. I am requesting your help because Airtable removed the “editable shared view” that I was using before. I therefore need to find a workaround. I would like to use a script, so that when a partner edits a Linked Field (here ‘Status’) in his Table View, it will directly compare its value to the Status of the client in my Lead Table (lookup field) to update it, based on the one the partner selected. I have been able to prepare what I want using VSCode but I know nothing about scripting in JS or JSON. Could someone please help me ? I am adding some pictures to show the structure and what I imagined. Thanks a lot in advance for your help, Pierre

I am looking to export data from my airtable into JSON format. I am working with a Firebase Application, and I want to be able to collect data in AirTable, export it, and then dump it into a Firebase JSON based Database. Has anyone written a script/block/app that takes appdata and puts it into a JSON format? Thank You

I'm trying to generate some content using OpenAi's new ChatGPT API and I'm having an issue with updating the record field in my table with the response from their API. I have no idea why but for some reason I can't update the Long Text Field with the string in their response payload. Here is my script. Weirdly, it will work if I do a regex search using `exec` on the response first and then try to update the record... but it's only the first paragraph.  // generates blog post content let table = base.getTable('Blog Posts'); let openaiUrl = "https://api.openai.com/v1/completions" let record = await input.recordAsync('select a record to use', table); if (record) { // construct the body let body = { "prompt": "Write a 1,000 word blog post about how to become a " + record.getCellValue("Trade") + ".", "temperature": 0.7, "max_tokens": 1024, "model": "text-davinci-003", "top_p": 1.0, "frequency_penalty": 0.0, "

Hi, I created a custom extension and a button to call this extension from a specific record. I would like to use a field from that record in my code, but I keep on getting React errors because of the order in which it is loading.I can't use record.getCellValueAsString within a useEffect hook to capture when useRecordActionData  is loaded as it is considered using a hook within a hook.My end goal is to set number to the value in the Phone field of the selected recordTypeError: Cannot read properties of null (reading 'getCellValueAsString')Any ideas would be helpful.  const [number, setNumber] = useState(""); let recordActionData = useRecordActionData(); let base = useBase(); let tableId = recordActionData == null ? "null" : recordActionData["tableId"]; let recordId = recordActionData == null ? "null" : recordActionData["recordId"]; let table = base.getTableByIdIfExists(tableId); let record = useRecordById(table, recordId); setNumber(reco

I am using a modified version of the currency conversion script kindly provided in this thread https://community.airtable.com/t5/development-apis/custom-currency-calculations-using-scripting-panel/td-p/136067 by @Vivid-Squid but I don't want to have to run the script each time and select which record I want it to run on. What I'm after is that when I input an amount in the 'Amount (GBP)' field it automatically runs the script to populate the 'Amount (Home Currency)' field.Any ideas how I do this?My script looks like this (it basically converts an amount in GBP to equivalent amount in the users local currency):  let table = base.getTable('Currency'); let record = await input.recordAsync('Pick a record', table); let currencyType = record.getCellValueAsString("Local Currency"); let apiResponse = await fetch(`https://api.exchangerate.host/latest?base=${currencyType}`); let data = await apiResponse.json(); let conversionRate = data.rates.GBP; let result = await tabl