Ask the Community

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.

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.

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 Interf

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 schedule

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

I am trying to create a call log for our company, but the issue is that I want to figure out how to display multiple back and forth or escalations relating to one call case without adding many rows. I think this could be done with linked records. but here is the schema: Last Name First Name ID Date Type Relation Reason Description Phone Email Link to Assigned Staff / Assigned Team for follow-up. Status (for follow-up) with Resolved or Escalated. I want to demonstrate if it is Escalated that it would move to another person, and allow them to do the next level of response. Or to have multiple entries documenting communication attempts at various levels before Resolved Does that make sense? Feels like I need a sophisticated Junction Table

Hi AirTable Community, I have a commercial dry cleaning and laundry business. I’m trying to create an Airtable app that will let my clients share an itemised list of the garments they’re sending me for cleaning each day. I’d like to create an interface with a form at the top, that lets the client enter each item for cleaning with relevant detail, then a table directly below which lists each item, so they can see a summary of the data they’re inputting in real time. I’m confident about designing each element, but can’t figure out if/how I can put them on the same interface. Any guidance would be much appreciated. Thanks! 

When in data view I click a button that opens a URL, each time a new tab opens. To avoid that, I tried the trick of pressing the ⌥ button while clicking the button, but this time a .TXT file gets downloaded onto my computer on the clicking of the button.This is quite annoying, especially when you have to perform a button clicking multiple times. Do you have any solutions in store to circumvent this?I would appreciate your help on this.PS: I saw that this topic had already been covered in previous threads. But I thought that Airtable might have fixed this since the last time it was brought up.