Ask the Community

Hello everybodyI have 2 connected tables : Contact and Contact BehaviorIn Contact Behavior, I want to follow the way my contacts interact with my posts, my communities.In Contact, I have the general information about my Contact with a formularI connected Contact with Contact Behavior in 1 to 1 relashionship.All I want is, when I create a new contact in Contact Table, it creates automatically the contact in Contact BehaviorIn Contact, I have the forname, lastname, mail, phone and I generate by a formula the Complete Name (Lastname&” “&forname)In Contact Behavior, the first field is the Complete Name.My automation is :Trigger : when a contact is created in Contact tableUpdate the entry in Contact Behavior with this argument. Origin table : Contact. Id of the entry : Airtable record IDField in Contact Behavior : CompleteNameWhen I run the test, everything seems OKWhen I add a new contact it doesn’t worlDo you have a suggestion please 

No mention of this in the docs.Is it possible to limit the number of found records by setting the maximum limit to “1”?

Can anyone help me with my weekly automation to make sure all of my products from my latest product list are listed in all tables? I need a code for this: I want to check on airtable that my “inventory live”, “stock evaluation”, and “cost evaluation” bases, all include the latest products from my table: “latest product info”.

For context - I’m a literary agent and I’m trying to create a way to have a ‘live’ brochure of clients who are available for writer for hire gigs that I can share with editors. I’ve created a form which the clients can use to add and edit their details whenever they want and at the moment I have this set up to feed to a gallery interface just through the airtable interface section. It works reasonably well, but the long text field doesn’t seem to have a space big enough assigned to it in the display so a lot of the text is being cut off and I don’t want editors to be able to open the record because there’s other information there that I don’t want them to see. It’s also cutting off if the authors select more than 4 genres which is a bit frustrating.  Is there a way to adjust how the gallery interface deals with data display? Or is there another option within airtable I could look at that would enable me to customise more? I’m not very familiar with interfaces so this is a bit of an exp

Hey Airtable community, while building user-facing tools with platforms like Framer and WeWeb, I’ve noticed how much visual polish and UI flexibility matter for acquiring and retaining users. Small details increasingly shape how “premium” and trustworthy a product feels.This made me reflect on Airtable’s UI, especially as it’s moving more into the app and interface builder space: Many interactions (hover states, focus changes, view switches) happen instantly and without transition effects or micro-interactions. That looks less premium and more “beginner forgot the transition effect”. UI customization is still very limited. Things like border radius, colors, backgrounds, or basic theming aren’t adjustable, which makes it hard to align Interfaces with a brand or use them confidently in customer-facing scenarios. I’m curious: Would you prefer more visual flexibility, even if it’s optional or “advanced”? Or is Airtable’s current design philosophy exactly what you want? Would love to he

I set up a Teams account for our nonprofit and got a discounted rate. Later, I found out that one of our volunteers had already created a Teams account and was paying for it. I asked AT Sales how to merge the volunteer’s account with ours, but I got a canned, unhelpful response. Can someone help with the merge?

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