Ask the Community

I have a formula setup to show a status based on an 'Expiry Date'.This works from a date column {Expiry Date} with a column that works out the difference in days called {Diff}, this uses the formula: DATETIME_DIFF({Expiry Date}, NOW(), "days") Then is the status column I am using: IF(Diff <= 0, "❌", IF(AND(Diff > 0, Diff <= 28), "⚠️")) This works perfectly, my question is how do I add an additional "✅" status for all records that are in date? What would I need to add to the status column formula?

Hi, Rookie question; I have 3 columns “Full Name” (which has the formula to join the next two columns) “Last name” and “First Name”, putting a comma in between. The formula I’m using is: CONCATENATE({Last name}&", "&{First name}) The issue is when Last name and First name are blank (empty records), the formula runs indefinitely in the Full Name column creating rows and only putting in the comma (see pic). How do I stop this?

I have linked voiceflow via API with airtable, this works. I would like to filter via FilterByFormula in the parameters, if I then filter on just the order number it works fine. If I filter on just the email address it works fine, but if I filter on both I get the error INVALID_REQUEST_UNKNOWN, with the message Invalid request: parameter validation failed. Check your request data. How can I solve this?

Hey guys I've created a new base, where one of the tables syncs to another table in a separate base. Got everything working however, inside of the interface in the NEW base, the button to update a field in the linked table does not work. Any ideas?  

Hi Airtable Community, When applying the TRIM function to fields that are lookup fields from another table I receive an error. However when testing other formula’s E.g. Concatenate that does work this particular situation using Linked/lookup fields from another table. I would assume that the all functions gather data in the back-end in the same way. Can one confirm this is actually not possible to use TRIM in combination with Lookup Field type? Thank you

Hi! I am unsure if it is possible to create a formula to make this work for my school, please help!I have a base created to track all applicants. We offer 5 trade classes each held 3 times a year that have a minimum age requirement; age 16yrs and 8mths (Culinary), age 17yrs (Welding and Phlebotomy), age 17yrs and 6mths (Heavy Equipment and Electrical). Currently I have a formula for DOB and age as of the current date. I would like a way to populate which upcoming class the applicant will first be eligible for. e.g. Applied for Culinary Arts, will be age eligible starting with our fall class in October of 2024. Right now I am plugging each DOB into an age calculator based on our start dates and selecting a drop down myself but would love if I could make this work with a formula in Airtable! Thanks!

Hi! We experience an urgent issue while airtable status page says everything functions normally. Support seem to be sleeping, so I ask here if anyone know any kind of solution that we can do. What we experience:- No automations are running- Automations page doesn't respond saying "An error has occurred" - Different error codes every time. Here is one. Error: pgl8szkfLTtXp41CN- API doesn't respond- Table views doesn't loadAnything we can do, but to wait for support?

Is there a way in Airtable where I can have automation where either record A or record B is being changed then trigger the automation that will update record C to be record A and record D to be record B. 

I have a extremely complex Airtable formula that I need to figure out for a financial company.It's a 3 step formula, calculating Grant $ amount generated per project within a 12 month time frame which begins at client onboarding, so each client's time frame is different.

Hi everyone,Our company kick off migration project on Google Workspace, and we need to adjust our email account. Example: current email: alphabet@abc.com.vn; new email in new workspace: alphabet@sub.abc.com.vn. When we complete migration, we will rename the domain and email will come back to alphabet@abc.com.vn.So what I concern and need your support are as below:When we move to use new email account: alphabet@sub.abc.com.vn, do you have any way to set rules to automatic transfer/move bases in current workspace to new workspace?During this our migration time, does it have any risk or bug like miss data or something like that? If acctually we have this risk, what I need to do to backup my data during this migration time?Finally, when we rename the domain and email will come back to alphabet@abc.com.vn, is everything smoothly as what it should be?Please examine my concern. I'm looking for your soon reply.Thank& Best Regards.

Hoping someone can help me with this...So we are a golf cart company, we have a form on webflow that automatically updates our airtable when leads select which upgrades they would like. However, in order to make sure we have enough on hand, we need to be able to track for each upgrade column, how many people have ordered. For this to happen, we would need to be able to filter to a view so that it's only for paying customers, not just everyone that fills out the form.Ideally we'd like to make this into an interface that shows "Soundbars Ordered" then displays the number of times that upgrade column was checked in the deposits placed view.

I can't wrap my head around this... For demo purposes, I have created a pretty simple base that looks like so, and this all looks goodThen I created a simple interface; the only problem is the item highlighted, which is incorrect. I have tried all the options, and nothing is giving me the correct %. If I plot the same data in Excel, this is what I see:Any idea how do I get the right ROI % (I need the result from the same table)?    

Hi,I have a Comedy Club and I use an Artist Availability form I made, so that the comics can pick and chose the dates they are available, 3 months at a time.Is there a way to have automate a calender so I don't have to keep making a new form every 3 months?Thanks Gang Members! 

Hello all,Very new to Airtable, but very excited to be learning. We are currently using Airtable in conjunction with our Calendaring program to track when people are OOO or Travelling. We have set up an automation that when a Calendar invite has OOO or DOM in the title, it colors it RED or GREEN on our Airtable Calendar database and our managers can read that clearly. What our manager would really like to know is if 3 or more people are out at the same time or if people are travelling to the same area. This would show opportunities for site visits, etc. Is there a way I can write an automation that identify "high travel areas" like this? I realize we might not be able to get really specific.

Hey, is there a way to separate files in an attachment field in airtable?Currently we have customers submitting photos into an attachment that automatically creates a new airtable record. These photos are stored under the one attachment field in airtable. I'm wanting to create an individual record for each file/photo in a different table called photos. For example; a customer submits three photos in one attachment. I want this to trigger an automation that creates a new record for each file within the attachment field. I've attached the code I'm trying to use with no success. Is there a way to do it without code?

I’m trying to setup an automation to email someone outside of my organization. I get a message saying that’s not allowed on my plan (Plus) but it doesn’t say what plan will allow this. I just upgraded in order to do this… I don’t want to upgrade again without knowing for sure that the next plan will make this possible.

Hi, I’m trying to automate creating an invoice on Quickbooks Online by a button press on Airtable through Integromat. While I’m successful in creating an invoice, the invoice is created for a Customer in Quickbooks. However, I want the invoice to be created for a Project of a Customer in Quickbooks, which is what I’m struggling with. Here’s the workflow: Have a Projects table and an Items table in Airtable. Create Invoice button exists in Projects table. On button click an invoice is created for all the items from Items table associated with the respective Project. In Quickbooks: Customer exists. Multiple Projects exist under Customer. Problem: Unable to map the invoice created to a Project in Quickbooks Any ideas, tips or solutions on how to achieve this? Thanks!

I have created automations within Airtable so that when a box is checked in one table, all of the production tasks will be created in another table. My question is, sometimes the title for an event will change in the first table. How can I get that change to be automatically reflected in the production tasks found in my other table? I have tried several times without success. Thanks for the help!

As of today I cannot edit or create and fields in my Airtables. When I try and save edits, it loads for about ten seconds and then gives me an error and tells me to refresh. If I create a new field it looks fine for about ten seconds and then it forces me to refresh. After refreshing any changes are gone.This happens in my web browser and the AirTable app. I have tried restarting the browser/app, restarting the computer, etc., but nothing helps.Is anyone else experiencing this?

Hi,I want to search for 1 item in a table which contains multiple items in a cell - apple, banana, grape.The filterByFormula with the = only works if there is only 1 item in the cell.  If they are multiple items, I get an error.I tried using "contains" and "like" but they don't work.  What should I use?ThanksSteve

Hi Again Everyone. I had accidentally marked my post as solved but it is not, I will repost what I am struggling withBelow is my issue, I have been told about a "record ID" though I am unsure if this will work as I am trying to update a whole column of "Single Select" Statuses from "Booked" to "Completed" Hi, I am trying to create either a script or automation that will detect multiple records for me based on specific conditions. Then automatically changing their status I have my trigger set up, If a record has a scheduled date that was one day ago and the status on it is "booked"I want to then update anything under these conditions to "completed" I am having issues setting up the "updating" feature.   my configuration is as shown. I have NEVER done this type of automation, so I am extremely confused on this. any help would be greatly appreciated! Thanks in advance!

We have a database of transactions that is monthly via csv import. This contains information like transaction id, amount, duration.Most transactions are simple one-time occurrences; however, some transactions happen over the span of months.For these long duration transactions, we apply a partial payment at day 30, 60, 90, etc. until the final payment which is a remainder of the total transaction. The issue we run into is that the transaction length and amount can adjust part way through.For example, transaction A has a value of 1,000 and duration of 40 days. Day 30 has passed and day 40 is in the future so our system flags this transaction for partial payment.Calculating the day 30 partial payment is simple:Daily rate * 30(1,000 / 40) * 30 = 750The issue happens when we import the following month's transaction data. transaction A imports again, but this time it has been adjusted to have a duration of 43 days and value of 1,100.So a different calculation is needed to reconcile and

I am trying to create a scoring system using Airtable where judges can score a team (with the different metrics in columns). What I have done: Created 3 different tables for each judge Each judge’s table has a list of all the teams (teams are populated as new records across all judges’ tables automatically using external software) Judges can manually key in the score for each metric and an overall score is automatically calculated in the respective record What I need help with: However, I want to create a new table which gives a summary of the overall score for each team for each judge (i.e. looking across a particular record, I will be able to see the overall score for judges A, B and C). And I want this table to be updated AUTOMATICALLY whenever each judge finish scoring the team. What I have achieved thus far is using linked tables and lookup function. However, this is very inefficient as I have to manually choose which the team (or record) to be linked manually before I can looku

I'm trying to run a script with 4 inputs, one is a Users name and the other three are lists of users labeled Junior, Mid, Senior. I want to return Junior, Mid or Senior depending on which list the User is in, the user will always be in one of the lists. When I run tests where I search for a user within the Junior list the output is 'Name not found in any list'.I will attach my script code below; the logic seems right however it does not find the user in the lists.Script:function findUserList(User, SeniorList, MidList, JuniorList) {// Check if the inputs are strings and split them into arrays; if not, use them as they arelet seniorArray = Array.isArray(SeniorList) ? SeniorList : SeniorList.toString().split(", ");let midArray = Array.isArray(MidList) ? MidList : MidList.toString().split(", ");let juniorArray = Array.isArray(JuniorList) ? JuniorList : JuniorList.toString().split(", ");// Iterate through each list to find the Userif (seniorArray.includes(User)) {return 'Senior';} else

Hi there, i'm having issues with letters' case in my filterByFormula text and API call.I'm trying to do a searching box where user can give an input of what they are looking for, and Airtable fetches from a big database. Right now if i'm looking for "Hilfinger" it actually works alright and returns a few records, but if I type "hilfinger" it won't find anything.Here is my API call, i hope you can help:https://api.airtable.com/v0/appk7bV1OTtj*****/Offerte?filterByFormula=SEARCH(%22TEXT+HERE%22%2C+%7BNome+Oggetto%7D)&sort%5B0%5D%5Bfield%5D=Identificativo&sort%5B0%5D%5Bdirection%5D=descWhat would be ideal to happen is that Airtable gets the records even if cases are lower of uppercase.Thank you very much, any help would be much appreciated