Ask the Community

I have multiple automations available on multiple bases however when I create a new one or turn off an existing automation (running properly) and then turn it back on, it turns off itself automatically. It shows an alert sign

My script was working and then it wasn't after I increased my records from 50 to 100. With 100 records the script was being terminated after 30 seconds. 30 real time seconds is an eternity for computers. I will paste my simple script below and appreciate if you can provide some insight on why the script runs so slowly.First some background. My first Airtable automation triggers on a change to a Field in a Table. The following action is Find Records there are conditions in the action and the found records are output as a list of records that past the conditions. Next was the Repetable action that can take the list of records as input and inside I added the Update Record action. Here I hit the wall, for the life of  me I could find no way to auto extract the Record ID from the individual records in the list as input to Update Record.Next I turned to Make but ended in the weeds with the same issue. I used the same Airtable actions except Repetable was replaced with a

Hello,So the use case here is that we have a store with 50,000 products and we will start building additional stores. So I want to have a main product table where all the products are. This one is already done in Excel. Then I want to add checkboxes for B2B, IT, DE, and FR (Italy, Germany, France).  So when I click on the checkbox on the main list it should appear in the additional list. So when I click on b2b it should appear on b2b with all relevant data. In b2b I have additional fields where for b2b pricing for A, B, and C that I calculate with certain formulas based on Acquisition pricing.  Up to this point, it was easy. I already did this with automation. But where the problem comes is how the hell do I delete the record after? So I have it in b2b now. But let's say I don't want to sell it in b2b and I remove the checkbox. The records need to be deleted from b2b. I was thinking that the checkbox should be a relationship field

I have some numbers i need to include in a string.These numbers needs to be rounded down to two decimals, which I use ROUND() to do, my problem comes if the number has trailing zero's fx:233.50 becomes 233.5233.00 becomes 233Does anyone know how can keep the trailing zeros? 

Hi, i have an interface, and i added a commenter to my interface, however, when i tag the person who the interface is shared with, that person does not get a notification when they are tagged, is this normal, or am i missing something? The owner of the base gets the comment notifications

Hello,Each line of my table represents a blog article.On each line, I have a tag, the URL of the page, and several URL cells to fill with the URLs of the articles with the same tag.Is it possible to automate the filling of the URLs of the articles with the same tag?If yes, how can I do that?Thank you so much if you can offer me a solution!

I have this formula as 1 of 3 parts that's extracting certain bits of data from a reference cell into 3 adjacent cells. What I'm wondering is if I can add something to get a specific character insert BEFORE the info...Examplereference cell contains : flavor1, flavor2, flavor3 This part below pulls out "flavor1" into a 2nd cellI'd like it to do that but add a " / " before the flavorSo the result would be " / flavor1"IF( FIND(",", FlavorsLookup1_1),LEFT({FlavorsLookup1_1},FIND(",", {FlavorsLookup1_1})-1),{FlavorsLookup1_1}) &nbs

Hello-I am trying to create a formula/automation/script that looks at a field of images (All PDF Files), and takes the field that is named in the file "RULES", and add this file only to another field called RULES.Any ideas?Thank you!

I have a Zap that uses the "Find Many Records (With Line Item Support) in Airtable".It seems the search is limited to only 10 records.Is this the limit of the function or is something else happening that I'm missing?

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 w

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 u

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'

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 benefi

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")) 

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

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), "S

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 chil