Ask the Community

Hello,I am new to junction tables and have pretty much zero scripting experience, so bear with me.I am trying to create a breakdown of call sheets for group shoots and create individual “shifts” in a junction table. The goal is to be able to adjust start and end times for those linked in the shoots and to be able to create a more comprehensive reporting interface to track hours and OT by multiple criteria.I cannot show the actual base, but have created a basic example of the structure and result of Airtable’s junction table extension.Client tab:Franchise: Franchises have assigned POCs for internal notification

Hey community! Long-time lurker, first-time builder posting here.Like many of you, I've been frustrated with Page Designer living in base extensions while all my users are interface-only. Every time someone in the community asked "can I use Page Designer in interfaces?" the answer was always not yet. So I decided to just build it myself.What I builtA full drag-and-drop page layout designer that lives directly inside an Interface page as a custom element. It looks and feels like Page Designer, but it's a first-class interface citizen.Here's what it supports so far:📄 Page size presets — A4, Letter, Business Card, custom dimensions 🖱️ Drag-and-drop canvas — absolute positioning, resize handles, rotation, layer ordering (front/back) 🔤

my organization does trainings and after each training, we send participants a post-survey to fill out. each training covers slightly different topics, so the questions we want feedback on change slightly with each training as well. right now, i have one table called post-surveys where each field corresponds to the questions we ask, and the field names are shortened versions of the questions. then we build the form for each post-survey based on which questions we’d like to include. the downside is that it means that table has a huge number of fields and it’s hard to see if the question you want to include already exists as a field or you need to create a new one. (e.g. “S3 FSOW: Challenges” means in session 3, we had a question about challenges that related to the reasons we did the session, you can see how that makes it hard to keep track of the actual question)

I currently have a sign-up form that collects both a name and email address. When the person signs up, I have an automation set up to send a confirmation email. I have a bizarre situation where one person somehow keeps submitting their name and email address in what I assume is unicode bold, sometimes courier, and sometimes in a type of cursive. Whenever this happens, the confirmation email fails. The person who signs up on this form is older, and has no idea what she’s doing. I am hoping to be able to somehow convert all the unicode fonts into something that is readable so it can send emails.Some more context, the font also doesn’t get picked up if I do a Ctrl+F on the back end of the form. It’s as if the text isn’t there. If I copy and paste the text somewhere else online, it keeps the formatting, which makes me think it’s some kind of unicode that is still readable, but obviously not in this email situation. Can I fix this on the back end of AirTable so anytime she

I want to give to some users ( managers … )  the ability to invite new users ( projet team … ) from a creation form in the interface, I tried to do it but I should add the new ones from the base first then select him in the dropdown list showed in the creation form. How can I centralize the invitation just from the interface no need to go the base and add him from there ( it’s so hard to do this when we have a lot of inviations to handle ) 

Hi, I am trying to create a pipeline that a few users can manage a “global view” and then when updates are made to automations or tables from there all the workspaces sync, but the workspaces can be broken into regions and maintained separately by diff teams. Are we able to do something like this? Thanks! 

I’m reopening this topic, I’ve seen there was an old one and this issue seems to keep being not solved after 5 years, which is kinda ridiculous.Out of the blue, without any reasonable explanation, the record IDs of one of my main tables have changed.We use the Record IDs as the primary key to run reporting outside of Airtable. It fully broke our scheduling system. From the 31st of March to today, all the IDs of my records have changed.This happens in a synced table, which might be the reason, although not logic at all. No record has been deleted an re-created.How come this happens? A unique ID must be immutable, what’s the point of having IDs that change in time? 

Hello Airtable Community,I am working with a non-profit Educational Institute to centralize over 20 years of data currently scattered across various spreadsheets. Our data includes Programs (15+), Students, Enrollments, Mentors, Alumni, Marketing, Scholarships, Startups, and Events.Our Goal: We want to move away from siloed spreadsheets into a centralized Airtable ecosystem where we can track a participant’s journey from Student to Alumnus to Mentor or Founder.My Questions: Single Base vs. Multiple Bases: Given the volume and variety of data, should we aim for one "Mega Base" or multiple specialized bases? Unique Identifiers across Roles: For our Students, we use a University ID as a unique identifier. However, for Mentors, Alumni, and other external partners, we don't have a standardized ID. What do you recommend as a Unique Identifier f

We’re an embroidery company and We’ve been working on relaunching our website on Shopify and we were planning on using a third party warehouse management system but we’ve had a dreadful time with the supplier and we’ve decided to scrap that project as its delaying launching our website (already three months late) For at least this year, we’re looking to use Airtable as our operations system and set up with a two-way sync with Shopify.  Has anyone used Airtable as a :  lightweight WMS / production workflow layer alongside Shopify? Has anyone managed production workflows (e.g. batching, manufacturing, customisation) in Airtable?  Basically  we’llUse Shopify for: storefronts (each school has its own store) orders + payments Use Airtable as our operational system, to manage: order lines (each item in an order) supplier ordering

So far, I haven’t had any trouble entering text and currency into Airtable bases, but I’d like to calculate simple overall percentages from my data. I’ve looked everywhere and can’t figure out how to do it in Airtable.I know how to do it at the row level, but I don’t know how to calculate it for the total data. For example, I have values in Column 1 and Column 2, and I need to sum all the data from Column 1 and all the data from Column 2, then divide them to get the overall percentage. Im trying to do this in the interface view too, but its imposible.I’m starting to think that it’s not possible to calculate simple total percentages in Airtable. Or am I missing something?Thanks very much in advance for any help with this.

I sometimes wonder why I still pay airtable money. For an application that claims to be good for time planning it’s mad it still doesn’t seem to be able to do time and date maths properly. I am in UK (so GMT/BST) - I want to have a date field and a separate time field, and to be able to combine these two into a calculated dateTimenothing I have tried seems to work reliably for this without jumping the date back to UTC Has anyone found a solution for what should be a trivial task?Thanks Richard

Hi there, It appears that there are a lot of threads but I can’t find an answer. I want to be able to add some images and font sizes and colours. I’ve tried connecting to GMail and setting up a signature but it doesn’t include the signature in the email body. I also have a field with the persons name in the airtable base, however that isn’t displaying for some reason.  This should be pretty straight forward. I’m open to paying someone to do this.  Thanks in advance. Jared.

I’ve been banging my head against a wall trying to get this to work and at this point I’ve come to the conclusion this might not be possible. I’m hoping that there is a wizard out there that may be able to help with this issue.  So context:My base contains 3 tables. An inventory, a customer table, and an orders table. There are linked fields in both my Inventory and my Orders table that link to the customers table. Within my Inventory table there is also a linked field that links to the inventory. What I want to do is whenever I add a piece of inventory to a record in the Order table, that it adds the customers name to the item within the Inventory table.  I’ve tried getting Omni to help me set it up, I’ve tried getting the support chatbot to help, and I’ve even tried Claude to help me with no results. If someone could share the correct setup I’d be eternally grateful. If I’m knocking on a door that doesn’t exist

I have a production base and a sandbox version of the same. I often accidentally mix the two if I don’t carefully look up to check that I’m in “ Sandbox”  mode when I’m working fast.  I’ve read you can change the color or base name e.g., “ Base (Sandbox)”  vs. “ Based (Prod)” from the home screen.  However when I try that I only see the main Prod base and it’s only allowing me to modify the name of the Prod base. I don’t see  a separate way to modify the name of sandbox itself.Has anyone been able to manage this? and how? Thank you. 

Hi,It seems that the Google Calendar: Create Event requires a hard coded (chosen) calendar to place an event in. We have used a shared calendar for this, but it gets somewhat messy.Hence, would it somehow be possible to have the event placed in a dynamically chosen calendar? Either <current user> or somehow derived based on a variable (e-mail addresse for example)?Rgds,Björn

Hi, I have established a foundation to collaborate with an external community. All my providers are added as Guests and have only access to interfaces. I’m struggling to find documentation for Guests users only, and especially regarding the notifications. I need several things and either it’s not possible so i need to find a work around , or i don’t know how to set it up:1/ when someone leaves a comment on a record the @ does not show all the guests users (portal editors) only the Editors and on top of that they don’t see who left the comment either it says anonymous, is there a way to change that without changing the portal editors status? i would need the portal editors to tag each other.2/ is automation the only way to receive emails when a status is changing? or am i missing something? Thanks for your helpMarion

Hi,In an automation that is triggered by an user from an interface button, would it be possible to divide the action in two parts, with user interaction inbetween?I’d like to show the user a preview of an invoice that would be sent out after the user has checked it’s all good. The PDF would be produced in the first stage, then sent out in the second if OK.I cannot see any way to this in Airtable, but I have been amazed before by elegant solutions :). Would there be a solution also to this?Rgds,Björn

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

Hi, I have been trying to get in touch with the Sales Team for more than a month, I have a base that keeps exceeding the 125k records limit, and we urgently need to get more records. has anyone faced a similar situation, and if that’s the case, how did you solve it? Thanks

My referral transfer page is broken I can’t seem to transfer my credits to my workspace. Is anyone having the same problem?

I’m trying to configure a log-style table in Airtable where, when a new record is created, certain fields are automatically populated using values from the most recent existing record.The problem I’m running into:Using Automations → Find records, I can filter and sort records so that the correct prior record is identified However, Automations treat the result of Find records as a list, even when sorted and limited to one record Because of this, I can’t reliably reference a single previous record’s field value when updating the newly created record I’m using the Airtable free tier, so scripting and paid features are not availableWhat I’m trying to understand:Is there a supported way on the free plan to carry values forward from the most recent existing record into a new record using automations? If this isn’t directly possible, what table design or workaround is required to achieve this behavior wit

I want to use the Claude - Airtable connector in my team which allows them to create records from within claude. I want to make sure that when they are creating a record, for eg. a Task, they are asked to give all the information that is required for my processes. I don’t see how I can set the SOP when allowing them to create/edit from claude. 

When importing a CSV file I am selecting ‘create missing select options’. I can see these new options in the preview but when I’ve selected ‘import’- the records are there but with no new options. Troubleshooting I have already done:I am the owner- however on the free plan. I have saved the Excel file as a standard CSV and as a CSV UTF-8 file. I have tried importing a smaller sheet (sheet/data is not large to begin with) I have made sure the field mapping during import matches the multiple select field exactly. I have refreshed the base and switched views after import. The data is not computed fields (like formulas, rollups, etc.)  I have no hidden or filtered views.  I don’t have a huge amount of options in my multiple select fields to begin with.  I have submitted a ticket but am interested to hear what the community thinks. What am I missing?

Hi everyone,for a long time the page designer extension did a great job creating shipping labels for my records. But recently the page designer extension always crashes. I have the feeling that with the amount of records in my table - more than 30k - it became a problem for page designer. In bases with a smaller amount of records age designer works well. Does anybody else have similar issues?  Kai @ CPLI 

Hey 👋I've been building a custom Interface Extension using the Extensions SDK and ran into what seems like a significant limitation — I can't find any supported way to let users upload a file/attachment directly from within the extension UI.What I'm trying to do:I have a custom extension embedded in an Interface page. The workflow requires users to attach a file (e.g. a PDF or image) to a record — ideally triggered from a button or input inside the extension itself.What I've tried:Using a standard HTML <input type="file"> — the file picker opens, but there's no SDK method to then take that file and write it as an attachment to a record field. Looking through the @airtable/blocks SDK docs for something like updateRecordAsync with an attachment payload — attachment fields require a URL, not a raw file object. There's no upload endpoint expose