Ask the Community

Need some advice on picking the perfectmarket research firm? Here's a quick cheat sheet for you:Know Your Goals: Start by nailing down what you want to achieve with your research. Having clear objectives helps find a firm that gets what you're after.Dig into Reputation: Get your detective hat on and check the firm's reputation. Client reviews spill the tea on reliability and success – don't skip this step!Methodology Matters: Look under the hood at their research methods. Make sure they match your project needs and offer the depth of analysis you're craving.Industry Insight: General skills are cool, but if a firm knows the ins and outs of your industry, even better. It could mean more spot-on insights.Budget Balancing Act: Money matters! Balance your budget with the quality of service. Some firms might cut you a deal for long-term partnerships.Guard that Data: Data security is non-negotiable. Check if they've got the locks on to keep your info safe and sound.

Hello there,i generated an interface and when trying to open it within the mobile app on an iPhone 14 then it is loading endlessly with showing anything.On my desktop the interface is working fine.I closed and reopened the app but having the same issue.Any idea?Thanks a lot in advance.

Hey Lovely People, I have been searching endlessly on Airtable community for a formula that helps convert numbers into texts (such as 1,555 into one thousand, five hundred and fifty five). There were some extremely complicated formulas that simply didn’t work the way they should and there are no scripts. I wish I was a developer to do one. Is there someone out there interested in helping creating such a script? Please note that I need them more than 9,999 (meaning I have some numbers in millions as well). Best, Hady

I'm new to Airtable and I need a formula to check a box from a form submission.IF >=0, 3>= then True (Checkbox 1)IF >=4, 6>= then True (Checkbox 2)IF >=7, 9>= then True (Checkbox 3)IF >=10, 12>= then True (Checkbox 4)I have an automation that sends a specific email based on the selected boxes, but I do not have the time to manually check the boxes. I also tried setting an automation to check the box if it meets criteria but that isn't working either.Any help is greatly appreciated.

If my muliselect field has 25 things in it.I want to find Apples and return apples in the formula field, and I want to find Pears and return Pears to the formula field and if that multiselect field finds both i want it to return Error and if none i want it to return a blankthanks for your help!_Mary

There are so many amazing things Airtable can do… why can’t I figure out how to move attachments? I have a table and I have a team of employees that document images of damages they see in real life at the museum I work at. When that same team access’s this table they look at the attachment field see what has been noted as damaged the day before and then fix that damage in real life. Once the damage has been fixed I want them to either move that attachment to a “fixed” attachment field or put an automation so that they can rename the image as “fixed” and it will then move to a “fixed” attachment field. This very simple function doesn’t seem to exist?! Or am I missing something?

Hi! Hoping someone has done this before. I have a list of customers and their email addresses organized into groups. So I have 3 columns: customer name, email, and group #. I’m looking to make a new table for email automation. I’d like to pull all emails associated with a single group number into a CSV field called “recipients.” Is this possible? I’d appreciate some guidance if so. Alternate workflows welcome. Thanks!

I am such a novice at this, I hope I can accurately explain the problem. My goal for this to combine the sales and listing data from online source with my product data that I need to help me understand what is working and what designs I need to focus more on. Within a single Base, I have 2 tables with 2 sets of Data that are not currently linked. I will call them TABLE A & TABLE B. TABLE A - contains rows of listings for online products. Each row contains a single product with various details about the listing. This data is updated from an external source of my online vendor. For Example, A1 Title / A2 Listing Copy / A3 Number of Sales / A4 Product type / A5 UPC / etc… TABLE B - Contains my information about the online product. This is info and categories that I have created to help me track my designs and organize them for my use. For Example, B1 Design File Number / B2 Niche / B3 Thumbnail Image / B4 Ad Campaigns… etc I understand that I can link individual fields from one table

I create 'multiple select' field to store multiple functions of my product. When I do automation to google docs, the information in this field is grouped together into one field. Current format in google docs is value 1, value 2, value 3Any method to present the value each line?value 1value 2value 3Also, the product image can't be automated into google docs through airtable automation. How can I fix it?  Tks. 

Hi all, Im trying to use airtable in netlify serverles functions. When I try to create a record, I keep getting this error “Expected signal to be an instanceof AbortSignal”. ` const { formattedReturn } = require("./helpers") const Airtable = require(“airtable”) const base = new Airtable({ apiKey: “APIKey” }).base(“BaseID”) const eventBookingTable = base(“Events”) exports.handler = async function (event, context, callback) { const newRecord = async () => { const rec = await eventBookingTable .create({ Name: “iamnotcrazy”, Event: [“recwrjfffffff”], Email: “mymomgotmetested@gmail.com”, }) .catch(err => err) return rec } try { const record = await newRecord() return formattedReturn(200, { record }) } catch (err) { return formattedReturn(500, { err: err.message }) } } `

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 sync directly to the "Content in Progre

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 the school, so she clicks on the 'tab' for Students, a

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')) What I would like to have is a formula (preferably in 1 column) that calculates the number of days between the 3rd column and today unless a date has been entered into the 4th column. Then I want it to show the number of days between column 3 and column 4. I can't find a way to combine my 2 formulas

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 other linked table, but NOT the

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 😄