Ask the Community

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

Hi, I’m trying to create a pivot table in Interfaces > Dashboards. I need two nested rows (Vertical and Region) to cross-reference values against one column (Quarter) for the table to be useful.However, I just don’t see the Add Row option in the configuration panel on the right. Multiple sources tell me this should be possible, but I’m not seeing how. Can anyone help?Not able to nest another field. 

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 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.

Hello,I am using an Airtable form embedded on my website via an iframe. In the form settings, I enabled the option “Enter a URL to redirect to after the form is submitted” and added the URL of my thank-you landing page.However, after submitting the form, the page redirects back to the form instead of redirecting to the landing page I specified.The form is embedded on my website using an iframe, and I suspect that this might be affecting the redirect behavior.Could you please help me understand why the redirect is not working and how I can fix it?Thank you in advance for your support.Best regards,

I just want to highlight or select 20 views or more at a time and delete them when we move from one school term to the next or one year to the next. Is there now a way to do this? There are some posts about this from years ago ...

Hello,i want to know if is possible to copy automatically fields from a table New Books to anther table Books.They will have the same fields. The table Books contents all the existing books on a library and the table New books, all newly purchased books.  A form in softr will be filled with new books and it will be showed in table Books.   

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

Hello team, Is there a way to set up an automated outlook email(event) to be sent from a shared inbox and not my personal inbox in airtable?

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

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.

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

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

I've found that SEARCH() in filterByFormula handles escaped double quotes differently depending on the field type. Backslash-escaped quotes work correctly on text fields but silently return no results on linked record fields.Setup:- Table "Registrations" has a linked record field {Rider} pointing to table "Riders"- One of the records in the Riders table has the primary field value: Aubrey "Aub" Holland- A Registrations record links to that Rider- Table "Registrations" also has a plain text field {Direct name} where one of the values is Joe "Biggie" SmallsWhen searching the Registration table I get different results with a very similar search depending on which field I search: What Works (text field):  SEARCH("Joe \"Biggie\" Smalls", {Direct name}) != ""Returns the matching record correctly. What Fails (linked record field):  SEARCH("Aubrey \"Aub\"