Ask the Community

HiI have a simple script I run each night, which simply attempts to tick a box in about 100 records, which then drives an automation to fire off some reports on activity that day (1 per user). Unfortunately it never completes, it tells me it has failed. It works for many records, but not all. I have similar scripts for other reports. I'm using a script because it fires at a specific time. Any ideas how I can improve this please so that it will process all before timing out. The table in question only has 100 records or so. Thanks let table = base.getTable("Users"

I’m working on a project management system in Airtable, and I need to set up a counter system to assign unique numbers to tasks within a vertical hierarchy. The goal is to create a structured numbering system that reflects the task relationships and levels. Here are the details:Project Structure:I have a hierarchical structure with parent tasks ("Predecessors" field) and the associated subtasks ("Next task" field).Each task can have multiple subtasks, forming a vertical hierarchy.Requirements:Assign a unique number to each task.Ensure that the numbering system reflects the hierarchy (parent-child relationships).Use a formula or automation to generate these numbers automatically.Below is what I have tried:I have tried to create 3 different fields as below:1. tesst2:Formula: IF(COUNTA(Predecessors) = 0, "1", "")Explanation: This formu

Hey, I am having trouble with automating it where when a new 'special item' is created it will deactivate the previous 'special item' in the list and have the new one be active, I keep having errors with the update record.The attached file shows my screen

I've read through most of the posts having to do with this and still can't find an answer that works.  Most ask why this would need to be done.  We are currently using Airtable as a mass outreach table for individuals we contract work with.  Occasionally, they retire, die, or are no longer to be put in rotation.  We have the checkmark to indicate they need to be removed from rotation but we also have to update our operations software with these notes and new changes and want a record to track those updates but not available to reach out to.  We already use filters and views and statuses for the dozens of other items we care about and work with.  We might need to put them back in rotation too so I would rather not delete 100% and just move to other table.  I don't know why this seems so hard to do as it seems like a very important function that a lot of people could use the option of.  Would appreciate any advice!

Hello, I've been using Airtable to create VFX shot lists for feature films and scripted TV series.I find it very useful to display general information (VFX name, Description, Status, etc.), as you can see in the example below:But in some productions, they need me to add specific info for every VFX plate that is part of a particular VFX shot (sometimes it's just one plate, but in some instances there are many). This is pretty easy to achieve using Spreadsheet software (see below):But I'm having a hard time to replicate this simple organisation and layout in Airtable.As you can see, some fields are common for all three plates (Thumbnail, VFX Shot Name, Description), but other fields are specific for each plate (Plate Name, Video track, Plate Durat

Hi Airtable Community,Hoping you can assist.I'm having trouble merging duplicate records, (Keeping the original record and updating  specified fields from the new record, then deleting the new record once complete).I have no java script knowledge whatsoever so used ChatGPT to come up with a script. The first script deleted both records, the second updated but kept both records and the third script is completely useless! Essentially, I would like the automation to be able to find a duplicate address (Field Name is Property Address and is linked with another table) I have also The automation I have set up looks like this and the script is as followslet table = base.getTable("Sold Stock");let query = await table.selectRecordsAsync();let duplicateMap = new Map();// Find duplicates and co

See this?It displays a grid view of records from a specific table.  The tab labeled "All entries" is unfiltered; under "More," there are other tabs available showing the same data with pre-set filters.  I have no idea how I got those tabs to be available and I cannot find them anywhere now.  What I really want is to have different tabs displaying data from different tables according to a record picker selection.  The first table is "Clients," and the others are all linked to "Clients" and have different items that are related to specific "Clients" records (billing, events, job histories, whatever for each Client in Clients).  Being able to pick a Client and have one interface page with multiple tabs for those other tables would really streamline what I now do with separate interface pages in which I have to select the same Client over and over ag

Hello,I need help with figuring out how to lookup the right price of an item for a particular customer from a table.I have an order line item table that contains "Customer Name" and "Item Name". Using this information together I want to look up the price from the price level table.This is the image of the order line item table. I have a customers table where I store all information about my customers. I have an inventory table that contains all the items. The price level table contains all the pricing information. Each item can have different prices for different customers, hence the separate price level table.  

Okay i have a table that has input information that i have added formula to and get the desired results fields out of itresult fields are:Drawer Height, Side length, FB length, inner length, bottom width.note that each one of these fields has a value to it.I would like to take this information and have it out put into a table or view of only two fields:in a combination of different results:field one "drawer height", field two "side length"one all results of this combination have be added then the next set would followfield one "drawer height", field two "FB length"and so on. how would one go about this?thank you for taking the time to look at this 

when I'm trying to create automation to send emails I have a problem, when it ask me to who to send the emails I press on the plus button and then this is what is see - https://imghostr.com/bbb072_e90where is the email column? I want to send the emails to my clients 

i have a airtable with links its 110 in number in airtable but when i use api to access those links i am getting only 100. rest 10 are missing when i use the api  What might be the reason i have provided two pics one of data table and one is my code .

Hello everyone, thank you in advance for the help. Really appreciated Script Purpose When a record is created in first table (with start and end date field), create records with unique dates that go from start to end date in a new table const tableWithRange =base.getTable("Date range"); const tableWithDays = base.getTable("Days"); console.log(tableWithDays) let inputConfig = input.config(); const ranges = await tableWithRange.selectRecordsAsync({fields:["Date start","Date end","Employee"]}) var query = await ranges for (let range of ranges.records){ var fromDate = new Date(range.getCellValue("Date start")); var toDate = new Date(range.getCellValue("Date end")); // var employee = new String(range.getCellValue("Employee")); var outputRecords =[]; var date = new Date() var i = 1; do { var useDate = fromDate outputRecords.push( { fiel

I'm struggling to figure out a good way to determine if a projects start and end date span any part of a specific year where start and end dates could span multiple years.So for example, I have records with the following columns for projects:Project A  3/1/23 [Start Date] | 2/2/24[End Date]Project B  10/1/22 [Start Date] | 5/1/23 [End Date]Project C  7/1/22 [Start Date] | 3/1/24 [End Date]Project D  1/1/24 [Start Date] | 2/1/24 [End Date]I'm trying to determine which projects were in any part of 2023. In the example above, it would be Projects A, B and C.Ideally I can create a formula that just outputs "2023" for any in the 2023 range.

I have a base with records that consist of the URLs of several images inside my site's midia folder. They look something like:https://mysite.com/news/april/banner1.pnghttps://mysite.com/news/may/banner2.pnghttps://mysite.com/news/april/etc/week2/file.htmlhttps://mysite.com/tutorials/folder/name.pdfEtc, fake examples. I would like to extract just the names of the files inside each folder, like:banner1.pngbanner2.pngfile.htmlname.pdfI figured it might be possible if I could FIND the last '/' on each string and extract wha

Objective: I am trying to create an Airtable automation that triggers a script to increment a "Revision Number" field each time a button is clicked. The button is configured in an Airtable interface.Expected Behavior: When the button is pressed, the automation should trigger a script that receives the record ID as an input variable. The script should then fetch the record from the "Quotation" table, increment the "Revision Number" by 1, and update the record.Issue Encountered:Error Message: The script continually logs that no record ID is provided ("No record ID provided."), indicating that the recordId input variable is undefined.Script Setup: The script is set to fetch the record ID passed from the automation trigger (button press) and use this ID to locate and update the specific record.Automation Configuration: The automation is trigge

The following bit of code is intended for a Script block to pull data into airtable it was written by chatgpt I cant make this work for the life of me async function updateRDAPData() { let table = base.getTable('Wucy'); // Correct table name let query = await table.selectRecordsAsync({ fields: ['Value'] // This field contains the full RDAP URLs }); for (const record of query.records) { let url = record.getCellValue('Value'); // Get the RDAP URL from the record if (!url) { console.log(`Skipping record ${record.id} because no URL is present.`); continue; } console.log(`Fetching RDAP data from URL: ${url}`); try { let response = await fetch(url); if (!response.ok) { console.error(`HTTP Error: Failed to fetch RDAP data from URL ${url}: ${response.status} ${response.statusText}`); continue; }

Good day all. I am trying to create a formula to name my Clients based on the following: If {company} is not blank, use {company} and if {company} is blank use {last name}, {first name} - and if there is a spouse name use {last name}, {first name} & {spouse name}I can't quite get it to work - can anyone help? 

Hello Airtable CommunityAll of the info I've found on this subject is ironically in reverse (trying to reflect Airtable in Excel).I would like to have information that is originally added to Excel, to be reflected in Airtable.Is this possible? Furthermore would it be possible to use a shared document to do so?We're using a document from my company's Microsoft 360 account, but I can't seem to find the document under the cloud connected accounts (XLSB format) when importing a new table in Airtable.Thank you

I guess I just don't understand how/why Airtable is set up this way.If I have a Pro account.And another has a Pro account.Why can't they just SHARE one of their workspaces and/or bases with me - with edit access - without my having to pay a 3rd time?! To be a Pro user on "their" account?!That makes zero sense to me. ;-/ 

Hello, I am trying to automate the conversion of SVG attachments in PDF format (in another column).So far I got this script but doesn't seem to do the job. Anyone has a solution?

One if the biggest pain points I run into every day with Airtable, is trying to link records automatically.  A {formula field} that needs to feed into {linked field}.  If only there is an easy way to do this, any suggestions? My current solution is running an automation, but it doesn't work sometimes. If someone can tell me why this automation (images attached) isn't working i'd be so grateful. PROBLEM:SOLUTION:Attached images  

I'm new here so I do not know that many formula. I imported my tables from excel and I have it generate name of the product with product name + weight. However, I want the numbers that are generated in 2 digits format. And here is my current formula :"[90.0]"&" "&{product name}&" "&{weight)}I tried using Round(), but it didn't help.  

I have published a form and used the helper text as a description for some fields. When I preview the form within my account, it looks great. When I try to use incognito mode or a different account to view the form, the helper text is missing. Can someone help?

I would like to create an automation to assign an assignee to the A field in Airtable. The order of assigning a person in charge proceeds in the following order: ‘Lee Ye-ji’ -> ‘Sim Hyo-bin’ and must be repeated continuously.please help me!

I am trying to have a due date automatically calculated, but don't want weekends or holidays included. I am using the WORKDAY function, but still getting weekends. Workback from is the date to begin working on each task and Workback is the number of days allowed for each task. Can someone help?Here is what I am using: WORKDAY({Workback from}, {Workback},'2023-10-23,2023-11-23, 2023-11-24, 2023-12-22, 2023-12-25, 2023-12-26, 2023-12-27, 2023-12-28, 2023-12-29,2024-01-01, 2024-01-15, 2024-02-09, 2024-02-19, 2024-03-29, 2024-05-06, 2024-05-27, 2024-07-01, 2024-07-02, 2024-07-03, 2024-07-04, 2024-07-05, 2024-09-02, 2024-09-20, 2024-10-25, 2024-11-28, 2024-11-29, 2024-12-24, 2024-12-25, 2024-12-26, 2024-12-27, 2024-12-28, 2024-12-29, 2024-12-30, 2024-12-31, 2025-01-01')