Development & APIs

hey,I would like to have a field or fields that inside them will be a table that workers will need to fill while they are filling the form.for example, I have some items that i need to have control on the expire date and the pressure of them, so i need that in the form I will have a table with the names of the items as a column that already will be there and two columns for pressure and expiring date that they will fill. after that I need it to be inside a field. Thank you for your help.

My team of 7 disciplines uses airtable, each having their own base.   Each discipline has the same structure, but different syntaxes to describe their tasks.   Every time I create a new tool or script I have to set it up in each base. I could really use some advice on how to manage these scripts.   Ideally a real approach would be to have some shared library that automations could access.  It seems a bit absurd to me to have to copy and paste redundant scripts across each base.

when i create records,got a reeor about Authentication,the message is:{“error”:{“type”:“AUTHENTICATION_REQUIRED”,“message”:“Authentication required”}} this is my code and data: url = “https://api.airtable.com/v0/appjiuXPDkRCdDkhs/Pipeline” h = { “Authorization”:“keyE5yxxxxxxxxgb0x3”, “Content-Type”:“application/json” } data_list = {“records”: [{“fields”: {“Name”: “a”, “Priority”: 3}}]} print(requests.post(url,data=json.dumps(data_list),headers=h).text)

I want to create a unique share(public) link for each record, so I will send created link to each user, so each user can be edited only one record.Is it possible?Thank you! 

I am making a Vue.js project using Airtable API. have been trying to load more than 100 records using pagination, but when I use the offset value provided in the JSON file (itr3SD4RZBfi8WqqN/rec2JbRgoFjMrwofM), I get the following error:Uncaught Error: Airtable: invalid parameters for `select`:* the value for `offset` should be a numberHow could I solve the problem?

Hello Airtable community,Can anyone help me with sorting the list of records based on the created time via api? I would like to to get the order where the recently created record stays on top.Thanks in advance !

I'm issuing the following request to Airtable from Retool via the Sequin Proxy:{    "request": {        "url": "https://proxy.sequin.io/api.airtable.com/v0/{BASE_ID}/sample_requests_raw/{RECORD_ID}",        "method": "PATCH",        "body": "{\n \\"fields\\": {\n \\"Status\\": \\"my_status\\",\n \\"my_multiselect_field\\": [{name: \\"my_multiselect_field_value\\"}],\n }\n}",        "headers": {            "User-Agent": "Retool/2.0 (+https://docs.tryretool.com/docs/apis)",            "Authorization": "---sanitized---",            "Content-Type": "application/json",            "X-Retool-Forwarded-For": "49.37.243.51",            "x-datadog-trace-id": "2270676987214102529",            "x-datadog-parent-id": "168354330109794

I'm trying to do a search on multiple fields I've tried the following (as well as SEARCH)How do I do it?async function search(term) { try { console.log(term) return await base('Reviews') .select({filterByFormula: `FIND("${term}", {Name},"${term}", {Description})`}).firstPage() }catch(err){ console.log(err) } }  

I am getting the following error when trying to run a custom app (have tried 4 different apps and same result with each one). Any help would be greatly appreciated. Thanks ReferenceError: _airtableReact is not defined at Object. (https://static.airtable.com/js/by_sha/3f43c1b0/block_frame.js:1:61606) at r (https://static.airtable.com/js/by_sha/3f43c1b0/block_frame.js:1:361) at Object. (https://static.airtable.com/js/by_sha/3f43c1b0/block_frame.js:1:642245) at r (https://static.airtable.com/js/by_sha/3f43c1b0/block_frame.js:1:361) at Object. (https://static.airtable.com/js/by_sha/3f43c1b0/block_frame.js:1:704425) at r (https://static.airtable.com/js/by_sha/3f43c1b0/block_frame.js:1:361) at Module. (https://static.airtable.com/js/by_sha/3f43c1b0/block_frame.js:1:2445491) at r (https://static.airtable.com/js/by_sha/3f43c1b0/block_frame.js:1:361) at async Promise.all (index 1)

 Hi everyone, I'm making a 3rd party integration and I want to allow my users to update and revoke access to bases that they've previously granted me. While they can do this within Airtable, I think it'd be nice to have this option within my app. Can anyone link me to the relevant docs? Thanks 🙂 

Hello, i am new to airtable and really love it! I built an inventory list. This list is linked to another table for our videoproduction. Here we can choose items from our inventory we need for the shooting. This is working flawlessly. We now want to generate a packing list for the shootingthat displays all the selected items in a new table. So my first question is how can I setup a filter to the linked inventory list to show only selected items in our shotlist?the second question is: Is it possible to link items to another? For example If i select a camera for the shooting, batteries should be automatically selected as well. 

Hi , I was wondering if there is any way where we can update the table's column in airtable by taking user's input in thunkable ?

Hi,I am trying to call an external API using airtable script extension/automation.Those external APIs require Referer header validation. So, I tried the following based on the results of the search, but the Referer header is not set. await fetch(URL, { method:'POST', headers: { 'Content-Type': 'application/json', 'Referer': 'https://airtable.com' }, referrer: 'https://airtable.com', referrerPolicy: 'origin' }) Please let me know if there is a way to set the Referer header.The reason we need a Referer header is to verify that request is from the Airtable. If Airtable team have a remote server that performs script/automation, please let us know all the IP bands of the server. Then we can verify requests without Referer header.[Reference]- https://airtable.com/developers/scripting/api/fetch- https://community.airtable.com/t5/development-apis/airtable-domain-used-for-fetch-requests/td-p/133649 

Hello, devs,why am I getting this error again and again{"error":{"type":"AUTHENTICATION_REQUIRED","message":"Authentication required"}} my URL is from:https://api.airtable.com/v0/baseid/tablename?maxRecords=3&view=Grid%20view/-H/Toeken

I've seen a few templates that had ad data such as spend, impressions, engagement, etc imported into non-editable fields. This would be helpful to pull from a variety of ad and analytics platforms to correlate data.However, I don't see existing integrations which do this. Am I missing something or was this an example of custom integration work?

I had a AWS Lambda function that is to update an Airtable. And I am going to modify the function to adopt OAuth2 authentication. However, after testing in Postman, it requires user login in a browser and select workspaces and bases. But it is absolutly impossible for Lambda function and we don't want to store user account in the Lambda function.May I know if we can skip user login during the OAuth2 authentications? Also, can I predefine the allow list of workspaces and bases?

I created my own Extension under "Build an extension". Result was a full functional extension I was able to use in my Base over localhost:9000.Then I clicked "Delete Extension" inside the Extensions Menu in Airtable.Extension is gone, fair enough.But how can I reconnect the still existing Extension from my local machine to Airtable and use it again?Idea was to release it with `$ block release` add it in Airtable and find the "Edit Extension", like proposed here.FAQ sounds promissing:"When you run block release, the code is bundled and sent to the Airtable server — we host the released bundles for you. Collaborators in the base can then use your extension as well as install new copies of your extension in that base."But there is no hint how and where the released Extension is findable?!Google doesn't help, documentation doesn't help. What am I missing here 🥺?

Hey everyone,I am new to this forum! I thought id just throw this out there to see who I can stump and if I can get some help. I tried writing this with chatgpt but I dont think it has the most recent coding and API’s in its database.  I am on the free version of Airtable. The script I want to write is as follows.  First, the script gives a new entry or existing entry under the ‘ORGANIZATIONS table a random 6 digit number that no other entry will have and places it under the "Identifier Number" field which is a single line text. Once this entry has a number, it will never change. As a note, it would be really awesome if the first two numbers could be the year the record was created (for example its 2023 and the first two numbers would be a 23).  Next,  if any of the following fields match to new or existing entries: Street Address 1, Street Address 2, Zip, Organization Name. It will make sure all those above fields are correct and add the sa

Hi all,I'm trying to get the sender's url (within a strip) for an incoming webhook call so that I can response to call only from a specific domain.  I'm wondering how do i do that?  Thanks!EDIT Feb 24: I also need to get the sender's url for other reasons (such as deciding what the response will be); hence having access to it in the script serves multiple purposes.  Thanks!!!Best Regards,H8

I am attempting to fine tune by lead scoring in my Airtable CRM by sorting my Contacts by the amount of consecutive 'Voicemail' values in my 'Call Result' rollup field in Contact (which is a rollup from my Touch Points' table Call Result single select drop down.What I am looking to achieve is that those who have a lot of Voicemail unanswered get sorted to the bottom for my daily calls and the ones who have the least consecutive Voicemail unanswered get sorted at the top (so I don't keep calling people who just keep going to Voicemail when copy/pasting into my Touchpoints table).Any input on how I could do this much appreciated. Thank you!Video for context:https://share.getcloudapp.com/NQuWRnP0

I tried to use the API to create a new base. I copied and pasted the example from the official API reference, and the only changes I made is 1) used my own access token; 2) used the correct workspaceID. And the example returns{"error": {    "type":"INVALID_REQUEST_UNKNOWN",    "message":"Invalid request: parameter validation failed. Check your request data."    }} Not sure how this API could work if the example given by the official reference is not working.

Hello, I’m developing a custom integration to generate websites from Airtable. Wondering if there is any webhook to check when a field is updated via API. What i want to achieve is to receive it in my server. Thanks

Hey all,I am relatively new to using the Airtable API, and I might just be confused. I am hoping you all can steer me in the right place.I am used to using APIs to do things, but the Airtable Scripting Api seems weird to me.To my understanding, when I GET a record, I am only getting the record object with very little fields. Do I need to call getCellValue on all the fields to actually pull out the data or is there a better way to get the data out?

I am receiving a cryptic error when attempting to create a record using the code below:// Change this name to use a different table let table = base.getTable("Touchpoints"); //let ctable = base.getTable("Contact"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); let billTillString = await input.textAsync('Bill Orders till which date? (format YYYY-MM-DD)'); //let notes = await input.textAsync('Any Notes to mention'); let billTillDate = new Date(billTillString); /* //newRecs[0]['id'] = 'recDYGIT7fj80tTAH'; //let namer = new Array('recDYGIT7fj80tTAH'); //let Contact = record.getCellValueAsString("Contact"); // Contact RecordID //let recordID = record.getCellValueAsString("Contact RecordID"); //console.log("ID is: " + recordID); */ await table.createRecordAsync({ 'Start Date/Time': billTillDate, 'Contact': [{id: 'recI7YlI

I am attempting to setup a workflow for a Callback system for my Sales calls. My plan was that when a record in my Callback List View inside my Touchpoints table was updated to have the Call Result column be set to Voicemail select - that it would automatically duplicate itself and the duplicate would have 24 hours added to the Start Date/Time column - so that I would automatically see that record the next day in the Today's Calls View in the Touchpoints table.My challenge is that I am unable to find a way to duplicate a record based on the ID - so far I have created an automation and passed the record id as 'rec_id' variable to be accessed through the input.config() variable in the script that is set to run when my Trigger matches as per this screenshot:https://share.getcloudapp.com/p9uL4eKPAfter reviewing some other examples of scripts I have created a script which you can see in the Gist below:https://gist.github.com/HeadStudios/98c8837c02a0fb8540e3e36333281945While this script does