Ask the Community

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  

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

Trying to create a condition via formula which will mean that a client won't be able to be quoted via airtable extension with the following:Formula:IF(Type="Client", IF({On Hold}="On Hold">"Good", "✅ Good to Quote","❌On Hold - Do not Quote"))We are hoping to then enable the On hold note to propagate through to an extension we use to send quotes onto clients There is a field with single text which we use to fill out the client and then a options single select for on hold/good

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? 

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. Does anyone know anything / have an idea how I could do that (witho

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.

Bonjour ma base de donnée est inaccessible code erreur Erreur : pglap8CuYfR3wcpGI Merci de m’aider.

Hi there, we’re new to Airtable and i have just helped one of our departments setup a workspace which is using a form to capture information via a shareable link. My question is around security, is there any sort of captcha so the form isn’t flooded with bots? Also, i don’t see where i can set an expiry to the form (say for a week or month), is that an option? Thank you

I am trying to set up an email automation that sends an email the next day at 9am after a status change. I have created a formula field: IF(  {Status Changed},  SET_TIMEZONE(    DATEADD(      DATETIME_PARSE(DATETIME_FORMAT({Status Changed}, 'YYYY-MM-DD') & "T09:00:00"),      1,      'days'    ),    'Europe/London'  ))The automation is triggered using a status condition and when the formula field is ‘today’. and This creates the correct time and date in the formula field, but it is not triggering the automation.  

Hello folks!Noob here. Thank you all in advance for any and all advice. I’ve AI to build the tool so far. Think I’ve made some mistakes.Bit of background information. So I’ve been employed by a business to consult on a new food menu, cost recipes and implement a standard recipe book. They use airtable in their other venues for some things like inventory management but not kitchen operations. They’ve asked that I try build a tool for the kitchen that can then be shared across the group.Being new, I only got so far and I’m feeling a bit lost and confused about layout, how some things drag information from where and why some things are where they are. The AI tool has got me so far and it’s been good. But to fine dial this tool for their specific needs I am seeking help!How much are consultations? Does anyone do this for free/cheap to build their portfolio? I’m limited in what I can offer as the budget is well blown out on the venue already due to the build.What I need help with is:ingredi

I am looking to set up an automation based on when my date and time field are NOW Does not look like the automations date filter allows for NOW or takes formula code on it so how could I use a calculation field to look for any date that is now then tick a box or mark another field as True so that I can then base my automation filter off a column marked True? Not sure of the code that when time is NOW mark this fields as True etc…? Tried this but now working IF({Due Back Time Reminder} = NOW(), “True”, “False”)

Hi chat, My coworkers are running into issues with the filters for their interface. They are finding that they're interface filters are resetting frequently throughout the day. Filtering is critical for our workflow and often when they're viewing their pages, it will remove their last filter. Has anyone experienced anything similar?Specific issues:Filters clear without user action. In other cases, filters revert to an old or unexpected state. For example: Our team commonly filters on the Assignee field. Most of the day, users apply Assignee = Themselves (10+ times per day). Occasionally, they apply Assignee = A Coworker (1–2 times per day). However, the Interface will often revert to the less frequently used filter (Assignee = Coworker) as the default, even when that filter has not been recently applied.What's been confirmed/tested:The issue affects multiple users across the same Interface. Users remain on a single Interface page and are not navigating between other pages within the In

Hey everyoneThere use to be a feature for Groups in forms that seems to be missing now for new fields.When creating a form, you can create a group and add fields to that group.When you selected the Group, there was a permissions option for that Group where you can choose the fields to be editable or view-only.It appears that option is no longer available.This was incredibly useful for me. I was able to prefill fields in that group and it would prevent the end user from removing my prefilled option. This was really great when I didn't want to expose information in those fields to end user. I could prefill it and they could not edit it. But it was at least displayed there for them so they know what they were filling things out for. If this feature is gone, is there another way to prevent end users from changing prefilled fields in formsTIA!

https://airtable.com/invite/l?inviteId=invuYBzw8FmryWGPT&inviteToken=3e8b535eecb350617997aaa9c9e0c49b3be2d1c99a73fb32aed8f54c4befe51b&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

Hi everyone,I’ve set up an automation in Airtable that is supposed to trigger once a day at a fixed time. The automation is configured to send an email via Gmail.Here’s the setup: Trigger: At a scheduled time Interval: Every 1 day Time: 1:30 PM (local timezone +07) Start date: Jan 9, 2025 (Screenshot 1 shows the trigger configuration).The problem:Instead of firing once, the automation is running three times: Once at the correct scheduled time (1:30 PM) Once again almost immediately after (same minute) And another run about 2 hours earlier than scheduled Screenshot 2 shows the run history: 13:32 → executed once (2 hours early) 15:52 → executed twice in the same minute Screenshot 3 shows the action setup: It searches in the table 11. Einsatzplanung Using conditions (Einsatztyp = Installation, Start = in one week, Projekttyp has value, Willkommensmail senden = true) So far, we can’t figure out why Airtable is running the automation three times when the schedule is set for on

I am a big Airtable fan, I am very careful, but every now and then I create empty records by clicking on sections, etc. Now, I always figure it out and clean up but can only notice beginners do that almost systematically. I am sure certain there are UI enhancements the Airtable team could implement to make people aware they are actually adding entries in a table.

Hi there,  I’ve created a pie chart in my dashboard interface, and I selected a field to group records by (Gross Margin %). It seems to work well, but it sometimes displays multiples of the same value as separate slices (see multiple 14% and 40% in the legend below). Is this a bug, or am I missing something in the chart setup? I’m really confused why the same value wouldn’t group together automatically.  This is what my setup looks like: If anyone has any ideas, I’m all ears! Thanks so much :)

Bonjour, je cherche à faire un formulaire d’inscription à des cours de qi gong.Je souhaite avoir le nom, prénom adresse mail et numéro de téléphone,le choix (case à choix multiple) du forfait choisi (cours unique, forfait 10 cours, ou cour annuel)avec le prix qui s’affiche de chaque forfait Comment dois-je procéder, car j’ai une table “client” une table “forfait”mais le formulaire ne convient pas, puisque le champs “forfait” est un champ texte, alors que je souhaiterai un champ à choix multiple. Merci de votre aide