Ask the Community

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 Duration, Source Clip Info, etc.)I've tried different options in Airtable, like Grouping records, linking records and Lookup fields, but I can't manage to accomplish what I want:Is there a way to create a main record in Airtable and add subrecords to

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 collect their IDsfor (let record of query.records) {let propertyAddress = record.getCellValue("Property Address");if (duplicateMap.has(propertyAddress)) {duplicateMap.get(propertyAddress).

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 again to work on one client but in different interface pages.  Suggestions are welcome - thanks. 

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( { fields:{ "Date":new Date(useDate), "Link to rang

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 whatever comes after it, but I'm not managing. Anyone knows if that's possible? 

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 triggered by a button press in an interface, and it's supposed to pass the record ID to the script.Steps Taken:Verified that the automation trigger is corr

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; } let data = await resp

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

I have a table that has a column, lets call it Food. I want to create datasheets for the drop down options I have set up for the food column and I am looking for a way to cater a page set up based off what drop down option is selected. For example: There are two drop down options. Option one is Soda and option two is Carrot. Some important information about soda would be sugar content, manufacturer, calories, etc... and some important information about Carrots would be, pesticide use, region grown, etc... I have all of these bits of information created in my table and I now want to be able to print of datasheets showing the information. The problem I have is that I don't want to display the same information for both Soda and Carrots because only certain fields apply to each. So my question is, is it possible to create separate page designer layouts for specific field values in a table? If not is there a clever workaround I am missing to make it possible. Thank you in adv

Is there anyway to generate an automation that updates field records within a table by matching values in a different column, similar to an Index/Match function, between AirTable and Google Sheets? Essentially, my team manages IRB protocols and we need to track due dates for annual reviews. I'm trying to have the due dates updated in AirTable once the annual review due date is scheduled. Due dates are updated arbitrarily by my institution throughout the year, so I was planning to do a manual export from the institutional data source to a google sheet on a regular basis. Then, once the google sheet is updated, I want to run an automation that updates the Due Date for each corresponding IRB Protocol. Is there currently a way to do this only using AirTable & Google Sheets? My institution doesn't allow for 99% of external extensions. 

Is it possible to edit the email notification that is sent out when you @ a specific user?For context;  as our purchase order moves through various stages, the access to those stages is dynamic.  When a user a elevated stage access comments at a user with a lower stage access, the lower access user receives an email notification with a link.  However, the link takes them to the interface that they do not have access to.  We would like to update the URL that is provided to send the user to an interface where they can see the record and interact with the comments field.Thanks!

Dear community of people so much smarter than me!I am using Airtable to build a film budget that has a number of fields and formulas that are causing me headaches. Table 1) Budget top sheet (two rollup fields: budget & actuals)Table 2) Budget (above the line and below the line)Table 3) ActualsTable 4) Cashflow forecastCHALLENGES: 1) On the budget - certain line items are subject to fringe (payroll fees, withholdings on a state-by-state basis, admin fees, etc.) and need to be calculated on a per line item basis. This is not consistent across the budget. How to solve for this? 2) From the above - - for things subject to fringes - we need to have a number calculated and roll up to the first table outlined above (the budget top sheet). How best to do this?3) We also need to calculate contingency - which is only calculated on Below the Line costs... how best to delineate this - calculate this - and have the number roll up accurately to the budget top sheet? If you ha