Ask the Community
Recently active
Airtable has two nice features:In Interfaces you can launch a “Create Record Form” from an existing record and it will pre-populate the “parent” record value in the appropriate field. In Data Tables when using a Link field (to another table) you can specify a filter, to limit which records are displayed. However, these two features do not appear to be compatible 🙁 Worked Example:I have a Team Placement table, which links People records to Team records. I have an interface which lists the current Teams, from the record view I can launch the “Create Team Placement” form and the Team field is pre-populated. However, I want to have a filter on the table level to only allow “Active” Teams to be selectable. When I add this filter at the table field level and then re-launch the “Create Team Placement” form, this time the Team field is pre-populated with "Unnamed team” - even though the Team that should be pre-populated is “Active”. Has anyone else encountered this issue? More importantly, ha
I have a database of models and all their various measurements. Some key measurements are captured as a pseudo-range, meaning there are a pair of number fields to capture the low and high end of the range, as shown below:Height (1 number field) Bust, Bust+ (2 number fields) Waist, Waist+ (2 number fields) Hip, Hip+ (2 number fields)(Note: not all models have a pair of measurements recorded) Now let’s say I want to search for models that fit specific parameters...If I’m just looking for a single measurement range (of which there is a min/max pair), then the filter looks something like this: Simple enough.However this becomes a royal PITA to build a custom filter to search for a combination of dozen other measurement parameters (of which the measurements being searched also change. Sometimes bust/waist/hip, sometimes height/gender/weight, sometimes age/gender)The best I could do to minimize the work involved for my client to create a custom filter is to build a List interface page that
Hi, I’m new to using Airtable. I create a Gantt view when I set up dependencies between some milestones. I noticed that in my Gantt view when I have milestone that is dependent on another milestone, even if I move the first milestone it does not affect the milestone that is dependent on it. however, when a milestone is dependent on a task that has a duration, the change is reflected.Milestone 2 depends on Milestone 1 After moving Milestone1 one day later , Milestone 2 remains due for the 25th. I expected it to move 1 day later
Hi Any idea when Airtable will update its markdown syntax to accept inline images? I love to send emails with Airtable automation, but I can’t find a way to integrate my signature to emails !
Has anyone seen this message before when trying to sync and emailed CSV file into the base?“Unable to sync this source. A field in this table has too many select options, so no new select options can be synced”.How do i fix this?
I am building an app that will use the Airtable API to export and format data from many tables within our base. I am pushing my code to a public GitHub repository.I am obviously treating the API key(s) as secrets and not pushing them to my repo, should I also treat the base’s ID value as a secrets value? What about the table IDs?
Dear community,I am thinking about to turn on Airtable AI, but first I'd like to ask whether the Airtable AI has the power to do what I want.A brief introduction of my base and what I want to achieve:We provide logistics management for cruise vessels when they are in dry dock. We manage the complete supply chain and on site coordination. Building a detailed inventory of all items for the ship and keep track is one of our tasks. Now, we work with barcode tracking which means we have to assign a barcode to a record (primary field = barcode). This can be done by scanning the label (regret to say that, but the Airtable mobile app sucks!) , or manual input (risk of typos), or third party scanning integration. We also take photos of every single item (attachment field).And here is what I want (primary goal):AI should analyze the photo and search for a barcode label, then update the primary field accordingly.So much more what I want, for e.g.:AI should analyze the packing list (attachmen
So I want to extract text from a picture like below format the data to be analyzed like the Excel below.
Hello! I’ve had this issue for some time now but finally have the time to sit down and really figure it out. Except I can’t figure it out. Base 1 has Table 1, which is synced to both Base 2 and 3. Base 2 and 3 are not allowed to create new records, I have to go back to Base 1 to add records in. Syncing is enabled for both (see below). I need to be able to edit Table 1 from all 3 bases and have the changes show up for each base. Base 1 settings: Base 2 settings (same as Base 3): Message when I try to add records to Base 2: I have a feeling I’m just not understanding some simple little thing about how AirTable’s synced tables work, advice anyone?
Having trouble with another automation. I’m trying to make an automation that will send an email to an assigned care worker, when one of their assigned clients (global worker) has not had a touchpoint in more than two weeks. I’ve mapped it to send an email to their email ID from the linked table, but it’s saying “Invalid email address in the "to" field: fldoiK6gc9Jd7MMgy”. Here’s a screenshot of it:
Hey all, I’ve got another (hopefully) easy question for y’all.IF({Rental Fee}="", "", {Rental Fee} / {Open Duration})Here’s what I’ve got. Open Duration is another equation where I used DATETIME_DIFF to calculate the number of months (success!). Rental Fee is a currency field where I plug in the numbers. What I really want to do is see how much the rental fee came out to per month.Cool thing is that the IF field is working well enough, I only get #ERROR! on the fields where the equation is applicable. Not cool thing is the whole #ERROR! message bit. 😂 If rental fee is $10,000 and duration is 10, then why am I not getting $1,000?I can’t figure out what I’ve done wrong. Any thoughts? Thank you in advance!
Greetings, I’m new to Airtable.I want to run a script to delete field columns that contain the word (SS)I get this error:“deleteFieldAsync available: no⚠️ Your current environment/role does not support deleting fields via script.Please run this in Extensions → Scripting with a Creator role, or delete the fields manually.”I am the Owner of the base.I am in extensions → Scripts and running this script from there.Why is it not allowing me to delete if I am an Owner and I am running the script from extensions?Thanks!
Hey there, please pass this to the support team - passing on feedback - the new look is driving me crazy, not being able to collapse/reduce the left hand nav is frustrating, it takes up 25% of my screen with information i reference infrequently compared with the data in the table. arrgggghhhhh! anyhoo, love airtable thanks and have a great week
I’ve been trying to make formula to proper clean person name, but the result is weird. It’s like the LOWER() function dominates the whole result even though I put it in the middle… is this a bug?if I remove the LOWER() it only works if you dont meet with the all capital names (Like “JOHN DOE WHITE” would stay the same)I even tinker with internal AI and Copilot with the same results.I basically just want to make start with Capital, clean all unnecesarry whitespacesCan somebody help me?
Hello, I am pulling in data via json API and need to know where to go from here? I have a table (sales team) that has the "salesrep id" and I need to map in the ytd sales data for each salesrep id. I am not sure what to do next to loop through the json object data and map them accordingly.
Hi there, I’ve got a bookkeeping base I created and added an Auto-categorization feature that’s giving me some trouble. Basically, there is a Transactions Table, a Categories table, a Merchants table and a Rules table. In the rules table, you add the match terms you want the automation to look for, and a linked field with the category you want it to be. The way the automations works is this: record is created in Transactions, triggers automation automation looks to see if any match terms in the Rules table match up with the text in the transaction name if there’s a match, automation runs a script to fill in the category and some other fields (like “merchant”, which is a combo of the Vendor name that comes filled in from the bank plus the transaction year, and “payment type” etc) for the transaction in questionI confess I’m not adept at scripting and enlisted the help of ChatGPT to work this out. The script seems to be working most of the time, but recently has started throwing an error
It seems that the number of lines that the view moves in a single "scroll-notch" from the mouse wheel is the same in any cell height.This feels very unnatural (scrolling the same distance is expected, not the same number of lines).With taller cell heights this means that the entirety of the lines that are visible are new lines after scrolling a single scroll-notch away, which leads to the worrying ambiguity of "what if I have scrolled past some of the lines" since you don't have any lines that are common to both positions that may serve as visual reference points.The only workaround is to click on the scroll bar and drag it, which is not as ergonomic as having a proper scroll.This has been somewhat mentioned in this other question from 2021 "Adjust Mouse Wheel Scroll Sensitivity?" which doesn't have a single answer.
I have paid the invoice which failed yesterday. I had automatically been downgraded to free plan. However even after paying the invoice when I try to upgrade, it takes me to billing and then says we cant charge your card right now.
Is there any way to add the value of a field of each card and present it in the stack header in kanbam?
TWO TABLES MTO AND CATALOGUE. MTO HAS MANY RECORDS - EACH HAS {XQTY} AGAINST A LOOKUP FIELD CALLED LINE_MATERIAL (WHICH IS LOOKING UP THE PRIME_ID ON CATALOGUE).THERE MAY BE 10 RECORDS ON MTO WITH DIFFERENT XQTY VALUES ALL FOR THE SAME LINE_MATERIAL.I WANT TO SUM THE XQTY - GROUPING BY LINE_MATERIAL - AND UPDATE THAT TOTAL TO THE MATCHING RECORD (LINE_MATERIAL = ID) ON THE CATALOGU TO DATAFIELD SUM_1.I HAVE TRIED JAVASCRIPT, AUTOMATION AND OMNI AND CLAUDE - AND SO FAR NOTHNG WORKS. USING JAVASCRIPT IS THE PREFERRED WAY LINKING TO AN ACTION BUTTON BUT THEN YOU HAVE TO ACCOUNT THAT THE VISIBLE VALUES IN AIRTABLE ARE NOT REALLY THERE BUT RECORD_ID IS….TRIED EVEN TO ACCOUNT FOR THAT BUT NOT MADE IT WORK EVERY TIME SO FAR !!!!THANKS FOR THE HELP GANG…...MIKE IN LONDON
Hi all, I’m building an interface to help the tutors at our company guidance students in writing their supplemental essays for college. I have a base with two tables:Table 1: US Colleges (which has a list of US colleges and what they each look for in applicants; the primary field being the college name) Table 2: Supplemental Essays (which has the list of supplemental essays required for each college; the primary field being the essay prompt itself, and there’s a link record field to link each essay prompt to the relevant college in the US Colleges table)The interface I’m building is a Record Review, and I picked Table 1 (US Colleges) as the linked table so that the data can be organized by college.Everything works great when I’m editing the interface, but when I open the public view link, the records from Table 2 (Supplemental Essays) aren’t showing. How do I fix this? I’ve already allowed syncing for Table 2, but that didn’t solve anything. I’ve included screenshots below to better i
Hi Everyone. I have a reseller company selling my products. I need to pay them rebates every month.I have drawn up a table to track sales as they are made. It will then also pull through the rebate amount to each month’s column based on the contract start and finish date.I now want to create a dashboard that the reseller and I can view every month to see the total amount of resales for the month. IE. I want a chart showing each month’s total rebate. I would also like to setup seperate dashboards showing for example the number of active contracts, how much rebate is owed to each different sales person, etc….Can anyone please assist/guide me with this on how to get the information into a dashboard. I have created the dashboard similar to this excel file but Just not sure how to pull over the data for insights as I am struggling to get all the months into one chart.
Hi everyone! I’m working on an automation that needs to create records based on two linked lists, for example: A list of projects A list of team membersQuestion 1:Is it possible to have an automation that loops over the projects list and, inside that loop, creates records for team members only if the record doesn’t already exist? In other words, can I add a condition inside a repeating loop to check for existing records before creating new ones? Question 2:Is it possible to have nested loops in Airtable automations? Or are there any workarounds to loop over both projects and team members together to automatically create every combination without hardcoding? Thanks so much for your help!
I can’t figure out how to make links between two tables work the way I need them. Here’s the situation:Table 1 contains a list of Companies. These Companies are differentiated by Type (multiselect) and split into multiple views based on that: Producers view and Architects view.Table 2 contains a list of Projects. Each Project has a Project Owner field (link to Companies, single record) and Project Participants field (link to Companies, multiple records).So far so good. Back to Table 1, for each Company I need it to show the following fields:Projects (Participant) - Link to Projects and show all Projects where a Company is referenced as the Project Participant Projects (Own) - Link to Projects and show all Projects where a Company is referenced as the Project OwnerThis is where I get stuck: When creating a link to the Projects table (2) from the Companies Table (1), I’m only able to get the Projects (Particpant) field working, and have no way of differentiating the Project (Own) field f
Hello,I am building a dashboard in which I include a control formula in order to make sure the AI reads well.However the behaviour is inconsistent. Check formula :IF({Amount (vat incl.)}={Amount (VAT incl.) (check)},"✅","❌") Calcul formula{Amount (vat incl.)}-{Amount (VAT incl.) (check)} QUESTIONWhy is one result -0 and the other 0 when the mechanics between formulas and parameters are the same ?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
