Ask the Community

below is my code but the console log doesnt give me the number of records:async function loadRecordsAndLogCount() {console.log("Script started - attempting to fetch records.");try {const table = base.getTable("Tasks");console.log("Table 'Tasks' successfully accessed.");// Correctly await the asynchronous call to selectRecordsAsyncconst query = await table.selectRecordsAsync({fields: ["Predecessors", "Tasks", "Next task"]});// Log the total number of records fetchedconsole.log("Records selected, total:", query.records.length);} catch (error) {// Log any errors encountered during the executionconsole.error("Script encountered an error:", error);}}// Make sure to call the async function and properly handle any uncaught errorsloadRecordsAndLogCount().catch(error => console.error("Unhandled script error:", error));

=XLOOKUP(9,Table2[max],Table2[tier],,1) Trying to recreate this with automation but keep getting a list error.Have two tables: Projects and Fees, Projects has a number field, and Fees has a list of pricing tiers with a max number field. I want link fee data by automating the record link between Projects and Fees based on match the Project number field within a Fee Tier.See below, ignore first two setup steps, Find records find the Tier, but the last step fails due to "insufficient permissions"    

So, for learning purposes, I have a next review date I input when I create a field.I've set up an automation to email me the matter of the field when the review date arises. I also want to setup an automation to increase the next review date by 3 days when the date arises.How do I do this? I can also see a specific date option in the date section of the automation.

I am trying to implement a button for each record in an interface that increments a field in the record. I can get this working in grid view with a button field and a script. But when I go to the interface, all the buttons are disabled.I can get this working in an Records Review or List layout interface with a interface button element and an automation with a script in it. But the user has to click on each record to open the record detail view to see the button. Is there a way to put an enabled button visible for each record in an interface? 

We are looking using a Timeline or perhaps Gantt to assess producer workload at a glance. I have a Gannt and Timeline working at a basic level but need additional detail.I would like our team to input milestone dates into the base spreadsheet for each project line, to have those milestones show and update in the project blocks in Timeline/Gantt. Is there a way to include Milestones from date columns in a spreadsheet?Thanks

Hi!I'm new to the Airtable community, I'm still finding my way around. I hope all is well!Sooooo, Im wanting to create a smoother process for sending out invoices to my sub-contractors for a work week (Mon- Sun). I have come across a bump!Let's pretend this work week is Feb/12 - Feb/18 (Mon-Sun)So I have two tables:1. Booking Details: ignore the entry at the bottom, it's not part of the pretend work week2. Payout Details Now, The info from table 1 contains a job record: who worked it, the price, the date, etc. In this case, all those jobs were worked by "test@gmail.com" (one person). These jobs were done in different days but in the same Work week of Feb.12-Feb.18. Table 2 is supposed to put all the jobs together from this work week and combine them into 1 record: who worked them, the names of the jobs... which would go under booking details (name: from table 1, first column), and add the total of jobs completed.Now, for table 2, the reason I put start date and end date (although

My base is gone along with my spreadsheet. I emailed the support team a few days ago. Haven't heard back yet. Any idea how long it typically takes to hear back? 

We are trying to integrate SendGrid in the Airtable Extensions. I created a new API key in SendGrid and verified my email, however, upon trying to finish the integration, I get the following error: Invalid SendGrid API key or sender email address. Any suggestions? I have already tried creating a new API and re-verifying the email.

I have two buttons on the same table, each triggers a script and then sends a webhook to a third-party service. One works and the other does not. During the debugging process, I copy and paste the exact same code into the two scripts, and one works, but the other always says "O: TypeError: Failed to fetch at line 10" and that's the line that triggers the Webhook. It's rather strange given the two scripts are identical. Is there any limitation that one cannot have two scripts within one table? My code below.let table = base.getTable('URL');let record = await input.recordAsync('Select a record', table);let websiteContent = record.getCellValue('Website_Content'); // Retrieve the content from "Website_Content" columnlet recordId = record.id; // Get the record ID// Include the record ID and the website content in the webhook payloadlet payload = JSON.stringify({ websiteContent: websiteContent, recordId: recordId });// Send the data to the Azure Functionlet response = await remoteFetchAsync(

I'm creating a webhook that fires when a specific field in a record in Airtable is updated using the 'Create a webhook' endpoint. Doing so returns the default 200 response with the id of the new webhook in the response. The issue is that the webhook does not fire, and when I call the 'List webhooks' endpoint, I receive a 404 response with the error message "NOT_FOUND."I made a screen recording in Postman to show what I mean. Is this a bug?For additional context, after creating the first webhook, I successfully triggered it. However, I wanted to make changes and attempted to delete it so that I could create a new webhook. Upon calling the 'Delete a webhook' endpoint, I received a 404 response, after which point I was no longer able to trigger the webhook.

I am a project manager for a consulting company. We have a bank of questions we ask during our client interviews. I'd like to be able to create a process where our consultants can select specific questions from the master list based on the role of the person being interviewed and then be able to enter the specific answers to those questions for that interviewee. So, Consultant selects a subset of Interview Questions and enters the responses to those selected questions on the Interviewee record. Is there a way to do this in single base?

Bonjour à tous, J'ai un fichier avec une colonne TEXTE LONG et je souhaite remplir une colonne de SELECTION UNIQUE automatiquement en fonction d'un morceau de TEXTPouvez-vous m'aider ?

Is the Airtable API down right now? For the past 5 hours, I have been getting this error whenever I try to access my data from Airtable via API:An error occurred when calling Get Alltimeout of 25000ms exceededAll my mobile applications use Airtable as their database, so I am getting an influx of emails/messages from users reporting that the app is not working (Since it can't fetch the data from Airtable)Is this only happening to me? Or for everyone else?

I've been using Airtable forms for over a year and they were great. I noticed they changed the interface, which doesn't seem to add to functionality but complicated the process. Also, you can't add linked fields anymore. I had mobile browsers set up, and out of nowhere they became useless when they changed this function. I could be wrong but forms can now only be used for new data. Before, I could add a linked field where I could choose an existing record and add/edit data. The only reason I can think of for making this change is because it was easy for employees to interact with Airtable without having to pay the $12 per month but, what I don't understand is, why isn't available to employees who are on a monthly subscription. I'm really hoping I'm just not understanding the new form function because my use cases for Airtable have become irrelevant moving forward. Has anyone ran into an issue with the new form function? Or, can anyone suggest a workaround? Thanks!!

To send automated emails to multiple contacts at once, we insert a rollup list of email addresses (associated with a parent item) to the BCC field of the email automation. Since the data we are sending is sensitive, we don't want recipients knowing who else has received this email.I've noticed that the entire automation will fail due to an "invalid email address" (email is typed correctly with no extra spaces, commas, or semicolons). Since the automation is BCCing ~20-30 different email addresses, one "invalid email address" causes the email to fail for ALL recipients. After investigating a bit further, some of the "invalid email addresses" are actually coming back invalid. How is Airtable assessing the email addresses before sending an email? I would assume that it would send, then I would recieve a "post-master failure" email in return (acknowledging the error). Does anyone know how Airtable is able to qualify email addresses before they are sent? Thank you!

Hey everyoneBeen fighting with this all day. Hopefully someone here can help point me in the right direction.I am using PowerAutomate and Sharepoint. I have a Word document stored in a folder on Sharepoint that I would like to attach to a record in Airtable. I have gotten pretty far but as always that last bit is tripping me up.Here is the setup.Power Automate:I have a 'Get Properties' node that is returning information about the Word document that I think I need to attach the file including the link and file nameI have an 'HTTP' node that points to the airtable API, the base, table and record in question. I am using PATCH as the method and I have the authorization working. Additionally, I have the content-type set to application/json.In the body of the HTTP node, I have this JSON{ "fields": { "Contract": [ { "url": "https://my.sharepoint.com/sites/My-Team/Shared%20Documents/Word%20Folder/File%20Name%20001%20%5BProject%202%5D%20-%20File%20-%203.docx", "filen

Is this possible? I have too many tables!

Is it possible to queue records for processing with an automation, rather than processing them simultaneously? I have an automation that’s triggered by a record being created in Table A. The automation checks for records in Table B and if it finds a match it links it to the new record in Table A. If no match is found then a new record is created in Table B and linked to the new record in Table A. The problem I’m facing is that if two or more records are created in Table A in quick succession, the automation for the first record to be created hasn’t completed when the automation for the second record starts. This means that duplicate records can be created in Table B, when only one is needed. Is the only option to stop using the ‘When record is created’ trigger and instead build something that processes all new records on a schedule? It would have to run every 15 minutes as it needs to be close to real-time.

I currently have a script that is set to execute on the click of a button. It works really well, but I've increased the amount of records I'm doing this with and clicking the button 500 times, one record at a time, is quite tedious.The script is pulling in information from an API and due to AirTable's 30 second limit, it's only capable of doing a handful of records before failing.I've been trying to work with the automations tool to somehow mimic the clicking of the button one record at a time so that it can run the script for one record, finish the script, and then move to the next record, mimic the click of a button to start the script, and continue this until it's done it for each of the records.Is this possible at all? I've tried doing it for new records added to a view, but I would still have to add each record to the view one by one as it will group the records together and try to do them all at once when they're added to the view.

Is there a way to loop through each record found from the Find Records action, and perform a subsequent action for each individual record? As far as I can tell, you can only do something with the list of record IDs that result. I can think of workarounds but they are extremely complicated and I figured I'd ask to see if there's something a little more proprietary. 

Hi all I’d like to add a default number of ‘1’ in ten columns on a linked base - so that whenever a new record comes through from the ‘master’ base, it automically fills those columns with the number ‘1’. For some reason the default number option doesn’t work, and I can’t find any scripts that will work to be run as an automation to do this either. It feels like a simple request so hoping there’s a simple solution and I’m just being stupid… Thanks in advance, Curtis

Hi, I need help. I logged into my account and my spreadsheet is gone. I believe it was link to a team account which was deactivated which may have erased my spreadsheet ?! Is there anyway I can retrieve it ? I don’t see any options in my account portal. 

Hello everyone, I’ve got this error Error: network timeout at: https://api.airtable.com/v2/bases/appOZnMxRdfPA9ddR/tables/tbledHinNmtQRT4lb/records/update But this weird thing is that the update works. But still, i have this error. tableSociete.updateRecordsAsync([{ id: societe.id, fields: { "refreshtoken": responseJson.refresh_token, "accesstoken": responseJson.access_token }, }]) The other weird thing is that i dont have the error everytime but just with some “societe.id”

I work for a large theatre, and I'm trying to automate my Opening Night Tickets forms, but running into an issue. We have 12 different shows, and each person is allotted a specific number of tickets to each show. What I'd like to have happen with the form, is that the show will only appear as an option if there is a value filled out in that field on that person's record, and it will only show the number of tickets they're allotted (they can request less than allotted, but not more).For example, if John is offered 2 tickets to Show A, he would see options for 0, 1, and 2 in the dropdown. If he's only offered 1 ticket, it would show 0 and 1. If he's not offered any tickets, Show A would not appear in his form at all.Currently every show is appearing on the form, even if there's not value in the workspace. My bigger issue is even if I have a 1 in the field on the workspace,  for some reason they can still choose 2 in the form. I need to make sure they can only select up to the number

Hi !     I created a column to identify if the "End Date" of a task belongs to one of the weeks below, based on the ISO numbers for each week of the year (1~52 or 53).      But I am facing an error due to the year, that I cannot overpass.      It is considering the pure number of a week in 2023 (e.g.: #49) as a week in future, because the actual week number in 2024 is less than that.     Please, can someone help me with it?PAST: "End Date" week number < actual week numberTHIS WEEK: "End Date" week number = actual week numberNEXT WEEK: "End Date" week number = actual week number +1FUTURE: End "Date" week number = actual week number +2Here is the actual formula I have that is running, depite the error from year:"IF({End Date},IF(AND(YEAR({End Date}) = YEAR(TODAY()),DATETIME_DIFF({End Date}, TODAY(), 'days') < 0),"PAST",IF(AND(YEAR({End Date}) = YEAR(TODAY()),VALUE(DATETIME_FORMAT({End Date}, 'W')) = VALUE(DA