Important Update: Single Sign-On (SSO) for the Airtable Community will be required effective June 2n...
Recently active
Hello,Quick question: when I use a record picker in an Interface, why can I create a new linked record… but not pick an existing one?It is called a “picker”, right? 😅Context: I’m building a CRM to manage photography projects. A project can have multiple venues. I’ve got a field linking to my “Venues” table, and yes — the field allows multiple links.But in the Interface: I can only select one item at a time, I can’t pick multiple existing venues, But weirdly, I can create a new venue every time. Which… leads to dozens of duplicates, breaks the logic of relational design, and honestly makes me want to go back to Google Sheets and sticky notes.You used to have this working (RIP Record Lists and side panels). It was beautiful. It made sense.Now, even for simple things like choosing two people for a project or adding a venue that already exists, I need to invent workarounds that feel more 1998 than 2025.Or it is just me that don’t really understand the new logic of the interface and re
Hello,I am working with a formula field that I have created to take a Select list value from Field 1 and change it into a number. Example:Switch ( {field 1}“Choice 1”, ‘1’,“Choice 2”, ‘2’)The output of this is a text value of 1 or 2 not a numeric value. The tool will not allow me to use the following , the 1 and 2 turn red.Switch ( {field 1}“Choice 1”, 1,“Choice 2”, 2)Using the first switch function how do I now set the 1 and 2 to a numeric value?
Hello, we are a Charlotte-based organization and started experimenting with Airtable in our Operations department and now are trying to build Airtable for our organizational project management. We are looking for a contractor/consultant that is ideally in the Charlotte area and able to help us with our base, tables, interfaces and dashboards, ideally building it in a way we can easily manipulate in the future, if needed (e.g. no code?) -Susan
I am on the free plan. A few Co-workers can add an event to the calendar by submitting a shared form. The Airtable calendar is then updated. That works well. But say they need to delete an event. How can that be done using the same form, or do I need to make a new shared form?
My organization is implementing a new Airtable base structure complete with integrations with Softr, Fillout, and Make. It’s a complex build that has taken over a year to build. We recently upgraded to Business to take advantage of higher record limits and 2-way table sync. Now I have learned of the limitations of the 2-way sync and I am doubting everything.We were advised to design our operation in two bases; let’s call them People and Things. About half of the tables in each base have been synced into the other base. Here’s the problem:A table in People (Names) is synced to Things The synced Names table needs a rollup from a table in Things (Furniture). A linked field and the rollup are added to the synced table. We need that rollup back in the People base, but it does not sync back because of how 2-way syncing works (records sync, not fields native to in the target base). So, we sync Furniture to the People base - it includes the linked field to the Names table on Things. We try to
We have embedded an iframe with an Airtable Interface into our Website. The problem is that the content of the iframe is not updating in realtime once i change data inside Airtable which SHOULD reflect in an immediate change of the iframe (Interface) contents. The content in the Airtable Interface however is updated immediately - only the website embedded iframe is still showing old content.How can i make the content inside the iframe update immediately?
Hello!I am trying to create a field that returns matching values from 2 other fields.In the screenshot below, ‘Budget’ and ‘Offered’ have the same options (multi-select fields). I would like to have the third field, ‘Budgeted and Offered’ that shows the matching options from those fields. How can this be accomplished within airtable?
I have a record picker on Page 1. I also have a search button, which has an action set to ‘go to interface page’. This point to Page 2. On Page 2, what I’m trying to achieve is a record summary of the record picked on Page 1. Could someone advise if this is possible? If possible, please explain how. Thank you in advance.
In the form, i need to fill in the quantity for each item. Each item will be linked to the database. Each form need to be input quantity for around 10 items. pls see photo below
I am running a scraper to fetch data into my Airtable. Sometimes, the Company name is in full; for example, International Business Machines.I want to batch convert (correct term?) them into IBM. I am half done with the automation -- When a Record Matches “International Business Machines” .But what comes thereafter is the challenge -- I assumed it should be Update Record but unable to input the “IBM” text. Any help would be greatly appreciated. thanks
I shared on our Wix site the Airtable calendar. All looks good. But if the public clicks on the View larger version link, along the bottom right, it opens larger and shows at the top Using “Reserved Date/time field, customize labels , filter and sort. Filter and sort is fine but how do I remove “using Reserved Date/Time and customize labels. It looks weird and confusing to public. I am on the free plan.
Hi all - I’ve got a calendar interface that shows my warehouses their upcoming schedule. It displays three different event types. Problem is, while all the events appear normally on the web app, only one type of event is showing on the phone app. I’ve double checked all the interface settings, filters, date fields, etc, and everything is correct. Why would certain events appear differently between desktop and phone? Here’s the same month view on desktop vs phone - note the 5/25 & 5/26 FMSC Closed events appearing on both.
I am trying to figure out an effective way to share a view with external collaborators. Companies like Smartsheets allow unlimited guest editors for no extra cost on their business plan, but it seems that with Airtable if I want to share my project plan with a customer just to mark tasks as complete we need to pay $10/mo/user for portals, or full price to get them into the company Airtable account. Are there any alternatives here? How have you guys accomplished this effectively?
Hi everybody, as you can see I try to connect my airtable with my ghost CMS and I click “yes” on the field where it says “include file content, because it seems an existing problemn with Airtable. But whatever I do in zapier, it still an outdated URL. Is there any workaroudn to fix this?
I need help in displaying number of characters entered, and number of characters left in text fields in forms. Something like this:The number of characters remaining should get dynamically updated as the user types/deletes the characters.
Does anyone have a current script that is parsing any emails beiing received in the new “trigger when email received”. I am trying to parse the body, but I cannot figure out the inputs from the email received.I get errors on all of the inputs. My reason for the inputs, is that the receivedDate didn’t work.// Get inputs from the automationlet inputConfig = input.config();let subject = inputConfig.subject;let body = inputConfig.body;let receivedDateRaw = inputConfig.receivedDate;// Optional: log inputs (for testing)console.log("Raw receivedDate:", receivedDateRaw);console.log("Subject:", subject);console.log("Body:", body);// Parse date string into Date objectlet receivedDate = new Date(receivedDateRaw);// ✅ Function to get the next Tuesdayfunction getNextTuesday(date) { let day = date.getDay(); // Sunday = 0, Monday = 1, ..., Saturday = 6 let daysUntilTuesday = (9 - day) % 7; if (daysUntilTuesday === 0) daysUntilTuesday = 7; let nextTuesday = new Date(date); nextTuesday.s
Hi there, I’m trying to create an airtable automation script whereby it takes in the Full name of a record and changes only the first letter into uppercase (upper caps). This is my code, I can’t seem to get it to work, can anyone help me with this? let table = base.getTable("Training Masterlist"); // Use the correct field name that maps to the automation's Record IDlet recordId = input.config().AirtableRecordID; // Correct this if it's named differently // Ensure that the recordId exists, if not, log an errorif (!recordId) { throw new Error("Record ID is undefined.");} // Field namelet fullNameField = "Full Name (As in NRIC)"; // Fetch the record that triggered the automationlet record = await table.selectRecordAsync(recordId); // Get the current value of the "Full Name (As in NRIC)" fieldlet fullName = record.getCellValue(fullNameField); if (fullName) { // Convert the full name to the desired format let formattedName = fullName .split(" ") // Split the name into words
I have 2 forms that a customer fills out - 1 is info about the company, which populates on the company table. The second is for the employees table and it collects info about each employee that works at the company. I currently have the form set up to collect the company info first, then they click “continue” and it redirects to the employee form. They then have the ability to fill out the employee form as many times as needed. I tried using a pre-filled link for this button to auto fill in the company name on the employee table linking the two, but that does not work. Should I be using an automation? Is there any solution for this that does not include using a 3rd app?Any ideas for linking the records is greatly appreciated!! Thank you!
I apologize if this is the wrong forum.I am new to Airtable looking for someone to set up simple DB to keep track of customers.A table with maybe 6-10 fields. Will need to import current old DB, which I can probably do once the Airtable is set up or may need assistance.Thank you,Michael McDonnellcontact: [email protected]
Can anyone give me a definitive answer to this question?I have a list Interface with 3 levels of heirarchy - Apiary, Hive, InspectionThis is for beekeeping. An apiary is a collection of Hives and Hives are inspected frequently.On desktop in a browser (Safari) I can click into the Apiary Details and scroll down to the list of Hives and add a new one.Still on desktop, when I expand the Apiary the interface shows its Hives as expected with an ‘+Add Record’ (why can’t I call them Hives?) button, and when I expand a Hive I can see the inspections as expected and at the bottom of the list of inspections is a ‘+ Add Inspection’. All good. Makes sense.But none of those things are available in mobile (iOS 18.3.2, iPhone 12 Pro)I can open an item at any level and edit that item but I can’t add new hives or inspections. Looks like this:Am I missing something? This is a key feature for me and being able to do this in mobile is really why I’m building this app.I read an announcement from a year ago
Is anyone else having issues with Page Designer today? For some reason, all of the builds I’ve created across multiple bases with Long Text fields (with rich text formatting enabled) aren’t displaying correctly. I’m just seeing numbers like 0, 1, 2, 3. We rely on rich text formatting to include links and emails in our letters, so I’m wondering if it’s an issue with our setup or if this feature is no longer supported. I also put in a ticket just in case it’s a temporary error, but wanted to see if anyone else in the community has the same experience.Selected in green is rich text enabled, and right side is just the long text field
My base has a people table and a calendar table. The primary field in the people table is name. In the calendar table, the people table is linked with a field called assignee. In the calendar table, the assignee field correctly displays the primary field name value in grid, calendar, kanban, timeline, gallery and list views, however in all ~100 gannt views my team has created the assignee field now incorrectly displays the airtable record ID of the linked record in the people table. This just began yesterday. Why is this happening?Am I able to change something to correct this?
Hi all,We've been using a Page Designer invoice setup for a few years without issue, but we're now running into a problem where the Address field isn’t displaying properly.Originally, the Address was pulled in via a lookup field. The field shows the correct data in the row, but Page Designer is displaying a “0” instead of the address.As a troubleshooting step, I also tried using a plain long text field with the address manually entered—but in Page Designer, it just shows a blank square. It’s like the field isn’t registering at all.Is anyone else running into this? Or does anyone have suggestions on how to resolve it?
Hi There!I'm developing a resource allocation base for my team, where tasks may involve multiple collaborators, each with distinct daily availability and varying percentages of time commitment. While assigning resources at the project level is an option, it doesn't accommodate the differing daily time percentages required by each collaborator. How can I structure the template to effectively account for these variables?
In our base, we have a field where users can select a project from a linked table. However, we want users to only select from existing projects, not create new ones. Currently, the small "+" button still appears next to the field, allowing users to add new projects—something we want to prevent.Is there an easy way to disable or hide the "+" button in a linked record field without locking or restricting the entire field or table for the user? We're looking for a solution that allows selection from existing records but completely disables the creation of new ones via this interface.Screenshot to show that often projects are added by incident - which we would like to prevent
Already have an account? Login
No account yet? Create an account
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.
