Ask the Community

Hi, I am currently using the delete duplicates script. However, I need to ensure it deletes the newest record or the one where I have not added a status. Is there something I can add to the script to ensure this happens? Many Thanks, Hannah

I’d like to link a record in one workspace table to a record in another workspace table. Is this possible?

I have the following formula in a field names "Status":IF({Current Performance}=5,"5: Excellent",IF({Current Performance}>=4,"4: Good",IF({Current Performance}>=3,"3: Fair",IF({Current Performance}>=2,"2: Poor",IF({Current Performance}<2,"1: Very Poor")))))The Current Performance field is a lookup field set to show the last (most recent) item from the related table.If the Current Performance field is blank (no record in the lookup table) the formula will return "Very Poor" even though there is no number in the Current Performance field. I've tried various iterations of the formula, but can't seem to make it behave properly. Essentially, if the Current Performance lookup field is empty there should be no corresponding record in the Status formula field. Any ideas/suggestions?

I have been using Airtable for a few years now and just recently, any forms I create with the most basic info (like First Name and Last Name) are getting flagged with this red warning image.  This is not useable as I need people to link to the form and sign up for things. There are no passwords being requested, no account numbers. Just basic name info and some drop down selections on options for working with our business.  How do I get rid of this? I already reached out to support and no reply. 

Hi, I'm getting ready to delete a table, but first I want to see all the bases and tables it's linked to. I know about the Base Schema Extension, which works to see relationships within a base but I want to know about relationships between bases as well.I believe the behavior when I delete the base will be that the linked fields will be converted to string fields, so the values won't be lost, but before I do the deletion I'd like to know all the bases and tables that will be affected.Anyone know how to find that out?

I’m currently facing a challenge with syncing publish dates across different Airtable tables and bases and am looking for some guidance or a potential workaround.Here's a breakdown of my workflow:- I have two Airtable bases: "Marketing Campaigns" and "Content Marketing"; Campaign Managers work out of the "Marketing Campaigns", the content team works out of "Content Marketing"- When a Campaign Manager adds a new campaign that includes "Blog" as one of their tactics, that "Blog" record is added to a view in "Marketing Campaigns" called "Blogs in Development"- The "Blogs in Development" view in the "Marketing Campaigns" base is the source, and syncs to a "Blogs in Development table in the "Content Marketing" base - These records are then automatically added to another table called "Content in Progress" through an automation; this "Content in Progress" table is the content team's workflow/project tracker for all things content marketing- I don't

One of the very best things about grids and lists in interfaces is that they can be filtered locally, that is, user A can find records where State = TX while user B is looking at records whose State = FL at the same time and using the exact same interface. Solves a huge problem with views in classic Airtable. Fantastic.What I ask Santa for when I say my prayers: Let user A's (and user B's) filters on that interface page stick until that user resets the filters or edits them, even if the user switches to another interface page. At least make it an option that can be toggled in the options panel for the grid or listing object, over on the right side of the page in edit mode.Why it matters. Here's an example from my school management base. User starts in Interfaces by finding parents, say, by name ("Porter"). Now, she wants to jump over and confirm something relating to the children of the Porters who are attending t

I built an automation with a trigger and an action, but when I try to turn on, it doesn't working. The automation turn on and after it, turn off. Everything seems right and I don't know what to do to solve this. Someone know what can I do?

I am attempting to use my first webhook. I followed this guide: Airtable Webhooks Integration: Triggers & Automations Simplified 101 No matter what I try, I cannot get a response of any sort from my webhook URL. When I browse it directly I get a 404, of course. The automation is enabled. Here is a screenshot of what I have: Reqbin test (no matter what I put it says the same error: https://i.imgur.com/0jm1WU7.png

Formula for 1st Column:IF(IS_AFTER(TODAY(), {MOC Requested}),  DATETIME_DIFF(TODAY(), {MOC Requested}, 'days')) Formula for 2nd Column:IF(IS_AFTER(TODAY(), {MOC Requested}),  DATETIME_DIFF({MOC Submitted Date (from Memo of Correction)}, {MOC Requested}, 'days')) 

I have an automation that sends out a digest of all overdue tasks to my team on a twice-weekly basis. This has worked out great for the past 6 months or so, but now names are not appearing in the "assigned to" field. I've tested out all steps of this automation and user names appear correctly at the "find records" test phase, but when populating into the grid below w/in the email, it shows up blank (see below screenshot). Anyone have any ideas about what's going on?I guess one work around is that individuals each get an email that only shows tasks assigned to them but that's not great either since we like to have team visibility across tasks. 

We are using a base as template, which has some automations. I’ve noticed that when the base is duplicated all the automations become disabled. Is there a way to enable all automations on base duplication?

Hi, is it possible to do the following in the Interface Designer or in Forms (old/new)?I want to create an "add new order" page/form, which will show the user all possible products taken from the Products table, and next to each item the user would be able to enter the desired quantity.Would look something like this:ProductQt.product1<user input>product2<user input>......after submitted the form a new order needs to be created with each row in the above table becoming a new record in "Order Line Items" table. I'm ok using scripts if that will allow it.Is this possible?Thanks.

Dear All,I'm designing right know an Interface to show the Warehouse stand of a multi site operation. I've programmed the tables in order to present the stand on each site and then to sum it up to have the general situation. Now I'm trying to visualize all in Interfaces. For the general situation I'll use a Dashboard with filters, but it is not ideal because the number fields are way to big and there is no way to create multi field chart. For the site situation I used the Record picker as a start. This template is a lot better to show a lot of data, because when presented as elements from the Record picker, the number field are small. To visualize the data I wanted to insert here some useful charts, but I've realized it is not possible to connect them to the record picker field. It is quite a strange behavior here from the interfaces: you can connect the chart to the record picker, but then the only sources available for the chart are the o

Hi everyone,We have many automations that send an email to a member of staff when the automation is triggered.  That member of staff has left and I now want all of those automations to go to another  member of staff.  Is there a way that I can search through all the automations to find every instance of that email address being used so I can then manually (or automatically) update the email address with the new name?I've searched around and I haven't been able to find a way to do this without going into every automation individually... Thanks 😄

I have 3 tables - meals, dishes and ingredients.use case: Users should be able to add new dishes and meals through a form. A meal is a combination of 1 or more dishes. Each dish comprises of many ingredients (note ingredients is a separate table)So in a form submission, the user should be able to do two things:1. Add a new dish including its ingredients (note ingredients is a separate table so should be stored appropriately)2. Add a new meal and map dishes to it (a meal is a combination of one or more dishes)Many thanks in advanceHimanshu 

I have created a number of gallery views to which I've shared links & saved as bookmarks on my ipad home screen. The purpose is to have quick access to information in various categories. I prefer gallery view to grid view because it is less cluttered, less fiddely and neater, especially on a smaller screen. It works fine except for the following problems:1. The views open very slowly from the bookmarks - it may take 10-30 seconds for a view to open 2. Even though I'm logged into Airtable on my ipad, when I access the gallery views via the bookmarks I'm not3. I can't edit the records in the views (I can if I enter the airtable app and navigate around in it to each view, but it's very nitty gritty and a bit of a hassle. The whole point of doing the bookmark views was to get easy, direct access to each category of informationI've looked into settings for the links, but there were only 2 options and none were about editing. I also don't know how to f

Hi,Is there a way to insert css designs to the interface? if it can be done, How do I do it?Thanks 

Hi all, I'm trying to build an interface with the recipe and the instructions side by side.I managed to pull all the data i need but my instructions is only showing the first line. The full list only appears when i double click in it.I am not sure if i've missed any settings. For the instructions, I've set it to a dedicated table with one line of rich text formatted in bullet points. I am trying to post all this in one page so we can have them printed.Thanks!

Hey there, I'm trying to gain access to the Download Attachment URL (without using the API) so I can upload images from the Attachment of a record to a social media platform. I've tried using a workflow of AirTable --> Zapier --> Social Media Platform, but I can't find a way to get the image in my AirTable's attachment field to the social media platform. Let me know if you know how to help! PS -- The reason I don't want to use the API is that I saw AirTable's recent notice that they are disabling API access at the end of this year. 

Hello everyone,I would like to track commercial and private flights using airtable. Ideally a flight number or tail number will be entered into a column and in two other columns the flights status and ETA will be displayed.So far there doesn't seem to be any native extensions and I have been investigate third party APIs and have yet to find a suitable match. Any recommendations or suggestions?Thank youTom

Hi Everyone, I currently have 2 tables ("Lesson Tracker" & Student Record").What the lesson tracker does is that each new entry is basically a record of the student's name and the date of the lesson they attended.The student record table is essentially a database of the students, with their name, contact info, as well as a column counting how many lessons they have attended in total.What I would like is:1. Every time there is a new entry on the lesson tracker, an automation runs which first matches the student name on the new entry to the corresponding student row on the student record table.3. Once this matches, a lesson is added to the number of lessons column. Eg. If the student already attended 3 lessons, then this new entry would turn 3 into 4.The ideal scenario is this: "Sam Smith

In a long text field is there a way to create a global entry text for some headings so that whenever I want to enter new content i don't have to enter the headings as well?  For example, the headings I use are:VOA ITZAVOA Total sqftML ITZAML Total sqftLA ITZATA ITZA   

I am using Airtable as the backend for my app. I have a Table A for registering users and a Table B for registering restaurants. Through the Google Matrix Distance API, I am using longitude and latitude data to calculate the distance between registered restaurants and user data, obtaining the results in the "distance" column of Table B where the restaurants are registered.However, each automation I run through the script only updates for new users registering, causing interference with the distance results for users already registered. I would like each user to have their own distance calculation without interfering with others. I have no idea how to do this! I believe it might involve a filter or something like user ID .

hi all, i am new to airtable, and i am looking for a training or certification program to learn it all and pass a certification. Have not seen where to go yet.anyone knows of a clear and well structured training i can subscribe and follow? Any feedback on the Gap Consulting training? or an equivalent??thanks