Solved

Hi all...I'm sure this has been asked before so apologies for asking again. I have searched but any article I think might give me the guidance I need ends up getting confusing...possibly due to my lack of understanding but I think at this stage, my best option is to ask myself.I've created a purchase order system and it's all working fine except for one thing. For the purchase order number, I want it to be "Year-Cost Centre-Number" with the number component being a sequential count of previous orders for that same cost centre. That sequential count is where I'm running into bother - so far all I've managed to achieve is a sequential count of all purchase orders which works, but it's not my ideal set up. My base structure is:Purchase Requests table - this is the main table and is meant to manage the whole purchase order processCost Centres - table of all cost centres, linked back to the Purchase Requests tablePurchasers - table of anyone with permission to request purchases (not re

I have an email automation running every day at a specific time.Is it possible with airtable to match the time the email is send to different timezones?Eg. the same e-mail is send at 2pm CET and 2pm ACT, etc Thanks  

So I use airtable to organize content for my websites and it’s been great. I initially started using it to create a web archive for a artist syndicate that needed a place to put up all their media, which is where I first encountered this issue. When uploading to wordpress using WP All Import Pro I need to have a bare url, but airtable dumps context into the field when you query the url. I was able to get around this using a regular expression to search for the beginning of the actual url and exclude everything before and ignore special characters. That worked fine considering that I only needed 1 attachment per post. Well now, I’m doing something similar to my own photo/video site and have created a portfolio post type where I can upload multiple photos into a gallery for each post. Thus I have multiple attachments per record in airtable, which the regular expression does not work with since there are multiple urls. So my question is how can I get airtable to spit out a completely bare

I want to create a unique share(public) link for each record, so I will send created link to each user, so each user can be edited only one record.Is it possible?Thank you! 

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!