Development & APIs

I'm looking for a way to get record fields by id not by name.It's possible while using select method using returnFieldsByFieldId parameter , but don't find how with find, update and create methods.The web API supposes this is possible, but I don't find the way to do it thru javascript APIAny dea ?

I should make a GET request with body (I know, it’s strange, but this is what I have to do). Here below my script: let inputConfig = input.config(); let deliveryNote = inputConfig.deliveryNote; // array let courier = inputConfig.corriere; // array let deliveryDate = inputConfig.dataRitiro; // array let token = inputConfig.token; // string let authToken = String("Bearer " + token); var trackingHeaders = new Headers(); trackingHeaders.append("Authorization", authToken); trackingHeaders.append("Content-Type","application/json"); var trackRaw = JSON.stringify({ "deliveryNote": "2501461270", "courier": "DHL", "deliveryDate": "2022-05-05" }); var trackReqOption = { method: 'GET', headers: trackingHeaders, body: trackRaw } await fetch("https://api.retelogisticastorage.it/api/externalServices/trackDelivery", trackReqOption) .then(response => response.json()) .then(result => console.log(result)) .catch(er

As a personal project, I'm doing a no code app that uses Airtable as a database, the connection is done thanks to the Airtable API. But as we all know, Airtable is transitioning to the Personal Access token. Since API keys will be discontinued, I would like some help to how to connect to an air table database using Personal Access Token or Aouth integration to bubble ? Thanks for your time in advance.

Have a specific use to an influencer where I have dumped data from an exported CSV by quarterly revenue earned through affiliate marketing platform known as LIKEtoKNOWit. The login to access this CSV is behind a login page for each influencer/blogger to earn commission through links to products on Amazon or other ecommerce websites. Currently there is no API connection for creators through LIKEtoKNOWit and so I would like to create something where I can capture this data exported daily. No need for up to the minute calls or anything, but I am new to airtable and am hoping to build an interface for each brand to aggregate data by quarterly revenue and by brand. Is there a way to the data into airtable without LTK having an ability for creators to gather this information through an API?

Hello, Did anyone try to connect airtable to aws s3 (directly or via zapier) and notice an unusually high amount of "read object" calls coming into the s3 bucket from airtable?

Hi All I am trying to pass Airtable data into Revit with the help of the DynaWeb dynamo package.I created a grid view and integrated this with the dynamo script.I am confused why the 3rd row is in index 02nd row is in index 5Please help me to solve this issue. I appreciate any help you can provide.

Hello, I represent a manufacturer who makes custom objects. We use Airtable to manage our sales leads. We've developed a macro spreadsheet in excel to provide pricing in the way we need to. I'm considering a new workflow which allows customer to upload their documents using airtable form. Once the data is inside airtable, we could then access it inside Excel using this add-in to eliminate many keystrokes and human error. If anyone has experience using this add-in i'd like to see how your team likes using it and any other potential issues to look out for. Thanks for your time. 

I have setup an automation to send emails on record creation. However, the automation fails with a message: An unknown error occurred.The automation succeeds if I change the send to email to a personal email I have.I suspect this is something to do with the Airtable not supporting one of my emails but I cannot figure out why.Does anyone know how I can resolve the issue?The email that fails is hosted by Ionos web hosting.The email that succeeds is hosted by Gmail.Thank you,Ali

There's Table T1 that has 3 rows: R1 - ID: 8b71R2 - ID: c132R3 - ID: 90faI duplicate T1 and generate a new table `T1 -Copy`, but the IDs are now different. Is there any way to know the original ID from T1 using the API?

Hello, Did anyone try to connect airtable to aws s3 (directly or via zapier) and notice an unusually high amount of "read object" calls coming into the bucket?

Hi I’m trying to add data to a table using the API, one field of which is a ‘Multiple Choice’ field, so i’m passing data as an array. However, it will only accept the POST if the table has predefined multiple choice options and you’re sending a POST with one or more those options, else it throws a ‘INVALID_MULTIPLE_CHOICE_OPTIONS’ error. And, from what I see you cannot create multiple choice options by using the API either. I assume this is expected behaviour, but… is there a way of programmatically adding new options to a multiple choice typed field, or even getting a list of acceptable values for that field, so i can check the data before calling the API? Thanks! mk

HiThis is Elias. I work with Airtable Api. I need to know is airtable personal token has any expiration date?I did not get any mention about the token expiration date over the api documentation.Please reply the posts.

 Hello, folks, i am trying to change the filename for files in an attachment field, and i noticed that when there are a few records it seems like the names get changed, but when i try to process more than 30, the attachments automatically get removed. I also noticed that the comments in the records id indicate that two actions have taken place  But for the ones that worked it shows just one time the record has been edited  The script that i use is below, i noticed a similar behavior when i was trying to upload attachments from a URL as well, some get updated, while some do not.   // Define the table, view, and field names const tableName = 'StuTable'; const viewName = 'StuMis

HelloAssessing airtable for some internal operations work that has some custom process flows, part of which sometimes require filling data to move to the next step in the flow.We're looking at both the "data" option and the "interface" option.The "Data" option seems to provides more flexibility when it comes to custom extensions (using the bocks sdk). On the other hand, the "interface" option seems to build nicer UIs but with more limitations on UI customizations.Did anyone go through a similar scenario of assessing data's extensibility vs interface's nice UI?     

I've been using passwordless login through the Wized v2 beta, and today the magic links stopped getting emailed. The requests are successful (New users still created in Airtable, status code 200 etc), but no email. Is this a known issue at the moment?

Hi,I'm trying to patch call an empty cell which is always be in the last/current row. Is there a way to do this with a parameter?

Struggling to install the blocks CLI. Getting the following error. 4757 error code 1 4758 error path /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/@sentry/cli 4759 error command failed 4760 error command sh -c node scripts/install.js 4761 error node:internal/modules/cjs/loader:1093 4761 error throw err; 4761 error ^ 4761 error 4761 error Error: Cannot find module 'core-util-is' 4761 error Require stack: 4761 error - /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/are-we-there-yet/node_modules/readable-stream/lib/_stream_readable.js 4761 error - /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/are-we-there-yet/node_modules/readable-stream/readable.js 4761 error - /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/are-we-there-yet/tracker-stream.js 4761 error - /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/are-we-there-yet/tracker-group.js 4761 error - /opt/homebrew/lib/node_modules

Is there a way to have a list of employees on a Base as 'users' (the tagging option) without paying for their seats? None of them will be collaborators or have access to the Base or Workspace, it is just a feature that I find very useful. I selected Development and APIs because the use case is currently on Softr, which is connected via API. Use case: I have a form that is being used externally (on Softr.io); I want to be able to allow my Softr.io users to 'tag' to an employee they are requesting in the form so that the Base automatically associated/assigns a request or task to that employee. Again, these employees would not actually be a user or collaborator on the bases. It is only for me to organize the workflows when external users in my front-end are requesting specific internal users. Thanks. 

Hi,Looking for some scripting help. I am manually copy and pasting values from a Lookup field to a Multi-select field on the same table and want to know if there is a way to create a script that could do this process for me.  Example below:Want to copy the teams in the "Lookup of Teams" field and paste it into the "Manual Copy Paste (multi-select).  Any suggestions appreciated! Thank you. 

I would like to add a signature block to a inspection form. I am a small company(2) and I do not want to spend 1200 yr for 1 mini extension.

Hi, Could someone demo this script showing how to properly create the parent/child and template tabs to utilize this script? I am having difficulty getting it to properly work. Thanks.

Hello Airtable Community,I'm working on a script in the Airtable Scripting App that processes a table with 1700 records. The script is designed to fetch records from the table, generate tracking links using the Impact.com API, and update the records with the newly generated tracking links.Unfortunately, I'm experiencing an issue where the script gets stuck at the "Fetching records" step. The script does not proceed to fetch any records or send API requests, and no further logs are displayed. I've tried various approaches, including fetching records in smaller batches, but the issue persists.Here's the latest version of the script:let settings = input.config({ title: "Add Impact.com tracking links", description: `This script generates Impact.com tracking links for the specified Envato links and adds them to a new field in the same record. To use this script, you will need an Impact.com API key, affiliate ID, program ID, and media partner property

I want to Create Record by API and one field "Multiple choice" throw error.I want to add "Other" value and I get "Value not found in options in parameter"And when I try add this option I get error, even if it's one of valid option In other cases like "SP z.o.o.", "SP akcyjna", "SP komandytowa", it work well.  

I’m pretty new to JS, but trying to learning all the time. Some of the first code I wrote in the scripting blog has gotten supper hard to update, so thought to experiment to write small modules to keep divide up the code. However it seems I can’t put buttons into functions? let test = function () { let firstClick = await input.buttonsAsync( 'What do you want to do?', [ {label: 'Check todays rate', value: 'today', variant: 'danger'}, {label: 'Convert currency', value: 'convert', variant: 'primary'} ] ) } this gives me an error saying ‘SyntaxError: await is only valid in async function’ does theis mean my button can only be used in the global scope?

Hi,I need to lookup a value from shipping rate tables based on the weight value from another table.I have two tables I need to look up data from, an example of one is below, The other is the same structure but different data.This is my source table containing my weight values.I need to select a value from the 2nd column on the above table, when the weight in my source table is between two row values.For example, if source weight is 7.75kg, it should return 53.3 for the rate.Hope someone can point me in the right direction 😁Thanksjohn