Solved

I'm in a pickle and I can't figure out what to do even though I've read a lot of posts here and asked ChatGPT to help me over and over but nothing.I've got three fields that are formulas but they're formatted into integer type. 1. {Fecha limite de adeudo (dia)} and it's formula:IF(OR({Quincena 1}, {Quincena 2}),IF({Quincena 1},17,1)) 2. {Fecha limite de adeudo (mes)} and it's formula:IF({Quincena 1},MONTH(TODAY()),IF({Quincena 2},MONTH(DATEADD(TODAY(), 1, 'month')))) 3. {Fecha limite de adeudo (ano) (number)} and it's formula:VALUE({Fecha limite de adeudo (ano) (string)}) I tried combining them the following way but Airtable says "the result type is not a number or a date".IF(OR({Quincena 1}, {Quincena 2}),DATETIME_PARSE(CONCATENATE({Fecha limite de adeudo (dia)},'-',{Fecha limite de adeudo (mes)},'-',{Fecha limite de adeudo (ano) (string)}), 'DD-MM-YYYY'),"") I want this last field to be a date/object type and I don't know why it's not working because the thre

I am working on a field that pulls a result based on a number range.   I aim to convert the number of days from a person's hire date and an incident date to a set phrase such as "Less than 3 Months",  "4 Months to 1 Year", etc.   My first field converts the difference between their hire date and the incident date to the number of days.   My thought was to create a formula that says if the number of days is between 0-90, then the result is "less than three months," and so forth.   My fields are "Hire Date", "Incident Date", & "DateDiff".  The field I need to formulate is "Length of Service".   What is the best approach to get my outcome?  

Hi,I have an automation that triggers every day at a specific time.I want to end the automation after a number of days.How can I do that?Thanks,Jacqueline  

Hi all! First post - seems like a great community.I have an Airtable view that I'd like to be semi-public: Users who have an account with us should be able to log in and view the view, but those who don't should not. Can I do this from a security perspective? As I understand it, if I embed the view anywhere it has to be inherently fully public and that anyone with the link to the view (that the embed code uses, for example) would be able to just open the view directly in Airtable.Is there any way to do this?

Do e-mail automations work on the free plan?Thanks  

Hello everyone 🙂I work for a school and some workshops are made in groups of students.For instance, I need the 6 people from the Thursday, 11am slot to receive the same e-mail, visible e-mails in the "To:" field, and to Cc their trainer.Is there a way to select the e-mail addresses from the group meeting these criterias (day, hour) and send the same e-mail to all of them instead of sending individual e-mails?My idea is to do a concatenate formula to blend all addresses, but I'm not sure how to do it, and I'm afraid it would send multiple times the same e-mail...🤯Thanks a ton for your help!

I have an automation that emails the count of records that match certain criteria. This often results in emails that indicate there are 0 records for consideration. I’d like to only fire this automation (or send the email) if there matched records are >0. Is this possible using the new conditional automations, or via scripting? Thanks, Andy.

Here is my formula which I need to add a few more statements too.    IF(AND({LOS2} >= .0, {LOS2} <.26), "First 3 Months", IF(AND({LOS2} > .25, {LOS2} < 1.00), "Within 1 Year", IF(AND({LOS2} >= 1.00, {LOS2} < 2.00), "1 - 2 Years", IF(AND({LOS2} >= 2.00, {LOS2} < 3.00),"2 - 3 Years",  IF(AND({LOS2} >= 3.00,{LOS2} < 4.00,"3 - 4 Years")))))) Here is a screen shot of the table.  It isn't capturing the last statement in the formula; it is returning nothing. It should return 3-4 Years.  What am I missing?     

Hourly pay is dependent on age as shown below. I have 2 fields setup in my table: 'Age' and 'Hourly Pay'.I've tried all combos of IF, nested IFs and <= symbols but can't get the formula for all 3 age/pay combos to display correctly. Your help is needed folks..! 23 and over21 to 2218 to 20£9.50£9.18£6.83 

Seems like it should be relatively simple, all I want to do is use a button from an interface to add 1 to a number field in my tableI'm using the button linked to an automation and here's what it looks like:And this is using a dynamic update:But here's what happens when I test this:So I guess it's the wrong format, and I can't find any documentation on formatting for this. Seems like I can't even add two fields together.So how would you do this?  

I'm having issues getting a formula to round down prices to the nearest $2.50.I've tried FLOOR() FLOOR({Price}, 2.5)and ROUNDDOWN()ROUNDDOWN({Price},2.5)but without any success. Thank you in advance.

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!