Ask the Community

I need to import the “Resolution” field from Jira Cloud  (Resolved, Won’t Do, Cancelled, etc) -- this is not showing up in the Standard fields, and is not listed on the Help page (https://support.airtable.com/docs/airtable-sync-integration-jira-cloud)Also wondering if there is support yet for custom fields?

Previously, PDF files stored in Attachment fields would open with an inline preview inside Airtable.Recently, clicking the same PDF files now forces a direct download ("Save as" dialog) instead of showing the preview.This happens even though:- The field is still an Attachment field- The file type is PDF- The file opens correctly if re-uploaded manuallyThis behavior worked correctly before and appears to have changed recently.Is this an intentional change in Airtable’s attachment preview behavior, or a regression?If intentional, what is the recommended way to maintain inline previews for PDFs generated via automations or external sources?

One thing I keep seeing with Airtable setups is how quickly costs jump once you involve external users.The moment you need vendors, clients, or partners to log in and update anything — even a single field — Airtable treats them as paid seats. It doesn’t really matter whether they’re full editors or just touching a tiny part of the workflow.People usually try a few workarounds:Shared views (which break as soon as you need write access) Forms (which don’t work well for ongoing updates) Interfaces (which still run into permission and billing limits)It works for small setups, but once you cross a certain scale, the math starts getting painful.I ended up writing a longer breakdown of why this happens and what people usually do instead, in case it helps someone else:https://clientlybase.com/problems/airtable-seat-cost-explosion

we are having a problem on some orders where the attachments are downloading when we click on the opposed to opening 

Hi all, I’ve got a company that works with lots of freelancers and I decided that instead of a service like Calendly, I’d build an interface on Airtable, in a base where they all sync their calendars so I can see their appointments overlapping, and find the “holes” where people are available to meet. It’s worked really well (using filters in the interface, so I find the exact team members I need for each meeting). The one thing is, I’m trying to protect our contractors’ privacy, and don’t want to sync any information that’s extraneous to checking their availability (I don’t want any event details other than whose calendar it’s coming from, start and end time). I’ve successfully toggled off all details EXCEPT the event title, which, it seems, cannot be toggled off.My workaround has been to create a formula field where I change the event name to “Person Busy,” so they don’t show up in my interface, which works fine, but I wanted to see if anyone knows of a way to simply prevent Google Ca

Hi,Has anyone tried integrating Culture Amp survey data with Airtable for analysis and visualization? I'm considering whether integrating the Culture Amp data would produce better data analysis and visualization results, while also saving a lot of manual work. Thanks!

I’m using the utility function getHexForColor to get the color the user defined in a single select field and use it in my interface.  However, the hex colors I’m getting do not match the colors used on the AirTable UI.For example for a selection I have, the Airtable Color is blueBright and when I call getHexForColor  I get #2d7ff9, however, the AirTable UI uses #166ee1.I also noticed shouldUseLightTextOnColor doesn’t seem to work well on dark mode but I think that’s expected as I think dark mode is still experimental, right?

Hi Airtable Community!We're Query Streams, and we built a tool to automatically keep your Airtable bases updated with data from your databases and APIs.What it does:Connect your database or API to Airtable and set a schedule. Your bases stay updated automatically - no more manual imports or copy-pasting.New records get addedChanged records get updatedDeleted records get removed (if you want)Works with:Databases: SQL Server, MySQL, PostgreSQL, Oracle, and many moreAPIs: Google Analytics, HubSpot, Shopify, Stripe, ShipStation, and more comingSchedule options:Every few minutes, hourly, daily - whatever fits your workflowCommon uses:Project data from ERP systemsSales numbers from your CRMLive inventory countsMarketing metrics from Google AnalyticsOrder data from ShopifyWe'd love your feedback:What databases or APIs do you work with most?What would make this useful for your team?Check it out at querystreams.com - we have a free tier to get started.Happy to answer any questions!

Submitting our form causes buffering. The device used to fill out the form is a cell phone.I am not sure if it’s a data issue or maybe the size of the logo used in the form.Can anyone advise about this issue? Thank you

can someone help with this formula, when there are no dates in the fields it returns 12/31/1969, i’d like it to return a blank or “none”  DATETIME_PARSE(  MAX(    IF({Last Entered Patrol Start Date (from Patrol Reports Section 1)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 1)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 2)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 2)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 3)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 3)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 4)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 4)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 5)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 5

Hello! I am baffled by this issue. Essentially, I am creating a way for my office to check-out certain items (laptop chargers, phone chargers, etc.) using QR codes. I’ve got a form that allows people to use their phones (yay!), and I’ve got an array of QR codes that are just text based and give the name of the item, so every time someone scans them, the text pops up with the item name, and then they answer form questions like:whether the item is being checked out or backed in (the person enters this themselves), the name of the person doing the checkingAnd this is great. My fields track all the information I need, the QR codes work, etc.  BUT I CANNOT FOR THE LIFE OF ME LINK these records to my “Equipment” table, which I am making so our tech team can keep an eye on things like:Is this item available or checked out currently? Who was the last person to check it out? When was it last checked out?As you can see, I’ve tried a linked field, but I have to continuously select the Equipment N

wondering how long it takes for a new question to get approved? I’ve asked a question a couple days ago and it doesn't appear to have been approved yet.

My base has crashed. No one can access it for some reason. I’m able to access other bases but not this one. I’ve put in a customer support ticket but haven't gotten a confirmation email for it. It’s critical that I don't lose this information, please help!

Hi all, Am I correct in assuming that there’s no way to duplicate a base via API? It seems weird that there’s so much you can do loads of customisation with creating a base via API except you can’t do the 1-click duplicate which is available in the UI? The problem with the create base API is that several things don’t work - e.g. AI fields. It’s not practical to use API to create base then manually have to go in and configure a bunch of AI fields by copy/pasting the prompt in 😅 Any workarounds anyone has found?

I’m creating a list of property. Each item has one or more owners pulled from a separate table. I need to be able to add multiple owners for each property and assign a percentage of ownership. Eg. Property A is 100% owned by Bob    (owner is pulled from another table but percentage is specific to this record)Property B is 50% owned by Bob and 50% owned by Jim. Any ideas?

I am not able to + icon in timeline view, even though Add / Delete record button is enabled. Can anyone please suggest the look around?

I track media hits through a Base with 3 tabs/tables: Reporter Info, Media Campaigns and Articles. I’ve been trying to link these 3 tables so when I enter an article’s URL in the Article table, which also has columns for Media Campaign and Reporter Name, it will automatically fill the article URL and Reporter Name in the Media Campaigns table...and the article URL and media campaign name will appear in the Reporter Info table under the Reporter’s Name. I have managed to link the Articles table to the Media Campaigns, so the article’s URL will auto-fill but the corresponding Reporter field won’t automatically appear for that Campaign. And If I’m on the Reporters page, and select the reporter’s name, I have to enter the Media Campaign name, which then does auto-fill the article URL tied to that media campaign and reporter.But I want all 3 fields to automatically fill in the Reporter & Media Campaign tables, when I enter those fields in the Article Table. Is that possible?   

 Hello, So Airtable has a script that allows importing a CSV file to update records, I am trying to use this script in an Automation but instead of uploading the CSV to the script, I need it to grab it from an attachment field. The Airtable Script: // Ask the user to import a CSV file containing a header row let csvFileResult = await input.fileAsync( 'Upload a CSV file', {allowedFileTypes: ['.csv'], hasHeaderRow: true} ); // The file importer will automatically parse contents for many file types, including CSV files let csvRows = csvFileResult.parsedContents; // Edit this to the name of a table in your base let table = base.getTable('Purchases'); let shouldContinue = await input.buttonsAsync( `Import ${csvRows.length} records from ${csvFileResult.file.name} into ${table.name}?`, [{label: 'Yes', variant: 'primary'}, 'No'] ) if (shouldContinue === 'Yes') { // Create new records from the CSV. // Edit these field and property names to match your

Have a form that a record picker is used to select a client and am trying to get a encoded URL into a button that can be selected from within an Interface page and have the client pre-selected.Have made plenty of Forms pre-filled encoded URLs (Button linked to formula building the URL), but cannot get this one to work - only seems to be for the Record Picker elementHave other URLs for this exact form that work fine, eg:https://airtable.com/appgAgIX5zNGRiox4/pagqzLgwghd7xBloc/form?prefill_Action+Type=Maturing+Term+Deposit&prefill_Task+Name=Maturing+Term+Deposit+-+(Bank)(Amount)(Date) But when I try to pre-populate the record picker under Client (which selects record from a linked table) it just doesnt fill it. I have tired manually creating:https://airtable.com/appgAgIX5zNGRiox4/pagqzLgwghd7xBloc/form?prefill_Client=Shane+HarrisHave also tried using the Prefilled Forms extension using field names or field ID and get the same result

Bonsoir, j'utilise une extension dans Airtable. Pour que cette extension fonctionne, il faut que je l'actionne manuellement en allant dans l'extension.Serait-il possible d'actionner des extensions via un bouton quand on est sur interface ?

I have an Airtable automation where I : Filter participation records based on the type of participation. Send a recap email with details specific to each type. Currently, I want to update the record to mark the email as sent. Right now, I need to include the “Update record” action in every conditional block, because Airtable executes actions only inside the branch that matches.Question:Is there a way to have a single “Update record” action at the end of the automation, regardless of which conditional branch was executed (ex : where I wrote HERE on the picture), instead of duplicating it in every branch?I’m looking for a faster, cleaner solution to handle this “final step” without repeating it multiple times.  

Hello!We have a medium-sized team (50 people) that has recently moved to a newly built interface. Everyone in this team will have editor permissions for all of the fields that they see in the interface pages.We also want to be transparent with our entire org (300 people) and share this interface with them as many will be making requests via a form that creates record in this interface. However, we’d like to restrict them to editing only a few fields.Is this possible? Or will I just have to limit them to having commenter permissions?

I’ve been going through tutorials and step-by step instructions, and I can’t figure out why my automation is not working properly. Please help!I have two tables (Export and Projects), each with a field called “Slug”. When a record is created in the Export table, I need an automation to check the Projects table and compare the “Slug” fields. If there is a match, no action is required. If there is no match, then a new record needs to be create in the Projects table.Here are my automation steps:The trigger: When a record is created in the Export table.Find records: Where Slug in the Projects table is equal to Slug in the Export tableIf [Find Records > List properties > length] = 0, then create a new record in Projects.Except, no new record gets created.

Hi all, I am trying to create an automation such that when a person creates a new record in the projects table, a view is automatically created in the tasks table such that any records with that record are filtered to be the only records shown. I figured that this could be done with scripting, but I’m not sure how to create a view in the tasks table with a specific filter applied.

I have noted several small but recurring limitations and ideas related to Airtable. I would like to understand whether these are on the product roadmap and, if not, whether practical workarounds exist. Enforcing a true unique key constraint on a table’s primary field Right-aligning numeric and currency values in the list interface Rolling up values in a self-linked table currently requires separate rollup fields per level and an additional formula to consolidate them into a single field Gantt chart dependencies only support day-level granularity; hour-level dependencies are needed A native delete-trigger mechanism Could you advise whether any of these are planned for future implementation, and what recommended workarounds exist today?