Ask the Community

I am so disappointed in the updated Record Review layout. My team was satisfied with the filtering and sorting available with the legacy element-based record review layout. I am trying to find a way to customize an efficient arrangement of fields, but all I can do now is list them one per row..? I don't want to have to look for an Airtable alternative just to build an attractive record browsing interface.

Hi all, I have read a couple of posts on this question and tried the suggestions but I can’t seem to get it to work. I have a view that I am sharing via a view only link with various collaborators. In order to allow them to update certain fields of the records, I have an Edit Record button in the grid that opens a form where they can update the information, then an automation to update the form. One of the fields they can update is an attachment field. I want them to be able to add new documents without deleting the existing ones, as for certain records there are multiple documents that will be added over time. I would rather not create a separate field for each attachment and instead just add the new ones in with the existing ones. Is there a way to do this without using a script or an external program. I am on a free plan, and we have no budget for anything more. @Kamille_Parks I saw that you offered some solutions in the past. Below is a sceenshot of how the automation works at

Hi all! I am running a T-shirt business and currently am filling orders. I have embedded a form onto my website so that when customers want to place orders, their info goes straight into AirTable. My question is this: is there a way to save this info in a customized PDF or Word doc template, and send this back to my customers? Any help would be awesome! Thanks!

Relative Airtable Rookie (Well, maybe a Sophomore) here… So forgive me if this is obvious or somewhere - but I sure have looked and haven’t been able to find it! I know you can use Airtable forms for other people to input info directly into your spreadsheets. Cool. Got it. But I need the opposite. What if I have all the info, but I want to generate a report or a form to distribute that? (And make it look nice?) Case Study: I produce a television talk show and I want to generate several different “forms” or reports. Examples: a research dossier for the hosts to prepare for their on camera interviews of these subjects with headshots, bios, topic-related background, social media links, etc. on the guest as opposed to a different one for the editor - with much of the same overlapping info but links to where all the A/V assets are (DropBox, whatever) versus one for “transpo” - providing home address and cell phone for the limo driver to pick him/her up, drop them off (but no one else should

Hi, how can I download the submissions to my form? I need to save each form individually as a pdf, word doc or something similar (not in excel format!) so that I can include it in the file for each person that completes the form. I kindly appreciate guidance on how to download each form individually. Thanks,

Hi All, I am trying to create a button that one clicked will launch a web page that uses an internal url (or external) as the prefix with a cell value as the suffix. For Example: https://trsau.reecenet.org/pos/other-stock-on-hand/products/12345 The first part (https://trsau.reecenet.org/pos/other-stock-on-hand/products/) will be common in the formula with (12345) being the part that changes. To achieve this i have been try to us the following formula: The issue is that once pressed the i get the following error in the address bar.

First post, so I am sorry if this is not clear as to what I am trying to do.  My goal is to have a formula in a field determine if 3 different fields are either blank or not blank.  Depending on whether they are blank or not return a message to that formula field outlining what is missing and required.   See picture below.  I have tried to nest IF functions using blank or not blank, but I keep getting errors.  I have also tried to use the AND and OR functions in combination with the IF function with no luck.   A formula would work best for us.   Any ideas would be greatly appreciatedthanks Bob 

Hi,I have a Table called Budget. Budget table has multiple fields like Product, Cost, Monthly cost(Jan-Dec), budget year dropdown field, Property list, etc,.This is the form for creating a new budget in the budget Table.I want to list the property name with existing budget data in the Budget Table. If I chose X property Name, That Property Name already has a budget in that table, So I want to list down the budget cycle values only(years 2024, 2025,  2026, etc.,) depending on Property Name.For example, Property A has budget details with the budget cycle 2024 and 2025. So When I choose Property A in Property Name, Budget Cycle should list only 2024 and 2025. So that I can choose any one of these.Is that possible?

Hi everyone. I am currently working on a project for my client, to connect his platform dashboard with airtble.I am at the step in my demo test where I call webhook payloads api to get changes that are made in airtable table records. for changing existing record is ok. put for creating new record the payload returns "changedRecordById" instead of "createdRecordById" plus the payload is generated for each change on charate in a field.its important for me so i can lay my backend logic when to call update or create method. anyone has any idea why is stil receive payload this way. Thank you

Hi there, I am trying to calculate employee hours worked over 40 within the span of a worked week (Sunday - Saturday) for overtime calculations, and can't figure out what the formula would be for this. I have start dates and times on my sheet already.

We’re a film festival looking to pull the titles of our submissions in order to create slugs that can be used to create virtual posts on our WordPress site. I need a way to parse just the text from the submission, with the ability to remove special characters (i.e. " ’ ! ? ; : @ # $ % ^ etc.). I’ve gotten to this point so far: LOWER(SUBSTITUTE({English Title}, " ", "-")) This allows me to hyphenate the titles, but still includes special characters. Is anyone aware of a workaround for this, or do I need to manually create my slugs in this case? Cheers!

Hi all,Hoping you can help me. Check spoiler tag for completely detailed explanation of my situation, just in case you can spy a base design issue that could easily be fixed: I have a table called "Products" and a table called "Definitions". I'm linking each product in my products table to the definitions table. The record in definitions is the classification/type of product, i.e., a wall mounted faucet. In the Definitions table there are internal instructions that our staff need to check off using rich text format before the product is considered ready. It would be instructions like "Wall mounted faucet is not located on an exterior wall".I'm using a Lookup in my Products table to retrieve these instructions and attach it to products based on the definition. Unfortunately when I use a lookup to retrieve these internal instructions field in the Products table, it loses all rich text format. Fair enough - as per this help article I get that this isn't supported right now:&nbsp

I keep getting these "Something Went Wrong" emails from Airtable when my automation fails, but there's no information in the email.Is there any way to customize these emails to include more information? It's getting pretty convoluted to dig into the automation error, save the Record ID or other info, go back and find it in my base, etc, etc, etc.TIA,ML 

Hi — I have a lot of experience creating interfaces for my team. I have several that work great, and all commenting is run via the Interface with no need for team members to comment in the underlying base.Last Friday, I created a new base and interface for my team, but it seems no matter what, comment notifications are opening w/in the base rather than the interface, even when the initial comment was made w/in the interface. Can someone help!? 

Hello,I would like to create a Zapier automation to notify us when a client changes details of a field in our shared Airtable.As we use forms, it seems to set the "Last Modified Time" aswell as the "Created" time, so I cannot just create a simple view to show me only records that have a "Last Modified Time".Is there a workaround in Zapier? or is there a formula I could use to say "If last modified time is greater than created time etc etc" Thanks

Is it possible to list views from the web api using oauth?  I know make.com and zapier have this functionality, but according to the dev docs it seems like this shouldnt be possible.  I've done this using access tokens for enterprise but I want to implement this functionality using oauth.  

Hey there, I’m in need of some advice from the community. We have recently set up Airtable as a CRM and it is working wonderfully with the exception of e-mail tracking. We’re still using Hubspot for e-mail tracking with a button from within Airtable that takes you directly to the deal in Hubspot - so you can see/send comms to a contact. However, we’re really keen to ditch Hubspot but I don’t think it’s possible to solve the e-mail tracking from within Airtable. Does anyone have any experience with any other CRM’s that offer email tracking and offer a clean/straight forward integration with Airtable? Currently, we use integromat to bridge the gap which works well but we cannot use it for contact mapping. Any help would be greatly appreciated.

Hi, I've created a simple email automation that sends volunteers a record of their contact info (people table), plus their assignments from previous years (assignments table). The assignment details appear fine as lookup or rollup fields in the people table, but when I try to run the automation the assignment details are blank.Does it have to do with the fact that it's a one-to-many relationship (one person, multiple assignments)?People table with rollup and lookup fields:Automation email fields:Automation preview (contact info not shown but appears correctly):Thanks for any insights; I've been struggling with this for hours! 

I have two dates formatted the same way and displaying in the table consistently. When I add them to my email, I am getting two different formats. The data format in the table is US. One appears correctly (5/3/2024) and the other appears incorrectly (2024-05-17). I also have a date time field that is also US format with time 12 hrs. The data in that field shows up as 5/2/24 5:00pm in the table but appears in the email incorrectly (2024-05-03T00:00:00.000Z).The only additional piece of info is the dates are getting pulled in from another table with the key being the first date (5/3/24). All of them look right in both the original table and the linked table. I tried changing the two that were showing up wrong to Friendly to see if they would change but they didn't. 

I am trying to come up with a calculation of the parts I need to batch-produce a product.I currently Have tables for: Products, Product Variations, Parts, and Production Plan.For example, If I need to make the product "Tea Light", this comes in small, medium, and large sizes, two different patterns, and two different wood types. These are in the Product Variations table.Each tea light has the following parts: one bottom piece, two different top pieces, and then eight sides. These are in the Parts table.In the Production Plan table, the "Quantity to Produce" field should take into account the current stock of that product which is in the "Product Variations" table.I've used ChatGPT to get 90% of the way there. But for some reason, it can't figure out the formula needed to calculate the numbers of each part to produce given the quantity of product needed.Hopefully, that makes sense. Thanks!

Hi,I am pretty new to AirTable, so not sure if this is possible. However, I currently have a table for all users of my website and then a separate table for customer reviews. Each review populates a new row, so the same company may have multiple reviews, each with its own row.I would like to input a formula to work out the average rating across all of the reviews for each company so I can then display this as an overall rating on their profile. Is this possible, if so if someone could help me with the formula that would be amazing.

Very new to Airtable and having some fun with formulas.I have project records with a simple status field (Planned, In Progress, Completed) and some basic date fields.I created a formula that checks if the project is "On time" or "Overdue" based on the completed (planned or actually completed) date field vs today.I don't need this formula to calculate on Completed projects so i'm looking for a formula that sets the field to blank if status is Completed, but calculates if Planned or In Progress.Current checking formula:IF({Completed Date} < NOW(), "Overdue", IF(IS_SAME({Completed Date}, TODAY(), 'day'), "At Risk", "On Time"))

I couldn’t find any updated information about this topic on the community forum.Currently, I am developing some email automation workflows, and I am aware that occasional failures may happen due to unexpected errors.I would like to create a solution to recover the failed runs, but from what I’ve observed, I can only view the execution history by accessing the web page directly.I searched the documentation for any reference to an API or endpoint that allows retrieving the automation run history so I can filter and manage it according to my needs, but I couldn’t find any relevant information.

Hi Airtable Community,  The problem is to check in Airtable whether a value in a column (e.g. column 2) occurs **for the first time** or whether it is a duplicate. If the value is the **first occurrence**, a value from another column (e.g. column 4) should be displayed in another column (e.g. column 3). However, if the value is a duplicate (i.e. it already occurs in column 2 in an earlier row), column 4 should remain empty.Happy for any ideas to solve this 🙂  Thanks & bestMirko

Hi there,I'm facing an architectural problem for which I haven't found a solution as of yet. This problem is linked to the way I handle revenue and payment depending on the client type – small company or big company.Here's how I decided to structure my database to handle revenue and payment for small companies:And here's how I decided to structure it to handle the workflow for big companies: But this leads me to the following problem in terms of database design. I could have found a solution to this problem by:breaking the [Revenue Items] – [Client Sessions] direct relationshippulling the Client Sessions into the [Revenue Items] table with lookup fields and assigning each of them to the proper revenue item in dynamically filtering them based on their execution date Only problem... dynamic filter is not offered on lookups! That means that all client sessions for the deal are assigned to each revenue item, instead of having only client sessions of January be put