Ask the Community

Hey Airtable community! 👋I’m Ruben, co-founder of Stacksync, a modern integration cloud that helps teams keep their Airtable data perfectly in sync with the rest of their systems, databases, and warehouses in real time.Over the past few months, Airtable has quickly become one of our most popular integrations. I’ve seen teams use it for everything from internal operations dashboards to lightweight CRMs, but things can get tricky once automations or APIs start scaling. That’s where real-time sync and solid architecture really make a difference.We’ve learned a ton about what works (and what breaks) when data starts flowing both ways. I’m happy to share what we’ve learned and hear how others here are approaching similar challenges.Looking forward to connecting, learning, and helping others build smarter with Airtable.If you ever want to chat about connecting Airtable with other parts of your stack, feel free to reach out! 

I’ve been doing my research as to which program will suit my not-for-profit and airtable has come up as the leader on several fronts. I’m a little overwhelmed and trying to find the best place to start - I dont know what I need because i dont know what airtable is capable of at the moment. which course should i begin with in the academy? where did everyone learn airtable? i want to be a master!

Hello, I’m trying to use for the firs time a Airtable table inside a Docusign Maestro. At the Airtable workspace I created a table called Clients. Now, using a Docusign Maestro step called “Read from Airtable” I would like to select that table then read the records.A picture where I’m trying to config the step: How to do that? Thank you,Alexandre

Hi. Hope someone could help. I’ve automated a create tasks from a task template and it worked. Now how do i automated creating subtasks. I have subtask template table as well. That’s where I’m stuck on. Thanks!

I would like to send an email at 10am every week day to orders with the status ‘past due’. At the moment I have an automation with Trigger > at a scheduled time Action > find records (if status is ‘past due’) Action > send email however the test email fails due to “Cannot email more than 25 recipients at a time.” at the moment it is adding every recipient to one giant email, rather than separate emails. Is there a way to have it send out separate emails for each ‘past due’ record? I don’t want all of my clients to see each others email address :slightly_smiling_face: Thanks

Here’s the scenario: I have a long text field (called ‘Email Draft with Placeholder’), and a formula field (called ‘Email Draft’) where I’m replacing a few placeholder key using REGEXREPLACE.I’m then displaying ‘Email Draft’ in a Record Review in the Interface. Here, it displays as expected, maintaining the new line breaks.If you copy that text (by dragging across it and CMD+C), and paste it into a Gmail new email, it all still looks good.But if I send the email, and look at what was sent, all the new lines are gone! 😱I’d be really grateful if anyone could explain what’s going on here, and how I can fix it! 

Hi, Is there any way of wrapping the text in the header fields so that I don’t have to have such a wide column to fit the header in? In the example above I want to be able to see “Genre” rather than “Ge…” and “Proofer 1” instead of “Pro…” Thanks in advance! Kate

I have a form for Licensure to get submitted, but I am wanting the person submitting to see the Description of the Code that is chosen.I can't seem to get this to show how I want because I need on my database to have a column with ONLY the code to be passed over on the file I generate.  Ultimately what I want is what you see below.  I want the "License Code - PS to be what is showing.  If we have someone in certain states I need it to change to a certain code.  Here is what it should look like (coming from step 3 below, but read why I don't seem to like this).  I tried a few items listed below:1. First, I wanted to use a formula in the Automations, but it won't allow this from what I could see.  I can chooseStatic or Dynamic to update the record, but can't use a Formula here.2. Second I the

My employer requires a strict technical control to ensure that employees can only check in from their authorized workstation. The idea is to automatically capture the user’s public IP address at the time of check-in and compare it against a whitelist of IP addresses stored in Airtable.The key constraint is that the solution must remain 100% Airtable-based: forms, automations, scripting, with no external front-end, middleware, or proxy server (e.g. Netlify, Vercel, etc.).However, in our tests, Airtable scripts always return the IP address of Airtable’s servers (AWS), not the end user’s IP. We would like to know if there is any native Airtable method or internal configuration that would allow us to capture the real client IP address directly within Airtable.

Hi guys, I am new to this… I am trying to sync my Shopify orders to airtable. If customer order 2 times, how can I separate the 2 items to 2 records instead of all jam in one? We used to manage it on GoogleSheet with zapier, and they have a function of creating multiple lines, how I can do that in airtable? Thanks xoxo

I am new to Airtable. We set up an images table. When I synced products from Airtable to our Shopify webshop some images ended up one line lower in the table, and thus images end up with the wrong products. When I “repaired” the images in the Airtable images table, and synced A>S nevertheless images skipped out of their row to another product and deleted images were still resident in the products table. How should I properly sync products + their images A>S ?

Hello. I want to create an app/system for managing Shopify store from Airtable. Is there anybody interested in a solution that here? What features would you like to have? (ex. order management, product/inventory management etc.) Would be happy to hear some feedback. Thank you!

Hello Airtable Community, I have experienced recently a misunderstanding with an automation of Airtable. I have a Plus Plan but the number automations free are 0, It says I have done 50.000 automatizations and now I cannot try my app anymore. I don’t need even 50.000 automatizations by now but It has been a misunderstanding of an automation of “When record updates” in the Collections base. This Collections Base is linked with the products (that are 1.000) and this products are sync with Shopify AirPower API that sync the changes every time. So the solution, i think, is to do not watch this records in the automatization… but I did not noticed earlier… Is there any solution on this type of situations? I am a developer and I need to keep working with the automatizations to develop an web for my client, even upgrading to Pro Plan will stop the work f

I’ve created a Shopify PIM template for e-com brands. In this template, you can find:A global dashboard with products distribution (Categories, Sales Channels, Region Catalogs...) Products catalog: a classic products catalog with an interface to easily update one or multiples products at the same time. Inventory: interfaces to manage your inventory (per location, low stock levels...). Monitoring center: to easily track last updates and missing data.Connection between Airtable and Shopify is made by SyncBase. It’s a two-way sync integration so all changes made on this Airtable PIM can sync to your Shopify store in a few seconds.Just drop a message if you want to get this template for free! All I’m asking is feedback :D

Hi there, I’m trying to put together an expenses claim form for my team including mileage claims. We previously uses Google API Distance Matrix on JotForm to calculate the distance an employee travels between two locations. I wondered whether there was a way I could add something like this to an Airtable form? The distance that came out between the two locations then calculated how much that employee is owed for the petrol used. Any advice would be appreciated. 

I’m trying to understand the steps for filtering views by using URL parameters, including how to call the field in the url given it’s not in English and contains spaces.I couldn’t figure it out from official documentation.Any leads will be much appreciated

I use Wix Booking App and also have an AirTable Calendar.My goal is to have Wix appointments show up on my AirTable Calendar and ALSO have any appointments made in Airtable block those times on my Wix Availability Calendar. Can this happen?  How? Thanks!

Hi,I’m a newbie and was wondering what affects the fields listed in the field selection of interface Levels. I currently have only 1 field I can choose from, where the table actually contains a number of fields. What do I need to do to be able to choose a different field? 

I have an airtable base that contains data from a dozen sources and lots of duplicates. The duplicates are easy to define based on phone number. With dedupe currently you have to look at each individual cluster of duplicates and select what you want to keep. That's fine for some scenarios but that should not be the only option. It would take hours for me to look at each cluster.There should be a easy way to:1- Select the fields where duplicates exist.2- Select which record to keep (most completed fields, newest, oldest, etc).3- Run it and be done.I really don't want to have to export to excel and re-import because airtable can't handle such a simple function.

Hi everyone! I need to generate the documentation of an Airtable database and I was able to use the script below, but it would be much more useful and efficient if the output were in an Airtable table (which I could easily update daily or weekly thanks to an automation). Obviously I could go ahead & code all this, but I’m quite slow with JS (rather a SQL/Python kind of guy) and was wondering if someone had already gone through the trouble… for (const table of base.tables) { output.text(table.name); output.text(table.id); output.table(table.fields); output.table(table.views); } In a perfect world, I would also love to find a way to programmatically update table and field descriptions: I am migrating data from other tools to Airtable to create beautiful workflows and I’d like to reuse existing docs to update all object’s desc at once instead of manually updating descs. table by table, field by field.

Hello Airtable Community,I’m receiving an array from a Fillout form via webhook into Make (see attached image)I would like to use this array in a Search Records module for Airtable to find all records where the primary field matches any of the values in the array.What’s the correct formula syntax in Make’s Airtable module to achieve this?Thanks in advance   

I’m building a simple dashboard for our executive team that includes a Number element for a currency field. The dashboard needs to work well on mobile because our execs often access it while traveling internationally.On desktop, the number element displays correctly with thousands separators (e.g., $1,284,428,043.95). However, on mobile, the formatting disappears and shows as a long unformatted number (e.g., $1284428043.95), which is hard to read.The number element is set to Summary → Sum. It’s aggregating a rollup field from another table, which is formatted as currency. The thousands separator appears fine on desktop but not on mobile.How can I get the thousands separator (comma) to appear on mobile for this number element? Is this a limitation of Airtable Interfaces on mobile, or is there a workaround?Thanks!

We are looking to enable users outside our domain (parents of our students) to submit a form with an attachment. If we turn on the setting "Allow unrestricted access to shared forms" at the org level what other impact might that have from a security perspective? We are using AirTable to manage very sensitive data about our students. Thanks!

We’ve created an airtable base for submissions from teams, and then those need to be reviewed by assigned reviewers.  In the form, the review must select their own name. In another field, they need to select the project they are reviewing. I would like to filter the projects that are options to be just the ones the review is assigned to.  Is there a formula to say the “Assigned Review” field matches the name selected in the review name field?  As a work around, I was going to use filter by View -- but I’m also not seeing that option anymore. Was that moved? 

Hi, I am looking into options or workarounds to check if a value of a record exists in database before submitting a form. Is there a third party software or tool that is compatible with Airtable to do this? or is there any workaround with an automation to submit the form and check if record exists. If it does not exist, open again the form and show an error message to fill out a correct email. I would appreciate any suggestions.Thank you.