Ask the Community

Hi, I am pretty new to this and not a developer. We are using Airtable for our product database for our Shopify store, and have Airpower as the sync between them. This works pretty good, but there is one major thing we need that Airpower does not support.We need the number of "committed" inventory of the products to sync from Shopify into Airtable in real-time. Right now, the Airpower Inventory sync only brings the "available" number through, but both are required for us, and we need the data to by syncing constantly so it's up to date.Is this something we could use a webhook for? Or is there a simpler process?

Is there a way to use Airtable sync to conditionally sync data from one base to another? I need to only sync specific records and not all of the records in table.If it is not possible using Airtable sync, is there any other way of accomplishing this?

When creating a PRD or similar and I want to copy a User into the file so they are aware of the update I have always used the @ sign and selected the email from the dropdown list. When I then come out of this the email has automatically been sent. Do I also need to set up an automation? I have not done this previously as it is not always to the same person / group. 

Am I overcomplicating this?I have an automation to create a time stamp in a Date Completed field when a Status single-select field is changed to Done. The Date Completed field is populated with the full date and time, but I need to utilize this information in a Reporting interface for my management so I’d like to be able to have them select the month from a Dropdown Filter. To that end, I’ve created Month Completed field that uses a simple formula to just show the 3-letter code for the month, based on the Date Completed field.The issue I’m having now is that I’m not able to use that 3-letter code (because it’s a formula field?) as a filter on the Dashboard.I could create another automation that’ll convert the formula field into plain text or even a single-select field, but I feel like I’ve now created a whole bunch of steps to do something that might be accomplished in a simpler method. Note that the Month Completed info isn’t being used anywhere else. The Date Completed will likely al

I have a few collaborators that have editor access, but keep getting an error message stating “You are not permitted to perform this operation” when trying to submit a form that creates a record. They can update records without any issue, but I can’t seem to get it so they can create new records.   This is through a form in an interface, but I can’t find anything that would prevent them from submitting the form. There are no restrictions within the form itself that I see. I’ve checked that they have Editor access to the specific interface, there is nothing on the interface page with the form that would allow me to make any restrictions, and I’ve confirmed the table where the record is being create allows for collaborators with editor access to create new records.  I then created it as a separate form, not within the interface and the only way we could get it to work was to open the access to anyone, which we don’t want.  Can someone point me to what I’m missing or should be doing diffe

I have an Airtable base that includes a Form View in a particular Table. I would like to be able to create a new Record in that Table and fill in some, but not all, of the fields for that Record. I’d like for the remaining fields for that record to be filled in by someone else. Can I send a URL that is unique to that record for that person to go to and fill in the remaining fields?

Hi all! I have a problem that I feel should have an obvious solution: I’d like to set up an Automation that normalizes a string value after input by base collaborators. However, the Automation appears to run too early, catching only parts of the input string. (This behavior is not consistent, though: From time to time the Automation will catch the whole string.) I selected When record updated as trigger and configured it to watch only for changes in a specific field (in my case: Keyword). Example from the screenshot: The entered text is “Aldi Angebote”, but the Automations appears to run already after the first letters are typed in, so only “Ald” is used as Automation input. What’s the best way to solve this problem? Is there a better trigger for this use case that I am missing?

NEVERMIND - I filtered out the empty ratings. Thanks!

I have an Airtable that is populated from Jotform submissions. The Jotform has a configurable list that for someone to fill in their schedule for the week. The configurable list can’t be split in Jotform so I’m trying to split information in Airtable. I want all of the days of the week listed in the configurable list cell to be extracted in a Days Open column but can only figure out how to extract the first instance using regexextract.  For example the configurable list will come in as:Day Open: Monday, Opening Date: 2025-06-16, Closing Date: 2025-10-27, Start Time: 09:00 AM, End Time: 02:00 PMDay Open: Saturday, Opening Date: 2025-08-09, Closing Date: 2025-08-30, Start Time: 10:00 AM, End Time: 04:00 PM and I want Monday, Saturday to show up in the days they are open. 

Hi everyone! 😄I’m trying to create a script for Airtable Automation that limits the number of records a user can create per page in Softr + Airtable. The idea is: Table: Projects Field that identifies the logged-in user: Criado por Field that identifies the originating page: Página Acesso Limit of records per user per page: defined in the script (e.g., 3) Desired behavior: if the user tries to create more than the limit, the extra record should be automatically deleted. So far, I’ve tried using Find records + Delete record in the automation, but it didn’t work as expected. I’m looking for a ready-to-use script or example that does the following: Count how many records already exist in the Projects table for the same Criado por and Página Acesso. If the count exceeds the defined limit, delete the newly created record. Does anyone have a script that works in this scenario or can share an example adapted to this table and these fields?Thanks! 🙏

ObjectiveI would like to automatically import files (PDF or other formats) into Airtable, from either: a local directory, or a Google Drive folder. ContextI currently have a CSV file containing the drawing numbers.However, since it’s not possible to include file attachments directly in a CSV, the corresponding files (PDF drawings, images, etc.) are stored separately in a folder.RequirementI would like each file to be automatically matched with the correct record in Airtable, based on the drawing number, in order to consolidate all data and files into a single, centralized table. Thank you in advance for your help.

Hello,I am creating a management system for tracking the required materials for projects. In each project, there will be predefined material quantities needed to complete the project. When the work on a project starts, the user will generate a Purchase Order (PO) (third table) and add multiple materials through the interface. I need some help in creating this interface.The base design is as follows:I have two base tables. The first one is called the Master Material Base, and the second base is called Jupiter Castle.The structure for the Master Material Base consists of one table called the Master Material Table, which contains four fields: code, description, type, and unit. I have granted permission to share and sync this table with other basesIn the second base, Jupiter Castle, I have the following design:(First table): I have synced the Master Material Table into this base.(Second table): I have created a new table called Material Tracker, which contains the following fields:Line ID

We are a newly established company. I am looking for 3D printer to produce prothetics parts,considered as medical devices. Can the community advise on printers, and materials? We have to consider that the through put will be low at the beginning and will increase later. We might be at prototyping level to start with. Can we use smth like there printers https://43dprint.org/best-3d-printers-under-2000/?

Hi.We are using Airtable to display data about our system landscape. We want to share this data with our organization, and have therefore crated links and added these to our internal CMS system.If the link is shared to somebody outside our organization, the information should not be available. We tired to handle this with the “Access restricted to our email domain”, but found out that it requires that the use is an airtable user. If we don’t make any restrictions that link can be accessed by anyone how has it.In the perfect solution, we would like that only our Active directory users have access to the shared link. Is there any way to solve this?Thanks in advance.  

Good morning,we get this error since an hour on our interface designer extension ‘Sorry, an error occurred’.No further information.Any ideas, what we can do? Thanks for your help.Tobi

HiI want to be able to generate a barcode/QR code upon approval of incoming goods.Once generated, each packet that has been approved (receipted) from incoming goods needs to be able to be printed in bulk along with the details of each packet.The packet tag will then need to be viewed within Softr interface when scanned via the users mobile camera.Anyone have experience with making this work with Softr as front end (for taking the camera scan) with AT as backend? Or any suggestions?​@ScottWorld  ​@Mike_AutomaticN ​@TheTimeSavingCo ?

Hi everyone, I have been troubleshooting this for hours. This is an automation that used to work and suddenly it no longer does. I have an automation, triggered by a button, It’s a simple form submission and the button triggers the creation of various new records in different tables. Many of these records are linked. The Links are written by the automation. All of this works great. But for the last of the records, that is supposed to be created, it does not. The records IS created, however the linked records are not connected. I am linking to records that were created in earlier steps. And linking these records in the earlier steps was no problem. I do not get error messages or anything. The link simply does not get written. Any thoughts?

Hi Airtable builders!Thanks to SyncBase (my Airtable - Shopify integration), you can now create new Shopify Products and Variants directly from Airtable. How does it work?Once you installed the app (can be found on the Shopify App Store), select “Products & Variants” as data you want to sync.  The app will create for you new synced-tabs into a new base (or an existing one if you’d prefer). In the Products tab you will be able to create new records (blank or with already prefilled data). Each new record creation will trigger a product creation in Shopify (draft status, no stress :D). => And of course, you will then be able to edit all this Product data from Airtable too.  Happy to get your feedback and to help if needed :)   

Hi! Recently we have been displaced due to flooding in our apt, I wanted to create a base to track the items which need replacing and repair along side with an image to have an overview and then send to our insurance. Has anyone created a similar base or have a base template that is similar? Thank you for your help it is greatly appreciated during this tough time! M

Is anyone aware of eitherA way to HIDE this on interfaces? It is not a good look when providing access to outside parties that this was edited by AI etc. or to have these blank boxes in interfaces. If Airtable plans to get rid of that in general? If no plans to hide that commentary, I need to adjust my layouts :)  

Hello,I'm wondering if it's possible to get a pivot view in Airtable similar to those in Excel and Google Sheets that would show multiple values ​​at once, e.g., the sum of the values ​​along with the share of the total and the percentage change year-over-year. Like in the example below.Many thanks for help

I need help 😥I’m currently trying to import a CSV file into one of my bases under a Teams plan workspace, but I’m receiving an error message stating that the maximum allowed file size is 5 MB  which, as I understand, applies only to Free plans.Could you please confirm why this limit is being applied to my paid workspace and help me resolve it? I’d appreciate any clarification or steps to fix this issue so I can proceed with the import. Please refer to the screenshot below: Thank you for your assistance. 

Hi everyone.  I have built a database of car images that dynamically filters models down to by the make selected, the trim by the model selected, and so on.  When I build out an interface the dynamic filtering functionality works as intended (if I select Audi in my dropdown on the interface, when I select my model filter it is automatically limited to Audi models.)  However, my issue begins when I share the interface.  Currently I’m sharing the interface to the web with password access.  My team will handle the updating of the interface, and other members of my organization will need to reference the data on a read-only basis.  However, when I send out the share link the dynamic filtering functionality of my drop down no longer function in the same way.  If I select the make Audi, the models no longer filter down to Audi models.  Is there some setting that I’m missing to enable dynamic filtering on a shared interface?

I have a base that I’ve published as a library, let’s call it Part Numbers. It only has two fields - a Part Number and a description. I have 2 or 3 other bases that are pulling in this library as a table, and they’re linking records to it.I now need to make some updates to the Part Numbers base - some individual #s may be deleted, or descriptions might be changed, etc. If I upload a new CSV to the main library base and overwrite everything that’s there, but many of the #s never change at all, will the linked records in other bases stay linked?

The left sidebar, which contains nothing but the new LLM button, can no longer be collapsed. In an interface that is essentially a series of excel-like rows and tables, every inch of my screen is valuable, especially on a laptop screen. This bar of empty space actively slows down my workflow as it increases the amount of scrolling sideways I have to do, and it also throws off my muscle memory by moving all of the tabs over, and pushes the actual useful information on the left side of the screen away from the edge of the screen where I am used to finding it. Please add an option to move the LLM button to the top right, next to the base history and contact sales buttons, where there is a ton of empty space already. Or, add an option to minimize the sidebar, like we used to be able to. Or better yet, give us an option to hide the LLM button entirely if we are not interested in using it. I know every CEO believes that LLMs are the next big thing that must be included in any technology, but