Ask the Community

Hi,I send automated emails to my referral sources updating the status of their referrals.  I would like to keep the color formatting and in particular the graphic from the progress bar that shows up in airtable.  However, when the automation runs, it only shows the progress in a numerical value.  Is there a way to bring the progress bar to life in the automation?  DW 

Hello Airtable Community,I hope this post finds everyone well. I'm reaching out to share a recent experience I had with Airtable's billing and support teams, and I'm seeking your insights, opinions, and perhaps similar experiences.Background: I've been a dedicated Airtable customer since January 2021. My team and I chose the Pro Starter Pack, which catered to our needs perfectly. Over the months, we've integrated Airtable deeply into our business processes, trusting the platform's stability and consistency.The Issue: To my surprise, I recently discovered a significant spike in my monthly invoice, jumping a staggering 360%. Concerned, I immediately reached out to Airtable's support for clarification.Airtable's Explanation: The support team informed me that my plan had been switched from the 'Pro Starter Pack' to the 'Pro' plan. The reason? The Pro Starter Pack was deprecated. This transition was executed without any prior notification or my explicit consent. My account was simply upgrad

Recently our Softr.ai app has not been able to consistently load information from our airtable databases. This never used to be the case and nothing has changed in the configuration. I am wondering if this is linked to the API changes - I read somewhere that if an airtable client now goes over their API limit (which we do if we are treated as a Team client and not a Pro client) then the 5 API calls per second is impacted. Is this what might be happening? (See screenshot - "request limit exceeded") I understood from what  you said that we would be getting unlimited APIs on our current plan (Pro) until it runs out in April 2024 (because we have paid for an annual subscription), but I am wondering whether this is not the case and our ability is to make API calls is already being impacted. It would be really useful to know the answer to this as   is currently not useable as it is not loading consistently. Could you ask one of your team to let me know

I have an issue where a sync that used to work has stopped as of 13 hours ago.The sync is from one base to another.This is the error message on the table that is being synced from the original."Unable to sync this source. Internal sync error"There have been no structural change or field name changes on this base during this period.Filed a support ticket (00634496) but this is business critical and a day to get a response doesn't answer that.

Why wouldIF(NOT( IS_AFTER( Date,'10/4/2023)function correctly andIF(IS_BEFORE(Date,'10/4/2023)not function the same in a formulais not after = is before 

Hello,I am reaching out to see if anyone else has had this problem and knows how to fix this.We use a form that is to file reports at the end of a shift, which includes the time stamp of when the form is being filled out. This form is then sent out to Administration and Management staff via the Automation tool in Airtable. Which then gets populated into the corresponding Base. Strangely, when the automation sends out the email, it creates a strange and incorrect time signature along with the date (example: Saturday, 2023-09-24T02:26:00.000Z when it was the 23rd of September and at 9:26pm). It does not effect the base however, and places the correct date and time in there, but I am wondering if anyone has had this same issue and has found a way to correct it??

Yesterday I noticed that several of my base to base sync's are broken.In every instance the source base has a main table, with a sharable view.That view is sync'd to other bases in the workspace.Nothing has changed in the original source base to 'break' the sync.All the locations where the original base syncs out to have filters so only pertinent information is pulled across.I get the error "Unable to sync this source. Unable to sync new data" in all the bases that the source syncs to.I did find one other older post in here with something similar,  and tried those help steps that were listed, but they didn't solve the issue.I reached out to AT's live chat yesterday, and was told they couldn't help via chat.I also have a support email out, and am waiting on their response.I just thought I would ask the broader group if anyone had similar issues - appreciate any insights!

I am trying to create new records via airtable.js, when I try to create a new record in Link-to column with row-value (i.e. name - string not Record ID), it does not work and reply Class {error: “INVALID_RECORD_ID”, message: “Value “VALUE” is not a valid record ID.”, statusCode: 422} Is there any way to avoid this condition? or there is not “typecast” command in airtable.js ? if yes, please let me know some example, var dataCompt = { "field1": "value1(text)", "field2(Link-to column)": "value2(text)" }; function createATData(){ base(tableName).create(dataCompt, function(err, record) { if (err) { console.log(err); return; } //loadArtists(); }); }

Has anyone seen this error before? Been getting it a lot more as of late and unsure how to approach troubleshooting it.While requesting "dev_file" from Airtable we ran into an error: Cannot read properties of undefined (reading 'error')Thanks in advance!

Before I say anything else, Airtable is excellent.  Super awesome product.  That said, this problem is really holding us up.I see I am not the first person to ask this question, but I am surprised that it's not resolved, and that such a basic feature is not already available when this question has been asked a couple of years ago.  Is there some reason that this cannot be easily added as a feature?  Snag: Without sorting, the info in the email digest is useless.  An emailed grid could just be sorted, or just use any view created in the base or interfaces.  This would seem like an easy feature to add given the entire platform is based on table data.  I do realize things can be complex in programming even for something simple.  Is this feature coming though?  It makes or breaks the email digest concept for us.  I am guessing we're not the only ones who could benefit.  In all my views I have a table that is sorted and u

Hi! I had set up a sync from one AirTable base to this one and it was working fine until last week this little warning symbol came up and I got a sync failed message but I am not sure why the sync failed. I've tried to re-sync the bases together but with no luck. Can anyone help!  

Hi All! I am still new to Airtable and writing formulas and (hopefully) this is an easy question.I am trying to write a formula that will display text that matches the "checked" state of 3 different checkboxes, and also will display "New" if none of those checkboxes are checked.This is what I have written so far, and it is working to display the state of the first checkbox, but because that is true, it's not moving on to the next thing I want it to test for. Is there an additional logic I could add to the formula that would accomplish this? Or a totally different way of going about it?My current formula in the Status column: IF({Service Started}, "Service Started", IF({Ready for Pickup}, "Ready for Pickup", "New")) Screenshot for context: Thank you so much!Devon

Hi, I am trying to create a formula that accomplishes the following but am not quite sure how to set it up. Does anyone have any suggestions? IF({FPL %} > 125% but < 300% = "Eligible")Thanks!

Hi guys,I have been trying to create a simple Make.com scenario to test the waters, where an Airtable record is created from a pre-specified Etsy receipt. The first step works great, all records are pulled from Etsy's API, but when we get to Airtable, I'm getting a repeated [404] Not Found error.According to Airtable developer @EvanHahn's answer here, Airtable only returns 404s in two cases. I quote:the resource you’re fetching is missing. For example, if we can’t find the table, or the base, or the record, or whatever.the URL you’re hitting is totally bogus. For example, a request to api.airtable.com/v0/garbage will return a 404.It seems that it's getting the base, the table, and the record just right, so I assume the URL it's hitting must be correct.The error persists regardless of smart link or column ID use.Make.com gets its access via a personal access token:The connection screen looks like this: You will see that Etsy has 4 acquired permissions whereas Ai

Hello!  I'm relatively new to AirTable, we're migrating here from FileMaker Pro.  I'm forced to duplicate a calculated field in FileMaker, which is essentially the same a a Formula in AirTable.  Basically it does some complex looking at a zipcode value and either displays a Metro Region if it's a certain zipcode, or instead, just displays the City name.  I've been trying to do this:SWITCH(AND({l_zip} >= 94100, {l_zip} <= 94199), "North/San Francisco",AND({l_zip} >= 93600, {l_zip} <= 96199), "North/Other Cities",{l_zip} = 91604, "South/Los Angeles & Vicinity",{l_zip} = 91711, "South/Los Angeles & Vicinity",{l_zip} = 90755, "South/Los Angeles & Vicinity",AND({l_zip} >= 90000, {l_zip} <= 90199), "South/Los Angeles & Vicinity",AND({l_zip} >= 90200, {l_zip} <= 90599), "South/Los Angeles & Vicinity",AND({l_zip} >= 90800, {l_zip} <= 90899), "South/Los Angeles & Vicinity",AND({l_zip} >= 91100, {l_zip} <= 91199

Good morning to you,I'm trying to create dynamic ToDoLists.At first, I thought I could solve my problem by using complete NoCode (see my post).Finally, after some advice, I turned to @Giovanni_Briggs code and post.I've never coded the day before yesterday, and I'm trying to use AI tools to understand what I'm doing.I've managed to adapt the proposed code to my base and half of what I want to do works.As it happens, my code copies the tasks from my original list very well,It links the new tasks to the event we've validated internally,But it doesn't create a link between parent and child tasks (I've been tearing my hair out for 24 hours trying to solve this problem).To explain, each parent task (main task) is linked to several subtasks (child tasks).example : The Hotel taskis therefore linked to several subtasks:Hotel searchValidation of a hotel according to quotation and price/quality ratioHotel reservationHotel paymentReceipt of invoiceWhen I use my script, everything works fine except

Hi there! I am using IF formulas in two separate formula fields and they work just fine. I am trying to merge the formulas in one field and it is not working. The third and fourth IF keep disappearing. Can someone please help me?Here are my formulas :1st fieldIF(AND(Campagne = 'Grands Donateurs - Somme à amasser', {Progrès de la campagne} = 'Somme à amasser'), {Objectif restant},IF(AND(Campagne = 'Grands Donateurs', {Progrès de la campagne} = 'Somme amassée'),{GD - Montant promis})) 2nd fieldIF(Campagne = 'Sièges', {Sièges - Montant promis},IF(Campagne = 'Sièges - Somme à amasser', Objectifs-{Sièges - Montant promis})) What I thought it would look like :IF(AND(Campagne = 'Grands Donateurs - Somme à amasser', {Progrès de la campagne} = 'Somme à amasser'), {Objectif restant},IF(AND(Campagne = 'Grands Donateurs', {Progrès de la campagne} = 'Somme amassée'),{GD - Montant promis}), IF(Campagne = 'Sièges', {Sièges - Montant promis},IF(Campagne = 'Sièges - Somme

I need to get some Airtable data into a Powerpoint/Google Slides/similar, without copying and pasting. Any ideas please? This isn’t an ongoing automation requirement, it’s a one-off. And I’m not sure merely embedding an Airtable is going to fly for the recipient. Thanks.

I have one table with item names in the first column, and I want to add a column that displays TRUE if the item name is present in the first column of another table of item names. In Excel I would do this with a VLOOKUP or MATCH wrapped in an IFERROR.

I have a table "Performance" with device performance data of my app. The table has the following columns: user-id, device-name, fps, time-stamp Now I want to extract the devices which have "fps" below a threshold (let's say below 10), because I want to blacklist those devices. I want to check in every week and see if there are any "new devices" with less than 10 fps and add them to the blacklist. say I have a second table "Blacklist", where I manually enter the devices I have so far blacklistednow a new record enters the "Performance" tableI want to check if the "device-name" of that new record already exists in the "Blacklist" table and if not, hightlight the field, or set a flag in another field, e.g. "IsBlacklisted"how to do that?

I'm inputing a list of records to the Update Record action. Let's say 3 records. I want a field in all three records updated. In the Record ID box if I enter a record id only one of the 3 records is updated. if I leave the record id box blank and click search I put one of the record field names in the Display box and I put the following formula in the Formula box.IF(OR({Net Profit} < 2,{ROI} < 0.4,{Average Rank (90 Days)} > 99999,{Amazon 3x Cost} < 3,{Pack QTY} > 2,{Estimated Monthly Sales} < 10,{# of FBA Sellers} > 5,{EUM} < 10,{EPM} < 13,{Rating} < 3,{Reviews} < 10,FIND("Oversize", {Product Size}) != 0,FIND("yes", {Amazon Sells and in Stock}) != 0),RECORD_ID(),BLANK())This formula is based off the filter I use in the Search Records action. When I try to exit I click ok and the 3 values of the field that I entered in the Display  box are displayed but I am unable to exit. It wants me to click ok again and if I do I just get the 3 values displayed

Morning! I'm trying to figure out a formula but struggling to get it to work and wondered if anyone could help please?Status column is a single select column with status numbers from 0-499 which i want to add information into a new column from a formula showing "1. called off and not yet delivered"Status 500 needs to say "8. Not listed in dropdown - detail in Comments" in the same formula column.This is as far as i have got, can anyone point me in the right direction please? Thank you!  IF(  OR(    {Status} <500, "1. called off and not yet delivered"){Status} = 500, "8. Not listed in dropdown - detail in Comments")

Hi AllI have a base with 3 tables: Routes, Passengers, and Absences. The Routes table has multiple passenger fields, which are linked record fields to the Passengers table. The Absences table has a passenger field, which is a linked record field to the Passengers table and has a lookup field to the associated route field - as well as a date of absence. When an absence is added to the Absence table, it pulls the route the passenger is on. If a passenger changes route, the linked record lookup field for the route in Absences will change for past absences. This means the data in Absences is no longer historically representative. What is the best way to preserve the original route that is pulled through onto records in the Absences table? Preferably I would avoid: a) having the route name in an extra text field or b) creating a linked record field directly to Routes rather than using a lookup field, but open to all solutions. Thanks in advance for your help!

In a grid view, I can select multiple records and then right-click to e.g. delete this selection.Is it possible to add this selection to a linked record field in another table?

Text:I am interacting with two tables in my AirtableFirst table: "Payment History," where I have a lookup column called "Unpaid Delivered Tasks" that displays codes in a format like "#C0005, #F0055, #T800."Second table: "Sales," where the first column is called "Unique Code," and it contains codes corresponding to each sale. Additionally, there's an important column named "Advisor Payment Status" with two options: "Pending" and "Paid."What am I looking for?I'm trying to find the most effective way to update records in the "Sales" table when an automation or script is executed from a specific record in the "Payment History" table. The goal is to search for all the codes listed in the "Unpaid Delivered Tasks" column of the "Payment History" table and update the corresponding records in the "Advisor Payment Status" column of the "Sales" table to mark them as "Paid."What I've tried:I attempted to create an automation where I manually entered the code into a text column. This worked well wi