Solved

Hello everyone, we created the following script yesterday, which is running and working, but we are facing the 30second timeout issue every time. Is there a way to make this script run smoother or more efficient, or what could be a solution to loop the automation? // Fetch records from TABLE1let table1 = base.getTable('Supplier summary');let result1 = await table1.selectRecordsAsync();// Fetch records from TABLE2let table2 = base.getTable('ERP_suppliers_hub');let result2 = await table2.selectRecordsAsync();// Loop through TABLE2 recordsfor (let record2 of result2.records) {  let SupplierId = record2.getCellValueAsString('supplier_id');  let key = record2.getCellValueAsString('supplier_id_key_formula');    // Check if the key 

I just realised this simple formula, on most fields does not work . Test was done on a Single-Line field. IF(test1 != BLANK(), "Not Blank", "Blank") This will always return "Not Blank".  A workaround seems to be to do the below: IF(Not(test1 = BLANK()), "Not Blank", "Blank") Any idea why this is so? Or is there a simpler work to check for 'Not Blank/Empty'?

Hello all ! (It’s my first post in this forum, if i’m not following guidelines please feel free to tell me !) I quite new in the Airtable world. I’m currentlty trying to create a script (with the script app powered by Airtable) in order to fetch data from my (test) shopify store. But here is my point : → Airtable do not allow to use the class authentication used by Shopify, which is : GET https://{username}:{password}@{shop}.myshopify.com/admin/api/2021-01/shop.json → So i need to use Basic Auth as it’s explained in theire documentation. But it’s not working, and i get this error message : “[API] Invalid API key or access token (unrecognized login or wrong password)”. Did someone ever face this issue and know how to solve it ?(I’m sur about my credentials, and i also delete and recreate my app in order to prevent this mistake). I’m surely missing something but i don’t know what it is… Here is my code : const apiKeyShopify = "MY_SHOPIFY_API_KEY"; const passwordShopify = "MY_SHOPIF

Hi, I have a column with a date and time (starting date and time) in one tab and another column (Duration time) with a duration in another tab. I created a lookup in order to use this duration in a formula to get the endin date and time. I couldn't figure out why my formula is not working...Help ? 🙂

Hi All, I am trying to use the DATEADD formula to add a number of years to a date, The date is in one table and the number of years to add is in another table. DATEADD(Date,{Years till expiry}, ‘Years’) This just returns the same date as the date field. Annoyingly if I remove the {Years to Expiry} and just put a number in there it works fine, But i need to pull a different number of years depending on another field. I am trying to produce an expiry date for a qualification which is linked to a Google drive. the qualifications are listed in another table with the years to expiry number linked to each qualification. once this works i will want to run some conditional formatting in a report to see which qualifications are out of date. I have tried formatting the columns to integer and decimal. Thanks in advance Steve

Hi all 🙂I'm trying to link two tables based on one of two conditions, but am not sure if it works with simple automations or if it requires a script (I'm also new to scripting). I have the following two tables:TABLE 1 contains (amongst other information) vendor IDs that are either the simple IDs or a combination of ID and city code, example:ID100009100014CGN100014BON TABLE 2 contains each vendor and the recipient, for example:Vendor IDRecipientKey100009BER1100009BER100009BER2100009BER100014CGN1100014CGN100014CGN2100014CGN100014BON100014BONNow, I would like to link the tables under the following conditions:1. If the Key in TABLE2 is available as an ID in TABLE1, the records should be linked2. If the Key in TABLE2 is not available as an ID in TABLE1, but the vendor ID in TABLE2 is available as an ID in TABLE1, the records should be linked via the vendor ID3. If none is available, there should not be any linkI tried linking it with two different automations, but the auto

Hello!I'm new here and new to Airtable, but I was looking for some help if it's possible 🙂I have a table with bookings and I want to run an automation at the beginning of every week that groups all the upcoming bookings that are relevant to each individual person in the bookings, to send them an email with an overview of all their upcoming appointments.It's easy enough if I do it for each booking individually, but then one person might receive 3 emails with each booking which I am trying to avoid.I have been playing around with the Find Records function in the automation, where I can create an array of all the upcoming appointments for the week but I don't know how to dynamically find and group the records based on the persons name. At the moment, I just have a list of all the bookings.Is this something that is possible in Airtable? and how can I go about it?Thanks for your time!

Hi Folks, I'm trying out using the rating field for a ongoing review process and want to be able to roll up an average of those ratings. I've managed to get the rollup to work but can't get rid of the NaN for fields that don't have ratings yet. I've tried a couple different formulas that I've seen for similar questions but nothing seems to be working. Thanks!

Hi,I'm attempting to locate a know record with an email address containing a "+".  I've tried introducing a '\' and '\\' before the '+' to no avail.  Tried CURL with your API encoder, no luck.CURL EXAMPLE:curl -H "Authorization: Bearer patZZZZZZ" https://api.airtable.com/v0/appXXXXX/tblYYYYY? filterByFormula=%7BEmail%7D%3D%22bob%5C%2B1%40gmail.com%22I can get results with an email without a '+' character in nodeJS and CURL.How do I specify a filter that enables the retrieval of a record by email address containing a plus?  This does NOT work:const header = {   maxRecords: 1,   filterByFormula: `{Email}="${email}"`,   fields: [      "Record ID"   ],   view: "BulkEmail"} 

Here's what I want to do. I have a field that lists percentages for the fees my company wants to add to a contract. Admin fee 10%, Late fee 5%, etc. If I were to stack these fees, I want to have a field that returns the sum of each percentage multiplied by the contract subtotal field. Is there any way to do this? Like: SUM ( (10% x $800), (5% x $800) ) but where it could recognize the array and do the math for each percentage. 

I have created a formula that gives employees a personalized link to fill out a form so that when they fill out the form, they only need to answer the questions and don't have to put their name, employee id, etc. Is there a way to get around not having them sign in to use the personalized links?I have already turned off the "See who submitted this form" box and the under Share Link settings the "Restrict access to enterprise email domains" option. It doesn't make the person sign in with the regular link to the form, only the personalized one. Hoping there is a way around this. Any help would be greatly appreciated. Thanks!

In my scenario, I have a trailer that may have multiple batteries assigned to it. When a battery needs to be removed, the client brings up the battery detail in an Interface and clicks 'Remove'. This launches an automation where multiple things occur:A ticket is opened for the batteryNotes are added to both the trailer (in the trailer table) and the battery (in the battery table).Then, I want to run a script to remove the battery from the trailer.I found another post that was doing something similar, and after much troubleshooting (I'm new to coding), I've got it down to one error that I'm not sure how to troubleshoot. Error: Request parameters failed validation. at main (script:14)A few notes, yes, the input values from the automation are lists, but there will only ever be one value in the list, which is why I used JSON.stringify. I also suspect the code in line 13 may be wrong.Thanks so much for your help!Code:   const inputConfig = input.config(); const inp

Hi there,Just wanted to see and confirm, that after duplicating a database, if you delete any records in the duplicate, it doesn't impact the original database, i.e. that you don't delete records in the original.  I feel they are both separate entities, but wanted to make sure.Thanks,-Robert 

Hi, I would like to extract only the 2nd character of a data field, to concatenate with another complete data field.Can this be done please? Many thanks.

Hi. Still learning here! This support is invaluable, thank you. 🙏I have an automation that sends an email with when 3 specified fields are 'not empty'. The email contains an invoice as an attachment. I want to make absolutely sure that the automation will never run again on that record under any circumstances, - even if I accidentally change a field and the record records a new modified date/time.Is this possible please?

I've read the solutions for how to update a multiple select field without overwriting via automation. However, I have a bit of a wrinkle—this doesn't seem to be possible when using a Repeating Group.The background:I have a list of live performances in a table called Shows. I have a list of performers in a table called Artists. The two tables are linked via a Linked Record field so that Artists (one or more) can be added to specific shows.Some Artists perform on shows year after year. I have a multiple select field in the Artists table for "Years Active."The desired automation:When an Artist is attached to a show, I'd like the "Years Active" field in the Artist's record to update to include "2024" in addition to any existing years already in the field.The issue:Normally, I would insert the current value of "Years Active" followed by a comma and then "2024." However, the only two fields I can insert are the record ID and name field. This seems to be a limitation of working within a Repea

Hello everyone! I'm fairly new to Airtable and have a question as I'm building my database.I've found it helpful for me to assign "focus times" for tasks independently from their due date in previous systems, so I added a Single Select field named "Status" that has several options: Today, Tomorrow, This Week, Backlog, Completed, and On Hold. I have attached a screenshot of how that looks.Is there a way to create an automation that (at midnight) automatically updates anything with the Tomorrow status to have a Today status instead? I was able to create an automation to change a singular record, but I failed to find a method to update them all. I'm not sure if it's impossible, or if I just don't understand automations enough yet.Regardless, thanks so much, and have a great day!

Hello all, I have a question, and hopefully there's some type of solution to this issue. I managed 3 properties, but for now - we can just focus on 1. Property A has a total of 100+ units. When an end user fills out the form - they type in the unit number - and this is how I have my automation set up:As you can see from the above image, I have a find record and it will update that record for it's respective tenant. Example: The concern here I'm facing is, because Property A has 100+ units, is there a simpler way of creating automations to find records for each unit?Here's a view of the configuration for Property A, finding the "101" integer:Essentially, the goal is to not create 100+ automations for this property to statically assign each unit, but my fear is maybe I have to?I hope I articulated this!Thanks! 

I am working to automate a process that feels like I should be able to script but have been struggling. Admittedly I am new to scripting so I may not be understanding how to structure this, I have asked around, tried to get an assist from Chat GPT, and poked and prodded this along but the final outcome has eluded me. Let me break down the intended function and drop the code in. Any help is greatly appreciated.  Intended function:The automation is initiated when a record enters the "Meetings" view of the "Connections" table, there is a text field called "Attendee Emails" where a formula has collected and concatenated emails using ", " as a delimiter. We are passing that through to the script as an input variable called "attendeeemails". What we need is for the automation to go through the string stored in "attendeeemails" and pull each email out one by one, and check each individual email against the "Email" field in the "Full view" in the "People" table. When any individual e

Hello,Not sure if I overlooked the obvious, but I could not do the following which seems simple :I have a table with contacts (persons) with their mail, function etc. They are linked to 1 Company in the companies tables, companies which have an address and Zip code. I need to display a list of all contacts filtered by the Zip code entered in Filters: how can I retrieve that value from their company ?I already placed all companies in a nice Googlemap addons so salespersons can visualize where clients are, but values were all in the companies table, whereas here I need to show the contacts emails to reach them if someone visits their region. Thank you !

I’m using the Send email action in automations but having a problem with the signature line. I want it to be: Katherine Kasmir Executive Director BRITE But it shows as: Katherine Kasmir Executive Director/n BRITE Is there any way to get it to look like the top version?

I've just read that there will a limit of 1000 calls per month to the API... I use the API on several base to expose data on small website but I can't find where is current state of those usages... So I can't have any idea about my monthly number of calls - How can I check this ? There are statistics of items in base, automations, users... but where is the API consumption state ?Thank you.

Is it possible to have an input Mask in the tables / forms? I want a field to be displayed in the format S0123, or another field to be displayed as 4 digits such as 0025 (not simply 25). Thanks in advance all.

HiI would like to create a number field "recall" that each time the record is update make something like that: recall = recall +1.I used the automation with the update record filter and I try to apply formula on the recall filed by used a formula like tahs: SUM({recall}, 1) but it is returned an error about the format of the value.Do you have idea how to increment the value?For the moment I fixed by add string +1 and the result is "+1+1+1+1+1" for each time the update is execute.Thanks

What types of pushback did you experience/aware of when Airtable was first rolled out. I am ready for AT vs. Excel and "why now, if what we are doing works" any other hints and tips?