Ask the Community

Good morning. I would like your advice on how to handle my needs.I would like to create a CRM-like contact database called "Contacts".Then I would like to create a database "Event1" where people can submit a form and register for the event. Then in this database I would like to create other tables always referring to the event in question.I would like the contacts to be linked to event 1 if present in the CRM "Contacts" and, if not present, to create a new contact in "Contacts" with the data of the new subscriber.It would therefore be two linked databases. One is the contact database and the other manages the contacts for that single event, but connecting them to the main database.I hope I explained myself, I'm waiting for yours.Thank you!

I have a user groups as individual records. Each month, my team adds a field with the number of members in each group. This means I don't have a specific field i can put the 'latest' number in for more public views to the wider company. I am trying to create a formula field which says "If this field is blank, try this one, if that field is black, try this one" until a field with values is found... What I have tried, but got no success with (I am not a natural with code/formulas). Can someone help? 😄  IF(NOT(BLANK({2026-01 Members}, {2025-12 Members}, {2025-11 Members}, {2025-10 Members}, {2025-09 Members}, {2025-08 Members}, {2025-07 Members}, {2025-06 Members}, {2025-05 Members}, {2025-04 Members}, {2025-03 Members}, {2025-02 Members}, {2025-01 Members}, {2024-12 Members}, {2024-11 Members}, {2024-10 Members}, {2024-09 Members}, {2024-08 Members}, {2024-07 Members}, {2024-06 Members}, {2024-05 Members}, {2024-04 Membe

I have a score card with a computed percentage grade (e.g., 84) that I want to turn into an easy letter grade for my stakeholders.Rather than using a huge nested IF formula I thought I'd try to use SWITCH to compare and create some values.SWITCH( {% GRADE}, >=93, 'A', <=64, 'F')But I keep getting a generic Sorry, there was a problem creating this field. Invalid formula. Please check your formula text. error message.I can't find anything in the help documents talking about using comparison operators like =, >=, <= with SWITCH.Is what I'm trying to do even possible or am I stuck with that massive nested IF statemen

I'm trying to find out how many fields in our database are empty or not being used. It's really tedious to check each tab one by one. Any siggestions?Thank you!

Hey guys,I spent the day trying to get my head around a moving average function. In my case I want to calculate the 7 day average of my Google Ads CPL (cost per lead) metric. I have daily data from Google Ads in my base along with all important metrics like ad spend, clicks, impressions and so on. I also track the amount of leads. For the day to day calculation a formula does quite well but when it comes to calculate things "across" rows Airtable is quite limited.My approach is to use an automation that runs a script every time I update either the amount in ad spend or leads. This way I kind of "fake" a formula field. I feel like I am almost there but it's not working still and I am having a hard time trying to debug with ChatGPT.My logic is:Values are updatedDate field value is readScript finds the last 7 days based on the original date in the updated row (not today)Script gets the ad spend and leads values of fi

I have already successfully created an automation to send an email triggered by a record's field changing.Now I am trying to create another automation to send a weekly email. In the automation's configuration section, I am filling in the To field. I click on the + sign, and the only options I see, for inserting a value from a field are "Actual trigger time", "Expected trigger time", "Next trigger time". This looks like a bug. Instead of giving me an option to select email recipients from a table, I am being asked about trigger times.Anyone else seeing this? Is this a bug or am I just misunderstanding how to configure a "scheduled time" automation? How are the email recipients of such an email normally selected?

I am building a base for client follow up. When our clients are a couple, they are entered on the same row in our main table. I have the client name column as a look up field in our Client Birthday table, so it pulls the name from our main table. However, in the Client Birthday table we need them to be on separate rows. Is there a way to use an automation or script to split the client names into two rows?For example, if we enter John Doe and Karen Smith on one line in our main table, could we make them show up in two rows in our Client Birthday table?Thank you!

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