Other Questions

Hi there, I'm receiving the following error when attempting to register a webhook via curl to notify when there is a new entry in a table.  "error":{"type":"INVALID_REQUEST_BODY","message":"Could not parse request body"}Here is the code that I'm attempting to execute: curl -X POST "https://api.airtable.com/v0/bases/MYBASEID/webhooks" -H "Authorization: Bearer MYTOKEN" -H "Content-Type: application/json" --data '{ body { "notificationUrl": "https://MYURL", "specification": { "options": { "filters": { "dataTypes": [ "tableData" ], "changeTypes": [ "add" ], "recordChangeScope": "MYTABLE" } "includes": { "includeCellValuesInFieldIds": [ "MYFIELD" ] } } } } }' same goes forcurl -X POST "https://api.airtable.com/v0/bases/MYBASE/webhooks" -H "Authorization: Bearer MYTOKEN" -H "Content-Type: application/json

Once a project is completed, what the best way to archive it so the information is available to reuse or reference later?

We’re using Integromat to insert rows into Airtable, and have suddenly started getting this error message as a response from Airtable without any changes on our side. “You are not permitted to perform this operation because the field or table has been configured to limit who can perform this operation”. It literally started happening half way through a scenario, so the first X rows were inserted fine, and then the rest came back with this error. There are no field specific permissions - everything is set to ‘Editors and up’. Can anyone help? Thanks

I am trying to find the Client Secret and Client ID in Airtable to connect with Workfront Fusion. I searched and couldn't find it easily. Anyone have any idea on where this is located at in Airtable? Thanks!

I'm experiencing really horrible lag for myself and and all users this morning. We're having to constantly refresh the page to make sure we're not working on top of one another.Is anyone else having this issue?

I have two tables: Employees and Licenses. I created a view, named Current Licenses, on the Licenses table.  This view ensures that only the active license for an employee is displayed.I linked the Employees table to the Licenses table, specifying the view: Unfortunately, the list of Licenses in the Employees table includes the non-currently licenses.Am I doing something wrong?

 Too bad Airtable Extensions not available on mobile apps yet. I searched just to see what comes up and here I found this post in Airtable Support Docs talking about the differences between desktop and mobile. I don't quite understand what the explanation means under "Extensions". Here is what is says about availability of Extensions for mobile with a comparison table:Use a share link for a whole base in your device's browser to view all the extensions in the base.https://support.airtable.com/docs/differences-between-the-desktop-and-mobile-versionsWhat share link?  Is it standard share link to the table?  I don't see any share links to extensions.  Does it mean I can share the extension and access the shared view on mobile browser and then run the extension from the mobile browser simply from the shared link? 

I have two tables that I have linked:Case StudiesEvents and PolicyEach of these tables has a 'Region' field in the accompanying records (set to single selection). I am trying to set it up so that when the location fields match between the two tables, these matching record are linked automatically. For example: There is a record in the Case Studies table named 'European Union'.There is a record in the Events and Policy table named 'Brexit'The 'European Union' record has a single selection field called Region, which is set to 'Europe'.The 'Brexit' record has a single selection field called Region, which is set to 'Europe'.Ideally, the 'Brexit' record would automatically add to a linked record field set up in the 'European Union' record (I know this will also be vice versa, which is fine). I would like to repeat this in these tables with different regions (i.e. Africa, Asia, North America etc.). For example, a record titled 'US Election' in Events and Policy will

Hi Folks,We have one or more attachments (pdf, docx mostly) per record, and want to run a Boolean search on the content of these documents. This is similar to how you can search in Google Drive, Dropbox etc.@kuovonne I saw some of your suggested workaround. Do you know if Airtable or any extensions / integrations have done this seamlessly?Thanks in advance,Vikram

As accountant not programmerfrom where I must start to make accounting system same waveapps 

please help me with this. Any type of help is highly appreciated. require(“dotenv”).config(); const Airtable = require(“airtable”); const base = new Airtable({ apiKey: process.env.API_KEY }).base( " " ); const express = require(“express”); const cors = require(“cors”); const bodyParser = require(“body-parser”); const app2 = express(); app2.use(cors()); app2.get("/featuredPaths", (req, res) => { console.log(“query params::”, req.query); var remOrLoc = req.query.remOrLoc; var skill = req.query.skill; var site = req.query.site; var skillnew = req.query.skillnew; var country = req.query.country; var vetted = req.query.vetted; var limit = JSON.parse(req.query.limit || 100); // var formula = “FIND(’” + sitename + “’,Sitename) > 0”; var formula = “SUM(FIND(’” + remOrLoc + “’, Remote_or_Local) > 0, FIND(’” + skill + “’,Skills) > 0,FIND(’” + skillnew + “’, skills_new) > 0,FIND(’” + site + “’, Sitename) > 0,FIND(’” + country + “’, Country) > 0,FIND(’” + vetted + “’, Vetted)

Hi, Airtable Team! :wave: Cloud file attachment (GoogleDtive, OneDrive, Box etc.) take up space in the dedicated storage? Best regard, Andrey Ttbomk

Hello there. I’d like a view to only show the last record added. I can’t seem to figure out how to do this. Is it possible? If so, how? Thank you!

I have the most updated iOS version of the app and I’m having issues with my cover photos loading for the gallery view.I see others had this issue in the beginning of May and they were told with the update it should be fixed- I downloaded the app recently and see that this is still an issue…anyone else having a problem?Upon first loading the app today, all gallery view covers were blank- I did attempt to simulate customizing the cards and changing from ‘fit’ to ‘crop’ and back and only a few loaded. Some are still blank😩   yes, I did email support but their immediate reply is to check with this awesome community in the meantime 🤣

Good morning,  Not sure what the issue is, but for the last hour I have not been able to access any of my bases. Airtable is not loading my bases. Instead it times out and I receive error pgl3RApTgwNHAw7d7.Anyone having similar issues?

Context:  I'm working on an Animated TV Show and have made a Base for tracking the Production.  The main function so far has been tracking all of the various Meetings/Milestones/Working Periods that happen within a certain Department.  I also have a Crew List Table and another Table that tags those Crew Members to specific Teams all within the same base.  I then have tagged those Teams to the Events that they're needed for, so I could add those people to Google Calendar for Meetings, but also to track what Teams are working on at any given time and what Milestones they have to be aware of.  One feature I'm trying to build is a way to quickly evaluate Time Off requests by plugging in their requested start/end for their Holiday and then seeing all of the Events that fall within that range - see screenshot for the filters I started with.Problem:  I had a Working Period in this instance (see screenshot), that the Team shown needs to be involved in, that w

My boss - who has been using Airtable with the rest of our team for years - has suddenly been unable to log into the site and gets a privacy error whenever she tries:None of the rest of our team has any problem accessing Airtable. She has tried using different browsers, clearing browsing data, and using incognito mode, all to no avail. Have any of you seen this issue before, and do you have any other recommendations? I created a ticket with Airtable support, but they seem to be particularly slammed at the moment and haven't responded yet, so I thought I'd try here.Thanks!Joel

I'm trying to set up a formula and could use some help. The first part is simple and is working: IF(Actuals <= {Approved/Expected Amount},"✅ On Track","❌ Over Budget") However I would like it to provide a different result ("Profit") if the Type of record is "Income" vs "Expense" and I'm having difficulty getting that second part to work. Any help is appreciated! 

Is it possible to disable CSV export for some users?

I’m using Airtable, but whenever someone tags me or mentions me I do not receive a notification. I may have unsubscribed from email notifications at one point. When i go to settings it still shows my notification settings as being on. Any ideas please :slightly_smiling_face:

I've been getting notifications from Airtable that I need to verify our domain (for enterprise). It says:By June 1st, your domain(s) will be disabled if not verified. If disabled:All users on your domain will be treated as external users and may not become organization members.You can neither configure SSO, nor require login with SSO on your domainSCIM cannot be used to provision usersI'm in the process of doing this, but if it doesn't happen by the end of the day, does this have access implications for my users? If they are treated as external, will they lose access to existing items?

I have two Tables in the same Base.One field in the table (APPAREL) should look-up the value in another (SC APPAREL SYNC)Here is the Field (TEST2) in the APPAREL table which should look up the SAMPLE COORDINATOR in the SC APPAREL SYNCAs you can see, every record in my SC Table has a value (no empties)As you can see... all records are empty in the APPARELThe field I am looking up is a synced field from another table. How can I fix this?

We cannot figure out the lost payments. All this time, access to Pro has been blocked. We have been unable to continue working for a week already.Please respond to our request:Your reference number is: 00564457

Certainly! Here are some ideas on how you can create a fashion pants community database on Airtable:Pants Inventory: Create a table to track various types of pants available within the community. Include fields such as pant style (e.g., jeans, trousers, leggings), brand, size range, color, material, and any additional notes or descriptions. This helps members discover and explore different pants options.Member Profiles: Set up a table to keep track of community members who are interested in pants. Include fields such as name, contact information, preferred pant styles, size, and any specific preferences or requirements. This allows members to connect with like-minded individuals and exchange recommendations.Pant Reviews: Create a table where community members can share their reviews and opinions on different pants they have tried. Include fields for the pant brand, style, review rating, fit, comfort, quality, and any other relevant comments. This helps members make informed purchasing

I am trying to upload an attachment and I am unable to do so.  If I am on another machine, I can upload an attachment by either clicking on the + button or by dragging and dropping a document to a record.  I have checked the permissions, checked in another browser and cleared the cache for the browser that I am currently using and I still end up with the same results.  Please advise on what I should do next. Thank you,M