Solved

I have 100 records in a table with the same status "ready for publication". How can I use the "Find records" action to only retrieve the first found record?

I am building an inventory management base for my business and am running into a design problem:1. I have a table for parts.2. I also have a table for assemblies. Each assembly record has a field that links to multiple records from the parts table.Simple, however, I want to be able to say how many of each part goes into an assembly. Parts go into different assemblies in different quantities, so that data can’t (and shouldn’t) be stored in the part record.How can I say one assembly uses 2 of a part and a different assembly uses 3 of that part. (And I need a table of all the assemblies.) Hope that makes sense! I would appreciate any solutions.

Hi everyone!I have some issues with a table in interface. When i select a record in a replicated table in Interface the preview have only have a list on the name of the records. (img1)Instead of when i select the data directly from the database. This is important for me because sometimes there are records with the same name but with different details (ie. color of a fabric) (img 2)There are ways to make the selection of the details identical? 

I have a table with the following infoTable1Candidate1 - role1, role2, role3Candidate2 - role3, role4Candidate3 - role1, role4I want to have a newTable2 that shows the status (this field I want to edit) per candidate per roleRole1 Candidate1 statusXRole1 Candidate3 statusYRole2 Candidate1 statusZRole4 Candidate2 StatusXRole4 Candidate3 StatusY.....Is it possible?I found this question; it is somewhat related, but it looks like it implements one-way syncing from Table1 to Table2 through JS.

I have an automation where an email is triggered when a new record is added. However, the emails are generic and only says: "A new item has been created in the XXX job log"How can I get this email to say what the exact record title is? I have looked everywhere and I cannot figure this one out. Any help is appreciated... I am sure it is something simple. Thank you.

I have several rollup fields that search a table ('Transactions') for all accepted contract values for each given project via sum(values). For some reason, the rollups have stopped working and no longer sum up any new records added to the Transactions table. I am able to add and change previously working records, but any new records are not updating. Any assistance would be great.

Hi I am new to airtable and trying to figure out the formula, but stuck on figuring how to accomplish the following.  We have the following fieldsDeal Value = X AmountNo of Payments = can be 1 or more If its 1 = then we need the formula to be (Deal Value / 1) = goes in Payment #1 Amount ColumnIf its > 1 = then we need the Deal Value / No of Payments = go to multiple Payment Columns (Payment #2, Payment #2....... Payment #12) We have created multiple columns with a formula as Payment #2, Payment #3..... Payment #12 with the formula as {Deal Value}/ {No of Payments). However, if the No of Payments is 1, this scenario replicates for that row. We like to write a formula for the payment fields (2-12) which can derive the payment amount by IF No of Payments = 1, then "0" ELSE  {Deal Value/No of Payments) in the formula field. Any insights, what formula should I use for the payment fields to achieve this output? Thank you all very much. Veejay

Hi All,I'm wondering if there is a way to get an automation's name from within the automation.I'm working on a better error handling system for collaborative bases. When automations fail, they currently only send a notification to a single user - the person who turned the automation on or updated it last. I need multiple people to be informed in a non-arbitrary way should any one of the developers be out. I currently have something that looks like this:  output.set("update_status","success"); let buildErrMsg = function(automationName, description, name ){ let msg = description + " in " + automationName + ".\n\n" + "Failed with error: " + name return(msg) } try{ await table.updateRecordsAsync(recordsToUpdate) }catch(err){ err.description = "Issue with updateRecordsAsync"; err.automationName = "My Automation" let msg = buildErrMsg(err.automationName,err.description, err.name) output.set("update_status",msg); }  The output variable

We have an interface built for our finance team to keep track of invoices and which purchase orders they're paid on. (separate tables for invoices and POs). Today one of our team members asked me for help un-linking a PO from an invoice, in order to replace it with a corrected PO record. That's when we discovered that when he hovers over the PO card on the invoice record, he doesn't get the little grey "X" button to unlink the records like I do. We are both editors with full access to the base, and I had him try it on multiple browsers. Any ideas what I'm missing here? Thanks!

Hey Airtable community,My service business has multiple income streams, ranging from one-time to ongoing projects.I am attempting to create a table that can total both one-time revenue and requiring revenue for the month that income comes in. I am having a hard time getting my head around how to do this.I first have a date column with the date the project started and then a formula column that formates the date to just the month so that I can group by month.Currently, I'm only accounting for one-time revenue. I was thinking I could create another date column with automation to duplicate on the same day every month for recurring payments. From here, I don't know how I would total both one-time and recurring payments in a given month?Any help would be greatly appreciated!

Table A contains a list of products. The first column is the name of the product.Example product titles in Table A:White Long Sleeve T-ShirtBlue Short Sleeve HoodieTable B in the same base contains a list of product keywords.Example Keywords from Table B:WhiteLong SleeveT-ShirtBlueShort SleeveHoodieI would like help to create a script that automatically searches Table A's first column with the keywords in Table B, and "tags" them accordingly in a new column as linked records. The result of the script would look something like this:Table ANameTags (from Table B)White Long Sleeve T-ShirtWhite, Long Sleeve, T-ShirtTable A contains thousands of products. Products are added regularly and titles can also be modified occasionally. The list of keywords in Table B are added manually as a new product types or categories are created. This can continue.I am considering hiring an expert to help create this script and I would like to get a better sense of how complex this is and how much it might co

I can’t seem to update my community user name under my profile settings, nor can I find a link to contact a moderator to assist. Appreciate any help…

Is this possible? We would like to know the ‘aging’ of our status field. Meaning, how long has a record been sitting in the current status. I’ve included a screenshot (VIEW HERE) of our base pointing to the Status field and the ‘Aging’ field we want to populate with this data. We already have a last modified date but that, as you all know, is for ANY change made to a record. We only want ‘Aging’ to track the Status field. Thank you!

Hello,We are running a time study with our teams and we are bringing our data into Airtable from a time tracking tool.We are running into a scenario where a designer could have multiple time stamp entries for the same task on a project. The problem is we need to be able to sum up like project task records to get the overall total time they spent doing the task, thus creating a new record with the summed time number.Is there a way Airtable can do this? I started looking at rollups and formulas and I am not too sure where to start or if I am going down the right path.       Thank you!

I run a small company that makes products using parts from an inventory and sells them to vendors. I'm trying to achieve the following - I receive an order, I enter the order as an invoice which includes all the information about which products are ordered, the database checks the amount of raw parts I have in stock and tells me whether I have enough to make the products in the order. Currently I have few tables with junctions between them - a table with a list of parts, a table with the details of products and what parts are needed to make them, a table with a list of products with each product as a one line entry. Then I have invoices and a junction with invoice detail which use the product information. Currently I am using a one line entry to indicate whether an invoice is yet to be made or completed, I want a system that will tell me which parts I need to complete an invoice and then whether I have enough, which parts of the order can be made ok and which can't. I don't w

Hello AT Community!  Today I am bringing you my biggest challenge yet!  I have been banging my head over this for two days and I cannot make heads nor tails of it lol - I'm hoping you guys can give me some possible solutions to make this work!  Here's the situation:An organization has staff members and volunteers.  They want to be able to record and project their staff and volunteer growth.  They track these metrics:# StaffStaff LongevityStaff Replication Rate# VolunteersVolunteer LongevityVolunteer Replication RateLet's just focus on volunteers for simplicity!  In Year 1, they start with 0 volunteers.  Staff recruit volunteers and by Year 2, they have 5 volunteers.  Those volunteers will serve an average of 2 years before moving on.  In one year, roughly half of their volunteers will recruit a new volunteer.  So in Year 2, our 5 volunteers will recruit 2.5 more volunteers.  Year 3 starts with 7.5 volunteers and adds 3.75 more.&nbs

I have a column of case numbers. The numbers can be made up of a number only, for example, 832, or a number with a slash and a number after it, for example, 832/1.I need to create a function that searches for all the numbers that do not have a slash and adds a slash and the digit 0 to them. For example, case number 832 will become 832/0.In Excel, this can be done with the function IF(ISNUMBER(SEARCH), but this is not supported in Airtable. Do you have a suggestion on how to do this?

Hi All,I tried to get feedback from ChatGPT but it steered me wrong. Lol. Long story short, I'm trying to create an automation whereby, when a checkbox in a given record's checkbox field is checked:A status field in the corresponding record is changed from "Upcoming" to "Initiated" (I assumed this was "Update Record"). Then, a pre-made form that I have created is automatically e-mailed to a recipient (whose e-mail is already rolled up/selected on another field) on the same record. Where I'm stumped is -- on the update record action, it keeps asking for a mandatory unique record ID, and I'd like this change to instead apply to any record for which a user checks a checkbox in the checkbox field, not just a single, identified record. Any thoughts? Am I doing this incorrectly?ChatGPT said Airtable has some kind of mapping feature that could help me, here, but I couldn't find it.  

I had a AWS Lambda function that is to update an Airtable. And I am going to modify the function to adopt OAuth2 authentication. However, after testing in Postman, it requires user login in a browser and select workspaces and bases. But it is absolutly impossible for Lambda function and we don't want to store user account in the Lambda function.May I know if we can skip user login during the OAuth2 authentications? Also, can I predefine the allow list of workspaces and bases?

I created a number field for magazine circulation sizes, the first one being 900,000. I entered 900,000 and it turned into 900000. It’s pretty standard for numbers that are higher than three digits to use a comma after every third digit from right to left. So how do I make that happen in AirTable?

I am trying to create a table for my microgreen growing log. I would like to have a function that when I create a new record and fill in the crop name of that record, the corresponding harvest days will be autofilled in another field. But I don't want to use formula as the field type of harvest days as I might have to adjust the harvest days in some situation.

For various reasons, I sometimes need to have long text fields that contain spaces with no other characters. I've been doing this for over a year without any issues. But in the past 2 weeks, it seems like Airtable has stopped recognizing these "space only" strings in long text fields. If I enter any number of spaces or non-breaking spaces into a long text field with no other text, Airtable just deletes it when I leave the field.Here's an example from an older table where it worked (the "length" fields are just len(fieldName) so you can see that it's there):But this is what I'm getting now:I would greatly appreciate any ideas or suggestions!Thanks,Dorothy

I'm trying to fix a field that should show 'outstanding requests'. This displays information from a linked record field which has the setting 'limit selection to a view'. This view filters out completed/archived requests, leaving only those that are current.However, both in the in the field and in the interface that draws from the field, all the completed/archived requests still show (as well as the outstanding ones).  Other linked record fields that draw from a filtered view work fine (e.g. 'current development'). I can't figure out what's going on. Does anyone have any ideas? 

Can anyone see what I am doing wrong here.Two fields, one date (as text type) one time (as text type) - The formulae field SHOULD make these into a single date/time field - This is the formulae I have, but I get errors on any dates with two characters as the day - I have tried various formatting DD/MM etc with no joy!. DATETIME_PARSE(CONCATENATE({TU Start Date} & " " & {TU Start Time}))

Hello,as the subject says i'm looking to write a formula which returns a childs age at 1. august 2023 based on their birthday. i'm currently using a formula which gives me some info, but i would really like to know if there are other possibilities. This is what i use today:DATETIME_DIFF({Planlagt overgang},{Født},'months')I use months because years is not sufficient in detail - since i need more information.Is it possible to get "1 year and 2 months" or similar instead of "14"?Bonus task: how to return blanks instead of NaN.