Ask the Community

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 invento

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({La

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:

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

 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 f

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)

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 > le

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?

unfortunately there is no way for 3rd party clients to update an existing record ussing forms. it creates a new one upon submission. it would be great if users can click on a link which opens up a partially filled in form > they fill it in even further and hit ‘ update’. updates existing record rather than creating another.

Hello everyone,I’m a junior data analyst and recently I was asked at work to integrate new data that is external to our management system. This data consists of Excel spreadsheets stored in Airtable. While researching, I noticed that there are several ways to integrate this data.For example, one could use “bridge” solutions like OneDrive or SharePoint, or connect directly to Airtable via its API.I was able to connect directly using the API (after creating a Personal Access Token), performing a blank query and using an M script to retrieve over 20,000 records. However, I would like to hear from more experienced people whether this could be the best approach compared to using a bridge solution. I personally think it is, but I would appreciate the opinion of experts.I have tested this with free accounts and demo Excel files with over 20,000 records, and I can retrieve them both directly via API and using OneDrive or SharePoint.Additionally, I understa

Is there any word on a feature to allow users to change the day of the week that you use for the first day of the week? I know a lot of US calendars will use Sunday for some reason, but I don’t actually know any businesses that run on a Sunday start. I’ve always used a Monday start to the week. And I’m pretty sure most of the rest of the world uses Monday to start the week.I noticed people have been asking this for almost 8 years according to the help center. And it seems like the easiest change.People were trying to suggest that we change our browser settings to some part of the world that does Monday start, and others were reporting that that doesn’t actually change the user experience. And making that change messes up every other application I use, so it doesn’t make sense. Just about all my productivity applications let you set this as a personal preference, and I’m kind of stunned this is still out there.How can this be escalated, or is there a way to see i

Should i sort it in  notion?] 

When I choose Blank Layout on Create Interface and add grid element manually, my right panel looks like this. When I choose List Layout to start, my right panel looks like this : How can I have this second option when I add grid element manually.

I had Omni build a Form for users to collect new record information. It has two levels: Claims and Claim Details. I wanted it to allow a user to create a new “Claim” and the continue to add each new “Claim detail record” from this same form. It works in the regular interface, but as a form it only allows the user to select from existing “Claim Details.” Is there a setting for that field that I need to change in order to adds new detail records?

I have an automation that copies fields from one table to another once the checkbox is selected. One of the field is “Marketing, Communications & PR”. When the automation runs, it splits it into two items “Marketing”, “Communications & PR”. I want to have it as one sector when it is copied to the 2nd table. I tried some of the ideas mentioned previously but got confused. I can try “Marketing Communications & PR” which might solve the problem but don’t like it.Is it possible to solve this issue? Thanks a lot.