Ask the Community

Have built 4 tables to collect inventory information on our fire department’s truck inventory.Tables:cabinets i.e. E-211 Cab. #1 items i.e. 2 1/2” Brass Male to Male Coupler inventory: list and # of item in each cabinet archive inventory: because the governing body wants it.I am trying to create this using Interfaces. What I am trying to do is use a Record Review template that has the cabinets in the left pane and the inventory items for each cabinet in the right pane. I have been successful in that. I have a working Inventory Interface page. The item list is complete (2,501 items). The Cabinet list is complete (65 cabinets).Truck Captains will use an iPad to open Airtable to the Inventory interface and choose one of the truck/cabinets they are responsible for from the left hand list and check off the inventory items they find. If they find an item missing or the quantity less than that listed they will enter that number in the OH field. When they finish that list they will open anothe

Hello, Currently I have a date field called Date, I would like to make a formula that looks at this date and outputs the first Tuesday of the previous month.Example{date} - Shows March 13, 2025Formula - Should show February 4, 2025 (First Tuesday of Previous Month)I was able to find the 1st date of the previous month utilizing this, but I cannot seem to figure out how to get the first Tuesday. DATETIME_FORMAT(DATEADD(DATEADD({Date}, -1, 'month'), -(DAY({Date}) - 1), 'days'),"MM/DD/YYYY") 

The view that this embed is looking at is filtered correctly- when i open the view in AT, it should the exact dates. However, on the site- it keeps shifting over. here’s the view on the site, with the link to the page below: https://www.uptrusthq.com/deep-takes#schedule and here’s what the embed is coming from in airtable:   is there a way to fix this?

We have a form in Airtable for our app's affiliate program. When users search Google for "Airtable affiliate," our form appears as the top result.Although our form isn't related to Airtable's affiliate program, people don't read carefully and we are getting unrelated and confused applicants daily...I think updating the SEO meta title and description would reduce irrelevant clicks. Is it possible to edit the metadata for this form?Screenshot: https://cln.sh/QStGkLDQ

Hi,I have a content management system in Airtable where I could use some automation support. I am attempting to use the new Airtable AI, but it just won't work the way I want it. What I want to do is:Request a new record (requests new content using a form) to be created, it currently creates a Google Doc with the record details on it and changes the status to "assign to writer"I want to have it where if I assign the writer as "AI" it submits the record details to AI (with a detailed prompt I created).Writes the content and places that content on the Google Doc.I have it producing the AI generated content within Airtable using the prompt but can't get it to add that content to the Google Doc and update the database field to "For Review". I don't want to use Zapier/Make if I can help it.Has anyone had success with this or have an idea, and would you mind sharing a shot of your automation? Thank you. 

Hello, I have a base that has a Campaigns and Deliverables table. There is one Campaign which could have many deliverables. Each deliverable could have one owner. We want the Campaigns table to have a lookup that shows all of the owners for the deliverables. Unfortunately, if someone has multiple deliverables they own it reports their campaign twice in the lookup column. Is there a way to dedupe or only show the owners name once versus the same name multiple times? Thanks, Victor

Can’t edit my original post.Why not allowing users to do that? It’s locked for editing. Makes no sense.

Hi all, New to AirTable and have been trying to create a grid where one of the columns needs to be linked to a different record on a row-to-row basis. I have been able to link one record in the column but have found it difficult to add a 2nd record for the next row. Is it even possible to do this in AirTable?For example:Row 1 - Column A Links to one record  Row 2     Column A links to a second record Hope this information is clear, happy to try and clarify if it would be helpful. Thanks in advance!

Hello, I have a base tab with all of my company’s stakeholders and builded an interface for people to create a new contact. What is the best way to prevent people from creating a new contact through the interface and the associated form if this email already is in base ? Thanks a lot for your help

I’m having an issue with two-way syncs in Airtable.I have a Source-A table in a Base 1, which is synced to Base 2. In Base 2, the Target-A table is linked to a B table.The problem arises when I want to remove duplicates in Source-A: I have no way of seeing whether one of the duplicates is linked to a record in B in Base 2. If I merge duplicates and delete the one that is linked to a record in B, the connection between Target-A and B is lost.How can I prevent this loss of links?I tried using the Dedupe extension on the Target-A table, but I got an error saying I don’t have the necessary permissions.I understand that if Source-A is synced to multiple bases, removing duplicates can be problematic because additional data entered in Target tables isn’t reflected in Source-A.Is there a better way to handle this situation? 

Hello everyone,I'm looking to optimize my prospect tracking in Airtable and need your help to solve an interface issue.My current structureA Prospects table containing all my prospect information, including a "Commentaire de Suivi" (Follow-up Comments) field that rolls up notes taken during previous interactions. An Interactions table linked to prospects via a "Prospect" field (linked record).My needWhen I create a new interaction via Interface Designer, I want to be able to see the summary of previous interactions (the "Commentaire de Suivi" field from the Prospects table) while I'm entering my new interaction (so as to have the previous follow-up notes of my prospect meanwhile I take the notes of the current call for ex.).The problemI can't configure my interface to display both:Input fields for my new interaction (Interactions table) History of previous interactions (rollup field from the Prospects table)I'm using the free version of Airtable and the Interface Designer. I either end

Hey all, this is my first post, so I hope I do this right! I have created an automation that, when a field box is ticked, a series of Find Records run. Each Find Record action gathers a list of records (people) that meet certain conditions. This is followed by an Update Record, that adds the linked records to a single field. The Update Record step looks like this: Find Record 1 record ID, Find Record 2 record ID, Find Record 3 record ID. This works perfectly unless one of the Find Records comes back empty, in which case the whole automation fails. Two the Find Records often come back empty, so this is a problem. I’ve played around with conditional actions, which is messy but it kind of works until a conditional action has an empty Find Record, where the automation stops and doesn’t move down to the next condition(s). Can anyone think of a workaround? Thanks in advance!

I’m not even sure the correct terminology so having difficulty looking it up.  I am creating a form with timeslots.  I need people to fill out the form and select a timeslot, but once someone has selected one, that timeslot shouldn’t be able to be selected by someone else.  Is this even possible?

(I suspect this has been answered before, but I’m having a hard time figuring out how to search for it. Apologies in advance.)I have a table that includes several hundred rental product models. This table is called ‘Fixtures’.I have a table for individual projects called ‘Projects’.For each given Project, I will want to link a Client (I know how to do that) and then I want to create a document where I can list an allocation of equipment needs for the project that pulls in data from Fixtures.The final output needs to be a multi-page printable document that looks something like this…--ProjectClient(Qty) (Fixture B) (Qty) (Fixture Q)(Qty) (Fixture AN)… --So this is roughly equivalent to creating a sales estimate, but ideally pulls in data from the Fixtures table to then populate additional related info.If anyone could point me to a relevant sample base or offer any insight, I would appreciate it.

I see several posts that are similar to my question, but I haven't been able to find the actual solution yet.  I have a database of all our locations, and at any given time we have about 40 pending locations. I'd like to send an automated email to the listed manager each month asking for an update until the status is changed from pending to open.  Some managers have multiple pending locations at one time so I'd like to only send one email per manager rather than multiple if there are several pending in their area. There's probably a few ways to do this, but for now I have a rollup column on a different table that breaks down by district all the pending locations.Any thoughts?

How do you accomplish that Airtable shows as the example?  I want a picture on one side, then next it it several vertical fields, but they only go horizontally or below the picture.  

Current Issue:By default, Airtable automations trigger every time a defined condition is met, such as when a field is updated. However, in cases where changes happen in quick succession, the automation may run multiple times unnecessarily. This leads to inefficiencies and potential inconsistencies in workflow execution. Objective:I want to configure an Airtable automation that runs only after a certain period of time has passed since the last change, rather than triggering immediately with every update. This delay would allow for multiple consecutive changes to "settle" before the automation executes, preventing unnecessary or redundant triggers. 

I have a date field that I am wanting to use to send a slack notification when it is updated and/or changed, however while doing planning I am amending that date field multiple times to settle on the final agreed date - is there a way in which that slack notification can only be triggered once the date is settled and planning has been completed? 

Hello  I would like your help regarding the  privileges of the following  api key  : curl -s  -H "Authorization: Bearer p****" "https://api.airtable.com/v0/meta/bases"{"bases":[{"id":"app***”,"name":"Produ***","permissionLevel":"create"}]} My question what exactly permissionLevel":"create"  means ?  and is the difference with read-only ? Is there any security concert if for the above key if it is public ?  Thanks in advanceG. 

I have 100 people in my database, I want to send an email to each (email is in record) and in the email have a  button (webhook or form) that updates another field in their record. Example: Do you support the project? Button or form could either just have "Yes" (with no click being implied "No") or a form 

I am evaluating various platforms to build a custom production scheduling application for a client.  Here are some details:Customers place orders for products they need produced Each order can have multiple line items for different products they would like produced Each order line item needs to be scheduled on one or more machines to be produced. The scheduled jobs for each line item need to be run sequentially, but not necessarily back-to-back.  In fact, some products need to sit for a set period of time after one job before it can be consumed by the next job to make the final product If the date of the first job scheduled for a line item needs to be adjusted ahead or back, the other subsequent jobs need to be adjusted by the same amount of time as well.  For example, if a customer orders “Product A”, which needs to run on “Machine 1” on 3/20, then “Machine 2” on 3/21, then “Machine 3” on 3/25, if the job scheduled on “Machine 1” is changed to start on 3/21, then the job on “Machine 2

Hi 😊I need help with the form…🙄I have a table "Absences" created in Airtable, where employees can report paid vacation using the form. I also have a column "Remaining paid vacation days" created in Airtable using a formula, in which the employer can see what the balance of the employee's paid vacation is.I would like to add a field to the form that will be displayed while filling out the form (If the employee selects their name from the employees in the form and selects Vacation type-Paid vacation, a pre-filled field showing the data from the table: How many days of paid vacation the employee has left will appear).Thank you for your help! 😁

Hello all,I have multiple tables each with multiple single-select fields that I have created via the Airtable API.352 separate fields across 40-something tables. When creating the tables and columns I am able to define the selection options for each column and everything works smoothy.However I can not set a default option for these columns when creating them through the API. It is far too many columns for it to be reasonable to manually set each column default in the UI, as it is I already have to do some manual operations to create a formula field in each of these tables after creation due to limitations in the API capabilities.Does anybody know of a way to set default values in my field en mass?The majority of the fields hold the same selection options and would have the same default option set.I would even accept nuking the fields and/or tables and recreating them if my creation call can be altered to set the default but I was not able to accomplish this. I appreciate any assistanc

Hey all,I’m getting the dreaded “received invalid inputs” but it’s not specific.I have a form that someone fills out to get a “certificate” number in another table.There’s a specific view for the Non-Assigned certificates. There are two tables, one that stores the form’s data, and another that has a listing of certificate numbers and such. Now I’d set it up as such: Then the Find Records settings:  Not sure what else to do???