Ask the Community

I have a question about adjusting my base design to accommodate a new data requirement.I use my base to run our property management company. It consists of 4 main sections: Customer tables, Contract tables, Property tables and Invoice tables. When I created the base I did not think about the possibility of a customer selling one home and moving and retaining our services for the new home. Silly me. Our customers are owners of generational homes in a resort and as such they rarely sell.In the contracts table I have a field that captures the year we took them on as a customer of that property. That year is derived from the signature date of the contract for the current property. All fine and good until they move. Now we have an old customer with a new house and the years as customer is now only valid for the new property. I lose the history of their original contract. I need to have a way to keep the original year.I have thought about putting a field in the custom

Is it my impression or the latest version of the SDK removed support for defining a table as a custom parameter? My extension reads data from another table as support for that has been recently added. In order to avoid hardcoding things, I was allowing users to select a table. This was supported  (see link below). However, the latest version of the SDK does not seem to support that. (^0.0.0-experimental-e7419444f-20251120). I’ve updated my code so the parameter is now just a string. It seems to be working. Could you please confirm this makes sense?https://airtable.com/developers/interface-extensions/api/BlockPageElementCustomPropertyThe signature of the type BlockPageElementCustomProperty I’m getting does not include that type anymore (see below) and I also get a run time error.type BlockPa

Hi all,New to the community here 😊Quick backgroud, I use Airtable as core operational platform for enterprise-scale stadium delivery coordinating content, instructions, and approvals across major events. External stakeholders access structured workflows via a portal in Softr, while internal teams manage live production delivery in Airtable.I’m currently on Business and evaluating a move to Enterprise Scale.Before upgrading, I’m trying to confirm whether Enterprise Scale supports embedding Airtable Interfaces into third-party portals (e.g. Softr) with the following requirements:Embedded without public “share to web” access Users authenticate normally (Airtable / SSO) Interface permissions are enforced (role-based access, edit vs read) Users can edit records and reorder rows within the embedded Interface

Hi I am a New user to airtable. I need to create a quiz platform. I decided to use airtable for backend.But couldn't connect both and lack of guidance. Can you anyone please help me work around it its kinda emergency.

Hi Airtable Community,I’m trying to confirm whether the CSV Import Extension supports updating an Airtable Checkbox field from TRUE → FALSE when using “Update existing records / Merge”—or if there’s a known limitation/workaround.What I’m trying to doWe run a recurring sync where we: Export a CSV from Google Sheets that contains: a unique ID (used for matching) several columns of values one column that represents a boolean (e.g., TRUE / FALSE) Import that CSV into Airtable using CSV Import Extension → “Merge with existing records” Map: CSV ID → Airtable ID field (for matching) CSV boolean column → Airtable Checkbox field What works I

I have 20 project managers. Every Monday i need to email each of them independently their list of jobs that meet specific criteria they need to take action on. I am starting to run out of automations for this base and am trying to consolidate this into a single automation rather than an automation per PM. Here is what I am trying to accomplishat scheduled time (good on this part) find records - find the PM by email address (this is a record within the table) I've taken this line out because it does not seem to be able to dynamically pull each PM, but m not sure how tog et the automation to accomplish this step. find records - when status1 <100%, and status1 due date is empty (good on this part) find record - when status2 <100% and status2 due date is empty (good on this part) send email - the PM defined in pm email address in the table gets an email listing the records in parts 3 and 4. These records are sp

I have a table called “Tickets” that my team enters project requests. Each ticket has a due date. A second table called “tasks” are specific things that need to be done to complete the project. Some of these tasks must be done a specific number of days (lead time) before the ticket due date to meet the deadline.I have a third table with standard tasks with a field called “lead time” that I use as a template to populate the tasks for each project.I want to be able to automatically enter the task due date based on the pre-defined lead time and the ticket due date. These dates need to editable to account for holidays and other conflicts, so I can simply use a formula.I want to create an automation that will look at the ticket due date and calculate the task due date (subtract number of days from said task due date) and enter it into the task due date. I can handle most of the automation, but I’m a bit out of my league trying to grab data from one tabl

I’ve spent hours on this and can’t figure it out. My goal is to simply click a button to trigger a N8N webhook trigger. Can anyone help me?

DescriptionI have a Tasks table with a multi-select field (e.g. values: A, B, C).I also have a Subtasks table linked to Tasks.Goal:When the multi-select field on a Task contains A and B, the automation should create two Subtask records: one Subtask called  A one Subtask called B (both linked to the same Task) Current setup: Trigger: When record is updated Field watched: multi-select field on Tasks Run Conditional Logic If condition are met: Type = A → create record A in subtask table Otherwise If condition are met: Type = B → create record B in subtask table Problems:Type in Task table = A & B, but the

I’m working with a company that manages products, materials, and services across multiple Airtable tables.I want to use the Airtable API with Python to perform data integration / migration between two tables: A source table containing general product records A destination table where records must be created based on specific selected fields One of the main challenges is that I cannot rely on fixed column names, and I need a way to define which fields should be considered by the script when creating new records.I’ve read that working with JSON is the recommended approach by Airtable, but I’m unsure about the best practice to: Select only specific fields from a table Map them to the destination schema Maintain a relationship with a linked table (“categories”) My question is:What is the recommended way to automate field selection and mapping

Hello community,In our company we use Airtable in the Business version. This includes about 100 technicians who also have access.Since I now also use Airtable privately for our club, I’ve been thinking a bit about accounts and costs. This led me to the following thought:If I, as the workspace owner, have a Business plan, do all others who only fill out forms and enter data only need a Teams plan?Am I understanding this correctly? Or do all accounts need to be on the same plan level in order to work within the same workspace?

I’m looking for some advice re database design - and how to make the data entry easier using an interface…I’m a literary agent and specifically at the moment I’m trying to build the back end for tracking royalty statements. The tables I currently have are:ClientsTitlesContracts (which will usually only link to one client, occasionally two, but often multiple titles)Editions (which are created automatically when a contract is added and the formats a title will be produced in are decided - each edition will link to one title (although there will be, potentially, many editions per title, and one contract and which ever client/clients the contract and title are associated with). Payments (where I am trying to track the income and use views to be able to see what each client/title has earned)I’ve then gotRoyalty Statements (which is the top level statement info)Royalty Statement Detail (where a line for each edition co

Hey all!  I work in higher education, and we use Airtable to do a lot of our forms and petitions. When students submit these forms, we require them to include their unique 10-digit student ID.  I am trying to do two main things: Whenever a form is submitted, the ID number is checked. If the ID number has not been used in a form submission before, it creates a “student profile” in a new table.  All forms that are submitted with the same ID number are grouped under the same “student profile” so that our colleagues using the interface will be able to see all forms submitted by a student.  Does anyone have any advice? 

Only 57 out of 98 columns are loaded through the query HERE in Power BI. Does anyone know how can this be fixed?

A couple months back, I asked for help deleting lines of text beginning with the word ‘Highlight’ and was given this great formula: REGEX_REPLACE({Hook},".*Highlight.*\\n\n?","") It has been a huge time-saver but something I forgot to ask with my original question is if there is a way to add a blank line/line break where those lines were. I input data into the records that looks like:Highlight(blue) - Page 34 · Location 290“Look at that. That thing’s almost a book.”Highlight(yellow) - Page 34 · Location 292“You think… she’s going to print it? When it’s done?”Highlight(pink) - Page 34 · Location 294“I hope so,” I say as brightly as I can manage.  And when using the current formula, it comes out like:“Look at that. That thing’s almost a book.”“You think… she’s

I have a form where respondents need to be able to select a topic and then see the draft definition of that topic. The problem is that the definitions are long and I cannot figure out how to make the form show the entire definition. I’ve included screen caps below.Is there a way to resize the field space that is offered in a form so that the longer text is visible?  

I’m trying to build an automation so that if I put ‘Regular’ in the ‘type’ column in the bookings table it will automatically populate the ‘populate issues’ column in the same table with all the entries in a list (‘issue date’) from the ‘Issues’ table. I can’t work out how to build this automation and get a ‘Received invalid inputs’ error. Can anyone help?

When I go to print a view or table, and hit the print icon, it goes “gray”.

Quick question / feature request: Would it be possible to make the Calendar view in Interfaces scrollable (vertically or horizontally), instead of navigating month by month using the arrows? An infinite scroll would make it much easier to:  View multiple months at once Drag and reschedule calendar items several weeks or months ahead (e.g. 1–2 months forward)

In the left view column I have created forms. I also see that at the top of the page there is a row of links; Data, Automation, Interface, Forms. My question is should the forms created in View be duplicated in Forms or are they separate functions?Thank you if you can help.

My team recently inherited responsibly for the admin of an 850 seat Airtable enterprise license.We’re not an IT team; we’re just enthusiastic end users of Airtable, so we’re new to being admins.My question: is it possible to determine who gave out an editor license?When I go into the admin panel and hover over someone who was just upgraded, I get messages like:“[user name] was Editor on base [base name] on [date]” “[user name] was Creator on base [base name] on [date]” “[user name] made edits to workspace [workspace name] on [date]Is this telling me their last activity in Airtable?Is there a way to figure out who gave out the editor license they’re using?Thanks

I'm getting a pop-up saying "This form was upgraded" when I edit one of my forms.  I've tried both options it gives me, but I can't get the message to stop popping up.  It's unclear what to do.

i keep getting ‘Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct.‘This error from n8n. any idea how to fix it?

I hope someone can help with this please  Connecting from n8n and I’ve created a personal access token and entered it into the Credential to connect with field, Below is the scopes and access permissions I’ve checked that the Base name and tables are correct  I’m not sure what I’m missing here , will be grateful if someone can assist

I'm creating an athlete database. I want to create a column that shows where an athlete ranks, for various metrics, relative to everyone else. For example, let's say someone is 6'9" tall and that puts the athlete in the top 2% of all the athletes in the database. How can I calculate that for that athlete (and every other athlete)? Is that possible?