Ask the Community

SO I’ve been working with multiple bases, Data separated for clarity and unique scheduling, sessions, etc, data essentially, and I’ve had the need to bring some of that data across for analysis, reporting, e.g. In one base, it’s being used to track clients, scheduling of live courses with said clients, and tracking attendees(for one year only, then data is redacted, but numbers kept), another base is for an unique type of training, that the regular client training base couldn’t handle, as they’re different beasts.However, I’m needing to track the statistics, the matrices, etc in one base’s interface, and I’ve used Master sources before, but in this case it feels slightly different.  I’d need several tables from that other base, but was thinking of instead of having multiple synced tables, rather have one Master Source compiled of the other base’s data so that I could still use it in the Target base’s interfaces :).Anyone done anything like that before?Pros, Cons? Just a thought :) 

Can someone help me or show me the steps to how to set it up where I can archive records without deleting them? I would need to access them again in the future. Thank you so much for your guidance. I appreciate it.Amanda

I have three tables - Venues, Rooms, and Sessions. There is a fourth table called Working Agenda. What formula do I need to put in the Working Agenda Primary field to insert all the rooms and venues? The rooms and venues are the primary field in each of their respective tables. Do I need to add lookup fields for Venue Name and Room Name to the Working agenda? And If so, how do I automatically populate them without having to go into each record and select the room?https://airtable.com/invite/l?inviteId=invqf2ektCLhZAAC8&inviteToken=a13ea39ba4246111f600b52df60d4aea82f695b96b41399b40190b2cc06e2c3c&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

Hi everyone 👋I’m looking for someone who can help me design and structure a management system/dashboard for ItuTennis, a tennis academy with around 30 students.I currently have several Excel sheets in place (students, payments, coaches, attendance, etc.), but I’m struggling with how to properly structure the time factor and pricing updates. Some of the key challenges: Deciding whether to work with monthly sheets or one unified database with time-based views. Tracking historical data properly (real vs projected revenue, attendance trends, profitability per group). Registering salary increases for coaches and tuition fee increases for students (in Argentina, prices typically change every 3 months, so I need a clean way to track value changes over time without losing historical accuracy). Understanding how to structure everything so reporting becomes simple and reliable.  I’d also love to incorporate some automations if possible: Payment reminders Active/inactive student status

My DB have interfaces with Tally and Zapier, and they just stopped working.When I try connect it in Tally, it recognizes all DBs in my workspace, but can find no tables in the BD.Even tried duplicate the BD and rebuild the connections, but just got the same message: “No tables found”. But all tables are there, and all data’s there…Asked AI about it, and it wrote about API key and Tokens…Help, please?...

Attached is a screen shot of a small part of a schedule of conference that a large number of rooms (80) across 4 hotelsthat has numerous sessions per day over a week. I’ve used AT for many years, but I’m struggling as to the best way to design this base to get the most benefit from AT. I want to move out of the g-sheet to unable sort, group and filtering by different staff at different properties with different roles. Any suggestions would be appreciated. I did contribute a base, but it is for a different style event. I want to be careful to not create additional complexity in the base design. https://www.airtable.com/universe/expc6PovQs6jz2O4C/master-plan-for-a-massive-corporate-event

I’d like to build a base to track our produce prescription program. We have coupons with barcodes to distribute to the patients. Ideally I’d like the health worker to use a barcode scanner to scan the first coupon and the last coupon for each patient. Then I need to populate a table of all the coupons distributed within that range for each patient. I currently have a table set up for “patients” where health workers would assign the coupons. Then I have a table for “Coupons” where I’d like the records to be each coupon code distributed. Any help in how to do this would be appreciated!

Greetings, has anyone heard any rumors about making it possible to access extension from Interfaces instead of having to go to Data and then Tools  and then select Extensions? It is not a really big deal but it becomes irritating and time consuming when I have to send out invoices and I have to go through all these extra clicks to get to the Pages extension where I send out my invoices via email as pdfs.Thanks, Scott

I want to check Airtable automation script code for any type of vulnerabilities in the code. Is there a way I can do that? Or is there any Airtable API which exposes the script code which can help me to check the code?. I don’t want to do manual task of copying the code and checking each and everyone individually.

Hello, airtble have issue with invite link?I build table, build interface. Share link for that interface with my other email as editor.Go to Gmail app. Click invite link. Open browser and I have to build new project. What's wrong with air table? 

Hi everyone,I started watching the basic videos today, and since there are unfortunately no subtitles, transcripts, or anything like that, and the summary field remains empty, I'm hoping for some helpful suggestions on how to turn either of them on.It doesn't work in Chrome, Edge, or even in incognito mode.Thanks in advance!Tinks

This has been asked a couple of times with slightly different solutions, so seeing current thinking.I want to have an incrementing number that is specific to a group of records only. In fact I want 3. This is used to create unique names (don’t ask me what this client wants this!), but the number should increment if the record has a field set to x. So when grouped together, there is a sequential incrementation (1, 2, 3, 4,) , but others not in that group do not get that number. They would get a different increment (different field probably).My current thinking is to link the records to another table (using deep match?), identify the highest number of increment already, and then have an automation add to the new record ‘number +1’. Thoughts?

Hi Everyone!I am planning a wedding and using a site like Zola to gather all Emails, Addresses, RSVP information. When someone completes the form it auto populates a Google Sheet. Currently I have my guest list organized in Airtable with just names and all of these other pieces of information blank. I would like to create an automation that searches the Zola created Google Sheet whenever a row is added, finds a matching name and updates the Record in Airtable. If in the case a name is mis-matched or not present in my Airtable guest list, ideally I would like it to just add it to my guest list and I can manually correct the issue. I created the automation and used a test Google Sheets and everything passed but I am not seeing my data reflected. I have attached screenshots: 

Hi everyone, I’m currently running multiple automations through Make (formerly Integromat), and I’m receiving recurring 429 rate limit errors when writing to Airtable. Here’s my setup: • Multiple bases (each client has a separate base)• Automations triggered via webhook• In some scenarios, a single workflow performs 4–6 Airtable operations in sequence (search, create, update, etc.)• Sequential processing enabled in Make• Free plan currently From what I understand, Airtable has: • 5 requests per base per second rate limit• 1,000 API calls per month on Free• 100,000 per month on Team My question is specifically about the rate limit behavior: If I upgrade from Free to Team, does that change the per-second rate limit (5 requests per base per second), or does that limit remain the same regardless of plan? In other words: If I occasionally execute 6 Airtable operations within the same second inside one scenario, will upgrading prevent 429 errors, or is the 5 requests/sec limit enforced equal

Hello, I’m working on creating a project management system for a creative studio and I want to have Airtable suggest the best assignee for a task. I have a resource table that shows availability and skill, how do I then have a resource list ranked by percentage “best match” show up? I know I have seen a webinar or tutorial showing what this looks like, but I can’t locate it anywhere. In addition to this, how can I provide a low, medium, high tier to the skills that are matched back with each resource? Is it possible to have an AI agent within Airtable reference an external knowledge base to referencing when deciding on the best match

I could really use some help!I want my formula to return the correct Ship Deadline taking into consideration the time the order was submitted. If it came in before 4:00 pm on a weekday, it needs to ship the next day. If it came in after 4:00 pm on a weekday, it needs to ship in 2 weekdays.This screenshot shows that order 5014021 came in at 5:15 pm correctly shows it needs to ship 2 weekdays later. But for some reason, order 5014020 that came in at 7:15 pm on the same date is showing it needs to ship in 3 days instead.I can’t for the life of me figure out what I am doing wrong. Formulas are not my strong suit so I use AI to help write them. Any advice here would be very much appreciated. It will be so awesome if I can get this to work with anyone’s help!My formula:IF({Store Name} = "Retail",IF(OR(WEEKDAY({Created (DEV)}) = 6, WEEKDAY({Created (DEV)}) = 0),IF(WEEKDAY({Created (DEV)}) = 6,WORKDAY({Created (DEV)}, 1),WORKDAY({Created (DEV)}, 2)),IF(VALUE(DATETIME_FORMAT({Created (DEV)}, "H

HelloI’m currently working on a Production Planning base, which is essentially a way for us to communicate with factories on the projected production they can expect from us for the forthcoming months. Currently there are two sets of data:Projected Units  Quantity attached to a “Launch” or a “Deal”.  Confirmed Units. Quantity of confirmed units which have Purchase Orders attached As an example, we have a deal across “P6 & P7” (period/phase) with a customer and projected around 500k units. The problem is that the factory is not going to produce all 500k units at the same time and this deal stretches over a period of time - which based on the customers sales calendar is Feb-Mar-Apr. That is their sales window, so we need to work backwards around 10 weeks for shipping and then an additional 30 days for production.I’m currently trying to figure out the best way to disperse the 500k units realistically across the full period span so we can give the factory an idea of when we expect the

Today I noticed an issue with Lookup values—Airtable formulas are not recognizing them in conditions. Is anyone else experiencing the same problem?

Hello Community,Is there any way to update the two fields from the interface when I click an button using form or some other way. Current Problem:I have an automation which triggers on record update. My table as two date time fields: Start Time and End Time. And as you might know we cant enter date and time together in date-time field in Airtable. So when I set both of them it consumes 4 runs of the automation which is not efficient.Solution I am looking for:We would be mainly creating tasks from interface like this Now I dont want to have the Start Time and End Time as editable fields because then the above problem will be posed again. Is there any way where when I click the Update button it askes for Start Time and End Time and then it gets updated on airtable upon confirmation?If this is possible I would really appreciate some help in achieving it.Thanks for your time!

Hi,I have workspaces and bases created where as a user I am configured with “Creator” permissions. I have created a personal access token (PAT) and have applied ALL available read permissions and have set the scope to all resources. When I run for example a “list bases” API call, I get a successful response (code 200), however I get an empty list returned like it doesn’t see any of the bases I have created. From my perspective I have given all necessary permissions across the user and PAT, but I still can’t get any bases to come back via API. Any suggestions on something I might be missing or how to further troubleshoot? Thanks!

I would like to add a logo to an Invoice Interface .... but cannot see the option to add an Image element... I am on the free plan. Help please.

Hi everyone 👋I’m building an Airtable base to track and analyze daily puzzles from the NYT Letter Boxed game by The New York Times, and I’d love some advice on optimizing my structure and automations.Here’s what I’m currently managing in my base: Daily puzzle date The 12-letter grid (grouped by sides) Valid solution words Two-word solutions (minimum solve goal) My solve time Community solutions collected from different sources Difficulty level (manual tag for now) What I’m Trying to Improve: Better relational structure Right now, I have one main table for daily puzzles and another for words/solutions. I’m using linked records, but I’m not sure if I should normalize further (e.g., separate table for individual words across multiple days). Automation ideas I’d like to: Automatically tag puzzles as “Solved in 2 words” Track average solve time per week Possibly auto-calculate difficulty based on word count or uncommon letter usage Performance optimization As

Hello all.I’m wanting to run an automation that will create x number of new records in a table, where x is a number entered into a field (on another table).So someone wants 5 new records, the enter 5 into the field, the automation runs 5 times.I’ve seen this: But not entirely sure I understand how to implement this!Help muchly appreciated.

Hi Community, I have created a form, with a number of single select fields. When you got to enter, a blank field appear above the single select options - you can click on this, but it is not showing in the field in the back end. There are two options there, but the user end you can select a third non-existent option?The single selects are required fields, and the form has existed for a while without these glitches. Any tips welcome - though FYI, scripting (which the Airtbale bot told me to do) is a bit beyond my capabilitiesThanks 

Hi AirtabliansI have a date column which I have set to DD/MM/YYYY . . when i try to cut or import data into it sometimes it works, sometimes it doesnt, i have realised that even though I have set the field explicitly as DD/MM/YYYY format like most of the known world, it still wants in input in MM/DD/YYYY then it represents that back in the format I want to see it i.This is causing havoc with automations.I am guessing that there is a central “what format is the date in this entire table/workspace in” setting but I cant find it? My date settings field input still wanting me to enter in it appears this is why i cant cut or import data in unless it is MM/DD/YYYY format (which also means all the datas in the dataset are probably wrong, but i saved in s asecond text field as backup. The field is linked to an interface, in case that means anythiung?