Development & APIs

Hi, I am new to Airtable. It appears to be a good product with zero support. I was hoping to find someone who can train me. I have a lot of questions and with each question, I seem to go down a rabbit hole watching video after video and it is taking way too much time.Is there anyone who can help tudor me? I would pay (of course). Things I need help on:creating a form that will populate 2 tablescreating a form that will update information on a table. (not overwrite)And this is just today.Thanks. Kira 

I'm missing two fields plus two new ones (4 Total) I have created in PowerBI from Airtable Base's. I'm extracting data from many Bases's, and only have a problem with a certain one. That data isn't special, the fields are simple "Single Select" Fields.I get no error's in the PowerBI query, it just doesn't show the four fields.

Hi allI've just got into scripting, and have fallen at the first hurdle. I thought this would load an array of all my records as objects, with each field in the object with its value as a a key value pair. let table = base.getTable("Contacts");let query = await table.selectRecordsAsync({fields: table.fields});console.log(query.records); However, it only seems to load the record id and record name. All other fields do not seem to be within the object.I have tried specifying the exact fields in {fields: table.fields}, and then console.log(query.records[fieldname]), but this also returns undefined. I'm coming from Python to Javascript, and I'm not a proffessional. Am I doing something dumb? Thanks in advance.

Heya, I’m trying to pass through an Airtable duration field as a string to Zapier but it gets converted from hh:mm:ss.ss to sss.ss Is there any formula I can use to preserve it as a text string value? Or alternatively a way to format the sss.ss back to hh:mm:ss.ss in Zapier? Thanks!

Hi there. I have created a time tracking app and used Airtable as backend. While it works perfectly for all get API requests I have troubles with post requests.Users need to fill in a duration that they have worked. While everything else works absolutely fine I can't work out how I can create an API Post request where the user can input the duration using h:mm format and not seconds. I can work around it in Airtable using the formula but it is not practical to have App users type in their work time in seconds.Is there a way to create a working post request? I am slowly starting to loose hope in Airtable. thx in advance

Hi!I am populating a table with plain text from user input via "Softr". I am now analyzing these entries via the Google Cloud Natural Language API to gain insights into Sentiment, Entities etc. and outputting this data into separate tables for each dimension I am analyzing.How can I make sure to automatically link the analysis in the API output tables to the original entries in the "Entries" table? I would need to do this to identify the analysis data back to the user that has entered the text.Thank you guys in advance!

Hi folks,I have a dataset that I want to import into a CMS for blogging.In order for it to import and display correctly, the field in Long Text needs to be in Markdown - Code Block format so that it can hold a large chunk of HTML rich text.Is there a way via Script or otherwise to automatically convert cells to be Markdown - Code Block by default, rather than clicking into each field, selecting all the text, and manually choosing Markdown - Code Block?Before state: Ideal state: Greatly appreciate any help!

I am developing an extension to manage orders based on an ‘Orders’ table and a (linked) ‘Order Line Items’ table. My next objective is to allow line items to be re-ordered by the user via drag-and-drop.I assume I can achieve this by adding a integer field to the table which gets updated by the drag event (?), but since this actually also is a native Airtable UI functionality and you can order records via drag-and-drop when your table/view isn’t sorted – I’m wondering whether someone knows anything of a custom order index being accessible or anything?I’m guessing not, since I can’t find anything like that in the API docs…But maybe you have other ideas to achieve this other than the one I mentioned? Or experience with a similar feat and you’ve got a js library you’d like to suggest or something?

Since the AirTable API was limited to 100 entries in PowerBI, we have manually inserted a code found on that video: How To Fetch Unlimited Entries in Airtable To Power BI via API - YouTube Now, data is falling into PowerBI? However, we connot set up automatic refresh of data. Do you know how can this problem be fixed? Meaning autonmatic refresh of data after unlocking the 100 entries limit. Thanks!

I've used Zapier on and off for the last couple of years for small purposes. This week I used it for something important, and I'm wondering if the approach I took is the best way to solve the problem.I have a list of people (about 120) that I needed to send and email to. The email contains a link to an Airtable form that I want them to fill out. I defined a date-time modified field in Airtable that I used to trigger the zap in Zapier. The zap then connected to my client's Google Workspace/Gmail account to send the emails out. I was a little worried about how well Zapier would perform, so I triggered smaller batches of records, about 30 at a time. In the end, it worked fine. We had to do a follow-up email, and I used the same process, just with a different body content for the message.I didn't ask Zapier to do anything other than connect (record by record) to my client's Gmail account and send each message. After each batch went out, I marked those records as "sent" by hand (easy in Air

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?