Ask the Community

Hi all, We are trying to define roles and responsibilities within our organisation. One of the possible models that works really well in Excel is the Responsibility assignment matrix or RACI model. See https://racichart.org/ It is basically a table with tasks as rows and roles as columns and in each cell a marker that defines if someone is Responsible, Accountable, Consulted or Informed (hence RACI) by sdding a letter in a cell. When this table is filled in properly we can give each employee a clear overview of his/her responsibilities. Im getting the hang a bit of Airtable and am able to use it for a lot of our organisational overviews, but I have no clue yet if the above mentioned could also be achieved with Airtable and lead to a satisfying result, or if I should just stick to Excel for this. Would be awesome to hear your suggestions!

I'm using a Repeatable Group with an Update Record inside to take a list of records from a Find Records action and update a field in the found records. When the list of records contains only one record the test runs successfully. When the list of records contains more than one record I get a received invalid input error. I think I know why this is happening.If I look at the Input table after a test I see Record ID listed there followed by a single record id if only one record was found. If more than one record is found then I see Record ID followed by multiple record ids separated by commas. If this is what is being presented to the Update Record action of course this will cause an error. If I'm reading the documentation correctly the input from the Repeatable Group should be a separate Record ID followed by a single record id for each record found rather than a single Record ID followed by multiple record ids. Why is the Repeatable Group not presenting the Record IDs to the Update Rec

I have this code that works well when filtering a field that is SIngle Line Text empName="Dummy Employee"let records = query.records.filter(record => record.getCellValue("Name") === empName); But If i want to filter a field that is a "Link to another record" field, it will not find it.let records = query.records.filter(record => record.getCellValue("Linked Name") === empName); I have a work around where I have a formula field that converts the value in the field "Linked Name" to a string, but i would like to tidy it up. Has anybody encountered such an issue? Thanks in advance   

is there a way to get rid of that irritating warning that pops up in an interface when an action i am taking will hide the record from the view? the whole point of my action is to hide the record from my view. as it is, i have to click off of the record and select a new record to make it go away. 

I have a table with the following fields:Capacity Required - a number Capacity Provided - a roll up sum of a linked recordGap Remaining - the delta between Capacity Required and Capacity ProvidedI have another field called Status that looks at the Gap Remaining and provides a single select option The following are all nested, so will be triggered in order: If the gap remaining is negative, the status is "overstaffed"If the capacity required was 0 to begin with, the status is "N/A"If gap remaining is 0 the status is "fully staffed"if the gap remaining is less than the capacity required the status is "partially staffed"The status field behaves as expected for 1207 records in my table. But now I have a record where when the gap remaining is 0 the status is partially staffed...if and only if one of the values being rolled up is ".10" and only for one specific record. If I change the value from .10 everything works, putting a .10 value in a different record als

I’ve used a Rollup column to aggregate data from another table. There are duplicates in the data being aggregated, as well as blanks. I use the ARRAYUNIQUE(values) to operate on the roll up data. I even created an adjacent cell with an IF statement to test for ISBLANK and it is being returned as being blank. Once I set a filter the Rollup column to not show empty cells, empty cells are still shown. The issue is in the only DB in my account, in the Organization tab.

Hello Airtable Community,I am trying to upload an image via Base64 encoding using Airtable’s uploadAttachment API, but the uploaded image appears as a broken placeholder or a very tiny image instead of displaying properly.🔹 My Setup:Using Base64 encoding instead of a direct file URL.Posting via API to Airtable’s /uploadAttachment endpoint.The request is successfully received by Airtable, but the image does not display properly.🔹 Payload I’m Sending:{ "contentType": "image/jpeg", "file": "BASE64_ENCODED_STRING_HERE", "filename": "example.jpg" } 🔹 What I Have Tried So Far:✅ Verified the Base64 EncodingTested the Base64 string in an online decoder → it renders correctly.Confirmed the Base64 string is complete (not truncated).✅ Checked API ResponseAirtable successfully processes the request.The returned JSON includes a url for the image, but it does not display correctly.✅ Attempted Fixes:Tried adding data:image/jpeg;base64, before t

my kanban is a list of products with different stacks. I would like it so that when a product is moved from one stack to the other, the autmation sends a slack message as to what stack the product is currently moved to.How do I access the name of the stack? I clicked on the blue plus sign but nothing there relates to the stack name. Just the product details.

Dear community, Does anyone know how I can mute this notification? I am building a check in and check out tool in interfaces, when someone has checked out, I want to have his or her name removed from the list with people who are in the building. It works perfectly, only that ugly orange message, which tells me that the changes will hide this record keeps showing up. Hiding the record is exactly what I want it to do. It would be great to have this sorted out. Thanks for helping!!

Hi all,I'd like some help w/ a rollup field.Table A is a summary record for an order and table B has the line items of an order.  Each line item can have a different delivery date.  I'd like to create a rollup field in table A that calculates the difference between the min and max delivery dates of all line items in table B.   This rollup field presently looks like: DATETIME_DIFF(MAX(values),MIN(values),'days').  When I do this, I always get values of 0 returned.  I suspect that I cannot use a datetime_diff function within a rollup but I'm not getting an error so I wanted to confirm?  (I also just tried max(values) - min(values) but that doesn't work either, (also returns 0s).  I'd rather have a single field in my data to perform this function over 3 (one for min, one for max, one for the difference).  Any suggestions / confirmation that this just isn't possible using dates?Thanks!

I've created an automation that follows this schema:The issue is that when it finds three matches in the name, it writes the name as many times as there are matches. I only want the name to appear once.I don't know how to achieve this.Thank you for your help

Hi,I have automated record selection and adding a fixed value to the existing values in a field. or example, adding a new category to the existing categories of a record. now I would like to have this fixed value as an entry from the user through a form or something else and then use the value in my automation. So the user enters the fixed value and selects the records he want to add the value to. How can I make this possible? Is there a dynamic variable that could record the input and use it in the automation?  Thanks

Hi!1. I'm working on an Airtable automation that uploads files using chunked upload from Airtable attachments to Google Drive. The process fails with the error:'Response status was 308 Resume Incomplete but redirect mode was set to error'The logs show the script:Successfully startsGets the Google Drive folder IDObtains an access tokenCreates an upload sessionFails when trying to handle the 308 Resume Incomplete responseThe error occurs during the chunked upload process, specifically when handling the resume/redirect status code 308.Can you help me understand how to properly handle the 308 status code in this context? Or session (chunk upload) is not supported by Airtable?2. Of course, I would choose not to use chunk upload and upload files one by one (some of them are 100-300 Mb), but I face the 512 Mb RAM limit. Maybe you can also tell me what file size won't result into an error upon loading to the RAM in full size? That would also let me create a script, that partially automate

Let me preface by stating that I am new to airtable.I have 1 table that lists every compartment of a project. This table has a priority field that changes as the project progresses. I have another table that lists the tasks of every craft/discipline in all compartments. Each compartment has numerous tasks in it. Each task has a compartment priority field. I would like this field to be automatically updated to match changes made to the priority level in the compartment table. I'm sure this is possible and have attempted to do so with a script but have been unsuccessful so far. 

Does anyone have an idea how to create a histogram like this or a similar one, preferably one that can be scrolled?

Hi folks : )I'm trying to put a link in an automated email, and it keeps generating a sequence of characters at the end of the url that makes the link useless. Here's how I have it set up in the body of the email:Here's what the end of the url is supposed to look like:230526796288065/sign_document_d4deb6cd5dd95877_79e90063180a7cbf.pdfAnd here's what it looks like when the automation is done with it:This happens whether I set up the field as a URL or single line text, and the link opens fine from the data view; these extra characters only show up in the link generated by the automation email.Since the characters look like html encoding, I looked them up and found this, if it helps:%EF : ï%BB : »%BF : ¿How do I set it up so this doesn't happen? Or is it a bug that can be fixed?Thank you for your attention,Shawn

Is anyone else constantly interrupted by 'Reconnecting' and/or 'Saving Changes' messages? This happens on some of my least complex bases with a tiny amount of data in them. It is extremely frustrating, constantly breaks my focus, and causes my work to take longer than it should. This has been brought up to Airtable many times, but it continues to linger, so I figured I would post here and see if others are facing similar issues. 

I get this notification every 3-5 seconds: “Trying to reconnect… please check your internet connection” The connection is stable. Other apps work well.

Hi there! We are trying to move our corporate budget tracking to Airtable. As an example, say we have $400 to spend, the sum of the rate would need to be subtracted from $400 ongoingly. Do you have any ideas on how to best do this without manually subtracting the sum from $400 every time?

 Hello,I built a robust CRM Base with interfaces for all the field reps in my company - everyone is using the Airtable app on their Iphones.Everything works great other than the fact that pretty much 99% of the time you cannot simply open the app and access the interface and begin editing accounts, referrals, visit logs etc. When someone opens the app, the record is un-editable, and you need to force close / re open the app to be able to start editing whatever it was you wanted to do.There isn't even a "swipe up refresh" function that many apps have - that I thought might be help.Any advice on how to mitigate this? It is super annoying for everyone.

Hello there, How does it work with the privacy of Airtable? Can I trust that my data is safe at Airtable? With kind regards

Hi all!My team and I are using Airtable to store user research as we build out and iterate on different products within our org. One of our goals is creating a repository to reference research participants we've spoken with in the past to contact them more easily for future research. The goal of this base is two-fold: the first being a structured pool of participants to pull from, and the second is a collision map to make sure we're not pulling the same participant for several different projects and overloading them. Our project teams often aren't aware of who the other team is recruiting for research and this has happened a few times. In the participant repository base, my setup so far is 3 tabs, 1)Ongoing projects and their timelines, 2) Our staff members and 3)The participant database. I have a lookup field in the participant database tab that lists the projects a participant is involved with and another field with the status of those projects, whether they are active or i

 Hi,I have a problem with the release of my extension.The application works fine in development mode after block run.I wanted to switch to release, but after using block release I get the following errorspatrykjachym@MacBook-Pro-Patryk obliczanie_transportow % block releasebuildingcopying package.json filecopying package-lock.json fileinstalling node modules[npm][npm] added 107 packages, and audited 108 packages in 862ms[npm][npm] 7 packages are looking for funding[npm] run `npm fund` for details[npm][npm] found 0 vulnerabilities[npm] npm warn config production Use `--omit=dev` instead.❌ Error: npm warn config production Use `--omit=dev` instead.Failed to build the block code!patrykjachym@MacBook-Pro-Patryk obliczanie_transportow % My package.json { "dependencies": { "@airtable/blocks": "1.8.0", "airtable": "^0.12.2", "react": "^16.13.0", "react-dom": "^16.13.0" }, "scripts": { "lint": "eslint frontend" }}using node 1

Hi,I have a project management interface where I have a table listing all of my projects and then another table for tasks.  On the task table, there is a link to the project table.  I have created an interface using kanban that shows the tasks by priority (high, medium, low).  In the interface, I allow the linking of the task to the project table.  When I click the plus signal, it only shows me the first three fields from the project table.  Is there a way to modify what fields show on the "linking" screen that pops up?Thanks,Kevin

I store price data in a Products table, and link to it in an InvoiceLines table (Many InvoiceLines from One Product). However, when a price changes (is updated) in Products the original price of that item should not change in those records in InvoiceLines that have already been created. Given the Lookup type doesn’t offer it, can you think of a way to achieve this? At the moment the only way I can think of, is to export data from one table and import to another?